PH22138: -30020(00D35E74) ON CROSSLOADER WHEN SOURCE TABLE EMPTY

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When using cross-loader function of the LOAD utility to move
  data from one location
  to another, an SQLCODE -30020 for DRDA Exception condition with
  reason 00D35E74
  can occur. Problem occurs when:
  
  1. Source table is empty
  2. TCP/IP protocol is being used
  3. Cross-loader package (DSNUGSQL) is bound using DBPROTOCOL
  bind option DRDACBF.
  

Local fix

• BYPASS/CIRCUMVENTION:
  Workaround: Bind cross-loader package (DSNUGSQL) using
  DBPROTOCOL bind option DRDA.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Distributed Data Facility (DDF) users.                   *
  * Specifically users of the Db2 cross-loader                   *
  * Utility function that execute a SQL                          *
  * statement at a remote server.                                *
  * Db2 12 for z/OS users only.                                  *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * An SQLCODE -30020 with reason code                           *
  * X'220E' can occur when using the Db2                         *
  * cross-loader Utility function to                             *
  * execute a SQL statement at a remote                          *
  * server. A DSNL031I message is issued                         *
  * at the Db2 z/OS requester system with                        *
  * ERROR ID=DSNLZDTA5E74.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  An SQLCODE -30020 with reason code X'220E' (Data Descriptor
  Mismatch) can be erroneously issued when using the Db2
  cross-loader Utility function to execute a SQL statement at
  a remote server.
  This problem can occur when the source table is empty, and
  TCP/IP protocol is being used, and the Cross-loader package is
  bound DBPROTOCOL(DRDACBF).
  

Problem conclusion

• Db2 has been changed to correctly parse replies when no rows
  are returned using Db2 cross-loader Utility function in a
  distributed environment.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI69322

Modules/Macros

• DSNLZDTA
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI69322

     UP20/05/12 P F005

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.