SAP Knowledge Base Article - Preview

2144676 - DB6: DB2 Diagnostic Log File (db2diag.log) grows rapidly due to Index information

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.