itm6對tsm的監控

透過UA的ODBC實現，總共有78個表，mdl檔案內容如下：

//APPL tsm
//NAME ACTLOG S 300 @Server activity log
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from ACTLOG
//ATTRIBUTES
DATE_TIME D 28 @Date/Time
MSGNO N 8 @Message number
SEVERITY D 4 @Message severity
MESSAGE D 256 @Message
ORIGINATOR D 20 @Originator
NODENAME D 64 @Node Name
OWNERNAME D 64 @Owner Name
SCHEDNAME D 32 @Schedule Name
DOMAINNAME D 32 @Policy Domain Name
SESSID N 8 @Sess Number
SERVERNAME D 64 @Server Name
SESSION N 8 @SESSION
PROCESS N 8 @PROCESS
//NAME ADMINS K 300 @Server administrators
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from ADMINS
//ATTRIBUTES
ADMIN_NAME D 64 KEY ATOMIC @Administrator Name
LASTACC_TIME D 28 @Last Access Date/Time
PWSET_TIME D 28 @Password Set Date/Time
CONTACT D 128 @Contact
LOCKED D 12 @Locked?
INVALID_PW_COUNT C 999999 @Invalid Sign-on Count
SYSTEM_PRIV D 80 @System Privilege
POLICY_PRIV D 100 @Policy Privilege
STORAGE_PRIV D 100 @Storage Privilege
ANALYST_PRIV D 80 @Analyst Privilege
OPERATOR_PRIV D 80 @Operator Privilege
CLIENT_ACCESS D 256 @Client Access Privilege
CLIENT_OWNER D 256 @Client Owner Privilege
REG_TIME D 28 @Registration Date/Time
REG_ADMIN D 64 @Registering Administrator
PROFILE D 256 @Managing profile
PASSEXP N 8 @Password Expiration Period
//NAME ADMIN_SCHEDULES K 300 @Administrative command schedules
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from ADMIN_SCHEDULES
//ATTRIBUTES
SCHEDULE_NAME D 32 KEY ATOMIC @Schedule Name
DESCRIPTION D 256 @Description
COMMAND D 256 @Command
PRIORITY C 999999 @Priority
STARTDATE D 12 @Start date
STARTTIME D 8 @Start time
DURATION N 8 @Duration
DURUNITS D 20 @Duration units
PERIOD N 8 @Period
PERUNITS D 20 @Period units
DAYOFWEEK D 60 @Day of Week
EXPIRATION D 12 @Expiration
ACTIVE D 12 @Active?
CHG_TIME D 28 @Last Update Date/Time
CHG_ADMIN D 32 @Last Update by (administrator)
PROFILE D 256 @Managing profile
SCHED_STYLE D 12 @Schedule Style
ENH_MONTH D 52 @Month
DAYOFMONTH D 60 @Day of Month
WEEKOFMONTH D 52 @Week of Month
//NAME ARCHIVES S 300 @Client archive files
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from ARCHIVES
//ATTRIBUTES
NODE_NAME D 64 @Node Name
FILESPACE_NAME D 256 @Filespace Name
FILESPACE_ID N 28 @FSID
TYPE D 16 @Object type
HL_NAME D 256 @Client high-level name
LL_NAME D 256 @Client low-level name
OBJECT_ID N 20 @Server object ID for the client object
ARCHIVE_DATE D 28 @Date/time that the object was archived
OWNER D 64 @Client object owner
DESCRIPTION D 256 @Description
CLASS_NAME D 32 @Mgmt Class Name
//NAME AR_COPYGROUPS S 300 @Management class archive copy groups
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from AR_COPYGROUPS
//ATTRIBUTES
DOMAIN_NAME D 32 @Policy Domain Name
SET_NAME D 32 @Policy Set Name
CLASS_NAME D 32 @Mgmt Class Name
COPYGROUP_NAME D 32 @Copy Group Name
RETVER D 8 @Retain Version
SERIALIZATION D 32 @Copy Serialization
DESTINATION D 32 @Copy Destination
CHG_TIME D 28 @Last Update Date/Time
CHG_ADMIN D 32 @Last Update by (administrator)
PROFILE D 256 @Managing profile
RETINIT D 8 @Retention Initiation
RETMIN N 8 @Retain Minimum Days
//NAME ASSOCIATIONS S 300 @Client schedule associations
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from ASSOCIATIONS
//ATTRIBUTES
DOMAIN_NAME D 32 @Policy Domain Name
SCHEDULE_NAME D 32 @Schedule Name
NODE_NAME D 64 @Associated Nodes
CHG_TIME D 28 @Last Update Date/Time
CHG_ADMIN D 32 @Last Update by (administrator)
//NAME AUDITOCC K 300 @Server audit occupancy results
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from AUDITOCC
//ATTRIBUTES
NODE_NAME D 64 KEY ATOMIC @Node Name
BACKUP_MB N 8 @Backup Storage Used (MB)
BACKUP_COPY_MB N 8 @Backup Storage Used (MB)
ARCHIVE_MB N 8 @Archive Storage Used (MB)
ARCHIVE_COPY_MB N 8 @Archive Storage Used (MB)
SPACEMG_MB N 8 @Space-Managed Storage Used (MB)
SPACEMG_COPY_MB N 8 @Space-Managed Storage Used (MB)
TOTAL_MB N 8 @Total Storage Used (MB)
//NAME BACKUPS S 300 @Client backup files
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from BACKUPS
//ATTRIBUTES
NODE_NAME D 64 @Node Name
FILESPACE_NAME D 256 @Filespace Name
FILESPACE_ID N 28 @FSID
STATE D 16 @File state (active, inactive)
TYPE D 16 @Object type
HL_NAME D 256 @Client high-level name
LL_NAME D 256 @Client low-level name
OBJECT_ID N 20 @Server object ID for the client object
BACKUP_DATE D 28 @Date/time that the object was backed up
DEACTIVATE_DATE D 28 @Date/time that the object was deactivated
OWNER D 64 @Client object owner
CLASS_NAME D 32 @Mgmt Class Name
//NAME BACKUPSETS S 300 @Backup Set
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from BACKUPSETS
//ATTRIBUTES
NODE_NAME D 64 @Node Name
BACKUPSET_NAME D 256 @Backup Set Name
OBJECT_ID N 20 @Server object ID for the client object
DATE_TIME D 28 @Date/Time
RETENTION D 8 @Retention Period
DESCRIPTION D 256 @Description
DEVCLASS D 32 @Device Class Name
//NAME BU_COPYGROUPS S 300 @Management class backup copy groups
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from BU_COPYGROUPS
//ATTRIBUTES
DOMAIN_NAME D 32 @Policy Domain Name
SET_NAME D 32 @Policy Set Name
CLASS_NAME D 32 @Mgmt Class Name
COPYGROUP_NAME D 32 @Copy Group Name
VEREXISTS D 8 @Versions Data Exists
VERDELETED D 8 @Versions Data Deleted
RETEXTRA D 8 @Retain Extra Versions
RETONLY D 8 @Retain Only Version
MODE D 32 @Copy Mode
SERIALIZATION D 32 @Copy Serialization
FREQUENCY C 999999 @Copy Frequency
DESTINATION D 32 @Copy Destination
TOC_DESTINATION D 32 @Table of Contents (TOC) Destination
CHG_TIME D 28 @Last Update Date/Time
CHG_ADMIN D 32 @Last Update by (administrator)
PROFILE D 256 @Managing profile
//NAME CLIENTOPTS S 300 @Client Options
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from CLIENTOPTS
//ATTRIBUTES
OPTIONSET_NAME D 68 @Optionset
OPTION_NAME D 68 @Option
SEQNUMBER N 8 @Sequence number
OPTION_VALUE D 256 @Option Value
FORCE D 4 @Use Option Set Value (FORCE)
OBSOLETE D 12 @Obsolete
WHEN_OBSOLETE D 12 @When Obsolete?
//NAME CLIENT_SCHEDULES S 300 @Client schedules
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from CLIENT_SCHEDULES
//ATTRIBUTES
DOMAIN_NAME D 32 @Policy Domain Name
SCHEDULE_NAME D 32 @Schedule Name
DESCRIPTION D 256 @Description
ACTION D 20 @Action
OPTIONS D 256 @Options
OBJECTS D 256 @Objects
PRIORITY C 999999 @Priority
STARTDATE D 12 @Start date
STARTTIME D 8 @Start time
DURATION N 8 @Duration
DURUNITS D 20 @Duration units
PERIOD N 8 @Period
PERUNITS D 20 @Period units
DAYOFWEEK D 60 @Day of Week
EXPIRATION D 12 @Expiration
CHG_TIME D 28 @Last Update Date/Time
CHG_ADMIN D 32 @Last Update by (administrator)
PROFILE D 256 @Managing profile
SCHED_STYLE D 12 @Schedule Style
ENH_MONTH D 52 @Month
DAYOFMONTH D 60 @Day of Month
WEEKOFMONTH D 52 @Week of Month
//NAME CLOPTSETS K 300 @Client Option Sets
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from CLOPTSETS
//ATTRIBUTES
OPTIONSET_NAME D 68 KEY ATOMIC @Optionset
DESCRIPTION D 256 @Description
LAST_UPDATE_BY D 68 @Last Update by (administrator)
PROFILE D 256 @Managing profile
//NAME COLLOCGROUP S 300 @Collocation groups
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from COLLOCGROUP
//ATTRIBUTES
COLLOCGROUP_NAME D 32 @Collocation Group Name
DESCRIPTION D 256 @Description
CHG_TIME D 28 @Last Update Date/Time
CHG_ADMIN D 32 @Last Update by (administrator)
NODE_NAME D 64 @Node Name
//NAME CONTENTS S 300 @Storage pool volume contents
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from CONTENTS
//ATTRIBUTES
VOLUME_NAME D 256 @Volume Name
NODE_NAME D 64 @Node Name
TYPE D 20 @Type
FILESPACE_NAME D 64 @Filespace Name
FILE_NAME D 256 @Client's Name for File
AGGREGATED D 20 @Aggregated?
FILE_SIZE N 20 @Stored Size
SEGMENT D 20 @Segment Number
CACHED D 20 @Cached Copy?
FILESPACE_ID N 8 @FSID
FILESPACE_HEXNAME D 64 @Hexadecimal Filespace Name
FILE_HEXNAME D 256 @Hexadecimal Client's Name for File
BITFILE_ID N 20 @Bitfile ID
OBJECT_ID N 20 @Object ID
COPIED D 12 @Copied
DAMAGED D 12 @Damaged
//NAME DATAMOVERS K 300 @Data Movers
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from DATAMOVERS
//ATTRIBUTES
MOVER_NAME D 64 KEY ATOMIC @Data Mover Name
TYPE D 16 @Data Mover Type
HL_ADDRESS D 256 @IP Address
LL_ADDRESS D 256 @TCP/IP Port Number
USER_NAME D 64 @User Name
WWN D 16 @WWN
SERIAL D 64 @Serial Number
COPYTHREADS N 8 @Copy Threads
DATA_FORMAT D 32 @Storage Pool Data Format
ONLINE D 40 @On-Line
LAST_UPDATE_BY D 64 @Last Update by (administrator)
LAST_UPDATE D 28 @Last Update Date/Time
//NAME DB S 300 @Server database information
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from DB
//ATTRIBUTES
AVAIL_SPACE_MB N 8 @Available Space (MB)
CAPACITY_MB N 8 @Assigned Capacity (MB)
MAX_EXTENSION_MB N 8 @Maximum Extension (MB)
MAX_REDUCTION_MB N 12 @Maximum Reduction (MB)
PAGE_SIZE C 999999 @Page Size (bytes)
USABLE_PAGES N 8 @Total Usable Pages
USED_PAGES N 8 @Used Pages
PCT_UTILIZED N 4 @Pct Util
MAX_PCT_UTILIZED N 4 @Max. Pct Util
PHYSICAL_VOLUMES N 8 @Physical Volumes
BUFF_POOL_PAGES N 12 @Buffer Pool Pages
TOTAL_BUFFER_REQ N 12 @Total Buffer Requests
CACHE_HIT_PCT N 4 @Cache Hit Pct.
CACHE_WAIT_PCT N 4 @Cache Wait Pct.
BACKUP_RUNNING D 12 @Backup in Progress?
BACKUP_TYPE D 20 @Type of Backup In Progress
NUM_BACKUP_INCR C 999999 @Incrementals Since Last Full
BACKUP_CHG_MB N 12 @Changed Since Last Backup (MB)
BACKUP_CHG_PCT N 4 @Percentage Changed
LAST_BACKUP_DATE D 28 @Last Complete Backup Date/Time
DB_REORG_EST N 8 @Estimate of Recoverable Space (MB)
DB_REORG_EST_TIME D 28 @Last Estimate of Recoverable Space (MB)
//NAME DBBACKUPTRIGGER S 300 @Database backup trigger information
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from DBBACKUPTRIGGER
//ATTRIBUTES
DEVCLASS D 32 @Full Device Class
INCRDEVCLASS D 32 @Incremental Device Class
LOGFULLPCT C 999999 @Log Full Percentage
NUMICREMENTAL C 999999 @Incrementals Between Fulls
CHG_TIME D 28 @Last Update Date/Time
CHG_ADMIN D 64 @Last Update by (administrator)
MININTERVAL C 999999 @Minimum Backup Interval (minutes)
MINLOGFREE C 999999 @Minimum Log Percentage Freed
//NAME DBSPACETRIGGER S 300 @Database space trigger information
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from DBSPACETRIGGER
//ATTRIBUTES
FULLPCT C 999999 @DB Full Percentage
EXPANSIONPCT C 999999 @DB Space Expansion Percentage
EXPANSION_PREFIX D 252 @DB Expansion prefix
MAXIMUM_DB_SIZE N 8 @DB Maximum Size (Megabytes)
MIRROR_PREFIX_1 D 252 @Mirror Prefix 1
MIRROR_PREFIX_2 D 252 @Mirror Prefix 2
CHG_TIME D 28 @Last Update Date/Time
CHG_ADMIN D 64 @Last Update by (administrator)
//NAME DBVOLUMES S 300 @Database volumes
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from DBVOLUMES
//ATTRIBUTES
COPY1_NAME D 256 @Volume Name (Copy 1)
COPY1_STATUS D 20 @Copy Status
COPY2_NAME D 256 @Volume Name (Copy 2)
COPY2_STATUS D 20 @Copy Status
COPY3_NAME D 256 @Volume Name (Copy 3)
COPY3_STATUS D 20 @Copy Status
AVAIL_SPACE_MB N 8 @Available Space (MB)
ALLOC_SPACE_MB N 8 @Allocated Space (MB)
FREE_SPACE_MB N 8 @Free Space (MB)
//NAME DEVCLASSES K 300 @Device Classes
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from DEVCLASSES
//ATTRIBUTES
DEVCLASS_NAME D 32 KEY ATOMIC @Device Class Name
ACCESS_STRATEGY D 12 @Device Access Strategy
STGPOOL_COUNT N 8 @Storage Pool Count
DEVTYPE D 16 @Device Type
FORMAT D 16 @Format
CAPACITY D 40 @Est/Max Capacity
MOUNTLIMIT D 12 @Mount Limit
MOUNTWAIT N 8 @Mount Wait (min)
MOUNTRETENTION N 8 @Mount Retention (min)
PREFIX D 8 @Label Prefix
LIBRARY_NAME D 32 @Library
DIRECTORY D 256 @Directory
SERVERNAME D 64 @Server Name
RETRYPERIOD N 8 @Retry Period
RETRYINTERVAL N 8 @Retry Interval
SHARED D 4 @Shared
HLADDRESS D 256 @HLAddr
MINCAPACITY D 40 @Minimum Capacity
WORM D 4 @WORM
DRIVE_ENCRYPTION D 8 @Drive Encryption
SCALECAPACITY N 8 @Scaled Capacity
LAST_UPDATE_BY D 64 @Last Update by (administrator)
LAST_UPDATE D 28 @Last Update Date/Time
//NAME DISKS S 300 @Disks
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from DISKS
//ATTRIBUTES
NODE_NAME D 64 @Node Name
DISK_NAME D 64 @Disk Name
WWN D 16 @WWN
SERIAL D 64 @Serial Number
ONLINE D 40 @On-Line
LAST_UPDATE_BY D 64 @Last Update by (administrator)
LAST_UPDATE D 28 @Last Update Date/Time
//NAME DOMAINS K 300 @Policy domains
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from DOMAINS
//ATTRIBUTES
DOMAIN_NAME D 32 KEY ATOMIC @Policy Domain Name
SET_LAST_ACTIVATED D 32 @Activated Policy Set
ACTIVATE_DATE D 28 @Activation Date/Time
DEFMGMTCLASS D 32 @Activated Default Mgmt Class
NUM_NODES N 8 @Number of Registered Nodes
BACKRETENTION C 999999 @Backup Retention (Grace Period)
ARCHRETENTION C 999999 @Archive Retention (Grace Period)
DESCRIPTION D 256 @Description
CHG_TIME D 28 @Last Update Date/Time
CHG_ADMIN D 32 @Last Update Date/Time
PROFILE D 256 @Managing profile
//NAME DRIVES S 300 @Drives
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from DRIVES
//ATTRIBUTES
LIBRARY_NAME D 32 @Library Name
DRIVE_NAME D 32 @Drive Name
DEVICE_TYPE D 16 @Device Type
ONLINE D 40 @On-Line
READ_FORMATS D 16 @Read Formats
WRITE_FORMATS D 16 @Write Formats
ELEMENT C 999999 @Element
ACS_DRIVE_ID D 16 @ACS DriveId
DRIVE_STATE D 40 @Drive State
ALLOCATED_TO D 64 @Allocated to
LAST_UPDATE_BY D 64 @Last Update by (administrator)
LAST_UPDATE D 28 @Last Update Date/Time
CLEAN_FREQ D 12 @Cleaning Frequency (Gigabytes/ASNEEDED/NONE)
DRIVE_SERIAL D 64 @Serial Number
VOLUME_NAME D 256 @Volume Name
//NAME DRMCSTGPOOLS S 300 @Copy storage pools managed by the disaster recovery manager
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from DRMCSTGPOOLS
//ATTRIBUTES
STGPOOL_NAME D 32 @Storage Pool Name
//NAME DRMEDIA S 300 @Physical volumes managed by move drmedia
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from DRMEDIA
//ATTRIBUTES
VOLUME_NAME D 256 @Storage pool volumes
STATE D 20 @State
UPD_DATE D 28 @Last Update Date/Time
LOCATION D 256 @Location
STGPOOL_NAME D 32 @Storage Pool Name
LIB_NAME D 32 @Automated LibName
VOLTYPE D 12 @Volume Type
//NAME DRMMACHINE S 300 @Disaster recovery manager machine information
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from DRMMACHINE
//ATTRIBUTES
MACHINE_NAME D 64 @Machine Name
PRIORITY C 999999 @Machine Priority
BUILDING D 16 @Building
FLOOR D 16 @Floor
ROOM D 16 @Room
ADSM_SERVER D 4 @Server?
DESCRIPTION D 256 @Description
CHARACTERISTICS D 4 @Characteristics?
RECINSTRUCTIONS D 4 @Recovery Instructions?
//NAME DRMMACHINECHARS S 300 @Disaster recovery manager machine characteristics
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from DRMMACHINECHARS
//ATTRIBUTES
MACHINE_NAME D 64 @Machine Name
CHARACTERISTICS D 256 @Characteristics
//NAME DRMMACHINENODE S 300 @Disaster recovery manager machine node associations
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from DRMMACHINENODE
//ATTRIBUTES
MACHINE_NAME D 64 @Machine Name
NODE_NAME D 64 @Node Name
//NAME DRMMACHINERECINST S 300 @Disaster recovery manager machine recovery instructions
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from DRMMACHINERECINST
//ATTRIBUTES
MACHINE_NAME D 64 @Machine Name
RECINSTRUCTIONS D 256 @Recovery Instructions
//NAME DRMMACHINERECMEDIA S 300 @Disaster recovery manager machine recovery media associations
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from DRMMACHINERECMEDIA
//ATTRIBUTES
MACHINE_NAME D 64 @Machine Name
RECMEDIA_NAME D 32 @Recovery Media Name
//NAME DRMPSTGPOOLS S 300 @Primary storage pools managed by the disaster recovery manager
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from DRMPSTGPOOLS
//ATTRIBUTES
STGPOOL_NAME D 32 @Storage Pool Name
//NAME DRMRECOVERYMEDIA K 300 @Disaster recovery manager recovery media
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from DRMRECOVERYMEDIA
//ATTRIBUTES
RECMEDIA_NAME D 32 KEY ATOMIC @Recovery Media Name
TYPE D 8 @Type
LOCATION D 256 @Location
DESCRIPTION D 256 @Description
PRODUCT D 16 @Product
PRODUCT_INFO D 256 @Product Information
VOLUMES D 256 @Volume Names
//NAME DRMSRPF S 300 @Recovery plan files in source server
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from DRMSRPF
//ATTRIBUTES
RPF_NAME D 256 @Recovery Plan File Name
NODE_NAME D 68 @Node Name
DEVCLASS_NAME D 32 @Device Class Name
TYPE D 36 @Recovery Plan File Type
MGMTCLASS_NAME D 32 @Mgmt Class Name
RPF_SIZE N 12 @Recovery Plan File Size
RPF_DELETE D 20 @Marked For Deletion
RPF_DELDATE D 28 @Deletion Date
//NAME DRMSTANZA S 300 @Recovery plan file stanza names
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from DRMSTANZA
//ATTRIBUTES
STANZA_NAME D 256 @Stanza Name
//NAME DRMSTATUS S 300 @Disaster recovery manager status information
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from DRMSTATUS
//ATTRIBUTES
PLANPREFIX D 252 @Recovery Plan Prefix
INSTRPREFIX D 252 @Plan Instructions Prefix
PLANVPOSTFIX D 4 @Replacement Volume Postfix
NONMOUNTNAME D 256 @Not Mountable Location Name
COURIERNAME D 256 @Courier Name
VAULTNAME D 256 @Vault Site Name
DBBEXPIREDAYS N 8 @DB Backup Series Expiration Days
CHECKLABEL D 20 @Check Label?
FILEPROCESS D 20 @Process FILE Device Type?
CMDFILENAME D 256 @Command File Name
RPFEXPIREDAYS N 8 @Recovery Plan File Expiration Days
//NAME DRMTRPF S 300 @Recovery plan files in target server
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from DRMTRPF
//ATTRIBUTES
RPF_NAME D 256 @Recovery Plan File Name
NODE_NAME D 68 @Node Name
DEVCLASS_NAME D 32 @Device Class Name
TYPE D 36 @Recovery Plan File Type
MGMTCLASS_NAME D 32 @Mgmt Class Name
RPF_SIZE N 12 @Recovery Plan File Size
RPF_DELETE D 20 @Marked For Deletion
RPF_DELDATE D 28 @Deletion Date
//NAME EVENTS S 300 @Scheduled Event Results
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from EVENTS
//ATTRIBUTES
SCHEDULED_START D 28 @Scheduled Start
ACTUAL_START D 28 @Actual Start
DOMAIN_NAME D 32 @Policy Domain Name
SCHEDULE_NAME D 32 @Schedule Name
NODE_NAME D 64 @Node Name
STATUS D 12 @Status
RESULT N 8 @Result
REASON D 80 @Reason
//NAME FILESPACES S 300 @Client file spaces
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from FILESPACES
//ATTRIBUTES
NODE_NAME D 64 @Node Name
FILESPACE_NAME D 256 @Filespace Name
FILESPACE_ID N 28 @FSID
FILESPACE_TYPE D 32 @Filespace Type
CAPACITY N 20 @Capacity (MB)
PCT_UTIL N 20 @Pct Util
BACKUP_START D 28 @Last Backup Start Date/Time
BACKUP_END D 28 @Last Backup Completion Date/Time
DELETE_OCCURRED D 28 @Deletion occurred in Filespace Date/Time
UNICODE_FILESPACE D 12 @Is Filespace Unicode?
FILESPACE_HEXNAME D 256 @Hexadecimal Filespace Name
//NAME GROUP_MEMBER S 300 @Group Members
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from GROUP_MEMBER
//ATTRIBUTES
GROUP_NAME D 64 @Server Group
MEMBER_NAME D 64 @Members
CHG_TIME D 28 @Last Update Date/Time
CHG_ADMIN D 64 @Last Update by (administrator)
//NAME LIBRARIES K 300 @Libraries
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from LIBRARIES
//ATTRIBUTES
LIBRARY_NAME D 32 KEY ATOMIC @Library Name
LIBRARY_TYPE D 12 @Library Type
ACS_ID N 8 @ACS Id
PRIVATE_CATEGORY N 8 @Private Category
SCRATCH_CATEGORY N 8 @Scratch Category
EXTERNAL_MGR D 256 @External Manager
SHARED D 12 @Shared
LANFREE D 12 @LanFree
OBEYMOUNTRETENTION D 12 @ObeyMountRetention
PRIMARY_LIB_MGR D 64 @Primary Library Manager
AUTOLABEL D 24 @AutoLabel
LAST_UPDATE_BY D 64 @Last Update by (administrator)
LAST_UPDATE D 28 @Last Update Date/Time
LIBRARY_SERIAL D 64 @Serial Number
WORMSCRATCH_CAT N 8 @WORM Scratch Category
RESETDRIVES D 12 @Reset Drives
//NAME LIBVOLUMES S 300 @Library volumes
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from LIBVOLUMES
//ATTRIBUTES
LIBRARY_NAME D 32 @Library Name
VOLUME_NAME D 256 @Volume Name
STATUS D 12 @Status
OWNER D 64 @Owner
LAST_USE D 12 @Last Use
HOME_ELEMENT N 20 @Home Element
CLEANINGS_LEFT N 12 @Cleanings Left
DEVTYPE D 4 @Device Type
MEDIATYPE N 12 @Media Type
//NAME LICENSES S 300 @Server feature licenses
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from LICENSES
//ATTRIBUTES
AUDIT_DATE D 28 @Last License Audit
ORACLE_ACT N 28 @Number of TDP for Oracle in use
ORACLE_TRYBUY N 28 @Number of TDP for Oracle in try buy mode
MSSQL_ACT N 28 @Number of TDP for MS SQL Server in use
MSSQL_TRYBUY N 28 @Number of TDP for MS SQL Server in try buy mode
MSEXCH_ACT N 28 @Number of TDP for MS Exchange in use
MSEXCH_TRYBUY N 28 @Number of TDP for MS Exchange in try buy mode
LNOTES_ACT N 28 @Number of TDP for Lotus Notes in use
LNOTES_TRYBUY N 28 @Number of TDP for Lotus Notes in try buy mode
DOMINO_ACT N 28 @Number of TDP for Lotus Domino in use
DOMINO_TRYBUY N 28 @Number of TDP for Lotus Domino in try buy mode
INFORMIX_ACT N 28 @Number of TDP for Informix in use
INFORMIX_TRYBUY N 28 @Number of TDP for Informix in try buy mode
SAPR3_ACT N 28 @Number of TDP for SAP R/3 in use
SAPR3_TRYBUY N 28 @Number of TDP for SAP R/3 in try buy mode
ESS_ACT N 28 @Number of TDP for ESS in use
ESS_TRYBUY N 28 @Number of TDP for ESS in try buy mode
ESSR3_ACT N 28 @Number of TDP for ESS R/3 in use
ESSR3_TRYBUY N 28 @Number of TDP for ESS R/3 in try buy mode
EMCSYMM_ACT N 28 @Number of TDP for EMC Symmetrix in use
EMCSYMM_TRYBUY N 28 @Number of TDP for EMC Symmetrix in try buy mode
EMCSYMR3_ACT N 28 @Number of TDP for EMC Symmetrix R/3 in use
EMCSYMR3_TRYBUY N 28 @Number of TDP for EMC Symmetrix R/3 in try buy mode
WAS_ACT N 28 @Number of TDP for WAS in use
WAS_TRYBUY N 28 @Number of TDP for WAS in try buy mode
DATARET_ACT D 20 @Is IBM System Storage Archive Manager in use ?
DATARET_LIC D 20 @Is IBM System Storage Archive Manager licensed ?
TSMBASIC_ACT D 20 @Is Tivoli Storage Manager Basic Edition in use
TSMBASIC_LIC D 20 @Is Tivoli Storage Manager Basic Edition licensed
TSMEE_ACT D 20 @Is Tivoli Storage Manager Extended Edition in use
TSMEE_LIC D 20 @Is Tivoli Storage Manager Extended Edition licensed
COMPLIANCE D 20 @Server License Compliance
//NAME LICENSE_DETAILS S 300 @License usage details
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from LICENSE_DETAILS
//ATTRIBUTES
LICENSE_NAME D 12 @License Type
NODE_NAME D 64 @Node Name
LAST_USED D 28 @Last Access Date/Time
TRYBUY D 8 @Is Try Buy?
//NAME LOG S 300 @Server recovery log information
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from LOG
//ATTRIBUTES
AVAIL_SPACE_MB N 8 @Available Space (MB)
CAPACITY_MB N 8 @Assigned Capacity (MB)
MAX_EXTENSION_MB N 8 @Maximum Extension (MB)
MAX_REDUCTION_MB N 8 @Maximum Reduction (MB)
PAGE_SIZE C 999999 @Page Size (bytes)
USABLE_PAGES N 8 @Total Usable Pages
USED_PAGES N 8 @Used Pages
PCT_UTILIZED N 4 @Pct Util
MAX_PCT_UTILIZED N 4 @Max. Pct Util
PHYSICAL_VOLUMES N 8 @Physical Volumes
LOG_POOL_PAGES N 8 @Log Pool Pages
LOG_POOL_PCT_UTIL N 8 @Log Pool Pct. Util
LOG_POOL_PCT_WAIT N 8 @Log Pool Pct. Wait
CONSUMPTION_MB N 20 @Cumulative Consumption (MB)
CONSUMPTION_DATE D 28 @Consumption Reset Date/Time
//NAME LOGSPACETRIGGER S 300 @Recovery Log space trigger information
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from LOGSPACETRIGGER
//ATTRIBUTES
FULLPCT C 999999 @LOG Full Percentage
EXPANSIONPCT C 999999 @LOG Space Expansion Percentage
EXPANSION_PREFIX D 252 @LOG Expansion prefix
MAXIMUM_LOG_SIZE N 8 @LOG Maximum Size (Megabytes)
MIRROR_PREFIX_1 D 252 @Mirror Prefix 1
MIRROR_PREFIX_2 D 252 @Mirror Prefix 2
CHG_TIME D 28 @Last Update Date/Time
CHG_ADMIN D 64 @Last Update by (administrator)
//NAME LOGVOLUMES S 300 @Recovery log volumes
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from LOGVOLUMES
//ATTRIBUTES
COPY1_NAME D 256 @Volume Name (Copy 1)
COPY1_STATUS D 20 @Copy Status
COPY2_NAME D 256 @Volume Name (Copy 2)
COPY2_STATUS D 20 @Copy Status
COPY3_NAME D 256 @Volume Name (Copy 3)
COPY3_STATUS D 20 @Copy Status
AVAIL_SPACE_MB N 8 @Available Space (MB)
ALLOC_SPACE_MB N 8 @Allocated Space (MB)
FREE_SPACE_MB N 8 @Free Space (MB)
//NAME MEDIA S 300 @Physical volumes managed by move media
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from MEDIA
//ATTRIBUTES
VOLUME_NAME D 256 @Storage pool volumes
STATE D 20 @State
UPD_DATE D 28 @Last Update Date/Time
LOCATION D 256 @Location
STGPOOL_NAME D 32 @Storage Pool Name
LIB_NAME D 32 @Automated LibName
STATUS D 8 @Volume Status
ACCESS D 12 @Access
LRD D 28 @Last Reference Date
//NAME MGMTCLASSES S 300 @Management classes
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from MGMTCLASSES
//ATTRIBUTES
DOMAIN_NAME D 32 @Policy Domain Name
SET_NAME D 32 @Policy Set Name
CLASS_NAME D 32 @Mgmt Class Name
DEFAULTMC D 20 @Default Mgmt Class ?
DESCRIPTION D 256 @Description
SPACEMGTECHNIQUE D 80 @Space Management Technique
AUTOMIGNONUSE C 999999 @Auto-Migrate on Non-Use
MIGREQUIRESBKUP D 40 @Migration Requires Backup?
MIGDESTINATION D 32 @Migration Destination
CHG_TIME D 28 @Last Update Date/Time
CHG_ADMIN D 32 @Last Update by (administrator)
PROFILE D 256 @Managing profile
//NAME NODES K 300 @Client nodes
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from NODES
//ATTRIBUTES
NODE_NAME D 64 KEY ATOMIC @Node Name
PLATFORM_NAME D 16 @Platform
DOMAIN_NAME D 32 @Policy Domain Name
PWSET_TIME D 28 @Password Set Date/Time
INVALID_PW_COUNT C 999999 @Invalid Sign-on Count
CONTACT D 256 @Contact
COMPRESSION D 8 @Compression
ARCHDELETE D 12 @Archive Delete Allowed?
BACKDELETE D 12 @Backup Delete Allowed?
LOCKED D 12 @Locked?
LASTACC_TIME D 28 @Last Access Date/Time
REG_TIME D 28 @Registration Date/Time
REG_ADMIN D 64 @Registering Administrator
LASTSESS_COMMMETH D 8 @Last Communication Method Used
LASTSESS_RECVD N 20 @Bytes Received Last Session
LASTSESS_SENT N 20 @Bytes Sent Last Session
LASTSESS_DURATION N 16 @Duration of Last Session
LASTSESS_IDLEWAIT N 16 @Idle Wait Last Session
LASTSESS_COMMWAIT N 16 @Comm. Wait Last Session
LASTSESS_MEDIAWAIT N 16 @Media Wait Last Session
CLIENT_VERSION C 999999 @Client Version
CLIENT_RELEASE C 999999 @Client Release
CLIENT_LEVEL C 999999 @Client Level
CLIENT_SUBLEVEL C 999999 @Client Sub-level
CLIENT_OS_LEVEL D 20 @Client OS Level
OPTION_SET D 64 @Optionset
AGGREGATION D 12 @Aggregated?
URL D 200 @URL
NODETYPE D 8 @Node Type
PASSEXP N 8 @Password Expiration Period
KEEP_MP D 12 @Keep Mount Point?
MAX_MP_ALLOWED N 8 @Maximum Mount Points Allowed
AUTO_FS_RENAME D 8 @Auto Filespace Rename
VALIDATEPROTOCOL D 8 @Validate Protocol
TCP_NAME D 64 @TCP/IP Name
TCP_ADDRESS D 64 @TCP/IP Address
GUID D 48 @Globally Unique ID
TXNGROUPMAX N 8 @Transaction Group Max
DATAWRITEPATH D 12 @Data Write Path
DATAREADPATH D 12 @Data Read Path
SESSION_INITIATION D 256 @Session Initiation
CLIENT_HLA D 64 @HLADDRESS
CLIENT_LLA D 64 @LLADDRESS
COLLOCGROUP_NAME D 32 @Collocation Group Name
PROXY_TARGET D 256 @Proxynode Target
PROXY_AGENT D 256 @Proxynode Agent
//NAME OCCUPANCY S 300 @Client storage occupancy
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from OCCUPANCY
//ATTRIBUTES
NODE_NAME D 64 @Node Name
TYPE D 20 @Type
FILESPACE_NAME D 64 @Filespace Name
STGPOOL_NAME D 32 @Storage Pool Name
NUM_FILES N 8 @Number of Files
PHYSICAL_MB N 16 @Physical Space Occupied (MB)
LOGICAL_MB N 16 @Logical Space Occupied (MB)
FILESPACE_ID N 8 @FSID
//NAME OPTIONS S 300 @Server Options
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from OPTIONS
//ATTRIBUTES
OPTION_NAME D 40 @Server Option
OPTION_VALUE D 256 @Option Setting
//NAME PATHS S 300 @Paths
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from PATHS
//ATTRIBUTES
SOURCE_NAME D 64 @Source Name
SOURCE_TYPE D 16 @Source Type
DESTINATION_NAME D 132 @Destination Name
DESTINATION_TYPE D 16 @Destination Type
LIBRARY_NAME D 64 @Library
NODE_NAME D 64 @Node Name
DEVICE D 64 @Device
EXTERNAL_MANAGER D 256 @External Manager
LUN D 24 @LUN
INITIATOR_ID N 8 @Initiator
DIRECTORY D 128 @Directory
ONLINE D 40 @On-Line
LAST_UPDATE_BY D 64 @Last Update by (administrator)
LAST_UPDATE D 28 @Last Update Date/Time
//NAME POLICYSETS S 300 @Policy sets
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from POLICYSETS
//ATTRIBUTES
DOMAIN_NAME D 32 @Policy Domain Name
SET_NAME D 32 @Policy Set Name
DEFMGMTCLASS D 32 @Default Mgmt Class Name
DESCRIPTION D 256 @Description
CHG_TIME D 28 @Last Update Date/Time
CHG_ADMIN D 32 @Last Update by (administrator)
PROFILE D 256 @Managing profile
//NAME PROCESSES S 300 @Client schedule associations
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from PROCESSES
//ATTRIBUTES
PROCESS_NUM N 8 @Process Number
PROCESS D 64 @Process Description
START_TIME D 28 @Start Date/Time
FILES_PROCESSED N 8 @Files Processed
BYTES_PROCESSED N 20 @Bytes Processed
STATUS D 256 @Status
//NAME PROFILES S 300 @Profiles
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from PROFILES
//ATTRIBUTES
CONFIG_MANAGER D 64 @Configuration manager
PROFILE_NAME D 32 @Profile name
LOCKED D 12 @Locked?
DESCRIPTION D 256 @Description
//NAME PROF_ASSOCIATIONS S 300 @Profile associations
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from PROF_ASSOCIATIONS
//ATTRIBUTES
CONFIG_MANAGER D 64 @Configuration manager
PROFILE_NAME D 32 @Profile name
ASSOC_OBJECT D 16 @Associated object type
OBJECT_NAME D 64 @Object name
//NAME RECLAIM_ANALYSIS S 300 @Server reclamation analysis table
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from RECLAIM_ANALYSIS
//ATTRIBUTES
CATEGORY D 12 @Analysis category
NODE_NAME D 64 @Node Name
FILESPACE_NAME D 256 @Filespace Name
ENTRYTYPE D 40 @Analysis file copy type
HL_NAME D 256 @Client high-level name
LL_NAME D 256 @Client low-level name
OBJTYPE D 16 @Object type
ID D 100 @Object Identifier
AUDIT_STATE D 40 @Analysis object state
//NAME RESTORES S 300 @Client restore operations
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from RESTORES
//ATTRIBUTES
SESSION N 8 @Sess Number
RESTORE_STATE D 40 @Restore State
RESTORE_MINUTES N 8 @Elapsed Minutes
NODE_NAME D 64 @Node Name
FILESPACE_NAME D 256 @Filespace Name
FILESPEC D 256 @File Spec
FILESPACE_ID N 8 @FSID
//NAME SAN S 300 @SAN attached devices
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from SAN
//ATTRIBUTES
DEVICE_TYPE D 20 @Device Type
VENDOR D 8 @Vendor
PRODUCT D 16 @Product
SERIAL D 64 @Serial Number
DEVICE D 64 @Device
IS_DATAMOVER D 12 @Data Mover
NODE_WWN D 16 @Node WWN
PORT_WWN D 16 @Port WWN
LUN N 8 @LUN
SCSI_PORT N 8 @SCSI Port
SCSI_BUS N 8 @SCSI Bus
SCSI_TARGET N 8 @SCSI Target
//NAME SCRIPTS S 300 @Server Command Scripts
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from SCRIPTS
//ATTRIBUTES
NAME D 32 @Name
LINE N 8 @Line Number
COMMAND D 256 @Command
CHG_TIME D 28 @Last Update Date/Time
CHG_ADMIN D 32 @Last Update by (administrator)
//NAME SCRIPT_NAMES K 300 @Server Command Script Names
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from SCRIPT_NAMES
//ATTRIBUTES
NAME D 32 KEY ATOMIC @Name
DESCRIPTION D 256 @Description
CHG_TIME D 28 @Last Update Date/Time
CHG_ADMIN D 32 @Last Update by (administrator)
PROFILE D 256 @Managing profile
//NAME SERVERS K 300 @Remote server nodes
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from SERVERS
//ATTRIBUTES
SERVER_NAME D 64 KEY ATOMIC @Server Name
COMMMETH D 8 @Comm. Method
HL_ADDRESS D 200 @High-level Address
LL_ADDRESS D 20 @Low-level Address
DESCRIPTION D 200 @Description
ALLOWREPLACE D 12 @Allow Replacement
NODE_NAME D 64 @Node Name
LASTACC_TIME D 28 @Last Access Date/Time
LOCKED D 12 @Locked?
COMPRESSION D 8 @Compression
ARCHDELETE D 12 @Archive Delete Allowed?
URL D 200 @URL
REG_TIME D 28 @Registration Date/Time
REG_ADMIN D 64 @Registering Administrator
LASTSESS_RECVD N 20 @Bytes Received Last Session
LASTSESS_SENT N 20 @Bytes Sent Last Session
LASTSESS_DURATION N 8 @Duration of Last Session
LASTSESS_IDLEWAIT N 8 @Pct. Idle Wait Last Session
LASTSESS_COMMWAIT N 8 @Pct. Comm. Wait Last Session
LASTSESS_MEDIAWAIT N 8 @Pct. Media Wait Last Session
GRACE_DEL_PERIOD N 8 @Grace Deletion Period
PROFILE D 256 @Managing profile
SERVER_PWD_SET D 12 @Server Password Set
SERVER_PWSET_TIME D 28 @Server Password Set Date/Time
SERVER_INVALID_PWC C 999999 @Invalid Sign-on Count for Server
VVNODE_PWD_SET D 12 @Virtual Volume Password Set
VVNODE_PWSET_TIME D 28 @Virtual Volume Password Set Date/Time
VVNODE_INVALID_PWC C 999999 @Invalid Sign-on Count for Virtual Volume Node
VALIDATEPROTOCOL D 8 @Validate Protocol
//NAME SERVER_GROUP K 300 @Server Groups
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from SERVER_GROUP
//ATTRIBUTES
GROUP_NAME D 64 KEY ATOMIC @Server Group
DESCRIPTION D 256 @Description
CHG_TIME D 28 @Last Update Date/Time
CHG_ADMIN D 64 @Last Update by (administrator)
PROFILE D 256 @Managing profile
//NAME SESSIONS S 300 @Active client sessions
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from SESSIONS
//ATTRIBUTES
SESSION_ID N 8 @Sess Number
START_TIME D 28 @Start Date/Time
COMMMETHOD D 32 @Comm. Method
STATE D 32 @Sess State
WAIT_SECONDS N 8 @Wait Time
BYTES_SENT N 20 @Bytes Sent
BYTES_RECEIVED N 20 @Bytes Recvd
SESSION_TYPE D 20 @Sess Type
CLIENT_PLATFORM D 20 @Platform
CLIENT_NAME D 64 @Client Name
OWNER_NAME D 32 @User Name
MOUNT_POINT_WAIT D 256 @Waiting for mount point(s)
INPUT_MOUNT_WAIT D 256 @Waiting for mount of input volume(s)
INPUT_VOL_WAIT D 256 @Waiting for input volume(s)
INPUT_VOL_ACCESS D 256 @Waiting for mount of input volume(s)
OUTPUT_MOUNT_WAIT D 256 @Waiting for mount of output volume(s)
OUTPUT_VOL_WAIT D 256 @Waiting for output volume(s)
OUTPUT_VOL_ACCESS D 256 @Current output volume(s)
LAST_VERB D 32 @Last Verb
VERB_STATE D 20 @Verb State
//NAME SPACEMGFILES S 300 @Client space-managed files
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from SPACEMGFILES
//ATTRIBUTES
NODE_NAME D 64 @Node Name
FILESPACE_NAME D 64 @Filespace Name
STATE D 16 @File state (active, inactive)
EXTOBJID D 128 @Client object ID for the file
OBJID N 20 @Server object ID for the client object
FILE_NAME D 256 @Client's Name for File
INSERT_DATE D 28 @Date/time that object was migrated
DELETE_DATE D 28 @Date/time that object was deleted
CLASS_NAME D 32 @Mgmt Class Name
//NAME STATUS S 300 @Server status
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from STATUS
//ATTRIBUTES
SERVER_NAME D 32 @Server Name
SERVER_HLA D 64 @Server host name or IP address
SERVER_LLA D 32 @Server TCP/IP port number
SERVER_URL D 200 @Server URL
SERVER_PASSSET D 12 @Server Password Set
INSTALL_DATE D 28 @Server Installation Date/Time
RESTART_DATE D 28 @Server Restart Date/Time
AUTHENTICATION D 4 @Authentication
PASSEXP C 999999 @Password Expiration Period
INVALIDPWLIMIT C 999999 @Invalid Sign-on Attempt Limit
MINPWLENGTH C 999999 @Minimum Password Length
WEBAUTHTIMEOUT C 999999 @WEB Admin Authentication Time-out (minutes)
REGISTRATION D 8 @Registration
AVAILABILITY D 20 @Availability
ACCOUNTING D 4 @Accounting
ACTLOGRETENTION C 999999 @Activity Log Retention
SUMMARYRETENTION C 999999 @Activity Summary Retention Period
LICENSEAUDITPERIOD C 999999 @License Audit Period
LASTLICENSEAUDIT D 28 @Last License Audit
LICENSECOMPLIANCE D 52 @Server License Compliance
SCHEDULER D 20 @Central Scheduler
MAXSESSIONS C 999999 @Maximum Sessions
MAXSCHEDSESSIONS C 999999 @Maximum Scheduled Sessions
EVENTRETENTION C 999999 @Event Record Retention Period
CLIENTACTDURATION C 999999 @Client Action Duration
RANDOMIZE C 999999 @Schedule Randomization Percentage
QUERYSCHEDPERIOD C 999999 @Query Schedule Period
MAXCMDRETRIES C 999999 @Maximum Command Retries
RETRYPERIOD C 999999 @Retry Period
SCHEDMODE D 12 @Scheduling Modes
LOGMODE D 12 @Log Mode
DBBACKTRIGGER D 40 @Database Backup Trigger
ACTIVERECEIVERS D 256 @Active Receivers
CONFIG_MANAGER D 12 @Configuration manager
REFRESH_INTERVAL C 999999 @Refresh interval
LAST_REFRESH D 28 @Last refresh date/time
CROSSDEFINE D 4 @Crossdefine
SUBFILE D 28 @Subfile Backup
CONTEXT_MESSAGING D 16 @Context Messaging
SERVERFREE_STATUS D 28 @Server-free Status
SERVERFREE_BATCH C 999999 @Server-free Batch Size
TOCLOADRETENTION C 999999 @Table of Contents (TOC) Load Retention
MACHINE_GUID D 48 @Machine GUID
ARCHRETPROT D 4 @Archive Retention Protection
PLATFORM D 32 @Platform
VERSION N 8 @Version
RELEASE N 8 @Release
LEVEL N 8 @Level
SUBLEVEL N 8 @Sublevel
//NAME STGPOOLS K 300 @Storage pools
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from STGPOOLS
//ATTRIBUTES
STGPOOL_NAME D 32 KEY ATOMIC @Storage Pool Name
POOLTYPE D 32 @Storage Pool Type
DEVCLASS D 32 @Device Class Name
EST_CAPACITY_MB N 20 @Estimated Capacity
TRIGGER_PCT_UTIL N 4 @Space Trigger Util
PCT_UTILIZED N 4 @Pct Util
PCT_MIGR N 4 @Pct Migr
PCT_LOGICAL N 4 @Pct Logical
HIGHMIG C 999999 @High Mig Pct
LOWMIG C 999999 @Low Mig Pct
MIGPROCESS C 999999 @Migration Processes
NEXTSTGPOOL D 32 @Next Storage Pool
MAXSIZE N 20 @Maximum Size Threshold
ACCESS D 16 @Access
DESCRIPTION D 256 @Description
OVFLOCATION D 256 @Overflow Location
CACHE D 4 @Cache Migrated Files?
COLLOCATE D 20 @Collocate?
RECLAIM C 999999 @Reclamation Threshold
MAXSCRATCH N 8 @Maximum Scratch Volumes Allowed
NUMSCRATCHUSED N 8 @Number of Scratch Volumes Used
REUSEDELAY C 999999 @Delay Period for Volume Reuse
MIGR_RUNNING D 20 @Migration in Progress?
MIGR_MB N 4 @Amount Migrated (MB)
MIGR_SECONDS N 8 @Elapsed Migration Time (seconds)
RECL_RUNNING D 20 @Reclamation in Progress?
CHG_TIME D 28 @Last Update Date/Time
CHG_ADMIN D 32 @Last Update by (administrator)
RECLAIMSTGPOOL D 32 @Reclaim Storage Pool
MIGDELAY N 8 @Migration Delay
MIGCONTINUE D 20 @Migration Continue
DATAFORMAT D 12 @Storage Pool Data Format
COPYSTGPOOLS D 256 @Copy Storage Pool(s)
COPYCONTINUE D 20 @Continue Copy on Error?
CRCDATA D 12 @CRC Data
RECLAIMPROCESS C 999999 @Reclamation Processes
OFFSITERCLMLIMIT D 8 @Offsite Reclamation Limit
RECLAMATIONTYPE D 12 @Reclamation Type
//NAME STGSPACETRIGGER K 300 @Storage Pool space trigger information
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from STGSPACETRIGGER
//ATTRIBUTES
FULLPCT C 999999 KEY @STGPOOL Full Percentage
EXPANSIONPCT C 999999 @STGPOOL Expansion Percentage
EXPANSION_PREFIX D 252 @STGPOOL Expansion prefix
STGPOOL D 32 @STGPOOL
CHG_TIME D 28 @Last Update Date/Time
CHG_ADMIN D 64 @Last Update by (administrator)
//NAME SUBSCRIPTIONS S 300 @Subscriptions
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from SUBSCRIPTIONS
//ATTRIBUTES
CONFIG_MANAGER D 64 @Configuration manager
PROFILE_NAME D 32 @Profile name
SUBSCRIBER D 64 @Subscriber
IS_CURRENT D 12 @Is current?
LAST_UPDATE D 28 @Last update date/time
//NAME SUMMARY S 300 @Server Activity Summary Table
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from SUMMARY
//ATTRIBUTES
START_TIME D 28 @Start time
END_TIME D 28 @End Time
ACTIVITY D 64 @Process or Session Activity Name
NUMBER N 8 @Process or Session Number
ENTITY D 64 @Associated user or storage pool(s) associated with the activity
COMMMETH D 8 @Communications Method Used
ADDRESS D 64 @Communications Address
SCHEDULE_NAME D 32 @Schedule Name
EXAMINED N 20 @Number of objects (files and/or directories) examined by the process/session
AFFECTED N 20 @Number of objects affected (moved, copied or deleted) by the process/session
FAILED N 20 @Number of objects that failed in the process/session
BYTES N 20 @Bytes processed
IDLE N 8 @Seconds that the session/process was idle
MEDIAW N 8 @Seconds that the session/process was waiting for access to media (volume mounts)
PROCESSES N 8 @Number of processes used for process
SUCCESSFUL D 12 @Successful ?
VOLUME_NAME D 64 @Volume Name
DRIVE_NAME D 64 @Drive Name
LIBRARY_NAME D 64 @Library Name
LAST_USE D 64 @Last Use
COMM_WAIT N 8 @Current comm wait time in seconds
NUM_OFFSITE_VOLS N 8 @Number of offsite volumes processed
//NAME VFSMAPPINGS S 300 @Virtual Filespace Mappings
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from VFSMAPPINGS
//ATTRIBUTES
NODE_NAME D 64 @Node Name
VIRTUAL_FS_NAME D 64 @Virtual Filespace Mapping Name
FILESPACE_NAME D 256 @Filespace Name
PATH D 256 @Path
HEXADECIMAL D 12 @Hexadecimal Path?
//NAME VOLHISTORY S 300 @Volume history information
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from VOLHISTORY
//ATTRIBUTES
DATE_TIME D 28 @Date/Time
UNIQUE N 8
TYPE D 20 @Volume Type
BACKUP_SERIES C 999999 @Backup Series
BACKUP_OPERATION C 999999 @Backup Operation
VOLUME_SEQ C 999999 @Volume Seq
DEVCLASS D 32 @Device Class
VOLUME_NAME D 256 @Volume Name
LOCATION D 256 @Volume Location
COMMAND D 256 @Command
//NAME VOLUMES S 300 @Storage pool volumes
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from VOLUMES
//ATTRIBUTES
VOLUME_NAME D 256 @Volume Name
STGPOOL_NAME D 32 @Storage Pool Name
DEVCLASS_NAME D 32 @Device Class Name
EST_CAPACITY_MB N 20 @Estimated Capacity
SCALEDCAP_APPLIED N 8 @Scaled Capacity Applied
PCT_UTILIZED N 4 @Pct Util
STATUS D 20 @Volume Status
ACCESS D 20 @Access
PCT_RECLAIM N 4 @Pct. Reclaimable Space
SCRATCH D 20 @Scratch Volume?
ERROR_STATE D 20 @In Error State?
NUM_SIDES C 999999 @Number of Writable Sides
TIMES_MOUNTED N 8 @Number of Times Mounted
WRITE_PASS N 8 @Write Pass Number
LAST_WRITE_DATE D 28 @Approx. Date Last Written
LAST_READ_DATE D 28 @Approx. Date Last Read
PENDING_DATE D 28 @Date Became Pending
WRITE_ERRORS N 8 @Number of Write Errors
READ_ERRORS N 8 @Number of Read Errors
LOCATION D 256 @Volume Location
MVSLF_CAPABLE D 4 @Volume is MVS Lanfree Capable
CHG_TIME D 28 @Last Update Date/Time
CHG_ADMIN D 32 @Last Update by (administrator)
BEGIN_RCLM_DATE D 28 @Begin Reclaim Period
END_RCLM_DATE D 28 @End Reclaim Period
VOL_ENCR_KEYMGR D 32 @Drive Encryption Key Manager
//NAME VOLUMEUSAGE S 300 @SEQUENTIAL volume usage by client node
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from VOLUMEUSAGE
//ATTRIBUTES
NODE_NAME D 64 @Node Name
COPY_TYPE D 16 @Type
FILESPACE_NAME D 64 @Filespace Name
STGPOOL_NAME D 32 @Storage Pool Name
VOLUME_NAME D 256 @Volume Name
FILESPACE_ID N 8 @FSID
//NAME COLUMNS S 300 @SQL Table Column Catalog
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from COLUMNS
//ATTRIBUTES
TABSCHEMA D 8 @Table schema name (qualifier)
TABNAME D 20 @Table Name
COLNAME D 20 @Column name
COLNO C 999999 @Column number
INDEX_KEYSEQ C 999999 @Column key sequence number
INDEX_ORDER D 4 @Index key sequence (A - ascending D - descending)
TYPENAME D 40 @Column data type
LENGTH N 8 @Column length
SCALE C 999999 @Columns scale (for decimal or numeric columns)
NULLS D 8 @Can column contain NULL values ?
REMARKS D 252 @Description
//NAME ENUMTYPES K 300 @SQL Enumerated Types Catalog
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from ENUMTYPES
//ATTRIBUTES
TYPEINDEX N 8 KEY ATOMIC @Unique index code for enumerated type
TYPENAME D 20 @Declared enumerated type name
VALUECOUNT N 8 @Number of distinct enumeration values
VALUES D 252 @List of enumeration value names ( ordinal position within type )
REMARKS D 252 @Description
//NAME TABLES S 300 @SQL Table Catalog
//SOURCE ODBC tsm user=admin pswd=admin
//SQL Select * from TABLES
//ATTRIBUTES
TABSCHEMA D 8 @Table schema name (qualifier)
TABNAME D 20 @Table Name
CREATE_TIME D 28 @Date/time of creation
COLCOUNT C 999999 @Number of columns in table
INDEX_COLCOUNT C 999999 @Number of index columns
UNIQUE_INDEX D 8 @Is the index unique ?
REMARKS D 252 @Description

[@more@]