Monthly Archives: August, 2016

DB2: Various monitoring scripts

(1) Check High Cpu Utilization

(2) Swap high utilization check

(3) Transactional Log utilization

(4) Check backup failures

(5) Backup Running Longer

(6) Diag log monitoring for Severe/Error/Critical errors




Netezza: Object & admin privileges

A user/group can have an object or admin 0r both privileges granted to it. Below queries will help you to find out those details:

(1) Object privileges granted to an user/group


(2) Admin privileges granted to an user/group:

Admin Privileges


Credits: Abhishek Sakhuja from PureData Enzee community