Articles & Content


TSM is not just a black box - Commands a DBA Should Know (I03)

Topic: 2008 NA

Subtopic: DB2 for LUW

DATE: 2008-5-19 (01:30 PM - 02:30 PM)
SPEAKERS: Carolyn Sanders (EDS)

The TSM Database holds information about virtually everything concerning the TSM Server and Clients. You can use the TSM Administrative Client to look at specific information or the TSM SQL interface to query the database directly using standard SQL queries. Using these two techniques your capabilities include:- verifying the parameters setting for your TSM node and TSM management class. - querying your TSM session and check the status and see if it is receiving data or is in a media wait state. - checking the availability of scratch tapes and tapes drives. - reviewing the TSM activity log and see actual TSM errors associated with the API return code sent to DB2. - querying the TSM backup table and verify that those TSM exclude filters are working the way you wanted them to. - gathering metrics on when your API backups are running if you need to do load leveling.

EXP. LEVEL: Intermediate


1.Verify your configuration of TSM for DB2 LUW

2.Monitor Backups and Archive logs within TSM

3.Determine the health of TSM

4.Perform Problem Determination

5.Verify your DB2 LUW recoverability from TSM

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!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.