PI07131: DB2 ADMIN TOOL INCORRECTLY USES THE SCHEMA MASK TO MASK THE OWNE R OF A TABLE OR VIEW WHEN THE TABLE OR VIEW EXISTS ON A DB2 9.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Admin Tool incorrectly uses the SCHEMA mask to mask the
  owner of a table or view when the table or view exists on a DB2
  v9 NFM or later system, but the table or view was created prior
  to DB2 v9 NFM.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool for         *
  *                 z/OS who use the Generate (GEN) function     *
  *                 to generate a table on panel ADB2GEN         *
  *                 'Generate SQL from DB2 catalog' when         *
  *                 using SCHEMA MASK and specifying a value     *
  *                 for the 'Run SQLID' field, when the          *
  *                 table was created on a DB2 version           *
  *                 before DB2 9 New Function Mode (NFM),        *
  *                 and migrated to DB2 9 NFM and above.         *
  ****************************************************************
  * PROBLEM DESCRIPTION: DB2 Administration Tool for z/OS        *
  *                      incorrectly uses SCHEMA MASK to mask    *
  *                      the owner of the objects created        *
  *                      prior to DB2 9 NFM.                     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  SCHEMA mask incorrectly mask the owner of the objects that
  were created prior to DB2 9 NFM.
  

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:

Modules/Macros

• ADB2MSK  ADB2REG
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI14219

     UP14/01/16 P F401

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.