Using Db2 Version 8.2 and jdbc type 4 driver; after a period of time I get the following error:

DB2 SQL error: SQLCODE: -805, SQLSTATE: 51002, SQLERRMC: NULLID.SYSLH203 0X5359534C564C3031

All selects get this error once it occurs, after about an hour of operation.

A few questions if anyone can help:

1) What causes this error to happen all of a sudden?

2) I came across a post that said calling the following commands helps:

db2 bind @db2cli.bnd blocking all grant public
db2 bind @db2ubind.bnd blocking all grant public

If so, what is this doing and why do i need to do this?

I used to have that same problem, not sure exactly why it takes so long to hit but at any rate the bind seemed to resolve it.

Binding creates the package on the target database. Packages contain sql statements and the bind operation generates corresponding access plans.

The other way to resolve is to grant the id the BINDADD priveledge, then it should auto-bind.

jono