PI64634: ABENDS0C4 OR INZU499E

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When unloading a LOB, if the TRIM option is in effect (TRIME YES
  specified in SYSIN or ULTRIM is set in PARMLIB), an abend 0C4 is
  obtained with the following traceback:
  
     4     _inzctrlhFindAuxRel
                       +0000017C  2980        INZUTILK
     5     _inzctrlhCheckEcsLobParam
                       +0000063A  8292        INZUTILK
     6     _inzctrlhCheckEcsCommonPost
                       +00000444  9014        INZUTILK
  
  Another symptom can be obtained :
  return code 8 with the following message :
  
  INZU499E ERROR: INFORMATION WAS NOT FOUND IN THE
  SYSIBM.SYSAUXRELS
           TABLE FOR THE FOLLOWING LOB COLUMN: COL_LOB.
  
  Example of SYSIN :
  
   UNLOAD TABLESPACE QUIESCE YES
   SELECT COL_LOB1
   FROM MZLFRD.TBDZAAFRD30601
   OUTDDN (FOUT01)
         TRIM YES
  
  OTHER KEYWORDS: PB44652 ABENDS0C4 ABEND0C4 S0C4 0C4
           INZU499E MSGINZU499E INZU499 MSGINZU499
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload         *
  ****************************************************************
  * PROBLEM DESCRIPTION: ABENDS0C4 OR INZU499E                   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When unloading a LOB, if the TRIM option is in effect (TRIME YES
  specified in SYSIN or ULTRIM is set in PARMLIB), an abend 0C4 is
  obtained with the following traceback:
  
     4     _inzctrlhFindAuxRel
                       +0000017C  2980        INZUTILK
  
     5     _inzctrlhCheckEcsLobParam
                       +0000063A  8292        INZUTILK
     6     _inzctrlhCheckEcsCommonPost
                       +00000444  9014        INZUTILK
  
  Another symptom can be obtained :
  return code 8 with the following message :
  
  INZU499E ERROR: INFORMATION WAS NOT FOUND IN THE
  SYSIBM.SYSAUXRELS
           TABLE FOR THE FOLLOWING LOB COLUMN: COL_LOB.
  
  Example of SYSIN :
  
   UNLOAD TABLESPACE QUIESCE YES
  SELECT COL_LOB1
  FROM MZLFRD.TBDZAAFRD30601
  OUTDDN (FOUT01)
        TRIM YES
  or if ULTRIM is set to YES in PARMLIB
  

Problem conclusion

• The inzctrlh was changed.
  

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:

  UI39125 UI39126

Modules/Macros

•    INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R420 PSY UI39125

     UP16/07/07 P F607

• R430 PSY UI39126

     UP16/07/07 P F607

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.