PM69854: DB2 ADMINISTRATION TOOL FOR Z/OS GENERATED UNLOAD LOB USING PDSE RESULTS IN LONG EXECUTION TMES AS COMPARED WITH USING VBS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS generated UNLOAD LOB using PDSE
  results in long execution times as compared with UNLOAD to VBS
  PS in DB2 V10 NFM
  

Local fix

• Modify control card manually to unloaad to VBS PS by adding :
  .
  SHRLEVEL REFERENCE NOPAD SPANNED YES
  .
  to the UNLOAD statement generated by the Tool
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use Catalog Copy.                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using the Catalog Copy function    *
  *                      to copy the DB2 system catalog to a     *
  *                      User defined catalog, the DB2           *
  *                      Administration Tool generates an        *
  *                      UNLOAD LOB statement using a            *
  *                      Partitioned Data Set Extended           *
  *                      (PDSE), which results in a longer       *
  *                      execution time as compared to an        *
  *                      UNLOAD to a Variable Block              *
  *                      Spanned (VBS) PS in DB2 10 New          *
  *                      Function Mode (NFM).                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  DB2 Administration Tool for z/OS Catalog Copy should support
  UNLOAD LOB (except LOB in SYSIBM.SYSJAVA) to Variable Block
  Spanned (VBS) PS in DB2 10 NFM.
  
  SYSIBM.SYSJAVA contains more than one table, and Catalog
  Copy unloads data at the tablespace level, which means
  unloading all the tables in SYSIBM.SYSJAVA, as a result the
  LOB column will not be at the end of the unload record, which
  will cause the unload to VBS PS data set to fail with the
  following error:
  
  DSNU1233I #SSID- 261
  DSNUULVA - DATA IS TOO LONG FOR
  FIELD JAR_DATA, TABLE SYSIBM.SYSJAROBJECTS
  DSNU1219I #SSID- THE NUMBER OF RECORDS IN
  ERROR REACHED THE LIMIT 1
  

Problem conclusion

• Problem has been resolved so that when a tablespace contains
  only one DB2 catalog table and this table has one or more LOB
  columns, Catalog Copy will UNLOAD the LOB to the VBS data sets
  and then LOAD the columns into the user defined catalog tables.
  

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:

  UK82921 UK82922

Modules/Macros

•    ADB2CCV
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK82921

     UP12/10/30 P F210

• RA20 PSY UK82922

     UP12/10/30 P F210

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.