Other Cool stuff...

Total client data stored (TB)

tsm: SERVER1> SELECT CAST(FLOAT(SUM(logical_mb)) / 1024 / 1024 AS DEC(8,2)) FROM occupancy

Unnamed[1]

----------

73.04

Some TSM Server information

tsm: SERVER1> SELECT server_name, platform, -

VARCHAR(version)||'.'||VARCHAR(release)||'.'||VARCHAR(level)||'-'||VARCHAR(sublevel), -

server_hla, server_lla, server_url, logmode, crossdefine, licensecompliance FROM status

SERVER_NAME: TSM-SERVER1

PLATFORM: AIX-RS/6000

Unnamed[3]: 5.3.3-2

SERVER_HLA: 10.10.10.5

SERVER_LLA: 1500

SERVER_URL:

LOGMODE: NORMAL

CROSSDEFINE: ON

LICENSECOMPLIANCE: VALID

SQL Table Catalog

tsm: SERVER1>SELECT tabschema,tabname,remarks FROM tables

TABSCHEMA TABNAME REMARKS

--------- ------------------ ------------------

ADSM ACTLOG Server activity log

ADSM ADMINS Server administrators

ADSM ADMIN_SCHEDULES Administrative command schedules

ADSM ARCHIVES Client archive files

ADSM AR_COPYGROUPS Management class archive copy groups

ADSM ASSOCIATIONS Client schedule associations

ADSM AUDITOCC Server audit occupancy results

ADSM BACKUPS Client backup files

ADSM BACKUPSETS Backup Set

ADSM BU_COPYGROUPS Management class backup copy

...