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

in db2 the name is sysibm.systables for luw (name,creator)
but in mvs-z/os I am not sure