db2dart SAP returns "Inconsistent Database"

[Former Member]

Dear Gurus,

I've information from sapnote #98524 that to check Logical and Consistenty of database, we use db2dart.

When I tried to execute: db2dart <sid>, there's always this message in every instance (DEV, QA, PRD)

Warning: The database state is not consistent.

Warning: Errors reported about reorg may be due to the inconsistent state of the database.

We're using SAP ECC 6.0 EhP4, DB6 9.7 LUW, SAP RHEL 5.0

I know that inconsistent means uncommited transactions are not yet flushed into disk.

Then, how can you benefit from db2dart when the information you got is just some warnings?

Thanks much for your help.

Best Regards,

Bobby Gunawan

[malte_schuenemann]

db2dart is an offline tool. This means that if the database is active while db2dart is started, the tool will output such a message. Depending on command line options used, the tool will deny further processing.

To check a table's integrity, consider using the DB2 INSPECT utility. INSPECT is documented in the online help.

Malte