A Page for all those useful select statements we spend much too much time trying to work out...! One time it's a good idea not to have upset the DBA's over their backups...
Select Statements can be used within TSM to query it's internal database for information. They provide a much more flexible way of interrogating TSM than many of the builtin query commands.
There are many posts on the adsm-l mailing list requesting and providing select statements for various tasks. This page is here as a repositiory for them, many of the statements here come from ADSM-L. If you would like ot be accredited with posting the statement to ADSM-L, please add your details to the page describing the statement. The contibutor field here relates to who posted the statement to the Wiki.
note:
Pages created as part of this page should be created as 'SubPages'. This entails putting a '/' in front of the WikiName linking to your page. See HelpOnEditing/SubPages
Items on this page have been laid out as tables. Please continue this trend, if you are unsure how read HelpOnTables.
Title |
Description |
Contributor |
Reclaimable by days is actually a small TSM script using select statements that shows how many tapes went reclaimable by devclass by day. |
||
Mixed media scratch is a simple select query to count the number of available scratch volumes by media type per library |
||
Shows numfiles and logical occupancy for stgpools per node. If copypools are up to date, occupancies and nufiles should match. |
||
Shows a count of volumes per storage pool |
||
Shows a count of active files (IE existed on client at last incremental) per node and filespace. |
||
Shows a count of the number of files saved in TSM |
||
Shows total GB backed up in previous 24 hours |
||
Shows file versions and state for given node and file |
||
Shows the number of volumes used by a given node |
||
Shows number of volumes used for all nodes |
||
Shows the volumes in use for a given node |
||
Show information about migrations inthe last 24 hours |
||
Show how much data was backed up in last 24 hours |
||
Show the objects/hour for expiration |
||
Shows longest backup session for given node in last 24 hours |
The following is a list of all pages in the CategorySelectStatements category
- Archive date
- ArchiveUsers
- BackupFilesForANode
- BackupMb
- BackupSetVolumesNotCheckedIn
- BackupSets
- Backups
- CategorySelectStatements
- NodesWithoutFilespaces
- Select
- SelectOutput
- SelectStatements
- SelectStatements/LongestBackupSessionIn24Hours
- SelectStatementsSqlFunctionsAndScriptParameters
- Sql:SelectingFromMultipleTables
- WikiSandBox