Troubleshooting connections

Last updated: Dec 11, 2024

Use these solutions to resolve problems that you might encounter with connections.

IBM Db2 for z/OS: Error retrieving the schema list when you try to connect to a Db2 for z/OS server

When you test the connection to a Db2 for z/OS server and the connection cannot retrieve the schema list, you might receive the following error:

CDICC7002E: The assets request failed: CDICO2064E: The metadata for the column TABLE_SCHEM could not
 be obtained: Sql error: [jcc][10150] [10300][4.28.11] Invalid parameter: Unknown column name
 TABLE_SCHEM. ERRORCODE=-4460, SQLSTATE=null

Workaround: On the Db2 for z/OS server, set the DESCSTAT subsystem parameter to No. For more information, see DESCRIBE FOR STATIC field (DESCSTAT subsystem parameter).