PM06943: SEL LINE COMMAND SQLCODEN485 ERROR WHEN DB2 RESOURCE LIMIT FEATU RE ACTIVE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS SEL line command will
  end with a SQLCODE -495 when DB2's Resource Limit Feature / RLF
  is active.
  

Local fix

• To be advised.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool             *
  *                 for z/OS 7.2 who use the SEL line            *
  *                 command on a table and the                   *
  *                 RLF (Resource Limit Facility)                *
  *                 feature is active.                           *
  ****************************************************************
  * PROBLEM DESCRIPTION: The SEL line command will               *
  *                      end with a SQLCODE -495                 *
  *                      when DB2's RLF (Resource                *
  *                      Limit Facility) is active.              *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  The SELECT statement used for the SEL line
  command does not contain a FETCH FIRST 1 ROWS
  ONLY to limit the results table.
  

Problem conclusion

• On panel 'Tables, Views, and Aliases' (ADB21T),
  the SELECT statement used for the SEL line
  command now contains a FETCH FIRST 1 ROWS
  ONLY statement to limit the results table.
  Once the panel ADB21TSE 'Build SQL SELECT
  Prototype' is displayed, the subsequent
  SELECT executed will need editing to
  add a filter to limit the results table and avoid a
  SQLCODE -495.
  
  Example:
  - Add the Predicates to limit the ROWS.
  and a FETCH FIRST n ROWS ONLY.
  
  SELECT T.* FROM "owner"."table" T
  WHERE COL1 IN('A','B')
  FETCH FIRST 2 ROWS ONLY.
  

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:

  UK59531

Modules/Macros

•    ADBH1TSE ADB21T
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK59531

     UP10/08/12 P F008

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.