Toad World® Forums

unable to connect db2

i am using Toad Data Modeler Trail, I am getting the below error while i am trying to connect db2, I verified in db2 that “Systables” are located in QSYS2 instead of SysIBM library, but it is trying to located SYSIBM table.

Source: Toad Data Modeler - Internal error
Script: REDataMigratorDBDBzOS
Description: [IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0204 - SYSTABLES in SYSIBM type *FILE not found.
Row: 219
Column: 3

“REDataMigratorDBDBzOS” from package “Object RE Database for DB2zOS”

Please check and let me know to proceed further

Are you attempting to access DB2 on iSeries or DB2 on z/OS?

Hello there,

TDM does not currently support DB2 for iSeries, it supports DB2 for zOS and LUW (you can find more information in TDM Help | Databases | Supported Databases)