Hi,

I got
DBD:B2::db prepare failed: [IBM][CLI Driver][DB2/SUN64] SQL0805N Package "NULLID.SYSLH214 0X5359534C564C3031" was not found. SQLSTATE=51002
DBD:B2::st execute failed: [IBM][CLI Driver][DB2/SUN64] SQL0805N Package "NULLID.SYSLH214 0X5359534C564C3031" was not found. SQLSTATE=51002
Can't execute statement: [IBM][CLI Driver][DB2/SUN64] SQL0805N Package "NULLID.SYSLH214 0X5359534C564C3031" was not found. SQLSTATE=51002

Sun Solaris 10, DB2 V9.
bash-3.00$ db2level
DB21085I Instance "db2inst1" uses "64" bits and DB2 code release "SQL09010"
with level identifier "02010107".
Informational tokens are "DB2 v9.1.0.0", "s060629", "SUN64", and Fix Pack "0".
Product is installed at "/opt/IBM/db2/V9.1".


Thanks a lot.

rebind the packages

more detail?

Thanks.

db2 connect to ...
db2 bind @/opt/IBM/db2/V9.1/bnd/db2cli.lst blocking all grant public

I did it
bash-3.00$ db2 bind /opt/IBM/db2/V9.1/bnd/@db2cli.lst blocking all grant public

LINE MESSAGES FOR db2cli.lst
------ --------------------------------------------------------------------
SQL0061W The binder is in progress.
SQL0091N Binding was ended with "0" errors and "0" warnings.

But still got
DBD:B2::db prepare failed: [IBM][CLI Driver][DB2/SUN64] SQL0805N Package "NULLID.SYSLH214 0X5359534C564C3031" was not found. SQLSTATE=51002
DBD:B2::st execute failed: [IBM][CLI Driver][DB2/SUN64] SQL0805N Package "NULLID.SYSLH214 0X5359534C564C3031" was not found. SQLSTATE=51002
Can't execute statement: [IBM][CLI Driver][DB2/SUN64] SQL0805N Package "NULLID.SYSLH214 0X5359534C564C3031" was not found. SQLSTATE=51002

Thanks

just check case 2 at following tech article

http://www-128.ibm.com/developerwork...ex.html#N10AB6

--Rahul

Great! it works!!!
thanks a lot.

-Jianrong