Oracle SQL Developer and IBM DB2 Z/OS Connection Throws SQLCODE=-204 (Doc ID 2976138.1) (Doc ID 2976138.1)

Last updated on SEPTEMBER 26, 2023

Applies to:

Oracle SQL Developer - Version 23.1 and later
Information in this document applies to any platform.

SQL Developer connects to IBM DB2 database using Drivers, but Object Navigator is not listing Objects and shows error as :

DB2 SQL Error: SOLCODE=-204,
SQLSTATE=42704,
SQLERRMC=SYSCAT.SCHEMATA, DRIVER =4.27.25

Vendor code -204

SQL Developer connects successfully and opens worksheet. SQL queries work fine from Worksheet.

	To view full details, sign in with your My Oracle Support account.
	Don't have a My Oracle Support account? Click to get started!

In this Document

Symptoms

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.