PH39472: DB2 OBJECT COMPARISON TOOL ISPD014 ADBGAJOB NOVALUE CONDITION VARIABLE NAME TABLESPACE PARTITION CHANGE TABLE EXCLUDED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In an Object Compare job, if a change is made to the
  partitioning of a tablespace (for example, changing the value
  of NUMPARTS), but the table in that tablespace is excluded from
  the compare, then the following error may occur when generating
  the JCL:
  
  FUNCTION = ADBGAJOB, LINE 13458: If name = '' Then
  
  RC = 8
  
  ZERRMSG = ISPD014
  ZERRSM = Novalue condition raised for variable NAME
  ZERRLM = Error executing EXEC - now terminating
  
  ISPD117
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using Change Management (CM)       *
  *                      batch  with an exclude specification    *
  *                      on a table, an error occurs during the  *
  *                      building of the JCL.                    *
  ****************************************************************
  When using CM batch to change the number of partitions in a
  range-partitioned universal table space (UTS) with an exclude
  specification on the table in that table space, the following
  error occurs and terminates the CM batch job:
  
  FUNCTION = ADBGAJOB, LINE 13458: If name = '' Then
  RC = 8
  ZERRMSG = ISPD014
  ZERRSM = Novalue condition raised for variable NAME
  ZERRLM = Error executing EXEC - now terminating
  

Problem conclusion

• The problem 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:

  UI77203

Modules/Macros

• ADBGAJOB
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI77203

     UP21/09/21 P F109

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.