PDA

View Full Version : Executing DB2 Runstats from perl using DBD

RVenkatraman
11-25-02, 18:47
Is it possible to execute DB2 runstats using perl DBD.?
I am using Perl DBD module from Activestate on windows NT.
Bernd Dulfer
11-29-02, 06:06
Is it possible to execute DB2 runstats using perl DBD.?
I am using Perl DBD module from Activestate on windows NT.

Sure. Use the do method.
E.g.:

$dbh->do('runstats on schema.table');
RVenkatraman
11-29-02, 09:46
Originally posted by Bernd Dulfer
Is it possible to execute DB2 runstats using perl DBD.?
I am using Perl DBD module from Activestate on windows NT.

Sure. Use the do method.
E.g.:

$dbh->do('runstats on schema.table');

I tried using the do method
$dbh->do('runstats on table cidstage.DIM_DATE');
Got the following error
DBD::DB2::db do failed: [IBM][CLI Driver][DB2/NT] SQL0104N An unexpected token
"END-OF-STATEMENT" was found following "le cidstage.DIM_DATE". Expected tokens
may include: "JOIN <joined_table>". SQLSTATE=42601