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=3D4: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=3D4:2,
pszSqlStr=3D"RUNSTATS ON TABLE SESSION.TEMP_MID_1 AND INDEXES ALL",
cbSqlStr=3D52 )
[04/29/2008 13:25:49.903327] ---> Time elapsed - +3.230000E-004
seconds
[04/29/2008 13:25:49.903457] ( StmtOut=3D"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=3D"SYSSH100 ",
Section=3D65 )
[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=3D1 )
[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=3D0:4,
phStmt=3D&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=3D1 )
[04/29/2008 13:25:49.902529]
[04/29/2008 13:25:49.902600] SQLAllocStmt( phStmt=3D4: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=3D4:2,
pszSqlStr=3D"RUNSTATS ON TABLE SESSION.TEMP_MID_1 AND INDEXES ALL",
cbSqlStr=3D52 )
[04/29/2008 13:25:49.903327] ---> Time elapsed - +3.230000E-004
seconds
[04/29/2008 13:25:49.903457] ( StmtOut=3D"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=3D"SYSSH100 ",
Section=3D65 )
[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=3D1 )
[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=3D0:0, hDbc=3D0:0,
hStmt=3D4:2, pSqlcaOut=3D&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=3DSQL_HANDLE_STMT, hHandle=3D4:2,
iRecNumber=3D1, fDiagIdentifier=3DUnknown value 2467,
pDiagInfo=3D&a45fe47c,=
cbDiagInfoMax=3D140, pcbDiagInfo=3D&a45fe478 )
[04/29/2008 13:25:49.907843] ---> Time elapsed - +9.300000E-005
seconds
[04/29/2008 13:25:49.907956] SQLGetDiagFieldW( pDiagInfo=3D5570642,
pcbDiagInfo=3D140 )
[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=3DSQL_HANDLE_STMT, hHandle=3D4:2,
iRecNumber=3D1, fDiagIdentifier=3DUnknown value 2461,
pDiagInfo=3D&a45fe474,=
cbDiagInfoMax=3D4, pcbDiagInfo=3D&a45fe478 )
[04/29/2008 13:25:49.908577] ---> Time elapsed - +1.040000E-004
seconds
[04/29/2008 13:25:49.908658] SQLGetDiagFieldW( pDiagInfo=3D0,
pcbDiagInfo=3D0 )
[04/29/2008 13:25:49.908807] <--- SQL_SUCCESS Time elapsed -
+5.890000E-004 seconds
[04/29/2008 13:25:49.908908] SQLErrorW( hEnv=3D0:0, hDbc=3D0:0,
hStmt=3D4:2,=
pszSqlState=3D&a45fed14, pfNativeError=3D&a45fed10,
pszErrorMsg=3D&a45fe50c,=
cbErrorMsgMax=3D1024, pcbErrorMsg=3D&a45fe508 )
[04/29/2008 13:25:49.909343] ---> Time elapsed - +1.010000E-004
seconds
[04/29/2008 13:25:49.909565] ( iRowNumber=3D-1, iColumnNumber=3D-2 )
[04/29/2008 13:25:49.909761]
[04/29/2008 13:25:49.909835] SQLErrorW( pszSqlState=3D"42601",
pfNativeError=3D-104, pszErrorMsg=3D"[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=3D42601
", pcbErrorMsg=3D205 )
[04/29/2008 13:25:49.910104] <--- SQL_SUCCESS Time elapsed -
+1.196000E-003 seconds
? It couldn=B4t be more simple than 'runstats on table T and indexes
all'. How do I find where is the syntax error ?
|
