PM29201: GEN ON VIEW OMITS CREATE TRIGGER OPTION ON ADB2GEN PANEL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In DB2 Administration Tool for z/OS panel ADB21T users who use
  line command, GEN , on a VIEW object, are presented with panel
  ADB2GEN which omits the option:
    CREATE TRIGGER . . . . . Y (Y,N,D)
  .
  This option should be available for DB2 v9 NFM and later.
  Problem only occurs when line command GEN is used on a VIEW
  object. Using primary command GEN from the command line does
  produce the TRIGGER option in subsequent ADB2GEN panel.
  

Local fix

• Add the following parm to the GEN job, before submitting:
    GENTRIG = 'Y'
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who issue the GEN or REP line command   *
  *                 on a view and want the option to generate    *
  *                 information for triggers defined on a view.  *
  ****************************************************************
  * PROBLEM DESCRIPTION: In DB2 Administration Tool for z/OS,    *
  *                      the options panel ADB2GEN 'Generate     *
  *                      SQL from DB2 catalog' and ADB2REP       *
  *                      'Generate Report from DB2 Catalog'      *
  *                      does not provide an option to generate  *
  *                      trigger information when the GEN or     *
  *                      REP line commands are issued on a view. *
  *                      In DB2 Administration Tool for z/OS     *
  *                      10, the GEN line and primary command    *
  *                      was not available on the ADB21V         *
  *                      'Views' panel.                          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Panels ADB2GEN and ADB2REP does not display the option for
  TRIGGER when issuing line command GEN or REP on a VIEW on the
  ADB21T 'Tables, Views and Aliases' panel.  The GEN line command
  and primary command are not supported on panel ADB21VV in DB2
  Administration Tool 10.
  

Problem conclusion

• Panels ADB2GEN and ADB2REP were modified to produce the TRIGGER
  option when issuing a GEN or REP line command on a view.  Panel
  ADB21VV was modified to support the GEN function in DB2
  Administration Tool 10.
  

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

•    ADBH1VV  ADB2GEN  ADB2GEN2 ADB2REP  ADB21VV
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK66436

     UP11/04/08 P F104

• R720 PSY UK66437

     UP11/04/08 P F104

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.