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 for DB2 Universal Database , BC-DB-DB6-DBA , Database Administration with DB2 Universal Database , BC-DB-DB6-SYS , Database Interface/DBMS for DB2 Universal Database , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.