Results 1 to 3 of 3
  1. #1
    Join Date
    May 2006
    Posts
    2

    Unanswered: Problem in loading data from Datastage, SQLSTATE=38112

    Dear All,

    I am a new member of this fourm and need one help.

    I am getting the following error while loading the Data in DB2 Tables via Datastage.

    staodsXelusSUPLPROPLoadUpd..ODS_SUPL_PROP_upd: [IBM][CLI Driver][DB2] SQL0443N Routine "SQLTABLES" (specific name "SQLTABLES") has returned an error SQLSTATE with diagnostic text "SQLCODE=-805 MVSADM1_DBN1.DSN". SQLSTATE=38112

    SQLTables: Error retrieving system catalog information for requested tables(s).



    The procedure SQLTABLEs is already installed on the system .
    If any one of you has faced similar problem, please help. This is very urgent.

    Thanks
    Surabhi

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    -805 is a package not found. You probably need to do a remote rebind of the client on the DB2 MVS system.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    May 2006
    Posts
    2
    Thanks Marqus, it is working now.

Posting Permissions

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