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 (59)

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.

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.

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.

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.

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.

View category→

TSM Studio Server (3)

Microsoft SQL Server settings for TSM Studio Server

If SQL Server is running on the same Server as the TSM Studio Server service then we recommend 12GB of memory as a minimum to ensure the healthy running on TSM Studio Server.

By default SQL Server will be configured to use all available memory this will need to be changed so that there is enough free memory for  TSM Studio Server to function. It is recommended  that SQL Server be given 4GB of memory and the other 8GB is left available for TSM Studio Server.

To change the default memory settings in SQL Server. Start up SQL Server Management Server right click on the server and select properties

SQLServerProperties

 

Select Memory and then enter 4096 into the Maximum server memory field

sqlservermemorysettings

 

Permalink.

Performance Tuning TSM Studio Server


In TSM Studio Server 2.9.011 and above there are a number of added enhancements to help tune TSM Studio for you environment.

The first area to check is on the Concurrency Tab of the TSM Studio Server properties dialog which can be accessed from Configuration–>Properties as shown here

PropertiesMenuItem

 

The main setting to check here are Concurrent Reports and Concurrent Collector Threads. Report creation can consume large amount of memory so it is recommended to keep this number low.

PropertiesConncurrency

Also some of the collections can consume a large amount of transaction log space especially the activity log collector.  Each collector  can be individually tuned.  Goto Configuration->Collection schedules and edit the Activity Log collector and change the Concurrent Collectors to a small number (less than 5 )

ActLogCollection

Also check out the below link for SQL Server memory settings


https://www.spiritsoftware.biz/knowledgebase/microsoft-sql-…-studio-server

Permalink.

TSM Studio Server Security

As of TSM Studio Server version 2.9.1.0 security has been tightened up and no longer stores any security information in the registry.

The default logon to TSM Studio Server is now admin with a default password of password, (Domain field should be blank otherwise TSM Studio Server will assume it is a windows userid).

We strongly advise changing the admin password using the following procedure.

To change the password for the inbuilt admin userid use the Security–>Change Admin Password

SecurityChangeAdminPassword

 

Security in TSM Studio Server is now defined by assigning role(s) and Windows groups to a TSM Studio Server security group.

The TSM Studio Server security system will automatically create a group named Admins that has access to all functions in TSM Studio Server, the first time it is loaded it will look for the old group definitions in the registry and load them into this group otherwise it will populate with following default groups Administrators, Domains Admins and TSMStudioAdmins.

Also two roles will be created, one called Administrators which is assigned to the Admins Server group and one called Operational Report Viewer for allowing access to the Operational Report Viewer.

To access TSM Studio Server Groups select Security–>Groups

SecurityGroups

 

To modify the Admins Group Double Click or select edit from the Toolbar

SecurityGroupsList

 

Add Windows Group that should have admin access to TSM Studio Server, One Group per line

AddSecurityGroup

 

 

 

 

 

 

Permalink.

View category→

Dataviews (10)

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.

View category→

TSM (10)

How do I know which management classes are applied to my files and folders

In Windows you can use the Preview Include-Exclude option in the backup client.

Start the backup client and go to the utilities menu and select Preview Include-Exclude

bacclientutilitiespreviewincludeexclude.png

In the Preview Include-Exclude Dialog, choose the type either Backup or Archive ( Your normal nightly jobs will usually be of type backup )

Choose either to just show included files, excluded files or both. This information is ascertained from settings in your dsm.opt file

Choose  the directories and files to be reported on. If you have a large file system and you choose a top level directory this command may take a long time to run and produce a large output file

Lastly choose the output file and select ok

bacclientpreviewincludeexcludedialog.png

When the task finishes open the output file with notepad and it will look as follows with the files on the left and the management class on the left hand side

previewincludeexcludeoutput.png

The same preview include-exclude can be achieved with the backup-archive command line in both unix and windows as follows.  This example will produce the same out as above

previewincludeexcludecmdline.png

the -traverse=y tells the backup-archive client to include subdirectories

Permalink.

Windows TSM Scheduler Service

This article describes installation and configuration of the TSM Scheduler Service on windows. The TSM Scheduler service is used by the TSM Scheduling Services to automate client node backups.

I am using the version 6 client for these examples, even though the screens look different it is still the same process for the version 5 clients

After installing the Windows Backup Archive client start the Backup-Archive GUI go to the Utilities–>Setup Wizard

setupwizardmenuitem.png

tsmschedulersetupwizard.png

Select Next

Select Next on TSM Schedule Wizard Screen

Choose Install a new or additional scheduler

tsmschedulertask.png

Choose a Name for the Service. This the name you will in the Windows Services Manager

tsmschedulername.png

This is what you will see in Windows Service Manager

tsmschedulerwindowsservices.png

Choose an options file to be associated with this TSM Scheduler Service. It is possible to run multiple TSM Scheduler Service’s using different option files

tsmscheduleroptionsfile.png

Choose the node name for this TSM Service. Again it is possible to use a different node name for each TSM Scheduler Service and input the password. This node name will need to be registered on the TSM Server or the service will not start.

tsmschedulerauthentication.png

Choose the userid that the service will start as.  This userid will need to have access to all the files it must backup or be a member of the backup operators group in windows

tsmschedulerserverlogin.png

Choose the location for the scheduler service log files

tsmschedulerlogfiles.png

NOTE:  Some of these options are stored with the TSM Scheduler service and not in the options file and will override the option file settings. These values are stored in the registry at the following location

HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesTSM Client SchedulerParameters     (replace TSM Client Scheduler with the name you used when installing the service )

tsmschedulerregistry.png

Permalink.

Expiration

Expiring old backup and archive data from TSM is controlled by the EXPINTERVAL in your dsmserv.opt file.

EXPINTERVAL=24  specifies to run the expire process every 24 hours.

EXPINTERVAL=0 disables automatic expiration.

Removing old data from TSM can be run manually using the expire inventory command. Data is expired using the “Management Class” definitions that you have set on your files or if none are defined then the defaults for the policy set are used.  ( I will discuss policy sets in an upcoming article )

In version 5 expiration can only be run system wide, in version 6 you can run the expire inventory command on individual nodes, this is useful when changing management classes on individual nodes.

I recommend that you set the EXPINTERVAL to 0 so that you can control at what time this process runs and the setup an admin schedule to run the expire inventory command

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.

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.

View category→

Helpful TSM SQL Commands (29)

Show the number of Linux Client Nodes on a TSM Server

TSM v5

SELECT COUNT(*) FROM NODES WHERE PLATFORM_NAME LIKE ‘%LINUX%’

 

TSMv6 and above

SELECT COUNT(*) FROM NODESVIEW WHERE PLATFORM_NAME LIKE ‘%LINUX%’

Permalink.

Show all volumes in an error state

SELECT * FROM VOLUME WHERE UPPER(ERROR_STATE) = ‘YES’

Permalink.

Show the number of Windows Clients on a TSM Server

TSM v5

SELECT COUNT(*) FROM NODES WHERE PLATFORM_NAME LIKE ‘WIN%’

TSM v6 and above

SELECT COUNT(*) FROM NODESVIEW WHERE PLATFORM_NAME LIKE ‘WIN%’

Permalink.

Show volumes with write errors

SELECT * FROM VOLUMES WHERE WRITE_ERRORS>5     (Use a number relevant for your environment, this should be 0 if using a VTL)

 

NOTE: The > symbol when using the TSM Admin CLI is also used for redirection. To ensure it is used for correct intention here as a GREATER THAN sign remove the spaces on either side of the > symbol

Permalink.

Show All Filespaces that have not backed up or did not backup successfully

TSM v5

SELECT NODE_NAME, FILESPACE_NAME from FILESPACE  WHERE BACKUP_END IS NULL OR BACKUP_END < BACKUP_START

 

TSMv6

SELECT NODE_NAME, FILESPACE_NAME from FILESPACEVIEW  WHERE BACKUP_END IS NULL OR BACKUP_END < BACKUP_START

Permalink.

View category→
    • Home
    • FAQ
    • IBM Redbooks
    • Known Issues
    • Pre Release
    • Privacy Policy
    • Product Comparison
    • Sitemap
    • TSM Documentation
    • TSM Studio Dataviews
    • TSM Studio Documentation
    • TSM Resources
    • TSM Studio Videos
  • Twitter

    • #WCF If you are looking for an easy authentication method that you can use in WCF with multiple service contracts - http://t.co/ZjGu8UNJvF 25 April from Twitter Web Client
    • See the new blog on #TSMStudio posted on the tsmblog website - http://t.co/WHhd2oWRXa. 25 April from Twitter Web Client
    • Just finished the Microsoft WCF learning stream at http://t.co/oy2RmpnBqy absolutely fantastic way to understand WCF in-depth. 16 April from Twitter Web Client
    @spirit_software
  • Recent Comments

    • Operational Reporting Viewer - Spirit Software Solutions on How to uninstall6 years ago[…] Supported on Windows XP SP3, Vista. ...
    • TSM Studio Alerting - Spirit Software Solutions on How to uninstall6 years ago[…] TSM Studio Alerting Client Supported on ...
    • TSM Studio Operational Reporting - Spirit Software Solutions on How to uninstall6 years ago[…] TSM Studio Operational Reporting Client Supported ...
  • RSS IBM TSM Notifications

    • An error has occurred, which probably means the feed is down. Try again later.
© 2014 Spirit Software Solutions
  • Download
  • Purchase
  • Products
  • Support
  • Resellers
  • Contact Us