If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Missing NULLID.SQLLD003 package

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-21-04, 16:47
marcfuqua marcfuqua is offline
Registered User
 
Join Date: Mar 2002
Posts: 5
Missing NULLID.SQLLD003 package

Environment:
Server: DB2 V8.1 with fixpak 3 running on AIX V5.1 maintenance level ??
Client: DB2 V7.2 with fixpak 8 running on AIX V5.1 maintenance level ??

We're receiving an SQL0805N error (SQLSTATE=51002) with the missing package being NULLID.SQLLD003. I've tried the 'usual' binds (db2 bind ... blocking all grant public) from the client using the db2ubind.lst & db2cli.lst bind lists, but the problem still exists.

Does anyone know what is used to create SQLLD003 and/or what the 'purpose' is of that package?

Thanks for your time & assistance.

Marshall
Reply With Quote
  #2 (permalink)  
Old 01-23-04, 15:50
UnicornLtd UnicornLtd is offline
Registered User
 
Join Date: Oct 2003
Posts: 5
Well, I can help with part of your question:

All CLI packages start with SQLL, the dynamic packages have a format of SQLLyzxx

y = Size and cursor hold:
F - small with hold
C - small no hold
D - big with hold
E - big no hold

z = Isolation level:
0 - Cursor Stability
1 - No Commit (as/400 only)
2 - uncommitted read
3 - read stability
4 - repeatable read

xx = copy number in hex


Have you checked to see if this package is actually missing? Sometimes, it is there but the user doesn't have execute privilege.

Last edited by UnicornLtd; 01-23-04 at 15:54.
Reply With Quote
  #3 (permalink)  
Old 01-23-04, 15:53
UnicornLtd UnicornLtd is offline
Registered User
 
Join Date: Oct 2003
Posts: 5
Just noticed your versions. I strongly suggest applying the 10a fixpack to the client.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On