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 DECEMBER 01, 2020
Applies to:Oracle Database Provider for DRDA - Version 188.8.131.52 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