Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2012
    Posts
    4

    Unanswered: SQL0805N Package "CTSDSN1.NULLID.SQLC2H22.4141414141464462" was not found

    Hi,

    I new to db2 mainframes. For my project i need to connect to db2 mainframe using DB2 Enterprise edition from my local.

    First i cataloged the database of db2 mainframe that i have got access.And i am bale to connect to the database in db2 mainframe.

    After connecting that , when try to query the tables it is showing that

    "SQL0805N Package "CTSDSN1.NULLID.SQLC2H22.4141414141464462" was not found.SQLSTATE=51002"

    This is the error i am getting.

    Anybody can help me in this connection. It should be helpful to me if anybody can give information on this this.

    Regards
    Ajeena

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    From DB2 Enterprise edition, cd to .../sqllib/bnd and bind ddcsmvs.lst.

  3. #3
    Join Date
    Nov 2012
    Posts
    4

    DB2 bind error

    Hi,



    I tried with "db2 bind @ddcsmvs.lst" in bnd directory

    i am getting the following things at last one error
    -

    LINE MESSAGES FOR ddcsmvs.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-supplied

    list file to DB2/MVS, SQL/DS, or OS/400.

    LINE MESSAGES FOR db2clist.bnd
    ------ --------------------------------------------------------------------
    SQL0038W The bind option SQLERROR CONTINUE has been
    activated since it is required when binding this DB2-supplied

    list file to DB2/MVS, SQL/DS, or OS/400.
    SQL0038W The bind option SQLERROR CONTINUE has been
    activated since it is required when binding this DB2-supplied

    list file to DB2/MVS, SQL/DS, or OS/400.

    LINE MESSAGES FOR db2clpcs.bnd
    ------ --------------------------------------------------------------------
    SQL0038W The bind option SQLERROR CONTINUE has been
    activated since it is required when binding this DB2-supplied

    list file to DB2/MVS, SQL/DS, or OS/400.
    SQL0551N "U343439" does not have the required authorization
    or privilege to perform operation "BINDADD" on object
    "CTSDSN1.NULLID.SQLC2H20.()". SQLSTATE=42501

    LINE MESSAGES FOR db2clprr.bnd
    ------ --------------------------------------------------------------------
    SQL0038W The bind option SQLERROR CONTINUE has been
    activated since it is required when binding this DB2-supplied

    list file to DB2/MVS, SQL/DS, or OS/400.
    SQL0551N "U343439" does not have the required authorization
    or privilege to perform operation "BINDADD" on object
    "CTSDSN1.NULLID.SQLC3H19.()". SQLSTATE=42501

    LINE MESSAGES FOR db2clpur.bnd
    ------ --------------------------------------------------------------------
    SQL0038W The bind option SQLERROR CONTINUE has been
    activated since it is required when binding this DB2-supplied

    list file to DB2/MVS, SQL/DS, or OS/400.
    SQL0551N "U343439" does not have the required authorization
    or privilege to perform operation "BINDADD" on object
    "CTSDSN1.NULLID.SQLC4H19.()". SQLSTATE=42501

    LINE MESSAGES FOR db2clprs.bnd
    ------ --------------------------------------------------------------------
    SQL0038W The bind option SQLERROR CONTINUE has been
    activated since it is required when binding this DB2-supplied

    list file to DB2/MVS, SQL/DS, or OS/400.
    SQL0551N "U343439" does not have the required authorization
    or privilege to perform operation "BINDADD" on object
    "CTSDSN1.NULLID.SQLC5H19.()". SQLSTATE=42501

    LINE MESSAGES FOR db2arxcs.bnd
    ------ --------------------------------------------------------------------
    SQL0038W The bind option SQLERROR CONTINUE has been
    activated since it is required when binding this DB2-supplied

    list file to DB2/MVS, SQL/DS, or OS/400.

    LINE MESSAGES FOR db2arxrr.bnd
    ------ --------------------------------------------------------------------
    SQL0038W The bind option SQLERROR CONTINUE has been
    activated since it is required when binding this DB2-supplied

    list file to DB2/MVS, SQL/DS, or OS/400.

    LINE MESSAGES FOR db2arxrs.bnd
    ------ --------------------------------------------------------------------
    SQL0038W The bind option SQLERROR CONTINUE has been
    activated since it is required when binding this DB2-supplied

    list file to DB2/MVS, SQL/DS, or OS/400.

    LINE MESSAGES FOR db2arxur.bnd
    ------ --------------------------------------------------------------------
    SQL0038W The bind option SQLERROR CONTINUE has been
    activated since it is required when binding this DB2-supplied

    list file to DB2/MVS, SQL/DS, or OS/400.

    LINE MESSAGES FOR db2uexpm.bnd
    ------ --------------------------------------------------------------------
    SQL0038W The bind option SQLERROR CONTINUE has been
    activated since it is required when binding this DB2-supplied

    list file to DB2/MVS, SQL/DS, or OS/400.

    LINE MESSAGES FOR db2uimpm.bnd
    ------ --------------------------------------------------------------------
    SQL0038W The bind option SQLERROR CONTINUE has been
    activated since it is required when binding this DB2-supplied

    list file to DB2/MVS, SQL/DS, or OS/400.

    LINE MESSAGES FOR db2ueiwi.bnd
    ------ --------------------------------------------------------------------
    SQL0038W The bind option SQLERROR CONTINUE has been
    activated since it is required when binding this DB2-supplied

    list file to DB2/MVS, SQL/DS, or OS/400.

    LINE MESSAGES FOR db2uimtb.bnd
    ------ --------------------------------------------------------------------
    SQL0038W The bind option SQLERROR CONTINUE has been
    activated since it is required when binding this DB2-supplied

    list file to DB2/MVS, SQL/DS, or OS/400.

    LINE MESSAGES FOR ddcsmvs.lst
    ------ --------------------------------------------------------------------
    SQL0082C An error has occurred which has terminated
    processing.
    SQL0091N Binding was ended with "5" errors and "15"
    warnings.



    Please check this error, Please help me.

    Regards
    Ajeena

  4. #4
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    You got sql0551n for several packages. DB2 was previously looking for package SQLC2H22 (CLP package). Did you try to query the table again? If you get sql0805n, you need to ask your mainframe DBA to give you BINDADD authority so that you can do the bind from your client machine and then they can revoke it from you. If they don't want to give it to you, they can connect using their own id and do the bind for you (from your client machine or any LUW with the same version/fixpack level).

  5. #5
    Join Date
    Nov 2012
    Posts
    4

    Getting another error while binding

    db2 bind @ddcsmvs.lst

    LINE MESSAGES FOR ddcsmvs.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-supplied

    list file to DB2/MVS, SQL/DS, or OS/400.

    LINE MESSAGES FOR db2clist.bnd
    ------ --------------------------------------------------------------------
    SQL0038W The bind option SQLERROR CONTINUE has been
    activated since it is required when binding this DB2-supplied

    list file to DB2/MVS, SQL/DS, or OS/400.
    SQL0038W The bind option SQLERROR CONTINUE has been
    activated since it is required when binding this DB2-supplied

    list file to DB2/MVS, SQL/DS, or OS/400.

    LINE MESSAGES FOR db2clpcs.bnd
    ------ --------------------------------------------------------------------
    SQL0038W The bind option SQLERROR CONTINUE has been
    activated since it is required when binding this DB2-supplied

    list file to DB2/MVS, SQL/DS, or OS/400.
    SQL0551N "U343439" does not have the required authorization
    or privilege to perform operation "CREATE IN" on object
    "CTSDSN1.NULLID.SQLC2H20.()". SQLSTATE=42501

    LINE MESSAGES FOR db2clprr.bnd
    ------ --------------------------------------------------------------------
    SQL0038W The bind option SQLERROR CONTINUE has been
    activated since it is required when binding this DB2-supplied

    list file to DB2/MVS, SQL/DS, or OS/400.
    SQL0551N "U343439" does not have the required authorization
    or privilege to perform operation "CREATE IN" on object
    "CTSDSN1.NULLID.SQLC3H19.()". SQLSTATE=42501

    LINE MESSAGES FOR db2clpur.bnd
    ------ --------------------------------------------------------------------
    SQL0038W The bind option SQLERROR CONTINUE has been
    activated since it is required when binding this DB2-supplied

    list file to DB2/MVS, SQL/DS, or OS/400.
    SQL0551N "U343439" does not have the required authorization
    or privilege to perform operation "CREATE IN" on object
    "CTSDSN1.NULLID.SQLC4H19.()". SQLSTATE=42501

    LINE MESSAGES FOR db2clprs.bnd
    ------ --------------------------------------------------------------------
    SQL0038W The bind option SQLERROR CONTINUE has been
    activated since it is required when binding this DB2-supplied

    list file to DB2/MVS, SQL/DS, or OS/400.
    SQL0551N "U343439" does not have the required authorization
    or privilege to perform operation "CREATE IN" on object
    "CTSDSN1.NULLID.SQLC5H19.()". SQLSTATE=42501

    LINE MESSAGES FOR db2arxcs.bnd
    ------ --------------------------------------------------------------------
    SQL0038W The bind option SQLERROR CONTINUE has been
    activated since it is required when binding this DB2-supplied

    list file to DB2/MVS, SQL/DS, or OS/400.

    LINE MESSAGES FOR db2arxrr.bnd
    ------ --------------------------------------------------------------------
    SQL0038W The bind option SQLERROR CONTINUE has been
    activated since it is required when binding this DB2-supplied

    list file to DB2/MVS, SQL/DS, or OS/400.

    LINE MESSAGES FOR db2arxrs.bnd
    ------ --------------------------------------------------------------------
    SQL0038W The bind option SQLERROR CONTINUE has been
    activated since it is required when binding this DB2-supplied

    list file to DB2/MVS, SQL/DS, or OS/400.

    LINE MESSAGES FOR db2arxur.bnd
    ------ --------------------------------------------------------------------
    SQL0038W The bind option SQLERROR CONTINUE has been
    activated since it is required when binding this DB2-supplied

    list file to DB2/MVS, SQL/DS, or OS/400.

    LINE MESSAGES FOR db2uexpm.bnd
    ------ --------------------------------------------------------------------
    SQL0038W The bind option SQLERROR CONTINUE has been
    activated since it is required when binding this DB2-supplied

    list file to DB2/MVS, SQL/DS, or OS/400.

    LINE MESSAGES FOR db2uimpm.bnd
    ------ --------------------------------------------------------------------
    SQL0038W The bind option SQLERROR CONTINUE has been
    activated since it is required when binding this DB2-supplied

    list file to DB2/MVS, SQL/DS, or OS/400.

    LINE MESSAGES FOR db2ueiwi.bnd
    ------ --------------------------------------------------------------------
    SQL0038W The bind option SQLERROR CONTINUE has been
    activated since it is required when binding this DB2-supplied

    list file to DB2/MVS, SQL/DS, or OS/400.

    LINE MESSAGES FOR db2uimtb.bnd
    ------ --------------------------------------------------------------------
    SQL0038W The bind option SQLERROR CONTINUE has been
    activated since it is required when binding this DB2-supplied

    list file to DB2/MVS, SQL/DS, or OS/400.

    LINE MESSAGES FOR ddcsmvs.lst
    ------ --------------------------------------------------------------------
    SQL0082C An error has occurred which has terminated
    processing.
    SQL0091N Binding was ended with "5" errors and "15"
    warnings.


    Please look into the error and help me

  6. #6
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    From IBM Information Management Software for z/OS Solutions Information Center

    Code:
    Bind packages	One of the following authorities and privileges:
    SYSADM or DBADM authority
    BINDADD privilege if required packages do not exist, and CREATEIN privilege on the schema
    ALTERIN privilege on the schema if the required packages exist
    BIND privilege on the required packages if they exist

    Not sure what it means by createin on schema. I think what you need is authority to create a package in collection NULLID. Your mainframe DBA would know what to grant you.

Posting Permissions

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