Symptom
- One observes that the following severe errors related to index changes are continuously written to the db2diag.log:
. . .
YYYY-MM-DD-HH.MM.SS.MMMMMM-### X##########X### LEVEL: Severe
PID : ####### TID : ##### PROC : db2sysc 0
INSTANCE: db2<sid> NODE : 000 DB : <SID>
APPHDL : #-##### APPID: ###.#.###.###.#####.############
AUTHID : SAPR3 HOSTNAME: <hostname>
EDUID : ##### EDUNAME: db2agent (<SID>) 0
FUNCTION: DB2 UDB, index manager, sqlisplt ...
MESSAGE : INFO2: ... Split at record boundary, Split prefix, Many records, new key inserted on new page.
YYYY-MM-DD-HH.MM.SS.MMMMMM-### X##########X### LEVEL: Severe
. . .
FUNCTION: DB2 UDB, index manager, sqlisplt ...
MESSAGE : INFO: index page split pool ...
. . .
YYYY-MM-DD-HH.MM.SS.MMMMMM-### X##########X### LEVEL: Severe
. . .
FUNCTION: DB2 UDB, index manager, sqliCleanupPages, probe:###
MESSAGE : INFO4: empty cleanup ...
YYYY-MM-DD-HH.MM.SS.MMMMMM-### X##########X### LEVEL: Severe
. . .
FUNCTION: DB2 UDB, index manager, sqliMarkPageEmpty ...
MESSAGE : INFO3: page marked pseudo empty ...
. . .
Read more...
Environment
- DB2 for Linux, UNIX, and Windows , DB2 for LUW, DB6
Product
SAP enhancement package 2 for SAP NetWeaver 7.0
Keywords
KBA , BW-SYS-DB-DB6 , BW DB2 Universal Database , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BC-DB-DB6-CCM , CCMS/Database Monitors , BC-DB-DB6-DBA , Database Administration , BC-DB-DB6-SYS , Database Interface/DBMS , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview