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.