Problems after Netcool OMNIbus database is (nearly) full

iKnow-IT banner

We discover several problems when the Netcool OMNIbus database is (nearly) full.

How you can check the percent space used of the database in memory:

/opt/IBM/tivoli/netcool/omnibus/bin/nco_sql -server <servername> -user <user> -password <password> <<BL | tee /tmp/table_store.out 
select UsedBytes, SoftLimit, HardLimit from catalog.memstores where StoreName = 'table_store'; 
go 
exit 
BL 

cat /tmp/table_store.out | tail -3| head -1 | awk '{ print "\ntable_store: " $1/$2*100"% Full\n" }'