IBM Tivoli Storage Manager, Version 7.1

Sample commands to run for validation of the database upgrade

Run commands before and after you upgrade a server to get a summary of information about the contents of the server database. Comparing the results of the commands before and after the upgrade can help confirm that all data transferred correctly. Samples provide a set of commands to start with.

The following commands show examples for getting summary information for some specific types of objects:

File spaces: select node_name, count(*) as "Number of Filespaces" from filespaces group by node_name order by 2
Nodes: select platform_name, count(*) as "Number of Nodes" from nodes group by platform_name
Backed-up files: select node_name,sum(num_files) as "Number of Backup Files" from occupancy where type='Bkup' group by node_name
Archived files: select node_name,sum(num_files) as "Number of Archive Files" from occupancy where type='Arch' group by node_name
Management classes: select count(*) as "Number of Management Classes" from mgmtclasses
Server scripts: select count(*) as "Number of Server Scripts" from script_names
Storage pools: select count(*) as "Number of Storage Pools" from stgpools

The following example shows a more complete set of commands. You can run this set of commands as a script from a Tivoli® Storage Manager server command line. Redirect the output to a file to save the results.

select node_name, count(*) as "Number of Filespaces" from filespaces group by node_name order by 2
select platform_name, count(*) as "Number of Nodes" from nodes group by platform_name
select count(*) as "Number of Administrators" from admins
select node_name,sum(num_files) as "Number of Backup Files" from occupancy where type='Bkup'
    group by node_name
select node_name,sum(num_files) as "Number of Archive Files" from occupancy where type='Arch'
    group by node_name
select count(*) as "Number of Schedule Associations" from associations
select count(*) as "Number of Backupsets" from backupsets
select count(*) as "Number of Client Option Sets" from cloptsets
select count(*) as "Number of Collocation Groups" from collocgroup
select count(*) as "Number of Archive CopyGroups" from ar_copygroups
select count(*) as "Number of Backup CopyGroups" from bu_copygroups
select count(*) as "Number of Data Movers" from datamovers
select count(*) as "Number of Device Classes" from devclasses
select count(*) as "Number of Domains" from domains
select count(*) as "Number of Drives" from drives
select count(*) as "Number of Libraries" from libraries
select count(*) as "Number of Library Volumes" from libvolumes
select count(*) as "Number of Volumes" from volumes
select count(*) as "Number of Management Classes" from mgmtclasses
select count(*) as "Number of Node Groups" from nodegroup
select count(*) as "Number of Device Paths" from paths
select count(*) as "Number of Policy Sets" from policysets
select count(*) as "Number of Client Schedules" from client_schedules
select count(*) as "Number of Admin Schedules" from admin_schedules
select count(*) as "Number of Server Scripts" from scripts
select count(*) as "Number of Servers Defined" from servers
select count(*) as "Number of Servers Groups Defined" from server_group
select count(*) as "Number of Storage Pools Defined" from stgpools

Feedback