Oracle Database Provider for DRDA: DRDA or DB2 Clients Fail to Connect Using Encryption and Receive an Error Message Stating "Permanent Agent Error" or "SQL1224N The database manager is not able to accept new requests". (Doc ID 2730678.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database Provider for DRDA - Version 19.3.0.0 and later
Information in this document applies to any platform.

Calls to SQLConnect() return error code -1 (SQL_ERROR)

Calling SQLGetDiagRec() to retrieve error messages returns one or more of the following similar error codes, sqlstates and messages:

Configuration for encryption in the following client scenarios:

DB2 for z/OS:

Remote DRDA server entries in table SYSIBM.IPNAMES with SECURITY_OUT options: 'E', 'P'

DB2 for LUW:

db2 CATALOG TCPIP NODE with AUTHENTICATION options: SERVER_ENCRYPT, SERVER_ENCRYPT_AES, or DATA_ENCRYPT

	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.