Correct.

I am not exporting any data. i have a simple script that reads some
data for monitoring the db2 instance.

the output of the script is displayed on a web page (NAGIOS) to show
the status of the database.

script is :

SELECT CASE(HI_ID)
    WHEN 1001 THEN 'state of the database'
    WHEN 1002 THEN 'shared sorting mem util'
    WHEN 1003 THEN 'percent sort overflow'
    WHEN 1004 THEN 'max sort mem used'
    WHEN 1005 THEN 'fullness of transaction log'
    WHEN 1006 THEN 'fullness of log FS'
    WHEN 1007 THEN 'rate of deadlock'
    WHEN 1008 THEN 'locklist utilization'
    WHEN 1009 THEN 'DB lock esc. rate'
    WHEN 1010 THEN 'percent apps waiting on locks'
    WHEN 1011 THEN 'package cache hitratio'
    WHEN 1012 THEN 'catalog cache hitratio'
    WHEN 1013 THEN 'shared SQL workspace hitratio'
    WHEN 1014 THEN 'heap utilization'
    WHEN 1015 THEN 'manual reorg required'
    WHEN 1016 THEN 'hadr op status'
    WHEN 1017 THEN 'hadr delay'
    WHEN 1018 THEN 'manual backup required'
    WHEN 1022 THEN 'runstats'
    ELSE CHAR(HI_ID)
      END as "AREA OF ISSUE",
HI_ALERT_STATE_DETAIL AS STATUS,
HI_VALUE, substr(HI_ADDITIONAL_INFO,1,100) as HI_ADDITIONAL_INFO
FROM DB2$HEALTH_DB_HI
WHERE HI_ALERT_STATE != 1

and the view DB2$HEALTH_DB_HI is defined as

create view DB2$HEALTH_DB_HI as select * from
table(health_db_hi('',-1)) as sntable;

The work has been done by a guy named eaton. I am just in the process
to build a simple naggios plugin to monitor db2

kind regards

Michael

since the oracle export utility is an add-on cost.

The oracle export utility is not an add-on cost

it *does* at least this one :-)

db2inst1@db2host:/home/db2inst1 # db2 -tf /nagios/bin/health_check.sql

db2inst1@db2host:/home/db2inst1 # wc /var/tmp/lala
      7      13     353 /var/tmp/lala
db2inst1@db2host:/home/db2inst1 # cat /var/tmp/lala

AREA OF ISSUE                 STATUS               HI_VALUE
HI_ADDITIONAL_INFO
----------------------------- -------------------- --------
----------------------------------------------------------------------------------------------------

 0 Satz/Sätze ausgewählt.