Articles & Content
Topic: 2007 NA
Subtopic: DB2 for LUW
DATE: 2007-5-7 (04:20 PM - 05:20 PM)
SPEAKERS: Brad Price (Physicians Mutual Insurance Company)
Many DBA's now find themselves with dozens of UDB instances and oftenhundreds of databases across many servers and testing/productionplatforms. How is a DBA to keep track of all of these and ensure thateverything is safe, secure and properly configured?? Most tools andcommands only provide information for a single instance or database.Come learn how to combine UDB table functions, administrative views andshell scripts to quickly and easily answer critical questions about yourdatabases such as:1) Am I properly configured for active logging and log archiving onevery database?2) What version/fixpak is being used for every instance on every server?3) What is the total amount of memory being used by all databases on aserver??4) Does every database have a valid backup within the last "x" days??
EXP. LEVEL: Beginner,Intermediate
Learn about UDB table functions
Learn about UDB administrative views (new with Version 9)
Learn how to build a script to create a global inventory of all of yourdatabases across all servers
Learn how to build a script to check each of your databases to ensurethat valid backups are occurring
Learn how to manage all of your DB2 diaglog files and report if anysevere errors occurred over a given time period
This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.