IT32291: REORG INDEXES ALL REPORTS MISLEADING "SQLRREORG_INDEXES, PROBE:1160" IN DB2DIAG.LOG

APAR status

• Closed as program error.

Error description

• The following error is reported in the db2diag.log file
  following a successful REORG INDEXES ALL command. It might be
  observed with manual REORG INDEX command or by performing AUTO
  REORG.
  
  2019-12-30-14.22.13.237634-300 I1528553E1070 LEVEL: Error
  PID : 29198 TID : 139655085287168 PROC : db2sysc 0
  INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
  APPHDL : 0-35489 APPID: *LOCAL.db2inst1.191230191248
  AUTHID : DB2INST1 HOSTNAME: localhost
  EDUID : 158 EDUNAME: db2agent (SAMPLE) 0
  FUNCTION: DB2 UDB, relation data serv, sqlrreorg_indexes,
  probe:1160
  DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
  Object not dumped: Address: 0x0000000000000000 Size: 136 Reason:
  Address is NULL
  DATA #2 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
  sqlcaid : SQLCA sqlcabc: 136 sqlcode: 0 sqlerrml: 0
  sqlerrmc:
  sqlerrp : SQL11014
  sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
  (4) 0x00000000 (5) 0x00000000 (6) 0x00000000
  sqlwarn : (1) (2) (3) (4) (5) (6)
  (7) (8) (9) (10) (11)
  sqlstate:
  DATA #3 : unsigned integer, 4 bytes
  0
  DATA #4 : unsigned integer, 4 bytes
  0
  
  
  This started after installing fixpack 5 of v11.1. The message is
  misleading and does not indicate any kind of problem, it can be
  ignored.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * ALL                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to Db2 Version 11.1 Mod 4 Fix Pack 6.                *
  ****************************************************************
  

Problem conclusion

• First fixed in Db2 Version 11.1 Mod 4 Fix Pack 6.
  

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:

Fix information

• Fixed component name

  DB2 FOR LUW

• Fixed component ID

  DB2FORLUW

Applicable component levels