Hello,

DB2 LUW v8 FP15


I am running a simple 'runstats on table session.temp_MID_1 and
indexes all' and it fails with

[04/29/2008 13:25:49.902600] SQLAllocStmt( phStmt=4:2 )
[04/29/2008 13:25:49.902707] <--- SQL_SUCCESS Time elapsed -
+6.190000E-004 seconds

[04/29/2008 13:25:49.903030] SQLExecDirectW( hStmt=4:2,
pszSqlStr="RUNSTATS ON TABLE SESSION.TEMP_MID_1 AND INDEXES ALL",
cbSqlStr=52 )
[04/29/2008 13:25:49.903327] ---> Time elapsed - +3.230000E-004
seconds
[04/29/2008 13:25:49.903457] ( StmtOut="RUNSTATS ON TABLE
SESSION.TEMP_MID_1 AND INDEXES ALL" )
[04/29/2008 13:25:49.903583]
[04/29/2008 13:25:49.903664] ( Package="SYSSH100 ",
Section=65 )
[04/29/2008 13:25:49.903813]
sqlccsend( Handle - 2010514272 )
sqlccsend( ulBytes - 169 )
sqlccsend( ) rc - 0, time elasped - +4.500000E-005
sqlccrecv( )
sqlccrecv( ulBytes - 213 ) - rc - 0, time elapsed - +1.919000E-003
[04/29/2008 13:25:49.906177] ( COMMIT REPLY RECEIVED=1 )
[04/29/2008 13:25:49.906634]

[04/29/2008 13:25:49.906748] SQLExecDirectW( )
[04/29/2008 13:25:49.906826] <--- SQL_ERROR Time elapsed -
+3.796000E-003 seconds

[04/29/2008 13:25:49.901761] SQLFreeStmt( )
[04/29/2008 13:25:49.901826] <--- SQL_SUCCESS Time elapsed -
+5.340000E-004 seconds

[04/29/2008 13:25:49.902088] SQLAllocStmt( hDbc=0:4,
phStmt=&a45fedc4 )
[04/29/2008 13:25:49.902325] ---> Time elapsed - +2.620000E-004
seconds
[04/29/2008 13:25:49.902417] ( Re-using Cached Statement Structure=1 )
[04/29/2008 13:25:49.902529]

[04/29/2008 13:25:49.902600] SQLAllocStmt( phStmt=4:2 )
[04/29/2008 13:25:49.902707] <--- SQL_SUCCESS Time elapsed -
+6.190000E-004 seconds

[04/29/2008 13:25:49.903030] SQLExecDirectW( hStmt=4:2,
pszSqlStr="RUNSTATS ON TABLE SESSION.TEMP_MID_1 AND INDEXES ALL",
cbSqlStr=52 )
[04/29/2008 13:25:49.903327] ---> Time elapsed - +3.230000E-004
seconds
[04/29/2008 13:25:49.903457] ( StmtOut="RUNSTATS ON TABLE
SESSION.TEMP_MID_1 AND INDEXES ALL" )
[04/29/2008 13:25:49.903583]
[04/29/2008 13:25:49.903664] ( Package="SYSSH100 ",
Section=65 )
[04/29/2008 13:25:49.903813]
sqlccsend( Handle - 2010514272 )
sqlccsend( ulBytes - 169 )
sqlccsend( ) rc - 0, time elasped - +4.500000E-005
sqlccrecv( )
sqlccrecv( ulBytes - 213 ) - rc - 0, time elapsed - +1.919000E-003
[04/29/2008 13:25:49.906177] ( COMMIT REPLY RECEIVED=1 )
[04/29/2008 13:25:49.906634]

[04/29/2008 13:25:49.906748] SQLExecDirectW( )
[04/29/2008 13:25:49.906826] <--- SQL_ERROR Time elapsed -
+3.796000E-003 seconds

[04/29/2008 13:25:49.906970] SQLGetSqlca( hEnv=0:0, hDbc=0:0,
hStmt=4:2, pSqlcaOut=&081c92a8 )
[04/29/2008 13:25:49.907233] ---> Time elapsed - +1.440000E-004
seconds

[04/29/2008 13:25:49.907321] SQLGetSqlca( )
[04/29/2008 13:25:49.907393] <--- SQL_SUCCESS Time elapsed -
+4.230000E-004 seconds

[04/29/2008 13:25:49.907486]
SQLGetDiagFieldW( fHandleType=SQL_HANDLE_STMT, hHandle=4:2,
iRecNumber=1, fDiagIdentifier=Unknown value 2467, pDiagInfo=&a45fe47c,
cbDiagInfoMax=140, pcbDiagInfo=&a45fe478 )
[04/29/2008 13:25:49.907843] ---> Time elapsed - +9.300000E-005
seconds

[04/29/2008 13:25:49.907956] SQLGetDiagFieldW( pDiagInfo=5570642,
pcbDiagInfo=140 )
[04/29/2008 13:25:49.908114] <--- SQL_SUCCESS_WITH_INFO Time
elapsed - +6.280000E-004 seconds

[04/29/2008 13:25:49.908218]
SQLGetDiagFieldW( fHandleType=SQL_HANDLE_STMT, hHandle=4:2,
iRecNumber=1, fDiagIdentifier=Unknown value 2461, pDiagInfo=&a45fe474,
cbDiagInfoMax=4, pcbDiagInfo=&a45fe478 )
[04/29/2008 13:25:49.908577] ---> Time elapsed - +1.040000E-004
seconds

[04/29/2008 13:25:49.908658] SQLGetDiagFieldW( pDiagInfo=0,
pcbDiagInfo=0 )
[04/29/2008 13:25:49.908807] <--- SQL_SUCCESS Time elapsed -
+5.890000E-004 seconds

[04/29/2008 13:25:49.908908] SQLErrorW( hEnv=0:0, hDbc=0:0, hStmt=4:2,
pszSqlState=&a45fed14, pfNativeError=&a45fed10, pszErrorMsg=&a45fe50c,
cbErrorMsgMax=1024, pcbErrorMsg=&a45fe508 )
[04/29/2008 13:25:49.909343] ---> Time elapsed - +1.010000E-004
seconds
[04/29/2008 13:25:49.909565] ( iRowNumber=-1, iColumnNumber=-2 )
[04/29/2008 13:25:49.909761]

[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 ?