PH67525: MIG/TS LEVEL UNLOAD TABLESPACE MULTI TABLES WITH LOB AND SPANNED YES FAILED.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• MIG/TS level UNLOAD TABLESPACE MULTI TABLES with LOB and SPANNED
  YES failed.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS.   *
  ****************************************************************
  * PROBLEM DESCRIPTION: MIG function issue the following        *
  *                      message:                                *
  *                      DSNU1233I !DD1A 183 04:27:49.06         *
  *                      DSNUULVA - DATA IS TOO LONG FOR         *
  *                      FIELD CONTENT,...                       *
  ****************************************************************
  Issue #1:
  When the MIG function processes multi-table tablespace(s)
  (non-UTS) that has a mix of LOB and non-LOB table objects, the
  following error occurs:
  DSNU1233I !DD1A 183 04:27:49.06 DSNUULVA - DATA IS TOO LONG FOR
  FIELD CONTENT,...
  
  Issue #2:
  Error message "NOT DEFINED BECAUSE DUPLICATE NAME EXISTS IN
  CATALOG" occurs when using MOVETB command the second time.
  
  Issue #3:
  Submit of generated MIG Target job results in error
  SQLCODE = -204 due to auxiliary object type.
  

Problem conclusion

• Issue #1 has been resolved by ensuring the MIG function displays
  the following warning message when it detects non-UTS objects:
  ADB200E Warning: The MIG function has identified one or more
  multi-table Table Spaces that are not configured as Universal
  Table Spaces (UTS), which may lead to processing errors. To
  address this issue, return to the Databases panel ADB21D and
  execute the MOVETB command to convert the Table Spaces to UTS.
  Once the conversion is successfully completed, you may
  proceed with the MIG function to continue migrating objects.
  
  Issue #2 has been resolved.
  
  Issue #3 has been resolved.
  

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:

  UO06304

Modules/Macros

• ADB28M   ADB28S   ADB28SUB ADB2MVT2 ADBEDIAG ADBSMVTO
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RD10 PSY UO06304

     UP25/12/19 P F512

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.