PI81355: DB2 ADMIN TOOL - ADMIN ACCELERATOR LOAD STATEMENT DOES NOT LOAD ALL SELECTED ACCELERATED TABLES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When issuing ADMIN ACCELERATOR LOAD statement in batch, few
  tables are skipped due to stringsize error.
  
  ADB5044I *** INPUT STATEMENT:
  ADMIN ACCELERATOR LOAD TABLES ON IDAAFE
  LOCKMODE TABLESET
  INCLUDE YIBM302.IFCID366C
  , YIBM302.IFCID366C_DIST
  , YIBM302.IFCID366C_OLD
  , YIBM302.T_ROSS_NOCHANGE
  , YIBM302.T_ROSS_RELOD_REC
  , YIBM302.T_ROSS_RELOD_REQ
  ;
  1ADB5277I Below list of 1 table(s) were loaded on the
  accelerator IDAAFE:
  YIBM302.IFCID366C
  ADB5270I Accelerated tables have been successfully loaded.
  
  IBM0441W ONCODE=150 The STRINGSIZE condition was raised.
  From entry point ACCELLOAD at statement 2931 at compile unit
  offset +000005A4 at entry offset +000005A4 at
  address 461B28B4.
  

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 issuing the ADMIN ACCELERATOR      *
  *                      LOAD statement in batch, a few tables   *
  *                      are skipped.                            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When the LOAD primary command is issued in BATCH mode, the
  generated ADMIN ACCELERATOR LOAD statement skips a few
  accelerated tables due to the string size error and
  ONCODE150 / ONCODE=150:
  
  IBM0441W ONCODE=150 The STRINGSIZE condition was raised.
  From entry point ACCELLOAD at statement 2931 at compile unit
  offset +000005A4 at entry offset +000005A4 at
  address 461B28B4.
  
  Example:
  
  ADMIN ACCELERATOR LOAD TABLES ON >accelerator_name<
  LOCKMODE TABLESET
  INCLUDE >table_name1<
  , >table_name2<
  , >table_name3<
  , >table_name4<
  , >table_name5<
  , >table_name6<
  
  1ADB5277I Below list of 1 table(s) were loaded on the
  accelerator >accelerator_name<
  
    >table_name1<
  ADB5270I Accelerated tables have been successfully loaded.
  

Problem conclusion

• Problem has 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:

  UI47487 010PC2Ÿ 010PC2Ÿ UI47488 010PC2Ÿ 010PC2Ÿ 010PC2Ÿ

Modules/Macros

•    ADBDAT   ADBTEP2
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI47487

     UP17/05/25 P F705

• RC10 PSY UI47488

     UP17/05/25 P F705

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.