PH30215: VARIOUS IMPROVEMENTS

Obtain the fix for this APAR.

APAR status

• Closed as unreproducible in next release.

Error description

• 1. Support Db2 12 function level 508.
  2. Accelerator only table is not available for updating if the
  value of Location parameter is specified
  3. When opening a table with an accelerator, an SQL error is
  returned
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM Db2 Table Editor for z/OS       *
  ****************************************************************
  * PROBLEM DESCRIPTION: New V12R1M508 value was added to Db2    *
  *                      APPLCOMPAT bind option in Tools         *
  *                      Customizer.                             *
  *                                                              *
  *                      SQL error -4742 occurs when opening an  *
  *                      accelerator only table and a value is   *
  *                      specified in the "Location" field.      *
  *                                                              *
  *                      SQL error -4742 occurs when opening a   *
  *                      table with an accelerator.              *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  New V12R1M508 value was added to Db2 APPLCOMPAT bind option in
  Tools Customizer.
  SQL error -4742 occurs when opening an accelerator only table
  and a value is specified in the "Location" field.
  SQL error -4742 occurs when opening a table with an accelerator.
  

Problem conclusion

Temporary fix

Comments

• Apply the PTF
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI72405

Modules/Macros

• ETI$$PRM ETI2CSVE ETI2DB2  ETI2MAIN ETI2PCEP ETI2PEDT ETI2PFRM
  ETI2PHST ETI2PLOG ETI2PMAN ETI2PSAC ETI2PSEL ETI2PSQL ETI2PTLS
  

Fix information

• Fixed component name

  DB2 TABLE EDITO

• Fixed component ID

  5697G6500

Applicable component levels

• R150 PSY UI72405

     UP20/11/07 P F011

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.