Results 1 to 7 of 7
  1. #1
    Join Date
    Mar 2009
    Posts
    36

    Unanswered: Binding packages in db2 OS/400

    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

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    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

  3. #3
    Join Date
    Mar 2009
    Posts
    36
    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..

  4. #4
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    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

  5. #5
    Join Date
    Mar 2009
    Posts
    21
    Thank you very much db2girl...I will try this tomorrow.

  6. #6
    Join Date
    Mar 2002
    Posts
    11

    Binding to DB2 OS/400

    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

  7. #7
    Join Date
    Aug 2013
    Posts
    1
    the id used to do binding need to have full rights to the NULLID library

    or

    grant *SECADM special authority to the id, do the binding, then remove the *SECADM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •