PK96961: GEN COMMAND DOES NOT GENERATE THE CREATE TRIGGER AND NSP SYNTAX WHEN MASKING IS USED. MESSAGE ADB1847E ISSUED.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• GEN COMMAND DOES NOT GENERATE THE CREATE TRIGGER AND NSP SYNTAX
  WHEN MASKING IS USED. MESSAGE ADB1847E ISSUED.
  .
  Additional symptoms:
  PLIDUMP was called from statement number 4774 at offset
  +00000A60 from CREATE_MQT_DDL loadmod adb2gen
  .
  CEE0810S The storage address in a free storage (CEEFRST) request
  was not recognized, or heap storage (CEECZST) control
  information was damaged.
  .
  USER COMPLETION CODE=4039 REASON CODE=00000000
  abendu4039 rc00 rc0 cc12
  USER ABEND CODE 4038  REASON CODE 00000001
  abendu4038 rc1 rc01
  

Local fix

• APPLY PTF.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool for z/OS    *
  *                 who use the GEN or Migrate functions to      *
  *                 generate DDL for a trigger that contains an  *
  *                 unqualified table reference, and a mask is   *
  *                 specified that changes the value of          *
  *                 syspackage.qualifier (implicit qualifier).   *
  ****************************************************************
  * PROBLEM DESCRIPTION: When generating a trigger with the      *
  *                      conditions described in USERS AFFECTED, *
  *                      the following parser error occurred:    *
  *                      ADB1847E WARNING : Error parsing DDL    *
  *                      TRIGGER statement. Please verify the    *
  *                      generated DDL.                          *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  The parser was not able to parse the trigger because an
  invalid parameter (implicit qualifier) was specified by
  the GEN code.
  

Problem conclusion

• The problem has been fixed.
  

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

•    ADB2REG  ADB2REH  ADB2REM  ADB2REP  ADB2REY
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK52000

     UP09/11/21 P F911

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.