Michel Esber wrote:
> Hello,
>
> DB2 LUW v8 FP15
>
>
> I am running a simple 'runstats on table session.temp_MID_1 and
> indexes all' and it fails with
>
[snip]
> [04/29/2008 13:25:49.909835] SQLErrorW( pszSqlState="42601",
> pfNativeError=-104, pszErrorMsg="[IBM][CLI Driver][DB2/LINUX]
> SQL0104N An unexpected token "RUNSTATS ON TABLE SESSION.TEM" was
> found following "BEGIN-OF-STATEMENT". Expected tokens may include:
> "<collect_stats_start>". SQLSTATE=42601
> ", pcbErrorMsg=205 )
> [04/29/2008 13:25:49.910104] <--- SQL_SUCCESS Time elapsed -
> +1.196000E-003 seconds
>
>
>
> ? It couldnīt be more simple than 'runstats on table T and indexes
> all'. How do I find where is the syntax error ?
The problem is that RUNSTATS is a CLP command, not an SQL statement.
Therefore you can't (directly) execute it via an interface like ODBC
(or JDBC, etc), just as you can't use IMPORT, LOAD, EXPORT, etc.
directly via ODBC. However, the ADMIN_CMD stored procedure in v8 does
support RUNSTATS, so you should be able to execute it via something
like:
CALL ADMIN_CMD('RUNSTATS ON TABLE SESSION.TEMP_MID_1 AND INDEXES ALL')
See
http://publib.boulder.ibm.com/infoce...om.ibm.db2.udb
..doc/admin/r0012547.htm for details of ADMIN_CMD under v8.
Cheers,
Dave.