Spirit Software Solutions - TSM Administration and Reporting made easy
Spirit Software Solutions
  • DownloadDownload Products
  • PurchasePurchase Products
  • ProductsOur Products
    • SP Studio
    • TSM Studio Server
  • SupportProduct Support
    • Open a case
    • Helpful TSM SQL Commands
    • Knowledge Base
    • Known Issues
    • Pre Release
    • TSM Studio Documentation
  • ResellersResell TSM Studio
  • Contact UsGet in Touch With Us
Knowledge Base

TSM Studio

ANS0101E Unable to open English message repository ‘dscenu.txt’

This error is being caused because the admin cli “dsmadmc.exe” cannot find its message file. Firstly check that dscenu.txt exists, it should be in the c:\program files\tivoli\tsm\baclient directory ( if you installed the tsm client in the default location ).

If it does exists try adding the following environment variable.

DSM_DIR=C:\Program Files\Tivoli\TSM\baclient

Permalink.

I have started TSM Studio but I cant see the TSM Studio Window

Because TSM Studio saves the last known position of the window, it is possible that if the resolution changes, multiple screens were used or the window was accidently dragged off the screen that the TSM Studio is now on a part of the Window Screen that is not visible. To resolve this issue use ALT+CTRL+W to reset the position of the window

Permalink.

Checking for Successful Backups in TSM Studio

In this article I will show three ways that you can verify that your Backups were successful using TSM Studio.

The first is from the Events Table

To view the events table goto the Monitor Category and then double click on the Events Dataview

Select the Date Range

The events data is displayed

There are a number of other related views in this Category such as Missed and Failed Backups

View the Backup output from the Summary Table

To view the events table goto the Monitor Category and then double click on the Summary Dataview

Select the Date Range

Use the Filter Backup to just show Backups

Choose Backup

 

Filter the Successful Column to display Backup Jobs that have failed

A list of all the Failed Backups will now be displayed

 

The third way to check is to look at File Spaces

The file spaces dataview can be found under the Storage Category

 

Check the Backup Start Date and the Backup End Date.  If the Backup End Date is less than the Backup Start Date or the Backend End Date is blank then there is a problem with the backup of the Node owning this filespace

 

We also have a specific Dataview to show all suspect File Spaces, goto to teh Troubleshooting Category and select File Spaces where Backup End Date is less than Backup Start Date

Permalink.

Changing the Date on a TSM Server

If you change the date on the underlying Operating System that your TSM Server is running on you will need to run the ACCEPT DATE command. If TSM is up when the date change occurs then you can login to the TSM Server using the Admin CLI or TSM Studio ( example at the end of this article) and run the ACCEPT DATE command.

If your server was down and your windows TSM Server service will not start. Check the event log or console messages for the following error

TSM Server Error: Server: SERVER_NAME ANR0110E An unexpected system date has been detected; the server is disabled. Verify the system date and use the ACCEPT DATE command to establish the current date as valid.

If you are unable to access the server from the ADMIN CLI then go to the command prompt or unix shell, change to the directory where dsmserv.exe (just dsmserv on unix) is installed and run it. When you see the above message enter ACCEPT DATE and once the new date has been accepted run the HALT command to stop TSM and start the TSM Server in the normal way for that Operating System.

Why do you need to do this

If someone has accidentally changed the Operating System date to a future date and the expiration process runs then a lot of data could be lost.
If you can access the TSM Server from TSM Studio then goto to the COMMANDS menu and select ACCEPT DATE

acceptdatemenu.png

Permalink.

Restoring a Client Node from Another Client Node

It is possible to impersonate a client node on a different node and there are 2 ways to do this.

The first option is to just change the nodename to match the impersonated name, this requires that you know the password of the nodename to be impersonated.

Either change the nodename in the dsm.opt file to the nodename to be impersonated

dsm.optnodename.png

or change the nodename in the Backup-Archive Client by going into the preferences

tsmbacclientpreferences.png

and Changing the Node Name

bacclientnodename.png

Alternatively you can use the ASNodeName option. This requires specifying the ASNodeName option either in the dsm.opt file or using the Backup-Archive client and also granting access on the TSM Server to impersonate this Node Name.

Either modify the dsm.opt file as follows

dsmoptasnodename.png

or go into the preferences dialog as above and change the As Node Name field

bacclientasnodename.png

Now grant the Node Test1 access to impersonate Test2 on the TSM Server.

Open the Client Nodes dataview in the Configuration category in TSM Studio and choose the node that is to be impersonated. Right click to bring up the Commands context menu and choose Grant Proxy Access to and select the Node that will impersonate this node

grantproxyaccesstomenu.png

selectnode.png

Permalink.

Activity Log, Events and Summary Retention

What are the Activity Log, Events and Summary Table.  

The Activity Log is the message log for TSM. Everything that is logged in TSM goes into the activity log. The Events Table stores information about anything that is running from the internal TSM Scheduler including admin tasks and client backups.   The Summary log is a summary of all activity that happens on the server such as admin tasks ( expiration, reclamation etc ), backups and restores.   These TSM object are stored in the TSM Database so changing any retention values will affect the size of TSM database so keep an eye out of the database utilization when increasing these values.   To change the retention values for these objects in TSM Studio, right click on the TSM Server in the TSM Server navigation windows and select Server Properties

tsmserverpropertiesmenu.png

Goto the logging tab and simply choose the new retention values for the Activity Log, Event  and Summary Tables. The values are measured in units of days

tsmserverpropertiesloggingtabe.png

Permalink.

RelabelScratch Parameter

The RelabelScratch parameter is aimed for use with Virtual Tape Libraries (VTL) and instructs TSM to relabel the tape when it becomes a scratch tape

NOTE: Do you not use the parameter below TSM 5.5.3 as there is a major bug with this option which can cause your tapes to be relabeled incorrectly

Why is this parameter needed?  ( This is based on my experience with the Falconstor VTL Product)

When using VTL’s with De-Duplication, the Virtual Tape Library Engine and DeDupe Engine are separate subsystems ( either within the same System or in different Systems ). In these cases the VTL Engine is just a transient area for your data before it is deduplicated and is moved to the storage managed by the DeDupe Engine.

Over time TSM will expire old data, reclaim tapes and tapes will move back to the scratch pool. The problem is that the VTL and DeDupe engine do not know that these tapes have become scratch tapes and so will not remove the expired data. The only way that the VTL and DeDupe systems know that a virtual tape has become a scratch tape is when TSM starts writing on that virtual tape from the beginning again.

To overcome this problem the RELABELSCRATCH parameter was introduced. This will tell TSM that it should rewrite the internal TSM label on the virtual tape when it becomes a scratch tape. This will let the VTL and DeDupe engine know that the data on that tape can be removed from the VTL and DeDupe Engines.

To see how this parameter is set on your library

Run the following QUERY LIBRARY FORMAT=DETAILED and you get output like the following. Checkout the Relabel Scratch Option

tsm: SPIRITTSM55_SERVER1>query library format=detailed

Library Name: LB0.0.0.2
Library Type: SCSI
ACS Id:
Private Category:
Scratch Category:
WORM Scratch Category:
External Manager:
RSM Media Type:
Shared: No
LanFree:
ObeyMountRetention:
Primary Library Manager:
WWN:
Serial Number: 9EZ7Z00M08
AutoLabel: No
Reset Drives: No

Relabel Scratch: Yes

Last Update by (administrator): ADMIN

Last Update Date/Time: 02/04/2010 04:58:33

When using TSM Studio go to the Libraries Dataview in the Libraries and Volumes Category and check out the Relabelscratch column

librarydataviewrelabelscratch.png

To change the relabelscratch parameter the Library cannot have any activity to it

UPDATE LIBRARY libraryname RELABELSCRATCH=YES

where libraryname is the name of your Library

To change using TSM Studio

Right Click on the Library to bring up the Commands Menu and choose Edit

librariesdatavieweditmenu.png

libraryeditdialogrelabelscratch.png

Check the Relabel Scratch Option and Press Ok

Permalink.

Replying to Requests

Some commands when entered in TSM particular those that involve moving Tapes in and out of the IO Slot will require a response from the TSM Operator.

To display Outstanding Requests enter the following command

QUERY REQUEST

output similar to the following will be displayed

ANR8352I Requests outstanding:

ANR8373I 001: Fill the bulk entry/exit port of library LB0.0.0.2 with all DLT

volumes to be processed within 60 minute(s); issue ‘REPLY’ along with the

request ID when ready.

REPLY requestnumber  ( for example REPLY 1 )  where requestnumber is the number in the QUERY REQUEST output

To do this in TSM Studio

Open the Query Requests Dataview from the the Monitor Category

queryrequests.png

Right Click to access the Commands Menu and select Reply

queryrequestsreplymenu.png

Permalink.

Administration Schedules

Any TSM command can be run as an administrative schedule and the TSM Scheduler whilst not being an advanced scheduler does provide a lot of flexibility of when a task can start.

To have a look at the currently defined Admin Schedules QUERY SCHEDULE * TYPE=ADMINISTRATIVE FORMAT=DETAILED

From TSM Studio go to the Automation Category and open the Admin Schedule’s Dataview.

adminschedules.png

TSM has two styles of schedules that can be used

Classic Style and Enhanced Style

The Enhanced Style option gives more advanced scheduling options such as running on a particular day of the month, week of the month. We will cover the Enhanced Style in another article.

Let’s have a look at the Define Schedule Command

DEFEINE SCHEDULE schedulename TYPE=ADMINISTRATIVE CMD=’EXPIRE INVENTORY’ ACTIVE=YES DESCRIPTION=’Admin Schedule’ PRIORITY=5 STARTDATE=TODAY STARTTIME=NOW DURATION=20 DURUNITS=MINUTES SCHEDTYLE=CLASSIC PERIOD=1 PERUNITS=DAYS DAYOFWEEK=ANY EXPIRATION=NEVER

schedulename – Any name that has meaning to you

TYPE=ADMINISTRATIVE – Tells TSM this is an admin schedule, The other type of schedule is a client schedule which is used to define client tasks ( such as backups )

CMD=’EXPIRE INVENTORY’ – Enter the command to be run for this schedule, remember to enclose in quotes if there a spaces in the command

ACTIVE=YES – Whether this schedule is active or not. If set to no it will not run

DESCRIPTION=’Admin Schedule’ – Enter any meaningful description. Remember that any parameter that has spaces in it will need to be surrounded by quotes

PRIORITY=5 – If you have more than one schedule with the same start time. TSM will start the schedule with the highest priority first. ( 5 is the default )

STARTDATE=TODAY – This is the start date for the schedule. The schedule will not run until the start date has been reached. TODAY is a special keyword that is substituted with today’s date, you can also use TODAY+X (where x = the number of days ) or in the format MM/DD/YYYY   STARTTIME=NOW – This specifies the start window for the schedule which may not be the actual start time of the schedule. This is used in conjunction with the   DURATION and DURUNITS to determine when the schedule will start. NOW is a special keyword used to specify the current time DURATION and DURUNITS – These two parameters with the Start

Time specify the window that TSM will use to start the schedule.

DURATION being a numerical value from 1 to 999 and

DURUNITS can be MINUTES, HOURS, DAYS.

Our settings here tell TSM that is must start this schedule within 20 minutes of the Start Time.
There is a special case in that you can set the DURUNITS=INDEFINITE which tell TSM that is can start the schedule any time after the Start Time.

PERIOD and PERUNITS – These two parameters tell TSM how often to run the schedule so in this example it is once every day. There is a special value for PERUNITS, PERUNITS=ONETIME which instructs TSM to only run this schedule once.

DAYOFWEEK=ANY – This parameter tells TSM what day of the week to run this schedule on.  Other possible values are WEEKDAY, WEEKEND, Monday, Tuesday, etc.

EXPIRATION=NEVER – This parameter specifies when the schedule expires. After this date the schedule will no longer run. Use MM/DD/YYYY format.   To Define an Admin Schedule in TSM Studio open the Admin Schedule Dataview and select Add Schedule

adminschedulesadd.png
adminscheduleadddialog1.png
adminscheduleadddialog2.png

Also available from this Dataview,  Execute, Disable, Enable, Edit and Delete your schedules    To See a Time of Day diagram for your schedule open the automation Category and open the Admin Schedules Time of Day Diagram. To change the times simply drag the Admin Schedule to a new time. ( This dataview is only available at the Server Level )

adminschedtimeofday.png

Permalink.

Collocation Group TroubleShooting

We suggest you read the following Article on Collocation before reading this Article –> Read Here

As noted in the article on collocation. The main problems you will come across with collocation is running out of scratch tapes andor a large number of tapes in a filling status. The main cause of this is having a storage pool with a collocation method of Group and then having no collocation groups or nodes not in collocation groups.

Using TSM Studio go to the Trouble Shooting category and open the Nodes not in Collocation Group dataview.

nodesnotincollocationgroup.png

To Add a Node(s) to a Group simply right click the select Add to A Group

collocationeditmember.png

After putting all your nodes in a group, You will now need to move the data off the current tapes so that TSM can collocate the nodes and their data.

There are a number of ways to do this and here are two of them

1. To do this use the Move Data command on each tape and move the data back to the primary disk pool so that the migration process can move the data back to tape using the collocation you specified.

2. Or use the Move Data command to move the data to the same storage pool as the tape is already in, TSM will then move the data from the selected tape and collocate the data with nodes from the same group on other tapes.

Using TSM Studio to run the move data command. Open the Volumes Dataview from the Libraries and Volumes category Right Click on the Tape and Choose Move Data

volumesmovedata.png

Choose the Storage Pool to move the data to

movedatadialog.png

Permalink.

Adding and Labelling new tapes

All new Tapes being put into a Physical Tape Libraries will require a barcode on them. In most cases the vendor that supplied the tapes should also supple the barcode label.

TSM requires that the first time you put a new tape into the library you run the LABEL command.The LABEL command instruct’s TSM to write an Internal Label at the start of the Tape and this internal label will match the external barcode label.

The Assumption with these commands are that you are using a Fibre Channel or SCSI attached Library The tapes can be either placed into the slots in the library or they can be placed in the CAP slots ( TSM called these external IO slots – BULK IO )

When the tapes are ready you can run the following command

LABEL LIBV libraryname SEARCH=BULK LABELSOURCE=BARCODE CHECKIN=SCRATCH
Where libraryname is the name of your library
SEARCH=BULK tells TSM to search the external Input Output slots for the new tapes If you are not using the CAP ( External IO Slots ) and the Tapes to be labelled are already in the library then change the SEARCH=BULK to SEARCH=YES
LABELSOURCE=BARCODE tells TSM to make the internal tape label the same as the barcode
CHECKIN=SCRATCH tells TSM to mark this tape as a scratch tape When using TSM Studio open the Libraries Dataview in the Libraries and Volumes Category

libraries.png

Right Click on the Library that has the tapes in that you wish to Label and select the Label Command

librarylabelmenu.png

Enter the options for the Label Command as above and press Ok

labeldialog.png

NOTE: When using the SEARCH=BULK TSM will prompt you to enter the Tapes and wait for a reply. Click Here to see the Article on replying to requests

Permalink.

Auditing a Library

Auditing a Tape Library is the process in which TSM verifies the information it has stored internally about the tapes, their labels and where they are located in the library (slot numbers) with the Physical Tape Library.

Why do you need to audit your library?
From time to time your Library will have maintenance performed on it, Tape Library Arms get jammed, tapes get stuck in drives and need to be manually moved back to their slot and tapes can be manually inserted in Tape Libraries. When problems or tasks like these described happen in your tape library it is good practice to run the Audit Library command.

The Audit Library Command can verify the tapes in the Library in one of  two ways.
1.By Barcode, this option verifies the barcode information and slot position and runs quickly as the Tape Library already has this information stored in its internal memory.
2.By Internal Label, every tape that TSM uses has an internal label that has been written to the start of the tape by TSM when running the label command when the tape was initially placed into the Library. Using this method causes TSM to mount every tape into a drive and verify its label. As every tape is physically mounted and read this option can be time consuming.

Which option should you use?

In a physical library it is extremely rare for the barcode label and the internal label to not match, but it can happen, so if you have the time then I would recommend using option 2, but if you don’t have a big window for your tape library to be out of action then use option 1.

If you are using a Virtual Tape Libraries and have the Relabel option set then I strongly advise running option 2 from time to time on your virtual library.

When running either variation of the Audit Library command there must be no activity happening on the Library. Run the Query Mount command and make sure there are no tapes mounted or even idle.  Cancel all processes and Sessions that are using the Drives.   Once there are no drives in use run the Audit Library
From the Admin CLI   Using barcode information only AUDIT LIBRARY LibraryName CHECKLABEL=BARCODE

Using Internal Labels AUDIT LIBRARY LibraryName CHECKLABEL=YES   Where LibraryName is the name of your Library

From TSM Studio Go to the Libraries and Volumes Category and open the Libraries Dataview

libraries.png

Select the Library you wish to Audit  Right Click to bring up the Command Options and select either the Audit Library ( Check Label ) or Audit Library ( Check Barcode )

auditlibrarymenu.png

In TSM Studio you can check for label mis-matches, it requires that you first run the AUDIT LIBRARY command with the CHECKLABEL=YES option then from the Main Menu Select Tools–> Check TSM Tape Labels

checktapelabelsmenu.png

Choose the TSM Server and Library and then hit the Refresh Button   Use the View drop down to show you the mis-matched tape labels

checktsmlabelsdialog.png

Permalink.

Installing the Administrative CLI – Windows

The Administrative Client is part of the normal windows backup-archive client install but by default it is not installed. You will need to apply a custom install as shown below:

1. Start the Tivoli Storage Manager Client InstallShield(R)

admincliinstallscreen1.png

2. Choose the Destination Folder

admincliinstallscreen2.png

3. Choose Custom Setup as the Setup Type

admincliinstallscreen3.png

4. IMPORTANT – Make sure that you select the Administrative Client Command Line Option as shown below and choose ‘ run all ‘ from my computer

admincliinstallscreen4.png

5. Click the Install option

admincliinstallscreen5.png

6. To verify the installation, verify the existence of dsmadmc.exe in the C:\Program Files\Tivoli\TSM\baclient directory

You may come across an error if the paths are not correctly set up. If you see the following message when starting the administrative cli program or when testing a TSM Server connection in TSM Studio, follow the suggested action below.

ANS0101E Unable to open English message repository ‘dscenu.txt’

This error is a result of the administrative cli  program, “dsmadmc.exe”, unable to find the message file.

 

To start, you can check if the dscenu.txt file exists in the c:program filestivolitsmbaclient directory ( assuming, you installed the TSM client in the default location ).   

    

If the file exists, try adding the following environment variable   

    

DSM_DIR=C:\Program Files\Tivoli\TSM\baclient

Permalink.

Migration

TSM uses a hierarchy of Storage Pools to “migrate” or move data from one type of storage to another or to the same type of storage.

How does Migration work?

There are a couple of parameters that need to be setup to facilitate migration. The first is to setup the “Next Storage Pool” parameter, this defines which pool the data will “migrate” to from the current pool.

To see how this is currently defined on your storage pools

Run the following Admin CLI Command

QUERY STGPOOL F=D and look at the “Next Storage Pool” field

In TSM Studio open the Storage Pools Dataview from the Storage category and check out the NextStgPool column

 stgpoolnextstgpool.png

 To change the Next Storage Pool from the Admin CLI

 UPDATE STGPOOL stgpoolname NEXTSTGPOOL=nextstgpoolname

 From TSM Studio

Right Click on the Storage Pool and Choose Next Storage Pool and then choose the storage pool

 stgpoolnextstgpoolmenu.png

 

stgpoolnextstgpooldialog.png

 

The next part is setting the migration threshold parameters which tell TSM when to move the data from the current pool to the “Next Storage Pool”. These two parameters are

Low Migration and High Migration, they represent a percentage full threshold for the storage pool that they are defined on

These Parameters function like this

TSM writes data to the current pool, the current pool hits the High Migration Threshold and will start “migrating” data to the storage pool defined in the “Next Storage Pool” field.

TSM will keep “migrating” data until it reaches the Low Migration Threshold and will then stop and wait for the High Threshold to be hit again

To Change the Low Migration or High Migration from the Admin CLI

UPDATE STGPOOL stgpoolname LOWMIG=xx HIGHMIG=xx

From TSM Studio, Select the Storage Pool and right click and choose Migration Thresholds and then choose the values

 stgpoolmigrationthresholds.png

 stgpoolmigrationthresholdsdialog.png

Ideally you will want enough disk space in your Primary Disk pool to store the nightly backups and while the nightly backups are running you will keep the high migration value somewhere around the 80 mark and low migration value somewhere around the 60 mark just so you don’t run out of space in the Primary Disk Pool.  During this time you can be running other TSM admin tasks such as reclamation.

 In the morning when your backups have finished or close to finishing you can change the High Migration to 5 and Low Migration to 0, this will then force all the data from the Primary Disk Pool ( Usually to Tape ).

This is not the only way this can be done and you may have reasons to run things differently and if you have a VTL you may wish to run with low values continuously.

Another Parameter related to Migration is the Migration Processes parameter, this defines how many processes will be used to Migrate the Data to the Next Storage Pool. When moving from the Primary Disk data to a Primary Sequential Pool (In most cases this is usually a tape pool) each process will use one tape drive.

UPDATE STGPOOL stgpool MIGPROCESS=xx 

From TSM Studio, Select the Storage Pool, Right Click and choose Migration Processes.

stgpoolmigrationprocesses.png

 

stgpoolmigrationprocessesdialog.png

 

These procedures can be automated using Administrative Schedules  

To stop Migration set  HighMig=100 and LowMig=99 and to Migrate everything HighMig=0 and LowMig=0

Permalink.

Reclamation

Reclamation is the process of reclaiming unused space on a tape (applies to Virtual Tapes as well). Over time the TSM expiration process will expire old data, creating gaps of unused storage on the tapes.  Because Tapes are sequential media, TSM can only write data to the end of the tape, so these gaps of “Empty Space” cannot be used.

Lets see an illustration of this

Tape 1 is a new tape and data is written to it as follows (each number on the following line represents a file being backed up)

1-2-3-4-5-6-7-8-9-10-11-12-13-14-15-16

Over time the expiration runs and expires old files (The * represents an expired file)

1-2-3-*-5-*-*-8-9-*-*-*-13-14-15-16

TSM refers to this space ‘*’ as Reclaimable Space.

TSM can only write to the end of the tape and the Reclaimable Space cannot be reused until all the data on the tapes expires and the tape becomes a scratch tape again.

To view this reclaimable space

QUERY VOLUME volno F=D   (where volno is the Volume Number for the Tape ) and look at the Pct Reclaimable Space field.

When using TSM Studio open the Volumes dataview from the Libraries and Volumes Category and view the Pct Reclaim Column

volumespercentreclaim.png

To get back this reclaimable space TSM has a Reclamation process which copies all the valid information from the tape to a new scratch tape so looking at our previous illustration TSM will create the new tape with the valid files

1-2-3-5-8-9-13-14-15-16

This eliminates all the reclaimable space and the old tape becomes a scratch tape.

On each Storage Pool supporting reclamation there is a Reclaim Threshold parameter

Run the QUERY STGPOOL stgpoolname F=D and look at the Reclamation Threshold field

Or when using TSM Studio, open the Storage Pools dataview in the Storage Category and check the Reclaim column

stgpoolreclaim.png

NOTE:  For tapes with a value of READWRITE or READONLY in the ACCESS column. TSM will run the reclamation on them when they are FULL, if they are FILLING they will not be touched.

Tapes in an OFFSITE status in a copy pool will be reclaimed whether or not they are FILLING or FULL.

To Change the Reclamation Threshold for a Storage Pool use the following command

UPDATE STGPOOL stgpoolname RECLAIM=xx  ( stgpoolname is the storage pool and RECLAIM is the threshold to use )

On TSM Studio right click on the Storage Pool and select Reclamation Threshold and either choose one of the values or use the SET option to choose another value.

stgpoolchangereclamationvalue.png

As there are a number of admin jobs and backup jobs that all need to use tape drives, you will need to find the right window to run your reclamation processes and decide how many processes you wish to run. Remember that each process will require 2 tapes drives, one for the input tape and one for the output tape. Automatically starting and stopping your reclamation processes can be done with Administration Schedules. ( Check back soon to see an article on Admin Schedules )

Permalink.

Collocation

Collocation is the process of grouping your nodes together (collocating) to help improve restore performance.

Over time as you add more and more nodes to your environment, the data for these nodes will slowly become more and more dispersed across your tapes as you perform backups.  When restoring the data if only a small number of files are required, this will not be a problem but when a restore is needed for a large number of files and those files have become dispersed across a large number of tapes then restores time will become an issue. I have personally experienced an issue when restoring a large volume that took over 2 days when not using collocation.

Instead of having every node’s data being placed on tapes at TSM’s discretion, collocation allows you to define groups of nodes to be stored together on your tapes.

As with everything there is a trade-off, collocation groups will require the use of more tapes but can significantly improve restore times.

Badly configured collocation will cause the consumption of very large amount of tapes.  And in my experience this has been the number one cause of the “Where have my all my scratch tapes gone” and “Why do I have so many filling tapes” , we will explore this later in the document.

Collocation is set at the Storage Pool so it is possible to have different levels of collocation based on Storage Pools.  As Collocation is really designed to help with Physical Tapes it only applies to Primary Sequential and Copy Storage Pools.

There are a number of difference types of collocation methods that can be used

NO – Collocation is disabled for the Storage Pool

FILESPACE – TSM Attempts to put each file space on its own tape

NODE – TSM Attempts to put each Node on its own tape

GROUP – TSM will put groups of Nodes on their own tapes as defined in the collocation groups.  If no collocation groups are defined then the storage pool reverts to Node Collocation.

NOTE:  If Group Collocation is set and there are no collocation groups defined or there are nodes not defined in any collocation group then you very quickly run out of scratch tapes and see a lot of filling tapes with not much data on them

Firstly let’s look at how to check to see if collocation is set.  From the Admin CLI issue the command

Q STGPOOL F=D and check the status of the collocate field

From TSM Studio open the Storage category and open the Storage Pools Dataview and the check the value in the Collocate column

stgpoolcollocation.png

To change the collocation method being used

Admin CLI:  UPDATE STGPOOL COLLOCATE=GROUP

From TSM Studio

Go to the Storage Pools dataview and right click on the storage pool(s) you want to change

and choose Collocation

stgpoolreusemenu.png

Choose the collocation method and press Ok

choosecollocationmethod.png

 

The next thing to do will be create the collocation groups

From TSM Studio open the Configuration category and open the Collocation dataview

Right Click and Choose Add Group

collocationaddgroup.png

Enter the Group Details and then press Ok

collocationgroupdialog.png

Next Add Members to the Group, From the Collocation Dataview right click the Group and Choose Edit Group Members

NOTE: A Node can only be a member of one collocation group

collocationeditmember.png

Simply move nodes in and out of the group and press Ok

Read Here for Trouble Shooting Tips

Recommendations:  If you have plenty of tapes and will never run out then use FILESPACE or NODE.

If Tapes are at a premium and you dont care how long a restore will take then dont use collocation

Otherwise you will need to find a happy medium between tape usage and restore times using the Group method.  I have seen a number of different methods for collocating node, such as grouping by application type or OS Type.  I suggest putting nodes with small amounts of data that does not change very often together and putting nodes with large amounts of data by themselves.  For the rest of the nodes try and keep each group from using more that 50 tapes for any node in the group ( this number will depend on the number of drives you have, how fast the library can load the tapes and how fast the drive can move to the required location on the tape) to ensure fast restore times.

I have seen collocation disabled for copypools as a lot of organizations already replicate the critical data to their Business Recovery sites using other methods

As with everything I say in these articles test, test end test again

NOTE:  Virtual Tape Libraries do not have the same limitations as Physical Tapes. As the mount times and seek times are negligible collocation can be disabled without affecting restore times.

Permalink.

Reuse Delay

The reuse delay parameter is used to define how long a tape will stay in a pending state. It is specified in days and can be applied individually to primary sequential and copy storage pools (in other words storage pools that handle tapes).

Why do we need this parameter?   This parameter is used to ensure that if you had to restore your TSM Database to a previous days backup that the tapes will be in a consistent state with the TSM Database as at the point of the restore.

To Illustrate this, assume that the reuse delay parameter is set to 0 so that tapes become scratch tapes as soon as they are empty.

Monday

A TSM Database Backup is taken on Monday

Tape A1 currently has data for Node ZZ

Tuesday

The data for Node ZZ on tape A1 expires and because the reuse delay parameter is set to 0 tape A1 becomes a scratch tape

Tape A1 is now immediately used to backup node YY’s data

Wednesday 

For some reason, you have to restore to the last TSM database backup which was taken on the Monday.

Because the database is now running as at Monday TSM believes that tape A1 holds the data for Node ZZ.  A decision is made to restore data for Node ZZ which resides on A1 and TSM complains that the volume is corrupt because the data on the tape is not what TSM is expecting. In this case if the reuse delay parameter had been set to 2 days then tape A1 would not have been written on and the restore would work as expected.

How do I check for the tape status ?

Tapes that are empty but not yet available to be used as scratch tapes have a status of PENDING. To view pending tapes in TSM Studio open the Libraries and Volumes category and double click on the Volumes Dataview. As seen below check the “Status” column and look for tapes in a ‘PENDING” state.

volumetsmnav.png

volumetsmnav.png

To see when these tapes will become scratch tapes, check the Pending Date.  This is the date that the tape went into a pending state. Add the Reuse Delay value to determine when the tape will go from a Pending State to becoming a scratch tape.

volumependingdatecolumn.png

To find the Reuse Delay value check the Storage Pool that the Volume is in

volumetsmnav.png

Then goto the Storage Pools dataview locate the same Storage Pool name and check the Reuse Delay Column

stgpoolreuse.png

How do I set the value for this parameter ?

I recommend that you set the value of this parameter to be equal with the number of days or TSM Database backups you keep.

To change the reuse delay parameter from the command line

Update STGPOOL STGPOOL_NAME REUSEDELAY=days

Where STGPOOL_NAME is the name of the storage pool and days is the value for the REUSEDELAY parameter

UPDATE STGPOOL TAPEPOOL REUSEDELAY=2 for 2 days

To change the reuse parameter from TSM Studio goto the Storage Pools Dataview, select the storage pool that you wish to modify, right click to bring up the context menu. Select Reuse Delay and choose the value (in days) you wish to set. Press Ok

stgpoolreusemenu.png

Permalink.

Mount Retention

The Mount Retention parameter specifies how long to keep a tape in a tape drive after it has finished being used. By default the value of this parameter is set to 60 minutes. So a tape will stay in the drive for 1 hour after it is finished with.

Why?  The main reason for having this parameter high is that a tape mount is a relatively expensive operation in that is can take some time for a tape library to unmount and mount a tape, so if the same tape is likely to be used again in the near future it will not need to re-mounted if it is already in the tape drive thus saving time either for backup or restore tasks. If you have a shared library environment or do not have a lot of drives then I recommend you bring this value right down to around 5 mins ( or even 1 minute if tape drive contention is a big issue ). With Virtual Tape Libraries tape mounts operations are extremely fast and high mount retention values are actually detrimental to the performance of the system. In this case the mount retention parameter should be set to 1 minute. The mount retention parameter is defined in a device class. Device Classes are defined per Tape Library and each device class affects all the drives in the library it is defined with.

To change the Mount Retention parameter using the command line update devclass device_class_name MOUNTRETENTION=minutes   where device_class_name is the name of the device class minutes is the number of minutes to keep the tape in the drive after it is finished being used

To change the Mount Retention parameter using TSM Studio Firstly open the Device Classes dataview in the Configuration Category and double click to open the dataview

deviceclass-categgory.png

Find the Library Column and locate the library that you wish to change

deviceclasslibrary.png

Select this row and right click to bring up the context menu for this object and select Change Mount Retention

menuchangemountretention.png

Choose the Mount Retention Value and press Enter to Change

mountretention.png

Permalink.

*** Disclaimer ***

All the articles that I have written are from my own personal experiences using TSM for the past 15+ years. TSM is a diverse product that can be setup and deployed in many ways. Before using any of the methods in the articles, ensure that you use due diligence to test that all steps will work as described in your environment.

If you have comments, like help with the contents in one of the articles or would like to see an article on a particular TSM topic please send me an email at gelliott@spiritsoftware.biz. You are welcome to use these articles on your own sites as long as you have a link on the article back to this site

 

Example:  Written by Spirit Software Solutions

Graeme Elliott CEO,
Founder and Chief Architect
Spirit Software Solutions

All Articles are copyrighted by Spirit Software Solutions

 

*** LEGAL STUFF ***

Direct, incidental, consequential, indirect, or punitive damages arising out of your access to, or use of, the site and articles within. Without limiting the foregoing, everything on the site is provided to you ‘AS IS’ WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, OR NON INFRINGEMENT. “Please note that some jurisdictions may not allow the exclusion of implied warranties, so some of the above exclusions may not apply to you. Check your local laws for any restrictions or limitations regarding the exclusion of implied warranties.”

Permalink.

How can I see what files have been restored using TSM Studio

Firstly for the TSM Instance to be able to capture information about restored files the following option must be enabled in the dsmserv.opt and the TSM instance restarted

REPORTRETRIEVE   Yes

 

Then in TSM Studio you can use the Client Node–>Show Restored Files dataview to show restored file for a given date rangle

 

ShowRestoredFiles

Permalink.

Show can I work with TSM Studio Data Offline

In most of the TSM Studio dataviews there is an option to Export data to XML

ExportToXml

 

This XML can be loaded back into TSM Studio at any time without having a connection to a TSM Server using the Tools–>Load Dataview from XML Option

LoadDataviewFrom Xml

 

Permalink.

The file TSM Studio.scfg already exists error

If the following error message is seen when starting TSM Studio

The file ‘……\AppData\Roaming\Spirit Software Solutions\TSM Studio\TSM Studio.scfg’ already exists
Error 100 (Provider v5.0.3.1237): Cannot create data storage or file: ……\AppData\Roaming\Spirit Software Solutions\TSM Studio\TSM Studio.scfg
Error 113 (Provider v5.0.3.1237): Cannot create database: ……\AppData\Roaming\Spirit Software Solutions\TSM Studio\TSM Studio.scfg

This indicates there is a problem with the TSM Studio configuration file

Try cleaning the configuration file using the Clean Config File Utility

CleanConfigFile

If the Clean Config File utility indicates there is an issue with the configuration file then there are a number of options

  • Restore the configuration file from a previous backup
  • Delete the Configuration File, TSM Studio will recreate it but you have to re-enter the TSM Server definitions and license key
  • Send the Configuration File to support@spiritsoftware.biz and we will attempt to recover it

 

 

 

Permalink.

The result collection contains duplicate objects – error message when starting TSM Studio

This error is caused by duplicate keys in the TSM Studio configuration file. In our own testing labs we have re-created this issue by starting more than 1 copy of TSM Studio at the same time. There is no issue running multiple issues of TSM Studio simultaneously but we suggest waiting until TSM Studio is fully activated before opening another copy.

This will be resolved in TSM Studio 2.9.3.4. In the meantime to remove the duplicate keys now download the following program –> DuplicateKeysFix

Permalink.

Setting up Client Node Statistics Dataviews in TSM Studio

The Node (Backup, Restore, Archive and Retrieve ) Statistics dataviews in TSM Studio source their data from the TSM Server Activity Log.

The format of the numbers in the Activity Log is dependent on the regional and TSM Client settings on the Client Node so it is possible that there may a number of different number formats stored in the Activity Log. This does cause issues for TSM Studio when trying to determine which number system is being used and converting to numbers. To address this issue TSM Studio 2.9.3.5 has added configuration options to set defaults and overrides for the different number systems.

Firstly the default setting which all be used for all Client Nodes data can be set using the Settings–>Client Node Statistics Settings–>Client Node Statistics Defaults as shown here

 

In the settings dialog specify the default values used for the decimal point and thousands separator.

Use the Client Node Statistics Overrides to change this setting for individual Client Nodes

 

 

 

 

Permalink.

MHVTL and TSM Studio

To use TSM Studio to help configure libraries and drives presented from MHVTL to a windows TSM Server see this video by K. Gundurao

http://kgundurao.blogspot.in/2014/02/mhvtl-configuration-in-tsm-with-help-of.html

Permalink.

Running TSM Studio Version 2 on Windows 10

When TSM Studio 10 is installed, it is installed with a prepackaged version of IBM’s TSM Admin CLI   (dsmadmc.exe).  The version in 2.9.4.6 is not supported on Windows 10.

To run on Windows 10 you will need to install and use the version that is in the latest TSM Backup Client you can use the instruction in the TSM Studio Installation documentation see link below.

https://spiritsoftware.biz/knowledgebase/installing-the-administrative-cli-windows/

Then go to setting –> options

optionssettings

 

And setup the new location of the dsmadmc executable

 

gnernalsetttings

This issue will be resolved in version 3 which will be a free upgrade if your support and maintenance is up-to-date

 

Permalink.

Adding one or more TSM Server(s)

Adding Multiple Servers from the Servers Dataview
Expand Server->Configuration and Double Click on Servers

adding_multiple_tsm_server

 

The first task to perform after installing TSM is to add your TSM Servers. There are two ways to add your servers. You can add each TSM Server manually or import them from the TSM Servers Dataview  ( To be able to import your servers from the Servers Dataview you first must define a TSM Server manually ).

See an Example Here of setting up a TSM Server 
Adding a TSM Server

adding_a_tem_server

 

User Profiles :- – A quick note here about User Profiles. If you use the same userid with the same password to connect to all your TSM Servers then setup a User Profile. See the Knowledge Base article on User Profiles – User Profiles KB Article

 
Adding TSM Servers Manually

TSM Server Definition Dialog is Displayed, Enter the TSM Server Details

adding_a_tem_server1

Right Click on the TSM Servers Navigation view and Select Add TSM Server.

  • Enter the Server Name ( Any name that has meaning to you )
  • Enter a Description for this server (optional)
  • Enter the IP Address or DNS name for this server
  • Enter the Port of leave at the default  (1500)
  • Switch to the Logon Tab
  • If you are using a User Profile then select the User profile to use
  • Otherwise enter the Userid and Password for this TSM Server
  • Check the Auto Logon checkbox if you do not want to be prompted for a Password when connecting to the TSM Server

The same as above but with an example of using a DNS name instead of IP address

adding_a_tem_server2

 

Once you have created your first TSM Server you can now import the rest of your servers from the Server Dataview.

adding_a_tem_server3
  • Expand your TSM Server to show the Dataview Categories
  • Expand the Configuration Category
  • Double Click on the Servers node.
  • Select the Servers You want to import
  • Right Click on the Dataview to bring up the dataview context menu
  • There are two options for importing either using the IP Address of the Server Name
    • IP Address will put the IP Address in the address field for the TSM Server Definition
    • Server Name will put the Server Name in the address field for the TSM Server Definition
  • Next Specify the User Profile of Userid details for these servers and they will all be imported into TSM Studio
adding_multiple_tsm_server1

Select the servers to Import and Select the Import Servers to TSM Studio ( either Using IP Address or Using Server name, see below for the differences )

adding_multiple_tsm_server2

A Dialog will appear requesting the Userid and Password details, fill this in

adding_multiple_tsm_server3


Example Importing using IP Address

adding_multiple_tsm_server4

Example importing the same server using Server Name ( Notice the Server Address Field )

Spirit Software Solutions

Permalink.

Changing DRM Properties

Changing properties related to the Disaster Recovery Manager features in TSM is very easy in TSM Studio. Just right click on the TSM Server that you wish to change the properties for and select DRM Properties and change the settings as required

With version 2.0 of TSM Studio you can make this change at the group level as well to change the settings on multiple TSM Servers in one command.

blank_page

Spirit Software Solutions

 

Permalink.

Changing TSM Server Properties

TSM Server Properties are settings that can be changed using the TSM SET command. TSM provides most of these options in an easy to use  tabbed interface.

To access the TSM Server Properties Page, goto the TSM Servers Navigation Window, right click on the TSM Server of interest and when the context menu appears choose Properties

See Example Here

tsm_server_properties
The TSM Server Properties Dialog will appear

tsm_server_properties1

 

The following SET Commands are handled by this dialog

SET SERVERNAME
SET SERVERHLADDRESS
SET SERVERLLADDRESS
SET SUBFILE
SET LOGMODE
SET REGISTRATION
SET CONFIGREFRESH
SET TOCLOADRETENTION
SET CONFIGMANAGER
SET CROSSDEFINE
SET ARCHIVERETENTIONPROTECTION
SET ACCOUNTING
SET CONTEXTMESSAGING
SET ACTLOGRETENTION
SET SUMMARYRETENTION
SET LICENSEAUDITPERIOD
SET EVENTRETENTION
SET PASSEXP
SET INVALIDPWLIMIT
SET MINPWLENGTH
SET AUTHENTICATION
SET SCHEDMODES
SET MAXSCHEDSESSIONS
SET CLIENTACTDURATION
SET RANDOMIZE
SET QUERYSCHEDPERIOD
SET MAXCMDRETRIES
SET RETRYPERIOD

blank_page

Spirit Software Solutions

 

Permalink.

Enabling\Disabling the Password Expiry Checking Feature

The password expiry checker is enabled by default. It will once a day check to see if the password for the userid’s that have been configured to connect to the TSM Servers defined in TSM Studio have expired.

If they have expired a message will popup on the screen to inform you that your password is about to expire.

To disable this feature

  1. Goto Settings->Options
  2. Goto to the Security Tab
  3. Disable the Password Expiry Checker by unchecking the Notify when TSM Server Password is ablout to expire

Permalink.

Groups

TSM Studio makes it very easy to view the data from multiple TSM Servers in one dataview. The first step to make this happen is to create a Group.

 Use the following steps to create a group

  1. Right Click in the TSM Server Navigation Window to bring up the context menu
  2. Select Add Group from the Menu

  3. Enter a Name for the Group

  4. Enter a Description (optional)

  5. Go to the TSM Servers Tab and select the TSM Servers for this group

The group will now have the same structure as the any of the individual servers and each time you open a dataview under a group, all the data for all the TSM Servers in that group will be seen

 

Select Add Group from the TSM Navigation Window context Menu

groups_example
Enter the Group Details and then Move to the TSM Servers Tab

groups_example1

Select the Servers to part of this Group

groups_example2

Expand the Groups Folder-> the newly created group to expose the available Dataview’s, Choose a dataview for example we have chosen the Storage Pools Dataview which will show all storage pool information for all TSM Servers in this group

groups_example3

Spirit Software Solutions

Permalink.

How can I find if I have nodes that are not in Collocation Groups

Sometimes you may find that you are running out of scratch tapes faster than you expected or you may have a large number of tapes in a filling status. One of the causes for this is that you may have collocation enabled on your storage pools. This can be checked by opening the Storage  Pool Dataview and checking the COLLOCATE column. If the storage pool has a value of NO or is blank then collocation is not being used. If there is a value of GROUP, NODE or FILESPACE then it is important that you have your nodes defined in Collcation Groups.

To open the Storage Pool Dataview goto the Storage Category and double click on Storage Pools

To open the Nodes not in a Collcation Group Dataview goto the Trouble Shooting Caegory and double click on Nodes not in a collocation Group

Storage Pools with Collocation Enabled

collocation_example
Nodes Not in a Collocation Group Dataview

collocation_example1

Spirit Software Solutions

 

Permalink.

How can I reply to outstanding TSM Requests

To reply to outsatnding requests from your TSM Server. Open the Monitor Category and select by double clicking the Query Requests dataview.

Select the Request to reply to and right click the Dataview to bring up the dataview context menu.

Select Reply from the Menu

query_requests

Permalink.

How can I see the dsm.opt files being used

Each TSM Server that TSM Studio connects to has its own temporary DSM.OPT created when TSM Studio starts.

To see the names of these DSM.OPT files for each TSM Server goto View–>Show Opt File Names, this will give a list of each TSM Server and its associated DSM.OPT file

Spirit Software Solutions

Permalink.

How can I see which Schedules were missed in the Last 24 Hours

The Missed Scheduled Dataview can be found in the Monitor category and is available at both the Group and Server level

Missed Schedules for the Last 24 Hours at the Server Level

missed_schedule
Missed Schedules for the Last 24 Hours at the Group Level

missed_schedule1

Permalink.

How do I query the activity log

TSM Studio provides the ability to serach the Activity Log either at the TSM Server level or at the Group Level. Using this feature at the Group Level is a powerful way of searching the Activity Log of Multiple TSM Server similtaneously.

To Query the Activity Log at the TSM Server Level,

  • Expand TSM Servers from the TSM Servers navigation window
  • Choose the TSM Server
  • Right Click on the TSM Server to access its context menu
  • Select Query the Activity Log
  • Enter the Search Criteria required  ( All Fields are optional )
  • Press Ok

To Query the Activity Log at the Group Level,

  • Expand Groups from the TSM Servers navigation window
  • Choose the Group
  • Right Click on the TSM Server to access its context menu
  • Select Query the Activity Log
  • Enter the Search Criteria required  ( All Fields are optional )
  • Press Ok


Query a Server Activity Log

query_the_activity_log
Query a Group of Servers

query_the_activity_log1
Activity Log Dialog

query_the_activity_log2
Press Ok to Show the Dataview

query_the_activity_log3
Right Click on the Dataview Window to access the context menu and select New Query to run another search

query_the_activity_log4

Permalink.

How do I see how many scratch tapes I have left

TSM Studio provides and easy way to see how many scratch tapes each Library on your TSM Server has available. You can view the scratch tapes on a single TSM Server or on a Group of Servers Just go to the Troubleshooting category and select the Scratch Tape Counts by Library

Scratch Tape Count – Example
For a Single Server

scratch_tape_counts_by_library
For a Group

scratch_tape_counts_by_library1

Permalink.

How do I view the TSM Help for a Command

TSM provides a very powerful and easy way for you view help on TSM Commands. On the Main Toolbar there is a blue circle with a question mark in it. Press this to access the TSM Command help dialog.

TSM Studio needs a list of commands from the TSM Server, so they first time this dialog is run TSM Studio will connect to the Reference TSM Server and download all the available commands from the TSM Server, this process only happens once and the data is stored in a local cache.  Also to note that this process only get a lists of commands but not the help text.

In the  Display Help dialog there are three fields

Reference TSM Server – This is the server that TSM Studio will use if it needs any help text

Command – This is the command to display help for

Variation– Some Commands take more than one form such as the Define Schedule Command which has the following forms  Define Schedule ( Admin ) and Define Schedule ( Client )

Press Display TSM Help Icon from Main Tool Bar

using_tsm_help

Display TSM Help Dialog

using_tsm_help1

Command Tab

using_tsm_help2

Syntax Tab

using_tsm_help3

Parameters Tab

using_tsm_help4

Privilege

using_tsm_help5

Related Commands

using_tsm_help6

Example

using_tsm_help7

And finally the full help Tab which displays the full help desk from the Help Command

using_tsm_help8

Each time the help text for a command is loaded it is stored in the local TSM Studio Cache. If for any any reason you wish to update the help text ( for example when pulling the help from a TSM Server running a different version ) then use the Reload into Cache button on the bottom of the dialog

Permalink.

How to find which volume has a particular file on it

To find out which file a Volume resides on, use the Tools->Search Volumes for File

  • Enter the TSM Server to Search On
  • Enter the Node Name that the file resides on
  • Enter the FileSpace that the file resides on
  • Enter the FileName  ( * can be used for a wildcard search ie *NOTEPAD.EXE*, if wildcards are not used then the full path needs to be entered )

Select Tools -> Search Volumes for File

search_volume_for_file

Enter the Search criteria, The * can be used for wildcard search, if a wildcard search is not done then the full path to the filename is required

search_volume_for_file1

Permalink.

Installing TSM Studio

TSM Studio requires the Tivoli Storage Manager (TSM) Admin Client to be able to connect to and retrieve data from TSM Servers.

The Admin Client is packed in the windows TSM Backup Client package but is not installed by default.  See Below for installation instructions

To verify that the TSM Admin Command Line has been installed, go to the installation directory ( default is – C:\PROGRAM FILES\TIVOLI\TSM\BACLIENT ) and check for the existance of dsmadmc.exe. 

If you have any troubles installing the TSM Admin Client, shoot us an email we will be happy to help out. 

1. Start the Tivoli Storage Manager Client Install

admin_client_install

2. Choose the installation Folder

admin_client_install1

3. Choose Custom Setup

admin_client_install2

4. IMPORTANT – Make sure to the Administrative Client Command Line option is selected for install

admin_client_install3

5. Choose Install

admin_client_install4

Permalink.

Opening Remote Desktop or Putty to my TSM Server

TSM Studio provides a quick and easy way to connect via Remote Desktop or Putty to you TSM Server. Simply Right click on the TSM Server you wish to connect to in the TSM Server Navigation window and choose either

  • Start Putty Session or
  • Start Remote Desktop Session


If Putty or mstsc ( Remote Desktop ) executables are not in the path them use Tools–>Options ( On 1.7 or below ) Settings–>Options ( 1.8 and above) and on the General Tab input the paths to the executables

Accessing Putty and Remote Desktop
accessing_putty

Input Full to executables if Required
accessing_putty1

Spirit Software Solutions

Permalink.

TSM Studio Dashboard

The TSM Studio dashboard gives a graphical display of the current status of the selected TSM Server.  The Server Dashboard can be found under the Monitor Category and is  only available under individual server not at the Group level.

Permalink.

User Profiles

User Profiles provides an easy way to manager userids and passwords used to connect to your TSM Servers. If you use the same userid and password to connect to multiple TSM Servers or use a Central Configuration Server then we recommend you use User Profiles

  1. Goto Tools–>User Profiles to access the User Profiles Dialog
  2. Click on the Add User Profile button in the Tool Bar
  3. Give your User Profile a meaningful Name
  4. Enter the Userid and Password
  5. If you want TSM Studio to Auto Logon to your TSM Server without prompting for a password then check the Auto Logon checkbox

Now when you create your TSM Server you can link it to this User Profile. Changing the userid or password that is used to connect to these TSM Servers is now as easy as changing the user profile

To assign the User Profile to TSM Servers already defined

  1. Goto Tools–>Assocaite User Profile to TSM Servers
  2. Choose the User Profile to Assign
  3. Choose the Servers to Assign the User Profile Too

Permalink.

Using the Admin Schedule Time of Day View

The Admin Schedule Time of Day view provides a graphical display of your Scheduled Admin  jobs. You can change the start time for each job by simply dragging that task to the new start time.

The Admin Schedule Time of Day View can be found under the Automation Category of an individual TSM Server. It is not available at the Group Level

You can also Add, Edit and Delete Admin Scheduled tasks from this view.

Admin Schedules Time of Day Diagram

admin_task_time_of_day

To change the scheduled time of the task just click on the take and drag it to the new time to start. You can move multiple task by selecting more than one task


admin_task_time_of_day1

To Edit other details of the job then double click the task to bring up the edit window

admin_task_time_of_day2

To Enable or Disable a Task then right click on the task to bring up the context menu and select enable or disable

admin_task_time_of_day3

Spirit Software Solutions

Permalink.

Using the Chargeback Feature

There are two dataviews relating to charge back in TSM Studio. They can be found in the Charge Back category for a Server or Group.

To set a cost per MB to be used in a Dataview

  1. Goto Settings–>Options
  2. Goto the Chargeback Tab
  3. Enter Your cost per MB

The two Dataviews source their data from different internal TSM Tables

The Charge Back by Node uses the Audit Occupancy table and it is IMPORTANT to note that the Audit Occupancy table is only updated when an AUDIT LICENSE is run so before opening this dataview or running a report based on this dataview make sure it has been run

The Change Back by File System uses the Occupancy TSM Table so has no pre-requesities to being run

Permalink.

Using the Location’s Feature

This feature is only available in TSM Studio Professional

The Locations feature in TSM Studio has been designed withe TSM Consultant in mind. As you travel from site to site using TSM Studio you will just want to work with the TSM Servers relevant to that Location, to this end you can enable the Locations Feature and assign TSM Servers to a Location and then just view the TSM Servers for the Location you want to see.

To Enable Locations go to Settings–>Options and then to the General Tab and click the Enable Locations option

This adds a drop down box Locations and a Locations Icon to the Toolbar.  By default the “Default” Location is displayed. The Default Location will show all the TSM Servers that are defined.

To Add a New Location, click the Locations button on the Toolbar and then Click the Add Button in the Locations Dialog, simply add the Location Name, Description and choose the servers for this location

Enable Locations Settings -> Options and goto the General Tab

locations

There will now be a Locations Button and Drop Down on the Main Toolbar on the Desktop

locations1

Click the Locations Button to bring up the Locations Dialog and Click the Add Button to add a new Location the Simply Choose the Servers and Groups that will be available when this Location is selected

locations2

Permalink.

Using the TSM Studio Console

The TSM Studio console provides a way to see the console from a single or multiple TSM Servers in one window.  Messages can be color coded, filtered or the entire window paused so the messages can be analyzed.

Goto with the Group or TSM Server in the TSM Servers Navigation Window expand down to the Monitor Category and double click on Console

  The console window will now be opened and messages from that select TSM Server ( or the TSM Servers in the Group selected will be displayed )

 

Filtering Messages – The simplest way to stop a message from showing in the console window is to highlight that message, right click on the console window to bring up the context menu and select Filter Message from the menu. This will stop all messages with the selected Message Number from displaying

For more advanced filtering click on the Filter option from the console context menu. This will display the Advanced Filtering Dialog, you can choose to create Exclude Filters which will exclude they console messages that match the input pattern or create Include Filters which will include the console messages that match the input pattern.  Include Filters override the Exclude Filters.

To add a Filter click the Add Filter button from the Tool Bar menu,

  • Click the Include\Exclude button to choose the type of Filter
  • Enter the pattern Matching type ( Message Numer or Message Text ), this will select which field the String that is entered later in the dialog will match against
  • Search Type ( Either Exact Match, Wildcard match (use * ), or Regular Expression Match
  • String – The string pattern to search for
  • Enabled – Whether or not this Filter Rule is enabled. If the rule is not enabled it will not be applied against the console messages

Using the Disable All\Enable All buttons on the Tool Bar Menu all the Filter Rules both Include and Exclude can disabled or enabled in one go

Adding and Removing Servers It is possible to Add and Remove servers from the console window by using the Add and Remove button on the Main Tool Bar

When a TSM is shutdown or goes offline, TSM Studio will automatically keep trying to reconnect to that server until it is available again or it is removed from the Console Window

TSM Studio Console Feature
Double click the Console option from the Monitor Category


console

Example Filter Message


console1

Post Filter Message

console2

Using the Advanced Filter

console3


Advanced Filter Dialog


console4

Add a Filter to remove any messages in the console message that IBM in the Message Text

console5

Post Add Filter

console6

Permalink.

Viewing Multiple TSM Server at the same time ( Groups )

TSM Studio makes it very easy to view the data from multiple TSM Servers in one dataview. The first step to make this happen is to create a Group.

 Use the following steps to create a group

  1. Right Click in the TSM Server Navigation Window to bring up the context menu
  2. Select Add Group from the Menu

  3. Enter a Name for the Group

  4. Enter a Description (optional)

  5. Go to the TSM Servers Tab and select the TSM Servers for this group

The group will now have the same structure as the any of the individual servers and each time you open a dataview under a group, all the data for all the TSM Servers in that group will be seen

Select Add Group from the TSM Navigation Window context Menu

groups_example
Enter the Group Details and then Move to the TSM Servers Tab

groups_example1

Select the Servers to part of this Group

groups_example2

Expand the Groups Folder-> the newly created group to expose the available Dataview’s, Choose a dataview for example we have chosen the Storage Pools Dataview which will show all storage pool information for all TSM Servers in this group

groups_example3

Permalink.

What’s this Red Exclamation Mark

Whenever TSM Studio has trouble connecting to a TSM Server a Red Exclamation Mark will appear next to the Server and in the Main Tool bar. Until the error is cleared TSM Studio will not connect to that TSM Serves, this is to ensure that if the error is password related that the userid will not get locked.

To see what the error is right click on the TSM Server in the TSM Server Navigation Window and Select Show Server Connection Error or Click in the Red Exclamation Mark in the Tool bar.

Once the Error has been corrected Clear the Error by selecting the Clear Server Connection Error from the TSM Navigation Window context menu or select the Error in the Connections Dialog Box ( Visible after selecting the Rad Exclamation Icon on the Main Tool bar)  and press the Clear Server Error button

Red Exclamation Connection Error Indicators

RedExclamationEx1

Select the TSM Server in the TSM Navigation Window and right click to bring up the context menu and select Show Server Connection Error or Press the Icon on the Main Tool bar

RedExclamationEx2

This will display the Connection Errors Dialog, Once the Error is fixed, Select the Error from this dialog and Press the Clear Server Error button on the bottom of the dialog and the Red Exclamation Icons will disappear

RedExclamationEx3

Permalink.

Alternate Row Colors

Alternate Row BackColor Example

Alternate_Row_BackColor
Alternate_Row_BackColor1

Using the Alternate Row Color feature can make the data easier to read. After opening a dataview right click to bring up the dataview context menu and select the Alternate Row BackColor option or select it from the Toolbar and the color you wish to use

Permalink.

Customizing the Columns

The columns in a Dataview can be customized in a number of ways,

  • Columns can be moved
  • Columns can be hidden
  • Column Display Text can be changed
  • The alignment can be changed
  • The format of the data can be changed

To modify the columns right click on the dataview to display the dataview context menu and select columns ( or choose columns from the menu bar ). A dialog will be displayed showing a list of all the available columns and their settings.

Use the up and down arrow keys on the menu to change the order the columns are displayed.

To Hide a field click on the Hidden field for the column to hide.

To Change the Display text for a field click over the text in the Column Display Text field.

Use the Alignment Column to select the alignment for that column.

The Format field is used to the control how the column displays its data for example.

N0 defines a number field with no decimal points.

N2 defines a number field with 2 decimal points.

G defines a date field and shows just the date.

g defines a date field and shows the date and time

These are standard dotnet formats. If you want to have the data displayed in a different way let us know and we will help you format the data the way you want to see it.

Permalink.

Displaying Line Numbers

This will display Line Numbers as shown below

Sometimes it is handy to be able to the see line numbers in a dataview.

Right click on the Dataview and select the Line Numbers option from the Dataview context menu ( or from the Main Menu Bar ) to disable/ enable line numbers.

To Enable Line Numbers click on the Line Numbers option from the Dataview Context Menu.

Permalink.

Exporting the Data

From time to time you may wish to export the data from a dataview. TSM Studio provides a number of formats that you can use to export to Excel, PDF,  XPS and XML. .

Right click on the Dataview to display the context menu for that Dataview and select from the available Export Options, then choose the ourput file name.

Data exported to XML can be reloaded later using the Load from XML option on the Dataview context menu, this allows you to work offline if you wish.

 

Spirit Software Solutions

Permalink.

Filtering the Data

TSM Studio provides extremely powerful filtering capabilities.

At the top of each column on the right hand side where the title is displayed you will also notice a small filter icon. Click on this icon to display the filtering dialog for that column. The icon is only displayed when the mouse is positioned in the column header.

Filtering Examples
Show all rows where Devclass = ‘DISK’

Show all Rows where Stgpool Name is either DISKPOOL or BACKUPPOOL.

Permalink.

Get Column Totals ( Summary Feature )


Sometimes it is useful to be able to total, sum or average a column.


Right click on the Dataview to display the context menu and select Show Summaries.

ShowSummaries1
A dialog will be displayed asked for the field to summarize
ShowSummaries2
The summarized value will now be shown at the bottom of the dataview
ShowSummaries3

 

Spirit Software Solutions

Permalink.

Grouping the Data

This is what the appearance of resultant dataview will look like.

AlternateRowColorsEx1
AlternateRowColorsEx2

It can be useful to group the displayed data. Grouping can be done on a single column or multiple columns.

To enable grouping Right Click on the dataview to bring up the dataview context menu and select the Group By option. This will create a small header area at the top of the dataview.

Drag the column to which you want to group by into this header.

Permalink.

Realtime Monitoring


Select the Monitor Field option from the dataview context menu.

Realtime_Monitor_Example

Then choose the field to monitor and select Ok

Realtime_Monitor_Example1

The Monitor Parameter dialog will now be displayed.

Realtime_Monitor_Example2

A Number of the Dataviews ( such as the Storage Pool and Database Dataviews)  have an extra option in their context menu – Monitor Field.

This option allows you to choose one of the numeric fields in the dataview and watch it change over time.

  • To access the realtime monitor right click on the dataview to bring up the dataview context menu. 
  • Select the object you wish to monitor 
  • Select the Monitor Field option from the Menu
  • Select the field you wish to monitor

Spirit Software Solutions

Permalink.

What Dataviews are available

Spirit Software Solutions

See the Dataviews and Commands PDF found here  https://spiritsoftware.biz/tsm-studio-documentation/

Permalink.

Using the Timer

The Timer option is used to auto refresh any dataview. This can be useful when watching the running processes or attached sessions.

Right Click on the Dataview to bring up the Dataview content menu, select Timer

DataviewTimer

 

Enable the timer and select the interval to have the dataview auto refresh

 

DataviewTimerDialog

 

 

Spirit Software Solutions

Permalink.

    • Home
    • FAQ
    • IBM Redbooks
    • Known Issues
    • Pre Release
    • Privacy Policy
    • Sitemap
    • TSM Documentation
    • TSM Studio Dataviews
    • TSM Resources
    • TSM Studio Videos
  • RSS IBM TSM Notifications

    • Terms of Use
    • IT43823: DOCUMENTATION FOR THE UPDATE STATUSTHRESHOLD IS MISLEADING.
    • IT43779: TIER STORAGE POOL SUMMARY PROCESS HANGS WITH WORKER PROCESS SHOWING ZERO FILES/BYTES PROCESSED.
    • IT43750: REMOVE REPLNODE IN MULTI-TARGET REPLICATION ENVIRONMENT CAN SET NODE REPLICATION STATE TO NONE
    • IT43630: VERSION 8.1.X API FUNCTION DSMUPDATEFS() PERFORMANCE IS DEGRADEDCOMPARED TO PREVIOUS API VERSIONS
    • IT43739: ANR4560E MAY OCCUR ON COMBINATIONS DOCUMENTED AS COMPATIBLE.
© 2014-2023 Spirit Software Solutions
  • Download
  • Purchase
  • Products
  • Support
  • Resellers
  • Contact Us