PM81829: GEN MASK NOT APPLIED TO SEQUENCE SCHEMA WITHIN TRIGGER

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Users of DB2 Administration Tool for z/OS report that MASK is
  not applied to GEN of TRIGGER object that contains SEQUENCE
  object.
  .
  For example, a MASK containing statements:
   SEQSCHEMA:*ABCD,*ACBG
   SCHEMA:*ABCD,*ACBG
   OWNER:*ABCD,*ACBG
  does not change TRIGGER statement:
   SET N.OBJ1_NBR = NEXTVAL FOR MKABCD.SEQX_SEQ
  for SEQUENCE object MKADCD.SEQX_SEQ when using GEN with MASK.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who mask the SEQSCHEMA or SEQNAME of    *
  *                 a TRIGGER object that contains a SEQUENCE    *
  *                 object.                                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: When a TRIGGER statement which          *
  *                      contains SEQUENCE object is             *
  *                      generated using the Generate            *
  *                      (GEN) function, and the attributes      *
  *                      SEQSCHEMA and SEQNAME are masked,       *
  *                      GEN does not apply the mask to          *
  *                      the SEQUENCE object.                    *
  *                                                              *
  *                      For example, a MASK containing          *
  *                      statements:                             *
  *                          SEQSCHEMA:*ABCD,*ACBG               *
  *                          SCHEMA:*ABCD,*ACBG                  *
  *                          OWNER:*ABCD,*ACBG                   *
  *                                                              *
  *                      does not change TRIGGER statement:      *
  *                         SET N.OBJ1_NBR = NEXTVAL FOR         *
  *                         MKABCD.SEQX_SEQ                      *
  *                                                              *
  *                      for SEQUENCE object MKADCD.SEQX_SEQ     *
  *                      when using GEN with masking.            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When a TRIGGER statement which contains SEQUENCE object is
  generated using the Generate (GEN) function, and the attributes
  SEQSCHEMA and SEQNAME are masked, GEN does not apply the mask
  to the SEQUENCE object.
  

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:

  UK92570

Modules/Macros

•    ADB2PA   ADB2REG
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK92570

     UP13/03/19 P F303

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.