PI84092: DDL LINE COMMAND FOR VIEW INSERTS FORMAT CHARACTERS X'0D15' INTO STATEMENT COLUMN OF SYSIBM.SYSVIEWS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When the DDL line command is executed against a view, and the
  DDL is modified and executed in Admin Tool to create a new
  view, the entry for the new view in SYSIBM.SYSVIEWS.STATEMENT
  now contains format characters  x'0D15', which are not in the
  original view.
  This APAR adds a new command, EXECUTENF, to panel ADBPEDD2
  'Edit DDL Statements'.  This command will execute SQL
  statements without adding the format characters.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool for         *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: Format characters X'0D15' added         *
  *                      to column STATEMENT in DB2              *
  *                      catalog SYSIBM.SYSVIEWS.                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The EXECUTE command on DDL panel ADBPEDD2 'Edit DDL
  Statements' adds format characters X'0D15' to column
  STATEMENT in DB2 catalog SYSIBM.SYSVIEWS.
  

Problem conclusion

• Problem has been resolved where a new command EXECUTENF has
  been added to panel ADBPEDD2 'Edit DDL Statements' to execute
  SQL statements without adding the format characters X'0D15' to
  column STATEMENT in DB2 catalog SYSIBM.SYSVIEWS.
  

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

•    ADB222E
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI49874

     UP17/08/31 P F708

• RC10 PSY UI49875

     UP17/08/31 P F708

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.