PI13696: SQLCODE303 AFTER FALLBACK FROM DB2 10 CM TO V9 NFM

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• After a fallback from DB2 V10 CM to V9 NFM,
  DB2 HPU fails after issuing the following message:
  
   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 (DSNDB04.TCRMPT)
  
  PB12244 SQLCODE303
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: After a fallback from DB2 V10 CM to V9  *
  *                      NFM, DB2 HPU fails after issuing the    *
  *                      following message:                      *
  *                       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       *
  *                       (DSNDB04.TCRMPT)                       *
  *                      pb 12244                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  The odb2ctrl and odb2cmd  modules were changed.
  

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

•    INZUTILK INZUTILX
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R410 PSY UI16431

     UP14/04/01 P F403

• R420 PSY UI16432

     UP14/04/01 P F403

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.