467,907 Members | 1,145 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,907 developers. It's quick & easy.

DB2 SQL error: SQLCODE: -805, NULLID.SYSLH20A 0X5359534C564C3031

Hi,

we are using db2 v8.2 on windows. Have a error while run the
application,

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

normally i saw the error for package SYSLH203 , but never know what is
for SYSLH20A,

can someone tell me what could it be? tks

Mar 21 '06 #1
  • viewed: 5962
Share:
2 Replies
This is from DB2 Manual

Depending on the type of statement you are executing, DB2 will use a
particular package on the server. By default DB2 creates three packages
for each type of package. In this case NULLID.SYSLH2yy is reserved for
statements with CURSORHOLD on and isolation level Cursor Stability. You
can create more packages on the server by connecting to the database
and issuing the following bind command from the /sqllib/bnd directory:

db2 bind @db2cli.lst blocking all grant public sqlerror continue CLIPKG
5
Note: CLIPKG 5 will create 5 large packages, and will give you the
package that your application is looking for, as well as one more in
this case.

You can go all the way upto CLIPKG 30

cheers...
Shashi Mannepalli

Mar 21 '06 #2
Shashi Mannepalli wrote:
This is from DB2 Manual

Depending on the type of statement you are executing, DB2 will use a
particular package on the server. By default DB2 creates three packages
for each type of package. In this case NULLID.SYSLH2yy is reserved for
statements with CURSORHOLD on and isolation level Cursor Stability. You
can create more packages on the server by connecting to the database
and issuing the following bind command from the /sqllib/bnd directory:

db2 bind @db2cli.lst blocking all grant public sqlerror continue CLIPKG
5
Note: CLIPKG 5 will create 5 large packages, and will give you the
package that your application is looking for, as well as one more in
this case.

You can go all the way upto CLIPKG 30

cheers...
Shashi Mannepalli

You can also use:
db2jdbcbind.exe -url jdbc:db2://SERVER/DATABASE -user DB_USER -password
DB_PASSWORD -size 300
--
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~
| Gregor Kovac | Gr**********@mikropis.si |
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| In A World Without Fences Who Needs Gates? |
| Experience Linux. |
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~
Mar 27 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

12 posts views Thread by Bob Stearns | last post: by
5 posts views Thread by Raj | last post: by
2 posts views Thread by Richard | last post: by
3 posts views Thread by barmatt80 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.