Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2005

    Unanswered: Catalog OS390 DB

    I need to catalog a OS/390 DB from DB2 8.2 on AIX. in os/390 db name is 12 characters when try to catalog fro aix I get sql1001N error.

    Can anybody tell how can I catalog ?


  2. #2
    Join Date
    May 2003
    You don't acutally use the real database name for OS/390. Database is a totally different meaning on DB2 for z/OS than for DB2 on Linux, UNIX, Windows.
    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
    Oct 2005

    to catalog z/OS databases you are using the subsystem name.
    this can have more than 8 characters, correct.

    Still: you need DB2 Connect for any LUW DB2 to access host data.
    in DB2 connect you will have a dcs entry mapping the long name to something short with 8 characters being used finally.

    First: ensure you have DB2 connect.
    Second: for host you need one additional catalog statement: catalog dcs ... to the usual catalog database, catalog tcpip ,
    third: if you dont feel sure about the statements, may be using the GUI of the Configuration Assistant (db2ca in V8, db2cca in V7) helps.

    I suppose you are not using a connect server instance at a different machine ?

Posting Permissions

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