PM45602: ADBTEP2 GIVES "ADMIN IF DEFINEYES TB" AS FALSE, BUT THE TABLESPACE WHICH CONTAINS THE TABLE HAS DEFINE YES.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ADBTEP2 gives "ADMIN IF DEFINEYES TB" as false, but
  the tablespace which contains the table has DEFINE YES.
  This can result in an UNLOAD not being generated.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: Object qualifiers are not being         *
  *                      determined correctly when extra spaces  *
  *                      are provided around the separating      *
  *                      period (e.g. "SCHEMA" ."OBJECT") or     *
  *                      when the object qualifiers reach their  *
  *                      maximum size of 128 characters.         *
  *                                                              *
  *                      Also, the qualifiers are not            *
  *                      determined correctly if the qualifier   *
  *                      has an embedded period. This issue      *
  *                      does not result in an error but         *
  *                      rather the object is incorrectly        *
  *                      determined to be undefined whereby      *
  *                      the subsequent UNLOAD will be           *
  *                      skipped.                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Program has been changed to correctly determine all qualifiers
  correctly regardless of length or the presence of extraneous
  blanks around the separating period. Additionally, the program
  will fail if an object in an ADMIN IF DEFINEYES statement is
  not found in the DB2 catalog to prevent any UNLOAD from being
  skipped. If this error occurs, the following message will be
  produced:
  
  ADB5079E ADMIN IF statement object does not exist:
  <qual1>.<qual2>
  The qualifiers will vary depending on whether the object is a
  table space or a table.
  

Problem conclusion

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

  UK71416 UK71417

Modules/Macros

•    ADBTEPR  ADBTEP2  ADB2W1   ADB5000
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK71416

     UP11/09/02 P F109

• R720 PSY UK71417

     UP11/09/02 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.