IBM Support

SQL30021N received from DB2 Connect 9.7 FP4 when downlevel clients attempt connection

Flashes (Alerts)


Abstract

Upgrading DB2 Connect gateway to version 9.7 fix pack 4 causes clients to receive a SQL30021N error.

Content


Symptom:
SQL30021N Execution failed because of a Distributed Protocol Error that will affect the successful execution of subsequent commands and SQL statements: Manager "0x1440" at Level "9" not supported. SQLSTATE=58010

Cause:
The symptom is caused by a change that was introduced in DB2 Connect 9.7 Fix Pack 4 which sends incorrect DRDA data to the host database server.

Diagnosing the Problem:
You will encounter this symptom if you upgrade your DB2 Connect Gateway server to V9.7 FP4 and the clients that are connecting to the gateway are DB2 9.1 FP5 or below.

For example:
Client V9.1.5 -> DB2 Connect GW V9.7.4 -> DB2/zOS V9.1.5

Users Affected:
DB2 Connect servers affected:
DB2 9.7 FP4

DB2 Clients affected:
DB2 9.1 FP5, FP4, FP3, FP2, FP1

Workaround:
Possible workarounds to the issue are:
- Revert to previous fix pack release on the DB2 Connect Gateway
- Upgrade Clients to latest fix pack released

Resolution:
The resolution is to upgrade the DB2 Connect gateway to the fix pack level that contains the fix for APAR IC76415 which is DB2 9.7 Fix Pack 5.

Related Information

APAR IC76415

Download DB2 9.7 FP5

[{"Product":{"code":"SSEPDU","label":"Db2 Connect"},"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SSSNY3","label":"IBM Data Server Client Packages"},"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Component":" ","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.7","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
25 September 2022

UID

swg21509013

Page Feedback