PH12323: TABLESPACES NOW CREATED AS UNIVERSAL TABLE SPACES (UTS): BETTER 'ORDER BY' CLAUSE CHECKS BEFORE OPENING A QUERY IN EDIT MODE.

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• When this PTF is applied, tablespaces are created as Universal
  table spaces (UTS) during installation. Previously, tablespaces
  were created segmented (non-universal) table spaces. Although
  Db2 V10 still supports segmented (non-UTS) table spaces,
  segmented table spaces have been deprecated and universal table
  spaces (UTS) are now recommended.
   In support of this change, Db2 Table Editor now creates
  universal table spaces exclusively. This change does not impact
  existing installations.
  ..
  Additionally, processing of the "ORDER BY" clause has been
  improved to check for SQL correctness before opening a query in
  edit mode.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Table Editor for z/OS           *
  ****************************************************************
  * PROBLEM DESCRIPTION: When this PTF is applied, tablespaces   *
  *                      are created as Universal table spaces   *
  *                      (UTS) during installation. Previously,  *
  *                      tablespaces were created segmented      *
  *                      (non-universal) table spaces. Although  *
  *                      Db2 V10 still supports segmented        *
  *                      (non-UTS) table spaces, segmented       *
  *                      table spaces have been deprecated and   *
  *                      universal table spaces (UTS) are now    *
  *                      recommended.                            *
  *                      In support of this change, Db2 Table    *
  *                      Editor now creates universal table      *
  *                      spaces exclusively. This change does    *
  *                      not impact existing installations.      *
  *                      ..                                      *
  *                      Additionally, processing of the         *
  *                      "ORDER BY" clause has been improved to  *
  *                      check for SQL correctness before        *
  *                      opening a query in edit mode.           *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF.                               *
  ****************************************************************
  Code has been changed to fix this problem.
  

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:

  UI63416

Modules/Macros

• ETI2CSVE ETI2DB2  ETI2DCOL ETI2DPAR ETI2MAIN ETI2PCEP ETI2PEDT
  ETI2PFRM ETI2PHST ETI2PLOG ETI2PMAN ETI2PSAC ETI2PSEL ETI2PSQL
  ETI2PTLS ETIDDL
  

Fix information

• Fixed component name

  DB2 TABLE EDITO

• Fixed component ID

  5697G6500

Applicable component levels

• R150 PSY UI63416

     UP19/06/11 P F906

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.