PM53236: HPU UNLOAD ENDS WITH COMPLETION CODE SQLCODE -303

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The unload ends with completion code 8 after having reported
  SQLCODE = -303 and issues messages such as:
  
   DSNT408I SQLCODE = -303, ERROR:
            A VALUE CANNOT BE ASSIGNED TO OUTPUT HOST
            VARIABLE NUMBER 55 BECAUSE THE DATA TYPES ARE NOT
                                                    COMPARABLE
   DSNT418I SQLSTATE   = 42806 SQLSTATE RETURN CODE
   DSNT415I SQLERRP    = DSNXROHB SQL PROCEDURE DETECTING ERROR
   DSNT416I SQLERRD    = -310  0  0  452  55  0 SQL
                                           DIAGNOSTIC INFORMATION
   DSNT416I SQLERRD    = X'FFFFFECA'  X'00000000'  X'00000000'
  
  X'000001C4'
            X'00000037'  X'00000000' SQL DIAGNOSTIC INFORMATION
   DSNT417I SQLWARN0-5 = W,,,W,, SQL WARNINGS
   DSNT417I SQLWARN6-A = ,,,,   SQL WARNINGS
   INZU020E ERROR WHILE RETRIEVING TABLESPACE INFO FROM THE
  CATALOG
   INZU366I UTILITY RETURN CODE 8 (REASON CODE 0x120a003)
  
  This occurs where:
  - the DB2 subsystem against which the unload is run is a
    member of a data sharing group
  - the DB2 subsystem has a level lower than V1010
  - the data sharing group DB2 level is V1010
  
  PB11328     SQLCODE303
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: HPU 4.1 only: The unload ends with      *
  *                      completion code 8 after having          *
  *                      reported SQLCODE = -303 and issues      *
  *                      messages such as:                       *
  *                      DSNT408I SQLCODE = -303, ERROR:  A      *
  *                       VALUE CANNOT BE ASSIGNED TO OUTPUT     *
  *                       HOST VARIABLE NUMBER 55 BECAUSE THE    *
  *                       DATA TYPES ARE NOT COMPARABLE          *
  *                      DSNT418I SQLSTATE   = 42806 SQLSTATE    *
  *                       RETURN CODE                            *
  *                      DSNT415I SQLERRP    = DSNXROHB SQL      *
  *                       PROCEDURE DETECTING ERROR              *
  *                      DSNT416I SQLERRD    = -310  0  0  452   *
  *                        55  0 SQL DIAGNOSTIC INFORMATION      *
  *                      DSNT416I SQLERRD    = X'FFFFFECA'       *
  *                        X'00000000'  X'00000000'  X'000001C4' *
  *                               X'00000037'  X'00000000' SQL   *
  *                       DIAGNOSTIC INFORMATION                 *
  *                      DSNT417I SQLWARN0-5 = W,,,W,, SQL       *
  *                       WARNINGS                               *
  *                      DSNT417I SQLWARN6-A = ,,,,   SQL        *
  *                       WARNINGS                               *
  *                      INZU020E ERROR WHILE RETRIEVING         *
  *                       TABLESPACE INFO FROM THE CATALOG       *
  *                       (BAD03075.BBTSR001)                    *
  *                      INZU366I UTILITY RETURN CODE 8          *
  *                       (REASON CODE 0x120a003)                *
  *                      This occurs where:                      *
  *                      - the DB2 subsystem against which the   *
  *                       unload is run is a member of a data    *
  *                       sharing group                          *
  *                      - the DB2 subsystem has a level lower   *
  *                       than V1010                             *
  *                      - the data sharing group DB2 level is   *
  *                       V1010                                  *
  *                      PB 11328                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  odb2cmd ,odb2ctrl, inzquery, inzqryv8 and inzmain   modules
  were changed so the relevant function is used according to the
  DB2 release.
  

Problem conclusion

• APPLY the PTF.
  

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:

Modules/Macros

•    INZRSAVE
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R410 PSY UK77750

     UP12/04/12 P F204

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.