Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / DB2 Topics / March 2006

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
db2group88 - 21 Mar 2006 19:05 GMT
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
Shashi Mannepalli - 21 Mar 2006 19:55 GMT
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
Gregor Kovač - 27 Mar 2006 09:55 GMT
> This is from DB2 Manual
>
[quoted text clipped - 15 lines]
> cheers...
> Shashi Mannepalli
You can also use:
db2jdbcbind.exe -url jdbc:db2://SERVER/DATABASE -user DB_USER -password
DB_PASSWORD -size 300
Signature

-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~

| Gregor Kovac | Gregor.Kovac@mikropis.si    |
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| In A World Without Fences Who Needs Gates? |
|            Experience Linux.               |
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.