PM77761: MISLEADING MESSAGE '(W)THE LOB OBJECT HAS BEEN CHANGED FROM EXPL ICIT TO IMPLICIT.' AS SOURCE AND TARGET DDL ARE BOTH IMPLICIT.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Object Comparison Tool for z/OS issues a message:
  "(W)The LOB object has been changed from explicit to implicit.
     Please check the consistency between the number of auxiliary
  tables and the the number of LOB objects"
  when comparing source and target DDL which have implicit LOB
  objects.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison Tool      *
  *                 for z/OS who compare source objects with     *
  *                 target objects which have LOB columns        *
  *                 and LOB objects.                             *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Object Comparison Tool for      *
  *                      z/OS issues unexpected warning          *
  *                      message:                                *
  *                                                              *
  *                      '(W)The LOB object has been             *
  *                      changed from explicit to implicit.      *
  *                      Please check the consistency            *
  *                      between the number of auxiliary         *
  *                      tables and the number of LOB            *
  *                      objects'                                *
  *                                                              *
  *                      when comparing source and target        *
  *                      DDLs that both use implicit LOB         *
  *                      objects.                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  DB2 Object Comparison Tool for z/OS issues an unexpected
  warning message:
  
  '(W)The LOB object has been changed from explicit to implicit.
  Please check the consistency between the number of auxiliary
  tables and the number of LOB objects'
  
  when comparing source and target DDLs that both use implicit
  LOB objects.
  

Problem conclusion

• Problem has been resolved. The message has been updated to
  deliver accurate and clear information for the situation.
  
  DB2 has the following requirements on defining large objects:
  
  If the base table is nonpartitioned, user must create one LOB
  table space and one auxiliary table for each LOB column.
  If the base table is partitioned, user must create one LOB
  table space and one auxiliary table for each LOB column in
  each partition.
  
  According to this DB2 requirements, DB2 Object Compare
  performs consistency check while processing the LOB
  objects. If it is found that on source, the number of
  LOB objects is not consistent with the number of LOB
  columns,  DB2 Object Compare will recreate the LOB
  objects implicitly to ensure the LOB objects are defined
  completely after applying the changes.  The following
  message will be issued to inform the user of the
  situation.
  
  For non-partitioned table space:
  
  ADB7162I The number of auxiliary tables on source is not
  consistent with the number of LOB columns. The LOB objects
  will be recreated implicitly. Please check there is one
  auxiliary table for each LOB column after applying the
  changes.
  
  For partitioned table space:
  
  ADB7163I The number of auxiliary tables on source is not
  consistent with the number of LOB columns and the number of
  partitions of the table space. The LOB objects will be
  recreated implicitly. Please check there is one
  auxiliary table for each LOB column in each partition
  after applying the changes.
  

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:

  UK92575 UK92576

Modules/Macros

•    ADB2CMT  ADB7000
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK92575

     UP13/03/19 P F303

• RA20 PSY UK92576

     UP13/03/19 P F303

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.