Monthly Archives: August, 2016

DB2: Various monitoring scripts

(1) Check High Cpu Utilization

1_cpu_check.sh

(2) Swap high utilization check

2_swap_check.sh

(3) Transactional Log utilization

3_Transactional_logs_utilization.sh

(4) Check backup failures

4_backup_fail_check.sh

(5) Backup Running Longer

5_backup_running_long.sh

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

6_db2diag_monitor

 

 

Advertisements

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

Object_privileges

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

Admin Privileges

 

Credits: Abhishek Sakhuja from PureData Enzee community