Did you drop all the explain tables and recreate them?





"Dinesh"
<db2udbdba-ezmlms
hield-x53108560.x To
[Email Address Removed] "LazyDBA Discussion"
a.com> <[Email address protected]
cc
11/29/2005 12:28
PM Subject
db2expln fails after db2 8,2
upgrade










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



---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




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