Articles & Content

Archives

Be like a Hawk - Get a Bird's-Eye View of your Enterprise Databases (D04)

Topic: DB2 for LUW

Subtopic: 2007



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

OBJECTIVES:

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.