PI15099: SQL ERRORS ("ILLEGAL SYMBOL") DURING RECOVERY

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• CREATE TRIGGER fails with the message ARYG016E:   DSNT408I
  SQLCODE = -104, ERROR:  ILLEGAL SYMBOL ".". SOME SYMBOLS THAT
  MIGHT BE LEGAL ARE: NO BEFORE INSTEAD AFTER.  Second line of
  CREATE TRIGGER statement may contain trigger names once again.
  This can occur if the original DDL for the CREATE TRIGGER
  contained spaces between schema and name as such...CREATE
  TRIGGER SCNAME . TRGNAME ...
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Recovery Expert for z/OS.       *
  ****************************************************************
  * PROBLEM DESCRIPTION: CREATE TRIGGER fails with the message   *
  *                      ARYG016E:   DSNT408I SQLCODE = -104,    *
  *                      ERROR:  ILLEGAL SYMBOL ".". SOME        *
  *                      SYMBOLS THAT MIGHT BE LEGAL ARE:        *
  *                      NO BEFORE INSTEAD AFTER.  Second line   *
  *                      of CREATE TRIGGER statement may         *
  *                      contain trigger names once again.       *
  *                      This can occur if the original DDL for  *
  *                      the CREATE TRIGGER contained spaces     *
  *                      between schema and name as              *
  *                      such...CREATE TRIGGER SCNAME .          *
  *                      TRGNAME ...                             *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• APPLY the PTF.
  

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:

  UI22506

Modules/Macros

•    ARYLHGTR ARYLJGVS
  

Fix information

• Fixed component name

  DB2 REC EXPERT

• Fixed component ID

  5697H7400

Applicable component levels

• R310 PSY UI22506

     UP14/11/04 P F411

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.