hi, when i try to fine the expln statement for a query i get this error.

[db2inst1@WESSPTDW01 ~]$ db2expln -d warehous -t -q 'select * from gems.sca_sum_month'

DB2 Universal Database Version 9.7, 5622-044 (c) Copyright IBM Corp. 1991, 2008
Licensed Material - Program Property of IBM
IBM DB2 Universal Database SQL and XQUERY Explain Tool

Error during VALUES for package check.

Message Text =
SQL0901N The SQL statement failed because of a non-severe system error.
Subsequent SQL statements can be processed. (Reason "sqlriResolveOpFunc:
invalid opcode 0x348 at offset 648:0".) SQLSTATE=58004


sqlcaid = SQLCA
sqlcabc = 136
sqlcode = -901
sqlstate = 58004
sqlerrml = 56
sqlerrmc = "sqlriResolveOpFunc: invalid opcode 0x348 at offset 648:0"
sqlerrp = SQLRI007
sqlerrd0 = 0x801A006D = -2145779603
sqlerrd1 = 0x00000000 = 0
sqlerrd2 = 0x00000000 = 0
sqlerrd3 = 0x00000000 = 0
sqlerrd4 = 0xFFFFFCCC = -820
sqlerrd5 = 0x00000000 = 0
sqlwarn = ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' '

[db2inst1@WESSPTDW01 ~]$

Since it has told error during the package values check.

So i try to bind the package. But it also end up in error.

[db2inst1@WESSPTDW01 ~]$ db2 bind @db2ubind.lst blocking all grant public

LINE MESSAGES FOR db2ubind.lst
------ --------------------------------------------------------------------
SQL0061W The binder is in progress.
SQL0031C File "/home/db2inst1/db2ubind.lst" could not be
opened. SQLSTATE=00000
SQL0082C An error has occurred which has terminated
processing.
SQL0092N No package was created because of previous errors.
SQL0091N Binding was ended with "3" errors and "0" warnings.
[db2inst1@WESSPTDW01 ~]$


Kindly help me

Have you run into wrong path？
db2ubind.lst is in dir : ${HOME}/sqllib/bnd ...

Again the same error even trying in /$dir/sqllib/bnd path..


[db2inst1@WESSSTDW01 bnd]$ db2 bind @db2ubind.lst blocking all grant public

LINE MESSAGES FOR db2ubind.lst
------ --------------------------------------------------------------------
SQL0061W The binder is in progress.

LINE MESSAGES FOR db2ueiwi.bnd
------ --------------------------------------------------------------------
2239 SQL0204N "SYSTEM.SYSUSERAUTH" is an undefined name.
SQLSTATE=42704
2243 SQL0204N "SYSTEM.SYSUSERAUTH" is an undefined name.
SQLSTATE=42704

LINE MESSAGES FOR db2clpnc.bnd
------ --------------------------------------------------------------------
SQL0595W Isolation level "NC" has been escalated to "UR".
SQLSTATE=01526

LINE MESSAGES FOR db2arxnc.bnd
------ --------------------------------------------------------------------
SQL0595W Isolation level "NC" has been escalated to "UR".
SQLSTATE=01526

LINE MESSAGES FOR db2ats_sps.bnd
------ --------------------------------------------------------------------
1173 SQL0204N "SYSTOOLS.ADMINTASKS" is an undefined name.
SQLSTATE=01532
1203 SQL0204N "SYSTOOLS.ADMINTASKS" is an undefined name.
SQLSTATE=01532
1234 SQL0204N "SYSTOOLS.ADMINTASKS" is an undefined name.
SQLSTATE=01532
1482 SQL0204N "SYSTOOLS.ADMINTASKS" is an undefined name.
SQLSTATE=01532
1499 SQL0204N "SYSTOOLS.ADMINTASKS" is an undefined name.
SQLSTATE=01532
1517 SQL0204N "SYSTOOLS.ADMINTASKS" is an undefined name.
SQLSTATE=01532
1555 SQL0204N "SYSTOOLS.ADMINTASKS" is an undefined name.
SQLSTATE=01532
1679 SQL0204N "SYSTOOLS.ADMINTASKS" is an undefined name.
SQLSTATE=01532
1696 SQL0204N "SYSTOOLS.ADMINTASKS" is an undefined name.
SQLSTATE=01532
1715 SQL0204N "SYSTOOLS.ADMINTASKS" is an undefined name.
SQLSTATE=01532
1732 SQL0204N "SYSTOOLS.ADMINTASKS" is an undefined name.
SQLSTATE=01532
1895 SQL0204N "SYSTOOLS.ADMINTASKSTATUS" is an undefined name.
SQLSTATE=01532
1950 SQL0204N "SYSTOOLS.ADMINTASKSTATUS" is an undefined name.
SQLSTATE=01532
1962 SQL0204N "SYSTOOLS.ADMINTASKS" is an undefined name.
SQLSTATE=01532
1979 SQL0204N "SYSTOOLS.ADMINTASKSTATUS" is an undefined name.
SQLSTATE=01532

LINE MESSAGES FOR db2adminotm.bnd
------ --------------------------------------------------------------------
342 SQL0204N "SYSTOOLS.ADMIN_MOVE_TABLE" is an undefined name.
SQLSTATE=01532
371 SQL0204N "SYSTOOLS.ADMIN_MOVE_TABLE" is an undefined name.
SQLSTATE=01532
455 SQL0204N "SYSTOOLS.ADMIN_MOVE_TABLE" is an undefined name.
SQLSTATE=01532
536 SQL0204N "SYSTOOLS.ADMIN_MOVE_TABLE" is an undefined name.
SQLSTATE=01532
570 SQL0204N "SYSTOOLS.ADMIN_MOVE_TABLE" is an undefined name.
SQLSTATE=01532
590 SQL0204N "SYSTOOLS.ADMIN_MOVE_TABLE" is an undefined name.
SQLSTATE=01532
671 SQL0204N "SYSTOOLS.ADMIN_MOVE_TABLE" is an undefined name.
SQLSTATE=01532
767 SQL0204N "SYSTOOLS.ADMIN_MOVE_TABLE" is an undefined name.
SQLSTATE=01532
903 SQL0204N "SYSTOOLS.ADMIN_MOVE_TABLE" is an undefined name.
SQLSTATE=01532

LINE MESSAGES FOR db2ubind.lst
------ --------------------------------------------------------------------
SQL0091N Binding was ended with "0" errors and "28"
warnings.
[db2inst1@WESSSTDW01 bnd]$


do i need to create any of these tables ?

No, everything is fine.
These are just warnings.

if these are just warning,

when i try for the explain statement again, i am ending with same error only.

Just tell me how do i overcome this

[db2inst1@WESSPTDW01 bnd]$ db2expln -database warehous -q 'select * from gems.pacasset_sum_month' -t

DB2 Universal Database Version 9.7, 5622-044 (c) Copyright IBM Corp. 1991, 2008
Licensed Material - Program Property of IBM
IBM DB2 Universal Database SQL and XQUERY Explain Tool

Error during VALUES for package check.

Message Text =
SQL0901N The SQL statement failed because of a non-severe system error.
Subsequent SQL statements can be processed. (Reason "sqlriResolveOpFunc:
invalid opcode 0x348 at offset 648:0".) SQLSTATE=58004


sqlcaid = SQLCA
sqlcabc = 136
sqlcode = -901
sqlstate = 58004
sqlerrml = 56
sqlerrmc = "sqlriResolveOpFunc: invalid opcode 0x348 at offset 648:0"
sqlerrp = SQLRI007
sqlerrd0 = 0x801A006D = -2145779603
sqlerrd1 = 0x00000000 = 0
sqlerrd2 = 0x00000000 = 0
sqlerrd3 = 0x00000000 = 0
sqlerrd4 = 0xFFFFFCCC = -820
sqlerrd5 = 0x00000000 = 0
sqlwarn = ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' '

[db2inst1@WESSPTDW01 bnd]$