Articles & Content
Topic: 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
Click Here to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.