Need to monitor the Backups running on Teradata database.

Database

Need to monitor the Backups running on Teradata database.

Hi Teradata Team,

I need to write a shell script which monitors the database backups in teradata and alerts the dba for blocking of the backup sessions due to any contention of the resources.

* Backup software is netbackup
* We need to know when there is also a slow down in the speed of the backup.

we need to know when there is slown down in speed of the backup rates due to session
blocking or locking of resources.

I am looking for clue / resources from where i can pick up these data ( blocking of backup job ) and need to write a script to alert backup monitoring person when the backup job is getting blocked by other batch ids and sessions.

Please let me know the ideas for the same.

Thanks
Sakthi
1 REPLY
Junior Contributor

Re: Need to monitor the Backups running on Teradata database.

All the info which is available in the Performance Monitor can also be retrieved using the PMon/API SQL-UDFs in the syslib database.

Check the "Workload Management API" manual for details.

Dieter