Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2005
    Location
    London, England
    Posts
    8

    Unanswered: Oracle --> DB2 --> Oracle

    I'm trying to perform a query to find the table names through a DB link.

    The database I'm on is Oracle, the query I'm running goes through a DB2 database which somehow sits on top of a Oracle system? or helps translates something that then writes/communicates data or something to the underlying Oracle database.

    So it's like

    OracleA --> DB2-- >Oracle ?!?!?!?!?

    Oracle dblink to DB2 which sits on to of oracle?

    anyway when I query from OracleA I get the following... can anyone help? I'm very very new to DB2. How can I make the below query work?

    select table_name from all_tables@chidb2 *
    ERROR at line 1:
    ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
    DSNT408I SQLCODE = -204, ERROR: OTGDB2.ALL_TABLES IS AN UNDEFINED NAME
    DSNT418I SQLSTATE = 42704 SQLSTATE RETURN CODE
    DSNT415I SQLERRP = DSNXOTL SQL PROCEDURE DETECTING ERROR
    ORA-28506: parse error in data dictionary translation for ALL_TABLES stored in
    sys.hs_all_dd
    ORA-28559: FDS_CLASS_NAME is DB2MVS_V6_10.1.0.2.0, FDS_INST_NAME is GADI
    ORA-00604: error occurred at recursive SQL level 1
    ORA-00942: table or view does not exist
    DSNT408I SQLCODE = -204, ERROR: OTGDB2.ALL_TABLES IS AN UNDEFINED NAME
    DSNT418I SQLSTATE = 42704 SQLSTATE RETURN CODE
    DSNT415I SQLERRP = DSNXOTL SQL PROCEDURE DETECTING ERROR
    ORA-02063: preceding 7 lines from CHIDB2
    Last edited by swma; 12-20-06 at 18:04.

  2. #2
    Join Date
    Jun 2006
    Posts
    471

    catalog

    in db2 the name is sysibm.systables for luw (name,creator)
    but in mvs-z/os I am not sure
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

Posting Permissions

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