PI99349: ADMIN TOOL CREV CREATE VIEW LINE COMMAND ADB21T ADB21VV PROMPT PANEL ADB2PSTM ADDS X'0D15' STATEMENT IN SYSIBM.SYSVIEWS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• With the prompt option for CREATE SQL set to YES (Main Menu
  option P ('Change DB2 Admin parameters' => PR ('Prompt
  Options') => Definition SQL (CREATE, DROP, ALTER, RENAME,.) =
  YES),  if a user enters line command CREV ('create view') on a
  table on panel ADB21T, they then get prompted to create the
  view on panel ADB2PSTM.   The view is created successfully.
  However, the text of the view in table SYSIBM.SYSVIEWS, column
  STATEMENT, contains extra bytes x'0D15' between 'CREATE VIEW
  >viewname< AS' and 'SELECT' .
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool         *
  *                 for z/os who use the CREV line command       *
  *                 to generate and execute CREATE               *
  *                 VIEW statements.                             *
  ****************************************************************
  * PROBLEM DESCRIPTION: When a view is created via the          *
  *                      CREV line command, with the             *
  *                      Prompt option for CREATE SQL            *
  *                      set to YES, the text in the             *
  *                      STATEMENT column in                     *
  *                      SYSIBM.SYSVIEWS contains                *
  *                      unwanted characters.                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  With 'Definition SQL (CREATE, DROP, ALTER, RENAME,.)' set to
  'YES' under Prompt Options (panel ADB2PRMT), if a user
  user generates and executes view DDL via line command CREV
  on panel ADB21T or ADB21VV, special characters x'0D15' may
  appear in the STATEMENT column of SYSIBM.SYSVIEWS. This is
  because Admin Tool uses special characters to format
  the view on the prompt panel ADB2PSTM. The special
  characters (X'0D15') are part of the SQL statement that is
  passed to Db2, and Db2 stores the entire SQL statement,
  including the valid but unwanted special characters, in
  SYSVIEWS.
  

Problem conclusion

• The problem has been fixed by replacing the special
  characters with blanks just before passing the statement
  to Db2.
  

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

•    ADBMAIN
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI58928

     UP18/10/12 P F810

• RC10 PSY UI58929

     UP18/10/12 P F810

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.