PK19412: ADMIN TOOL ADB21KSE DISPLAYS THE DBRM SQL LINE NUMBERS AS NOT PART OF THE DBRM IN ISPF EDIT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The ADB21KSE panel does not show the line number of the SQL
  statement as a permanent part of data (expressed as an ISPF
  "NOTE"). An ISPF reset will remove this reference needed by
  customers.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool, who like   *
  *                 to  see the comment lines as data lines in   *
  *                 panel ADB21KSE, are affected.                *
  ****************************************************************
  * PROBLEM DESCRIPTION: The  ADB21KSE  panel did not show the   *
  *                      line number of the SQL statement as a   *
  *                      permanent  part of data (expressed as   *
  *                      an ISPF "NOTE").  An  ISPF reset will   *
  *                      remove this reference.                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  ADB21KSE displayed the DBRM SQL line numbers as not part of
  the DBRM in ISPF Edit.
  

Problem conclusion

• Currently, the  panel ADB21KSE marks any statement from the
  DBRM as comment lines if it's not valid SQL statement.
  .*
  After the changes, panel ADB21KSE will display a message to
  inform  the  customer  to use the ISPF EDIT line command MD
  (Make Data) to  quickly  and  easily convert the note lines
  into data lines.
  

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

•    ADB21KSE
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R710 PSY UK13804

     UP06/04/28 P F604

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.