PI81347: DB2 ADMIN TOOL - SUPPORT ACCELERATOR FUNCTIONS IN BATCH INVOLVING LONG LIST OF TABLES (CLOB SIZE LIMIT)

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• While issuing LOAD (and other similar) command on long list of
  accelerated tables (table name+schema size exceeding 32KB),
  Admin tool fails with below error:
  
  IBM0441W ONCODE=150 The STRINGSIZE condition was raised.
  From entry point _Concnvs at compile unit offset +00000062
  at entry offset +00000062 at address 3CD01BBA.
  IBM0441W ONCODE=150 The STRINGSIZE condition was raised.
  From entry point _Concnvs at compile unit offset +00000062
  at entry offset +00000062 at address 3CD01BBA.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration for z/OS     *
  *                 who use IBM DB2 Analytics Accelerator        *
  *                 (IDAA) for z/OS.                             *
  ****************************************************************
  * PROBLEM DESCRIPTION: When certain primary commands are       *
  *                      issued on panel ADBPZAT 'Display        *
  *                      Accelerated Tables' involving a large   *
  *                      number of tables, or when a batch job   *
  *                      issues ACCELERATOR statements           *
  *                      involving a large number of             *
  *                      tables, an ONCODE=150 STRINGSIZE        *
  *                      condition is encountered.               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When primary commands of ADD, DELETE, LOAD,
  ENABLE, DISABLE or DET are issued for a large number
  (e.g., 1000) of tables on panel ADBPZAT
  'Display Accelerated Tables', or wild cards are used in
  ADMIN ACCELERATOR batch statements that involve a
  large number of tables, an ONCODE=150 / ONCODE150
  error is encountered:
  
  
  IBM0441W ONCODE=150 The STRINGSIZE condition
  was raised.
  From entry point _Concnvs at compile unit offset >offset<
  at entry offset >offset< at address >address<:
  
  The current implementation supports a maximum string size
  of 32KB for internal processing of accelerator stored procedure
  parameters, and, whenever this limit is reached, the error above
  is encountered. This APAR adds an enhancement to support
  CLOB sizes of 2MB for ADD and LOAD, and 256KB for DELETE,
  ENABLE or DISABLE accelerated tables operation, in both
  online and batch modes.
  

Problem conclusion

• Problems have been resolved.
  

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

•    ADBASP
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI48284

     UP17/06/28 P F706

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.