All,

We recently migrated our db2 version from 8.1.6 to 8.2 .2 (Fixpak
9a) . today i tried to run the db2expln tool and it failed saying
unexpected error .

Error:
Licensed Material - Program Property of IBM
IBM DB2 Universal Database SQL Explain Tool

Error during explain call.

Message Text =
SQL1042C An unexpected system error occurred. SQLSTATE=58004


sqlcaid = SQLCA
sqlcabc = 136
sqlcode = -1042
sqlstate = 58004
sqlerrml = 0
sqlerrmc =
sqlerrp = SQLERFED
sqlerrd0 = 0x00000000 = 0
sqlerrd1 = 0x00000000 = 0
sqlerrd2 = 0x00000000 = 0
sqlerrd3 = 0x00000000 = 0
sqlerrd4 = 0x00000000 = 0
sqlerrd5 = 0x00000000 = 0
sqlwarn = ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' '


Command used

db2expln -d EP_PROD -stmtfile del1.sql -terminator @ -terminal


we bind the db2ubind list and db2cli list , after migration . is there
anything else we need to do . Please let me know your thoughts , Os i
Aix 5.2


Sql :-

delete from test.audit where date(auditdttm)='06/02/2005' with ur



Thanks,
Dinesh Kumar Lakshmanan
DB2 DBA


DB2 & UDB email list listserv db2-l LazyDBA home page