A fix is available
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 number
PM29201
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
720
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-12-17
Closed date
2011-04-01
Last modified date
2011-05-02
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
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.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"720","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
02 May 2011