PK70013: ADMIN LOB SUPPORT

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• ADMIN LOB SUPPORT
  ADMIN XML SUPPORT FOR DB2 9 UTILITIES.    (PK76039)
  REBALANCE SUPPORT FOR DB2 R810 UTILITIES. (PK06233)
  DB2 ADMIN ALC RC=8 ON LOAD STEP WHEN USING DSNTIAUL WITH USE
  CUSTOMIZED UTILITY OPTIONS=YES. (PK67248)
  

Local fix

• APPLY PTF.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool V72 who     *
  *                 wish to change or unload tables with LOB     *
  *                 columns.                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: Changes  to objects  with LOB  columns  *
  *                      was  previously restricted  or had the  *
  *                      limited capability.  Additionally, LOB  *
  *                      column data was unloaded to the SYSREC  *
  *                      data set,  with the limitations on the  *
  *                      maximum record length allowed.          *
  *                                                              *
  *                      With this APAR, change functions which  *
  *                      limited  or restricted the changing of  *
  *                      LOB  columns  now  have  the  expanded  *
  *                      capabilities  to  allow changing those  *
  *                      objects.                                *
  *                                                              *
  *                      Additionally,objects with LOB columns   *
  *                      can now  be unloaded with  base table   *
  *                      data going to the SYSREC data set and   *
  *                      the LOB column data going to the data   *
  *                      set  as directed by the LOB TEMPLATE.   *
  *                      This capability requires that the job   *
  *                      be built as a work statement list.      *
  *                                                              *
  *                      The MIGRATE function supports unloading *
  *                      LOBs either using a work statement list *
  *                      or using JCL.                           *
  *                                                              *
  *                      For Change  Management installations,   *
  *                      APAR PK70014 is required,  which also   *
  *                      delivers  similar  function  for  DB2   *
  *                      Object Comparison Tool.                 *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  This APAR delivers the supporting elements in DB2
  Administration  Tool to allow changing of objects
  with LOB columns,and to unload LOB column data to
  a separate output data set using a LOB TEMPLATE.
  

Problem conclusion

Temporary fix

Comments

• Apply the PTF to enable this support.
  ×**** PE09/03/10 PTF IN ERROR. SEE APAR PK81961  FOR DESCRIPTION
  

APAR Information

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

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

  UK42507

Modules/Macros

•    ADBBIND  ADBCCMM  ADBCDTS  ADBCEST  ADBCMPC
  ADBCPRE  ADBCVEX  ADBCVOB  ADBETEP  ADBFB2VB ADBHCUS7 ADBHUSC
  ADBHUSE  ADBHUSK  ADBHUSO  ADBHUSQ  ADBHUS2  ADBHUXK  ADBHUXO
  ADBHUXO1 ADBHZ2B1 ADBH5LE  ADBH7C   ADBMAIN  ADBP9000 ADBR
  ADBSR    ADBTEPU  ADBTEP2  ADBTTP   ADB1000  ADB2CBND ADB2CCA
  ADB2CLKS ADB2CUST ADB2CVC  ADB2DEP  ADB2DF   ADB2DIP  ADB2GENX
  ADB2LOBS ADB2PA   ADB2PARM ADB2PA5  ADB2PA6  ADB2RE   ADB2REE
  ADB2REG  ADB2REM  ADB2REP  ADB2RER  ADB2RES  ADB2RET  ADB2REU
  ADB2REY  ADB2REZ  ADB2RGC  ADB2RPT  ADB2TEP  ADB2U    ADB2UCU0
  ADB2US   ADB2USC  ADB2USCO ADB2USE  ADB2USH2 ADB2USK  ADB2USKO
  ADB2USO  ADB2USOP ADB2USQ  ADB2USU  ADB2US0  ADB2US2  ADB2US2O
  ADB2UT   ADB2UTH1 ADB2UTUL ADB2UT0  ADB2UX   ADB2UXK  ADB2UXKO
  ADB2UXO  ADB2UXOO ADB2UXO1 ADB2WCL  ADB2WL4  ADB2W1   ADB2Z2U
  ADB21D   ADB21DAJ ADB21S   ADB21SAC ADB21SAJ ADB21SP  ADB21T
  ADB21TAC ADB21TAF ADB21TAN ADB21TAP ADB21TAU ADB21XA  ADB21XAA
  ADB21XAR ADB23    ADB230   ADB231   ADB2310  ADB2311  ADB2312
  ADB2313  ADB232   ADB234   ADB235   ADB25L   ADB25LD  ADB25LE
  ADB25LEA ADB25T   ADB25TC  ADB25TE  ADB25TL1 ADB25TU  ADB25TU3
  ADB26CTP ADB26CTU ADB26CX  ADB27    ADB27A   ADB27AC  ADB27C
  ADB27CA  ADB27CAA ADB27CR  ADB27CU  ADB27CX  ADB27C0  ADB27DUP
  ADB27IFF ADB27PC  ADB27PTR ADB27TL  ADB27TUL ADB28ADD ADB28ASD
  ADB28ATD ADB28CR  ADB28HPU ADB28M   ADB28MC  ADB28M2  ADB28PC
  ADB28S   ADB28T   ADB28UL1 ADB28UT  ADB29    ADB5000  ADB52
  ADB70    ADB71    ADB72    H0IH720J
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK42507

     UP08/12/24 P F812

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.