PM81753: GEN/DDL COMMAND DOES NOT EXTERNALIZE FIELDPROC WITHOUT ROW ATTRIBUTES / WITH ROW ATTRIBUTES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' GEN / DDL functions
  does not externalize the 'WITH ROW ATTRIBUTES' / 'WITHOUT ROW
  ATTRIBUTES' for a CREATE TABLE statement's FIELDPROC.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Administration Tool for z/OS    *
  *                      Generate (GEN)  /  DDL functions do     *
  *                      not support 'WITH ROW ATTRIBUTES' /     *
  *                      'WITHOUT ROW ATTRIBUTES' for a          *
  *                      CREATE TABLE statement's EDITPROC.      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  DB2 Administration and DB2 Object Comparison Tool for z/OS does
  not support the DB2 statement 'CREATE TABLE...EDITPROC
  program-name WITH/WITHOUT ROW ATTRIBUTES'.
  

Problem conclusion

• Support added for the DB2 'CREATE TABLE...EDITPROC program-name
  WITH/WITHOUT ROW ATTRIBUTES' statement:
  
  - Users can use the 'CRE - Create a similar object' line
  command to create a table that has the 'WITH/WITHOUT
  ATTRIBUTES' option.
  
  - Users can use the 'CT - Create Table' command on panel
  ADB26 'Create/Drop/Label/Comment'. to create a table that
  has the 'WITH/WITHOUT ATTRIBUTES' option.
  
  - Users can use the 'ALT Alter Table' command to alter an
  EDITPROC for the table.
  
  - Users can use 'I- Details on table/view' line command or
  'DET - Show table details and related object information' line
  command to view 'WITH/WITHOUT ATTRIBUTES' of the table.
  
  - Users can use the GEN command on a table defined with
  the 'EDITPROC program-name WITH/WITHOUT ROW ATTRIBUTES' to
  generate the CREATE TABLE statement.
  
  - Users can use DB2 Object Comparison Tool for z/OS to select
  the Ignore field CHECKRID for SYSIBM.SYSTABLES catalog table.
  
  - Users can use DB2 Comparison Tool for z/OS to compare two
  tables, the compare program will compare 'ROW ATTRIBUTES' of
  the EDITPROC if 'WITH/WITHOUT ROW ATTRIBUTES' is different
  between the source and the target.
  

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

• ADBCDTS  ADBDT    ADBH6CTS ADBH6TOP ADBH7TOP ADBP7TOP ADB2CMT
  ADB2IGN  ADB2PA   ADB2PA6  ADB2REG  ADB21TI1 ADB26CRT ADB26CT
  ADB26CTF ADB26CTS ADB26TOP ADB27C   ADB27CA  ADB27CAA ADB27CMR
  ADB27CX  ADB27C0  ADB27DUP ADB33    ADB51    ADB7000
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK97962

     UP13/09/28 P F309

• RA20 PSY UK97937

     UP13/09/28 P F309

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.