Hi All,
I am getting the following error. So I tried to bind the packages but.. I am a DB2 DBA for LUW and have no clue how the commands works for os/400.

Please help asap. what are the steps thats needs to be followed.

DB2 Version : 8.1.0.0
OS version : HP-UX B.11.11 U 9000/800


[IBM][CLI Driver][AS] SQL0805N Package "NULLID .SYSSH000" was not found. SQLSTATE=51002

sqlstate = 51002

Try the following

From DB2 HP-UX:

cd .../sqllib/bnd
db2 connect to <DBALIAS> user <USERID> using <PASSWORD>
db2 bind @ddcs400.lst blocking all sqlerror continue grant public
db2 connect reset

Thanks db2girl for your reply...I have tried that option but...it is giving error as SQL0204N "QSYS.NULLID" is undefined name.. for all the packages..

Can anyone has come accross this error? Please help me..

Here is some info that may help:

Your DB2 for iSeries DBA must create the 'NULLID' collection.

A NULLID collection should be created and object authority CHANGE or higher on the NULLID collection should be granted to your userid that tries to connect to AS400 from client.

This collection does not exist by default on the AS/400. You have to create this collection, using either the SQL statement CREATE COLLECTION NULLID or the crtlib statement CRTLIB LIB(NULLID).

After you have successfully connected from the DB2 LUW to the AS/400, you will be binding db2 utilities against this AS/400. When binding the DB2 packages, the user must have sufficient authority to create packages in the library on the AS/400. One way to achieve this is to create an authorization list of db2 connect users with the ability to bind. Use the CRTAUTL command to create the list and specify this list in the CRTLIB ... i.e. CRTLIB LIB(NULLID) AUT(UDBBNDAUTL), where UDBBNDAUTL is your authorization list

Thank you very much db2girl...I will try this tomorrow.

I am trying to configure a connections from DB2 Connect Personal Edition on Linux to DB2 database on OS/400 (iSeries). The install and instance creation is done, but I can't complete the binding part - all I get is error messages:
"LINE MESSAGES FOR db2ubind.lst
------ --------------------------------------------------------------------
SQL0061W The binder is in progress.

LINE MESSAGES FOR db2ajgrt.bnd
------ --------------------------------------------------------------------
SQL0038W The bind option SQLERROR CONTINUE has been
activated since it is required when binding this DB2-supplie
list file to DB2/MVS, SQL/DS, or OS/400.
SQL0551N "" does not have the privilege to perform operation
"" on object "QSYS.NULLID". SQLSTATE=42501
SQL0551N "" does not have the privilege to perform operation
"" on object "NULLID.SQLABG02". SQLSTATE=42501
SQL0551N "" does not have the privilege to perform operation
"" on object "NULLID.SQLABG02". SQLSTATE=42501

LINE MESSAGES FOR db2ueiwi.bnd
------ --------------------------------------------------------------------
SQL0038W The bind option SQLERROR CONTINUE has been
activated since it is required when binding this DB2-supplie
list file to DB2/MVS, SQL/DS, or OS/400."

And so on...

Please let me know if all I need is to have the DBAs on that iSeries do the following:

CRTLIB LIB(NULLID)

or if it might be an indication of something else.

I ran standard commands:
db2 terminate
db2 CONNECT TO dbname
db2 BIND path\@ddcs400.lst BLOCKING ALL SQLERROR CONTINUE GRANT PUBLIC ACTION ADD
db2 terminate