PM83934: DB2 ADMIN TOOL IGNORES THE INLINE COMMENTS IN IN A VIEW WHEN USING REVERSE ENGINEERING TO GET THE DDL FOR THE VIEW

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS ignores the inline comments in
  a view when using reverse engineering to get DDL for the view
  ONCODE150 in ADB2REE.
  

Local fix

Problem summary

•   USERS AFFECTED: Users of the DB2 Administration Tool for
                    z/OS who use the Generate (GEN  DDL, and
                    Migrate (MIG  commands to generate DDL for
                    a view that has embedded SQL comments.
  
    PROBLEM DESCRIPTION: The GEN and DDL commands did not
                         support generating SQL comments within
                         a view. The MIG command did not
                         support generating embedded SQL
                         comments for a view when extracting
                         DDL.
  
    RECOMMENDATION:
  
  The GEN and DDL commands generated a view but without the
  embedded SQL comments even though the SQL comments exist in
  the view text stored in DB2. The MIG command did not support
  generating embedded SQL comments for a view when extracting
  DDL.
  

Problem conclusion

• A new GEN and MIG option 'Include SQL comments' has been
  added to give the user control of whether a view is generated
  with or without embedded SQL comments on panels ADB2GEN
  'Generate SQL from DB2 catalog' and ADB28M 'Migrate
  Parameters'.  The default is the existing behavior which is
  not to generate the SQL comments.
  
  These new options are only available when GEN or MIG are run
  in Batch and no Work Statement List (WSL , and the DDL output
  is designed to be run in SPUFI or DSNTEP4.  The DB2
  Administration Tool for z/OS Batch Restart Program ADBTEP2
  can also be used to run the DDL if the following option is
  manually added to the ADBTEPIN DD statement:
  
    SQLFORMAT = 'SQLCOMNT'
  
  The SADBSAMP(ADBTEP2R  sample job can be used to construct a
  job to run ADBTEP2.
  

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:

  UK95179 UK95180

Modules/Macros

• ADBHGEN  ADBH8M   ADBH8MV  ADBP8MV  ADB2GEN  ADB2GEN2 ADB2RE
  ADB2REE  ADB2REG  ADB2REH  ADB2REZ  ADB28M   ADB90
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK95179

     UP13/06/19 P F306

• RA20 PSY UK95180

     UP13/06/19 P F306

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.