PK06000: TWO INTERNALLY FOUND PROBLEMS IN THE FOLLOWING AREAS: 1. COMMA AS DECIMAL 2. ALL PARTS AREA AND PROMPT IS ON

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Two Internally Found Problems in the following areas:
  1. Comma as Decimal 2. ALL PARTS AREA and Prompt is ON
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool are         *
  *                 affected:                                    *
  *                 .* Users of R510, who use panel ADB222       *
  *                    "Execute SQL Statements from a Data       *
  *                    Set" when DB2 is running with comma       *
  *                    as decimal                                *
  *                 .* Users of R510 and R710 who use the        *
  *                    ALL PARTS Area in Panel ADB21XA for       *
  *                    partition index changes                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: .*                                      *
  *                      SQL -104 can be received in a comma as  *
  *                      decimal environment when using panel    *
  *                      ADB222 "Execute  SQL Statements from a  *
  *                      Data Set"  if the last non-blank        *
  *                      character of a line is a comma.         *
  *                      .*                                      *
  *                      With Prompt On, a value  specified  in  *
  *                      the ALL PARTS Area will  be forced  to  *
  *                      make the one at a time, for each index  *
  *                      in the partition;  i.e.  A  User,  who  *
  *                      enters  some  value  in  the ALL PARTS  *
  *                      Area, with Prompt On  will be directed  *
  *                      to ADB2PSTM Panel (Statement Execution  *
  *                      Prompt )  for  each partition index to  *
  *                      be updated.                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  See Problem Description.
  

Problem conclusion

• .*
  Because the character after the comma is not a blank, DB2
  misinterprets the comma as a decimal point instead of a
  list separator. The problem has been fixed. A blank is now
  inserted between the command and the carriage-return.
  Note: This change affects all functions that Add to WSL and
  also affects Execute SQL from Data Set, panel ADB222.
  .*
  Code has been fixed to Mass Update all Partitions, when the
  ALL PARTS Area is used and Prompt is ON.
  

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

•    ADB2A2WS ADB21XA
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R510 PSY UK06373

     UP05/08/26 P F508

• R710 PSY UK06374

     UP05/08/26 P F508

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.