notas:bases_de_datos:sql_for_tivoli_storage_manager
Diferencias
Muestra las diferencias entre dos versiones de la página.
Ambos lados, revisión anteriorRevisión previa | |||
notas:bases_de_datos:sql_for_tivoli_storage_manager [2012/02/13 16:59] – [SQL for Tivoli Storage Manager] cayu | notas:bases_de_datos:sql_for_tivoli_storage_manager [Fecha desconocida] (actual) – borrado - editor externo (Fecha desconocida) 127.0.0.1 | ||
---|---|---|---|
Línea 1: | Línea 1: | ||
- | ====== SQL for Tivoli Storage Manager ====== | ||
- | //Useful SQL Statements for TSM//\\ 09/29/2011 | ||
- | |||
- | This page has a collection of useful SQL statements for IBM Tivoli Storage Manager (TSM). Here you can find out a lot of selects that will help you to get information from TSM and to construct your own SQL statements. | ||
- | |||
- | If you have any selects to share or have any comments, please contact me at <thobias (a) thobias org> | ||
- | |||
- | ====== Database and Recovery Log ====== | ||
- | |||
- | ==== List all information from db table ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT * FROM db | ||
- | | ||
- | | ||
- | CAPACITY_MB: | ||
- | | ||
- | | ||
- | PAGE_SIZE: 4096 | ||
- | | ||
- | | ||
- | | ||
- | | ||
- | | ||
- | BUFF_POOL_PAGES: | ||
- | | ||
- | CACHE_HIT_PCT: | ||
- | | ||
- | | ||
- | BACKUP_TYPE: | ||
- | NUM_BACKUP_INCR: | ||
- | BACKUP_CHG_MB: | ||
- | | ||
- | | ||
- | | ||
- | DB_REORG_EST_TIME: | ||
- | </ | ||
- | |||
- | ==== TSM database utilization (%) ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT pct_utilized FROM db | ||
- | | ||
- | PCT_UTILIZED | ||
- | ------------ | ||
- | 82.3 | ||
- | </ | ||
- | |||
- | ==== TSM log recovery utilization (%) ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT pct_utilized FROM log | ||
- | | ||
- | PCT_UTILIZED | ||
- | ------------ | ||
- | 0.0 | ||
- | </ | ||
- | |||
- | ==== Selecting specific columns from db table ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT avail_space_mb, | ||
- | | ||
- | AVAIL_SPACE_MB | ||
- | -------------- | ||
- | | ||
- | 16: | ||
- | </ | ||
- | |||
- | ==== Number of database volumes not synchronized ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT COUNT(*) FROM dbvolumes WHERE ( NOT copy1_status=' | ||
- | copy2_status=' | ||
- | | ||
- | | ||
- | ----------- | ||
- | 0 | ||
- | </ | ||
- | |||
- | ==== Number of log volumes not synchronized ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT COUNT(*) FROM logvolumes WHERE ( NOT copy1_status=' | ||
- | copy2_status=' | ||
- | | ||
- | | ||
- | ----------- | ||
- | 0 | ||
- | </ | ||
- | |||
- | ====== Nodes ====== | ||
- | |||
- | ==== Number of nodes ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT SUM(num_nodes) FROM domains | ||
- | | ||
- | | ||
- | ----------- | ||
- | 165 | ||
- | | ||
- | tsm: SERVER1> SELECT COUNT(*) FROM nodes | ||
- | | ||
- | | ||
- | ----------- | ||
- | 165 | ||
- | </ | ||
- | |||
- | ==== Number of nodes per domain ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT domain_name, | ||
- | | ||
- | DOMAIN_NAME | ||
- | ------------------ | ||
- | AIX 47 | ||
- | EXCHANGE | ||
- | NT 69 | ||
- | VMWARE | ||
- | </ | ||
- | |||
- | ==== Number of nodes per platform ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT platform_name, | ||
- | | ||
- | PLATFORM_NAME | ||
- | ---------------- | ||
- | AIX 20 | ||
- | Linux86 | ||
- | TDP Domino | ||
- | TDP MSSQL Win32 1 | ||
- | WinNT 100 | ||
- | </ | ||
- | |||
- | ==== Nodes locked ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT node_name FROM nodes WHERE locked=' | ||
- | | ||
- | NODE_NAME | ||
- | ------------------ | ||
- | NODE_TEMP | ||
- | NODE99 | ||
- | </ | ||
- | |||
- | ==== Number of nodes locked ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT COUNT(*) FROM nodes WHERE locked=' | ||
- | | ||
- | | ||
- | ----------- | ||
- | 2 | ||
- | </ | ||
- | |||
- | ==== Number of nodes sessions ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT COUNT(*) FROM sessions WHERE session_type=' | ||
- | | ||
- | | ||
- | ----------- | ||
- | 3 | ||
- | </ | ||
- | |||
- | ==== TSM clients version ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT node_name, platform_name, | ||
- | VARCHAR(client_level)||' | ||
- | | ||
- | NODE_NAME | ||
- | -------------- | ||
- | NODE_01 | ||
- | NODE_02 | ||
- | NODE_03 | ||
- | NODE_04 | ||
- | NODE_05 | ||
- | NODE_06 | ||
- | NODE_07 | ||
- | NODE_08 | ||
- | ... | ||
- | </ | ||
- | |||
- | ====== Occupancy ====== | ||
- | |||
- | ==== Number of files per client ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT node_name, SUM(num_files) FROM occupancy GROUP BY node_name | ||
- | | ||
- | NODE_NAME | ||
- | ------------------ | ||
- | NODE01 | ||
- | NODE02 | ||
- | NODE03 | ||
- | NODE04 | ||
- | ... | ||
- | </ | ||
- | |||
- | ==== Space and number of files stored per client ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT node_name, | ||
- | SUM(num_files)as" | ||
- | | ||
- | NODE_NAME | ||
- | ------------------ | ||
- | SERVER-01 | ||
- | SERVER-02 | ||
- | SERVER-03 | ||
- | SERVER-04 | ||
- | ... | ||
- | </ | ||
- | |||
- | ==== Data stored per client (GB) ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT node_name, | ||
- | occupancy GROUP BY node_name | ||
- | | ||
- | NODE_NAME | ||
- | ------------------ | ||
- | SERVER-01 | ||
- | SERVER-02 | ||
- | SERVER 03 | ||
- | SERVER-04 | ||
- | ... | ||
- | </ | ||
- | |||
- | ==== Storage space used per filespace for a specific node ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT node_name, filespace_name, | ||
- | GROUP BY node_name, filespace_name ORDER BY "Total MB" DESC | ||
- | | ||
- | NODE_NAME | ||
- | ------------ | ||
- | NODEABC | ||
- | NODEABC | ||
- | NODEABC | ||
- | NODEABC | ||
- | NODEABC | ||
- | NODEABC | ||
- | NODEABC | ||
- | NODEABC | ||
- | NODEABC | ||
- | NODEABC | ||
- | NODEABC | ||
- | NODEABC | ||
- | NODEABC | ||
- | NODEABC | ||
- | NODEABC | ||
- | NODEABC | ||
- | ... | ||
- | </ | ||
- | |||
- | ==== Storage space used per filespace and per storage pool for a specific node ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT node_name, filespace_name, | ||
- | GROUP BY node_name, filespace_name, | ||
- | | ||
- | NODE_NAME | ||
- | ----------- | ||
- | NODE_XYZ | ||
- | NODE_XYZ | ||
- | NODE_XYZ | ||
- | NODE_XYZ | ||
- | NODE_XYZ | ||
- | NODE_XYZ | ||
- | NODE_XYZ | ||
- | NODE_XYZ | ||
- | NODE_XYZ | ||
- | NODE_XYZ | ||
- | NODE_XYZ | ||
- | NODE_XYZ | ||
- | NODE_XYZ | ||
- | </ | ||
- | |||
- | ==== Storage space used per filespace and per backup/ | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT node_name, filespace_name, | ||
- | GROUP BY node_name, filespace_name, | ||
- | | ||
- | NODE_NAME | ||
- | ---------- | ||
- | NODE_XYZ | ||
- | NODE_XYZ | ||
- | NODE_XYZ | ||
- | NODE_XYZ | ||
- | NODE_XYZ | ||
- | NODE_XYZ | ||
- | NODE_XYZ | ||
- | NODE_XYZ | ||
- | NODE_XYZ | ||
- | NODE_XYZ | ||
- | NODE_XYZ | ||
- | NODE_XYZ | ||
- | </ | ||
- | |||
- | ====== Schedules ====== | ||
- | |||
- | ==== Nodes without associated schedules ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT node_name FROM nodes WHERE node_name NOT IN (SELECT node_name FROM associations) | ||
- | | ||
- | NODE_NAME | ||
- | ------------------ | ||
- | NODE_TEMP | ||
- | SERVER-04 | ||
- | ... | ||
- | </ | ||
- | |||
- | ==== Number of nodes without associated schedules ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT COUNT(*) FROM nodes WHERE node_name NOT IN (SELECT node_name FROM associations) | ||
- | | ||
- | | ||
- | ----------- | ||
- | 12 | ||
- | </ | ||
- | |||
- | ==== Nodes with associated schedules ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT node_name FROM nodes WHERE node_name IN (SELECT node_name FROM associations) | ||
- | | ||
- | NODE_NAME | ||
- | ------------------ | ||
- | NODE01 | ||
- | NODE02 | ||
- | NODE03 | ||
- | NODE04 | ||
- | </ | ||
- | |||
- | ==== Number of nodes associated per schedules ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT domain_name, | ||
- | | ||
- | DOMAIN_NAME | ||
- | ------------------ | ||
- | AIX DAILY 24 | ||
- | AIX WEEKLY | ||
- | LINUX DAILY 38 | ||
- | ... | ||
- | </ | ||
- | |||
- | ==== Information about schedules and associations (2 tables) ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT associations.domain_name, | ||
- | client_schedules.description, | ||
- | client_schedules.objects, | ||
- | client_schedules client_schedules WHERE associations.domain_name = client_schedules.domain_name - | ||
- | AND associations.schedule_name = client_schedules.schedule_name ORDER BY associations.domain_name, | ||
- | associations.node_name, | ||
- | | ||
- | DOMAIN_NAME: | ||
- | NODE_NAME: NODE01 | ||
- | SCHEDULE_NAME: | ||
- | DESCRIPTION: | ||
- | | ||
- | OPTIONS: | ||
- | OBJECTS: / | ||
- | STARTTIME: 21:15:00 | ||
- | | ||
- | DOMAIN_NAME: | ||
- | NODE_NAME: NODE01 | ||
- | SCHEDULE_NAME: | ||
- | DESCRIPTION: | ||
- | | ||
- | OPTIONS: | ||
- | OBJECTS: /usr/ /opt/ /var/ /etc/ /home/ | ||
- | STARTTIME: 09:00:00 | ||
- | ... | ||
- | </ | ||
- | |||
- | ==== Some cool information about node, associations and schedules ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT associations.domain_name, | ||
- | client_schedules.description, | ||
- | client_schedules.objects, | ||
- | client_schedules.starttime, | ||
- | client_schedules.period, | ||
- | client_schedules.expiration, | ||
- | client_schedules.profile, | ||
- | client_schedules.dayofmonth, | ||
- | client_schedules client_schedules WHERE associations.domain_name = client_schedules.domain_name - | ||
- | AND associations.schedule_name = client_schedules.schedule_name ORDER BY associations.node_name, | ||
- | associations.domain_name, | ||
- | | ||
- | DOMAIN_NAME: | ||
- | NODE_NAME: SERVER-01 | ||
- | SCHEDULE_NAME: | ||
- | DESCRIPTION: | ||
- | | ||
- | OPTIONS: -archmc=MC_AIX_WEEKLY | ||
- | OBJECTS: /app2/ | ||
- | | ||
- | STARTDATE: 2006-05-01 | ||
- | STARTTIME: 06:01:00 | ||
- | | ||
- | | ||
- | | ||
- | | ||
- | DAYOFWEEK: TUESDAY | ||
- | | ||
- | | ||
- | CHG_ADMIN: ADMIN | ||
- | PROFILE: | ||
- | SCHED_STYLE: | ||
- | ENH_MONTH: | ||
- | | ||
- | WEEKOFMONTH: | ||
- | | ||
- | DOMAIN_NAME: | ||
- | NODE_NAME: SERVER-02 | ||
- | SCHEDULE_NAME: | ||
- | | ||
- | OPTIONS: | ||
- | OBJECTS: d: | ||
- | | ||
- | STARTDATE: 2006-05-01 | ||
- | STARTTIME: 21:00:00 | ||
- | | ||
- | | ||
- | | ||
- | | ||
- | DAYOFWEEK: Sun | ||
- | | ||
- | | ||
- | CHG_ADMIN: ADMIN | ||
- | PROFILE: | ||
- | SCHED_STYLE: | ||
- | ENH_MONTH: Any | ||
- | | ||
- | WEEKOFMONTH: | ||
- | | ||
- | ... | ||
- | </ | ||
- | |||
- | ====== Drives and Paths ====== | ||
- | |||
- | ==== Some information about paths ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT source_name, | ||
- | device FROM paths | ||
- | | ||
- | SOURCE_NAME | ||
- | -------------- | ||
- | TSM-SERVER1 | ||
- | TSM-SERVER1 | ||
- | TSM-SERVER1 | ||
- | TSM-SERVER1 | ||
- | TSM-SERVER1 | ||
- | </ | ||
- | |||
- | ==== Some information about drives ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT library_name, | ||
- | drive_serial FROM drives | ||
- | | ||
- | | ||
- | | ||
- | DEVICE_TYPE: | ||
- | | ||
- | WRITE_FORMATS: | ||
- | DRIVE_STATE: | ||
- | | ||
- | | ||
- | | ||
- | | ||
- | DEVICE_TYPE: | ||
- | | ||
- | WRITE_FORMATS: | ||
- | DRIVE_STATE: | ||
- | | ||
- | | ||
- | | ||
- | | ||
- | DEVICE_TYPE: | ||
- | | ||
- | WRITE_FORMATS: | ||
- | DRIVE_STATE: | ||
- | | ||
- | </ | ||
- | |||
- | ==== Number of drives not online ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT COUNT(*) FROM drives WHERE NOT online=' | ||
- | | ||
- | | ||
- | ----------- | ||
- | 0 | ||
- | </ | ||
- | |||
- | ==== Number of drives not online in library 3584 ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT COUNT(*) FROM drives WHERE NOT online=' | ||
- | | ||
- | | ||
- | ----------- | ||
- | 0 | ||
- | </ | ||
- | |||
- | ==== Number of paths not online ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT COUNT(*) FROM paths WHERE NOT online=' | ||
- | | ||
- | | ||
- | ----------- | ||
- | 0 | ||
- | </ | ||
- | |||
- | ==== Information about drives utilization ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT library_name, | ||
- | | ||
- | LIBRARY_NAME | ||
- | --------------- | ||
- | LIBRARY3 | ||
- | LIBRARY3 | ||
- | LIBRARY3 | ||
- | LIBRARY3 | ||
- | LIBRARY3 | ||
- | LIBRARY3 | ||
- | LIBRARY3 | ||
- | LIBRARY3 | ||
- | ... | ||
- | </ | ||
- | |||
- | ==== Information about drives x paths ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT b.source_name, | ||
- | | ||
- | SOURCE_NAME | ||
- | ----------- | ||
- | TSM01 L3584 DRIVE1 | ||
- | TSM01 L3584 DRIVE2 | ||
- | TSM01 L3584 DRIVE3 | ||
- | TSM01 L3584 DRIVE4 | ||
- | TSM01 L3584 DRIVE5 | ||
- | TSM02 L3584 DRIVE1 | ||
- | TSM02 L3584 DRIVE2 | ||
- | TSM02 L3584 DRIVE3 | ||
- | TSM02 L3584 DRIVE4 | ||
- | TSM02 L3584 DRIVE5 | ||
- | </ | ||
- | |||
- | ====== Management class ====== | ||
- | |||
- | ==== Management classes per domain ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT domain_name, | ||
- | | ||
- | DOMAIN_NAME | ||
- | ------------------ | ||
- | AIX AIX DAILY Yes | ||
- | AIX AIX WEEKLY | ||
- | AIX ACTIVE | ||
- | AIX ACTIVE | ||
- | LINUX LINUX ARCH1 Yes | ||
- | LINUX ACTIVE | ||
- | ... | ||
- | </ | ||
- | |||
- | ==== Management classes per domain of policy set ACTIVE ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT domain_name, | ||
- | | ||
- | DOMAIN_NAME | ||
- | ------------------ | ||
- | AIX DAILY Yes | ||
- | AIX WEEKLY | ||
- | LINUX ARCH1 Yes | ||
- | ... | ||
- | </ | ||
- | |||
- | ==== Default management class per domain of policy set ACTIVE ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT domain_name, | ||
- | | ||
- | DOMAIN_NAME | ||
- | ------------------ | ||
- | AIX AIX Yes | ||
- | LINUX ARCH1 Yes | ||
- | ... | ||
- | </ | ||
- | |||
- | ==== Management classes of a specifc domain of policy set ACTIVE ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT domain_name, | ||
- | | ||
- | DOMAIN_NAME | ||
- | ------------------ | ||
- | AIX DAILY Yes | ||
- | AIX WEEKLY | ||
- | ... | ||
- | </ | ||
- | |||
- | ==== Management classes of policy set ACTIVE that a specific node can use ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT nodes.domain_name, | ||
- | WHERE nodes.domain_name=mgmtclasses.domain_name AND set_name=' | ||
- | | ||
- | DOMAIN_NAME | ||
- | ------------------ | ||
- | AIX NODE1 DAILY Yes | ||
- | AIX NODE1 WEEKLY | ||
- | ... | ||
- | </ | ||
- | |||
- | ==== Management classes with backup copy group information ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT - | ||
- | | ||
- | | ||
- | FROM - | ||
- | | ||
- | WHERE - | ||
- | | ||
- | | ||
- | | ||
- | | ||
- | ORDER BY - | ||
- | | ||
- | | ||
- | DOMAIN_NAME | ||
- | ------------- | ||
- | STANDARD | ||
- | AIX | ||
- | AIX | ||
- | AIX | ||
- | ... | ||
- | </ | ||
- | |||
- | ==== Management classes with archive copy group information ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT - | ||
- | | ||
- | | ||
- | FROM - | ||
- | | ||
- | WHERE - | ||
- | | ||
- | | ||
- | | ||
- | | ||
- | ORDER BY - | ||
- | | ||
- | | ||
- | DOMAIN_NAME | ||
- | --------------- | ||
- | STANDARD | ||
- | AIX ACTIVE | ||
- | AIX ACTIVE | ||
- | WINDOWS | ||
- | ... | ||
- | </ | ||
- | |||
- | ====== Copy Groups ====== | ||
- | |||
- | ==== Destination pool of each management class (type: archive copy group) ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT domain_name, | ||
- | | ||
- | DOMAIN_NAME | ||
- | ------------------ | ||
- | AIX MC_AIX_DAILY | ||
- | AIX MC_AIX_MONTHLY | ||
- | AIX MC_AIX_NOLIMIT | ||
- | ... | ||
- | </ | ||
- | |||
- | ==== Destination pool of each management class (type: backup copy group) ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT domain_name, | ||
- | | ||
- | DOMAIN_NAME | ||
- | ------------------ | ||
- | AIX MC_AIX_DAILY | ||
- | AIX MC_AIX_TDP | ||
- | ... | ||
- | </ | ||
- | |||
- | ==== Some information about archive copy group ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT domain_name, | ||
- | | ||
- | DOMAIN_NAME | ||
- | ------------------ | ||
- | AIX ACTIVE | ||
- | AIX ACTIVE | ||
- | AIX ACTIVE | ||
- | AIX STANDARD | ||
- | AIX STANDARD | ||
- | AIX STANDARD | ||
- | ... | ||
- | | ||
- | tsm: SERVER1> SELECT domain_name, | ||
- | WHERE set_name=' | ||
- | | ||
- | DOMAIN_NAME | ||
- | ------------------ | ||
- | AIX ACTIVE | ||
- | AIX ACTIVE | ||
- | AIX ACTIVE | ||
- | ... | ||
- | </ | ||
- | |||
- | ==== Some information about backup copy group ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT domain_name, | ||
- | FROM bu_copygroups | ||
- | | ||
- | DOMAIN_NAME | ||
- | ------------- | ||
- | AIX ACTIVE | ||
- | AIX ACTIVE | ||
- | AIX STANDARD | ||
- | AIX STANDARD | ||
- | ... | ||
- | </ | ||
- | |||
- | ====== Activity Log ====== | ||
- | |||
- | ==== Search in the activity log for missed schedules in the last 2 hours ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT date_time, | ||
- | message LIKE' | ||
- | | ||
- | | ||
- | ------------------ | ||
- | 2007-07-26 | ||
- | | ||
- | domain AIX for | ||
- | node SERVER-1 | ||
- | has missed its | ||
- | scheduled start | ||
- | up window. | ||
- | </ | ||
- | |||
- | ==== Search in the activity log for messages with Error severity in the last 1 hour ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT date_time, | ||
- | date_time> | ||
- | | ||
- | | ||
- | ------------------ | ||
- | 2007-07-27 | ||
- | | ||
- | match found using | ||
- | this criteria.( | ||
- | SESSION: 252982) | ||
- | </ | ||
- | |||
- | ==== Search in the activity log for successful, missed or failed schedules in the last 1 day ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT date_time, | ||
- | ( message LIKE' | ||
- | message LIKE' | ||
- | message LIKE' | ||
- | message LIKE' | ||
- | date_time> | ||
- | | ||
- | | ||
- | ------------------ | ||
- | 2007-07-25 | ||
- | | ||
- | NT started at | ||
- | | ||
- | for node SERVER-2 | ||
- | | ||
- | | ||
- | | ||
- | | ||
- | N: 233833) | ||
- | | ||
- | 2007-07-25 | ||
- | | ||
- | NT for node | ||
- | | ||
- | | ||
- | code 1).(SESSION: | ||
- | | ||
- | | ||
- | 2007-07-25 | ||
- | | ||
- | | ||
- | node SERVER-1 | ||
- | has missed its | ||
- | | ||
- | up window. | ||
- | </ | ||
- | |||
- | ==== Search in the activity log for a specific ANR in the last 1 day ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT date_time, | ||
- | and date_time> | ||
- | | ||
- | | ||
- | ------------------ | ||
- | 2007-07-27 | ||
- | | ||
- | | ||
- | in library 3584 | ||
- | | ||
- | | ||
- | | ||
- | | ||
- | 2007-07-27 | ||
- | | ||
- | | ||
- | in library 3584 | ||
- | | ||
- | | ||
- | | ||
- | | ||
- | </ | ||
- | |||
- | ====== Summary ====== | ||
- | |||
- | ==== Summary of archive operations in the last 7 days ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> select cast(float(sum(bytes))/ | ||
- | as " | ||
- | activity=' | ||
- | | ||
- | Archive data in GB | ||
- | -------------------- | ||
- | 14508.09 | ||
- | </ | ||
- | |||
- | ==== Summary of backup operations in a specific range ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT CAST(FLOAT(SUM(bytes))/ | ||
- | AS " | ||
- | AND start_time >{ts ' | ||
- | | ||
- | Backed up data in GB | ||
- | -------------------- | ||
- | 38829.70 | ||
- | </ | ||
- | |||
- | ==== Statistics of archive, backup, restore and retrieve operations per node in the last 7 days (GB) ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT entity, activity, CAST(FLOAT(SUM(bytes)) / 1024 / 1024 / 1024 AS DECIMAL(8, | ||
- | FROM summary WHERE end_time> | ||
- | activity=' | ||
- | | ||
- | ENTITY | ||
- | ------------------ | ||
- | SERVER-01 | ||
- | SERVER-01 | ||
- | SERVER-01 | ||
- | SERVER-02 | ||
- | SERVER-02 | ||
- | SERVER-03 | ||
- | SERVER-04 | ||
- | SERVER-04 | ||
- | ... | ||
- | </ | ||
- | |||
- | ==== Total of backup and archive per node in a specific date ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT entity, CAST(FLOAT(SUM(bytes)) / 1024 / 1024 / 1024 AS DECIMAL(8, | ||
- | FROM summary WHERE ( activity=' | ||
- | start_time >{ts ' | ||
- | GROUP BY entity ORDER BY " | ||
- | | ||
- | ENTITY | ||
- | ------------ | ||
- | NODE01 | ||
- | NODE02 | ||
- | NODE03 | ||
- | NODE04 | ||
- | NODE05 | ||
- | NODE06 | ||
- | NODE07 | ||
- | ... | ||
- | </ | ||
- | |||
- | ==== Summary of Operations in the Last 24 Hours (GB) ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT activity, cast(float(sum(bytes))/ | ||
- | " | ||
- | AND end_time> | ||
- | | ||
- | ACTIVITY | ||
- | ------------------ | ||
- | BACKUP | ||
- | FULL_DBBACKUP | ||
- | MIGRATION | ||
- | RECLAMATION | ||
- | STGPOOL BACKUP | ||
- | </ | ||
- | |||
- | ==== Summary of Operations in a specific date (GB) ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT activity, cast(float(sum(bytes))/ | ||
- | " | ||
- | AND start_time >{ts ' | ||
- | | ||
- | ACTIVITY | ||
- | ------------------ | ||
- | ARCHIVE | ||
- | BACKUP | ||
- | FULL_DBBACKUP | ||
- | MIGRATION | ||
- | RECLAMATION | ||
- | RESTORE | ||
- | RETRIEVE | ||
- | </ | ||
- | |||
- | ==== Volumes reclaimed in the last 48 Hours ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT start_time, end_time-start_time AS ELAPTIME, activity, number, entity, mediaw, successful - | ||
- | FROM summary WHERE activity=' | ||
- | | ||
- | | ||
- | ----------------- ---------------------- --------------- ---------- ------------------ --------- -------------- | ||
- | | ||
- | 12: | ||
- | | ||
- | 12: | ||
- | | ||
- | 12: | ||
- | | ||
- | 12: | ||
- | | ||
- | 12: | ||
- | </ | ||
- | |||
- | ==== Volumes reclaimed in the last 48 Hours (better date format?!) ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT substr(char(start_time), | ||
- | substr(char(end_time - start_time), | ||
- | activity, number, entity, mediaw, successful FROM summary WHERE - | ||
- | activity=' | ||
- | | ||
- | START_TIME | ||
- | --------------- | ||
- | 2008-11-20 | ||
- | | ||
- | 2008-11-20 | ||
- | | ||
- | 2008-11-20 | ||
- | | ||
- | 2008-11-22 | ||
- | | ||
- | 2008-11-22 | ||
- | | ||
- | </ | ||
- | |||
- | ==== Admin tasks information ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT activity, substr(char(start_time), | ||
- | substr(char(end_time - start_time), | ||
- | ( activity=' | ||
- | AND start_time >{ts ' | ||
- | | ||
- | ACTIVITY | ||
- | ------------------ | ||
- | MIGRATION | ||
- | STGPOOL BACKUP | ||
- | FULL_DBBACKUP | ||
- | EXPIRATION | ||
- | RECLAMATION | ||
- | MIGRATION | ||
- | </ | ||
- | |||
- | ====== Volumes ====== | ||
- | |||
- | ==== Number of scratch volumes ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT COUNT(*) FROM libvolumes WHERE status=' | ||
- | | ||
- | | ||
- | ----------- | ||
- | 18 | ||
- | </ | ||
- | |||
- | ==== Number of scratch volumes in library 3584 ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT COUNT(*) FROM libvolumes WHERE status=' | ||
- | | ||
- | | ||
- | ----------- | ||
- | 18 | ||
- | </ | ||
- | |||
- | ==== Number of scratch volumes for each library ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT library_name, | ||
- | | ||
- | LIBRARY_NAME | ||
- | ------------------ | ||
- | 3584 18 | ||
- | </ | ||
- | |||
- | ==== Number of volumes per device class ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT devclass_name, | ||
- | | ||
- | DEVCLASS_NAME | ||
- | ------------------ | ||
- | 3584 133 | ||
- | DISK 6 | ||
- | </ | ||
- | |||
- | ==== Number of volumes per storage pool ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT stgpool_name, | ||
- | | ||
- | STGPOOL_NAME | ||
- | ------------------ | ||
- | AIX_ANUAL | ||
- | AIX_ARCH1 | ||
- | AIX_ARCH2 | ||
- | AIX_DAILY | ||
- | AIX_MONTHLY | ||
- | AIX_NOLIMIT | ||
- | NT_DAILY | ||
- | NT_MONTHLY | ||
- | </ | ||
- | |||
- | ==== Number of volumes unavailable ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT COUNT(*) FROM volumes WHERE access=' | ||
- | | ||
- | | ||
- | ----------- | ||
- | 0 | ||
- | </ | ||
- | |||
- | ==== Number of volumes in error state ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT COUNT(*) FROM volumes WHERE error_state=' | ||
- | | ||
- | | ||
- | ----------- | ||
- | 1 | ||
- | </ | ||
- | |||
- | ==== Volumes with write or read errors in the library ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT volumes.volume_name, | ||
- | volumes.write_errors, | ||
- | volumes.volume_name=libvolumes.volume_name AND ( volumes.write_errors> | ||
- | | ||
- | VOLUME_NAME | ||
- | ------------------ | ||
- | P10128 | ||
- | P10129 | ||
- | P10135 | ||
- | ... | ||
- | </ | ||
- | |||
- | ==== Number of volumes per library ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT library_name, | ||
- | | ||
- | LIBRARY_NAME | ||
- | ------------------ | ||
- | 3584 72 | ||
- | </ | ||
- | |||
- | ==== Volume information ordered by (%) reclaim ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT volume_name, | ||
- | | ||
- | | ||
- | VOLUME_NAME | ||
- | --------------- ----------------- ---------------- ----------- ------------ -------------- ------------- | ||
- | TA0148L4 | ||
- | TA0149L4 | ||
- | TA0045L4 | ||
- | TA0144L4 | ||
- | TA0122L4 | ||
- | TA0172L4 | ||
- | TA0023L4 | ||
- | TA0125L4 | ||
- | ... | ||
- | </ | ||
- | |||
- | ==== Full volumes with utilization (%) less than XX ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT volume_name, | ||
- | WHERE status=' | ||
- | | ||
- | VOLUME_NAME | ||
- | --------------- | ||
- | R00010L3 | ||
- | R00015L3 | ||
- | R00026L3 | ||
- | R00028L3 | ||
- | ... | ||
- | </ | ||
- | |||
- | ==== Full volumes with reclaimable space (%) greater than XX ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT volume_name, | ||
- | WHERE status=' | ||
- | | ||
- | VOLUME_NAME | ||
- | --------------- | ||
- | R00010L3 | ||
- | R00015L3 | ||
- | R00026L3 | ||
- | R00028L3 | ||
- | ... | ||
- | </ | ||
- | |||
- | ==== Full volumes with reclaimable space (%) greater than XX in the library ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT volumes.volume_name, | ||
- | volumes.status, | ||
- | AND volumes.status=' | ||
- | | ||
- | VOLUME_NAME | ||
- | ------------------ | ||
- | 256AFB | ||
- | 295AFB | ||
- | ... | ||
- | </ | ||
- | |||
- | ==== Volumes in a specific storage pool with reclaimable space (%) greater than XX ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT volume_name, | ||
- | WHERE pct_reclaim> | ||
- | | ||
- | VOLUME_NAME | ||
- | ------------------ | ||
- | tape11 | ||
- | tape84 | ||
- | tape86 | ||
- | tape90 | ||
- | ... | ||
- | </ | ||
- | |||
- | ==== Number of tapes per storage pool in the library ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT volumes.stgpool_name, | ||
- | volumes.volume_name=libvolumes.volume_name GROUP BY stgpool_name | ||
- | | ||
- | STGPOOL_NAME | ||
- | ------------------ | ||
- | AIX_DAILY | ||
- | AIX_ARCH1 | ||
- | ... | ||
- | </ | ||
- | |||
- | ==== False private tapes ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT volume_name FROM libvolumes WHERE status=' | ||
- | volume_name NOT IN (SELECT volume_name FROM volumes ) | ||
- | | ||
- | VOLUME_NAME | ||
- | --------------- | ||
- | TAPE01L4 | ||
- | TAPE01L4 | ||
- | TAPE01L4 | ||
- | TAPE01L4 | ||
- | </ | ||
- | |||
- | ==== Some information about volumes in the library ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT volume_name, | ||
- | WHERE volume_name IN ( SELECT volume_name FROM libvolumes ) | ||
- | | ||
- | | ||
- | VOLUME_NAME | ||
- | ---------------- | ||
- | 290AFB | ||
- | 241AFB | ||
- | 265AFB | ||
- | 365AFB | ||
- | ... | ||
- | </ | ||
- | |||
- | ==== Some information about volumes in the library - another way ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT volumes.volume_name, | ||
- | volumes.access FROM volumes, libvolumes WHERE volumes.volume_name=libvolumes.volume_name ORDER BY stgpool_name | ||
- | | ||
- | | ||
- | VOLUME_NAME | ||
- | ------------------ | ||
- | 290AFB | ||
- | 241AFB | ||
- | 265AFB | ||
- | 365AFB | ||
- | ... | ||
- | </ | ||
- | |||
- | ==== Nodes that have data stored in a specifc volume ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT DISTINCT node_name, volume_name, | ||
- | | ||
- | NODE_NAME | ||
- | ------------------ | ||
- | NODE45 | ||
- | NODE10 | ||
- | NODE33 | ||
- | NODE20 | ||
- | </ | ||
- | |||
- | ==== Number of nodes that have data stored per volume ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT volume_name, | ||
- | volumeusage GROUP BY volume_name, | ||
- | | ||
- | VOLUME_NAME | ||
- | ----------------- | ||
- | TA0016L4 | ||
- | TA0017L4 | ||
- | TA0018L4 | ||
- | TA0019L4 | ||
- | TA0023L4 | ||
- | ... | ||
- | </ | ||
- | |||
- | ==== Number of volumes in the library per owner (useful in a library manager environment) ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT owner, | ||
- | | ||
- | OWNER | ||
- | ------------------ | ||
- | library_client_1 | ||
- | library_client_2 | ||
- | library_client_3 | ||
- | library_client_4 | ||
- | library_server | ||
- | </ | ||
- | |||
- | ====== Storage Pools ====== | ||
- | |||
- | ==== Compare size and number of files between two storage pools ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT stgpool_name, | ||
- | occupancy WHERE stgpool_name=' | ||
- | | ||
- | STGPOOL_NAME | ||
- | ---------------- | ||
- | DAILY | ||
- | COPY_DAILY | ||
- | </ | ||
- | |||
- | ==== Utilization (%) of storage pool disk_pool ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT pct_utilized FROM stgpools WHERE stgpool_name=' | ||
- | | ||
- | PCT_UTILIZED | ||
- | ------------ | ||
- | 20.9 | ||
- | </ | ||
- | |||
- | ==== Maximum scratch volumes allowed and number of volumes used per stgpool (needs tsm version +5.3) ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> | ||
- | | ||
- | STGPOOL_NAME | ||
- | ------------------ | ||
- | DAILY 3584 1100 521 | ||
- | </ | ||
- | |||
- | ====== Volume History ====== | ||
- | |||
- | ==== Number of full tsm db backups in the last 24 hours ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT COUNT(*) FROM volhistory WHERE - | ||
- | type=' | ||
- | | ||
- | | ||
- | ----------- | ||
- | 1 | ||
- | </ | ||
- | |||
- | ==== Number of full or incremental tsm db backups in the last 24 hours ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT COUNT(*) FROM volhistory WHERE ( type=' | ||
- | AND date_time> | ||
- | | ||
- | | ||
- | ----------- | ||
- | 2 | ||
- | </ | ||
- | |||
- | ==== Information about tsm db backups in the last 48 hours ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT date_time, type, backup_series, | ||
- | ( type=' | ||
- | | ||
- | DATE_TIME | ||
- | ----------------- | ||
- | | ||
- | 04: | ||
- | | ||
- | 04: | ||
- | </ | ||
- | |||
- | ====== DRM ====== | ||
- | |||
- | ==== Information about drm volumes ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT drmedia.volume_name, | ||
- | volumes.pct_utilized FROM drmedia, volumes WHERE drmedia.volume_name=volumes.volume_name ORDER BY drmedia.state | ||
- | | ||
- | VOLUME_NAME | ||
- | ------------------ | ||
- | tape06 | ||
- | tape18 | ||
- | tape38 | ||
- | tape79 | ||
- | ... | ||
- | </ | ||
- | |||
- | ==== Information about drm volumes in the library ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT drmedia.volume_name, | ||
- | drmedia.volume_name=libvolumes.volume_name ORDER BY voltype | ||
- | | ||
- | VOLUME_NAME | ||
- | ------------------ | ||
- | tape48 | ||
- | tape59 | ||
- | ... | ||
- | </ | ||
- | |||
- | ==== Information about drm volumes in the library (another way) ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT volume_name, | ||
- | volume_name IN ( SELECT volume_name FROM libvolumes ) ORDER BY voltype | ||
- | | ||
- | VOLUME_NAME | ||
- | ------------------ | ||
- | tape48 | ||
- | tape59 | ||
- | ... | ||
- | </ | ||
- | |||
- | ==== Information about drm volumes in the library with state different from " | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT drmedia.volume_name, | ||
- | drmedia.volume_name=libvolumes.volume_name AND drmedia.state<>' | ||
- | | ||
- | VOLUME_NAME | ||
- | ------------------ | ||
- | tape36 | ||
- | tape82 | ||
- | ... | ||
- | </ | ||
- | |||
- | ==== Drm volumes with tsm db backups ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT volume_name, | ||
- | WHERE voltype=' | ||
- | | ||
- | VOLUME_NAME | ||
- | ------------------ | ||
- | tape10 | ||
- | | ||
- | tape15 | ||
- | | ||
- | tape45 | ||
- | ... | ||
- | </ | ||
- | |||
- | ==== Number of Volumes per DRM State ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT state, | ||
- | | ||
- | STATE Number of volumes | ||
- | ------------------ | ||
- | COURIERRETRIEVE | ||
- | MOUNTABLE | ||
- | VAULT 76 | ||
- | VAULTRETRIEVE | ||
- | </ | ||
- | |||
- | ====== Sessions ====== | ||
- | |||
- | ==== Number of nodes sessions ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT COUNT(*) FROM sessions WHERE session_type=' | ||
- | |||
- | | ||
- | ----------- | ||
- | 16 | ||
- | </ | ||
- | |||
- | ==== Number of nodes sessions in Media Wait state ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT COUNT(*) FROM sessions WHERE session_type=' | ||
- | | ||
- | | ||
- | ----------- | ||
- | 1 | ||
- | </ | ||
- | |||
- | ==== Nodes sessions in Media Wait state ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT client_name, | ||
- | FROM sessions WHERE state=' | ||
- | | ||
- | CLIENT_NAME | ||
- | ------------- | ||
- | NODE23 | ||
- | 11: | ||
- | NODE15 | ||
- | 11: | ||
- | </ | ||
- | |||
- | ==== Nodes using tapes (drives) ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT client_name, | ||
- | FROM sessions WHERE ( input_vol_access is not NULL OR output_vol_access is not NULL ) | ||
- | | ||
- | CLIENT_NAME | ||
- | ------------- ----------- ------------------ --------- -------------- ------------------ ------------------ ------------------ | ||
- | NODE10 | ||
- | | ||
- | NODE25 | ||
- | | ||
- | </ | ||
- | |||
- | ==== Information about sessions from a specific node ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT session_id, start_time, commmethod, state, wait_seconds, | ||
- | CAST(bytes_received/ | ||
- | | ||
- | | ||
- | ----------- | ||
- | 1569587 | ||
- | | ||
- | </ | ||
- | |||
- | ==== Performance of nodes sessions ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT client_name, | ||
- | CAST(bytes_sent/ | ||
- | cast((cast(bytes_sent as dec(18, | ||
- | cast((cast(bytes_received as dec(18, | ||
- | FROM sessions WHERE session_type=' | ||
- | | ||
- | CLIENT_NAME | ||
- | ------------- ----------- --------------------- --------------- --------- ---------- ---------- ------------ ------------- | ||
- | NODE10 | ||
- | NODE34 | ||
- | NODE28 | ||
- | NODE79 | ||
- | ... | ||
- | </ | ||
- | |||
- | ====== Backups ====== | ||
- | |||
- | ==== Search a specific file from a Node ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT * FROM backups WHERE node_name=' | ||
- | | ||
- | NODE_NAME: MY_NODE | ||
- | | ||
- | | ||
- | STATE: ACTIVE_VERSION | ||
- | TYPE: FILE | ||
- | HL_NAME: / | ||
- | LL_NAME: dsm.opt | ||
- | OBJECT_ID: 8395325 | ||
- | BACKUP_DATE: | ||
- | DEACTIVATE_DATE: | ||
- | OWNER: root | ||
- | | ||
- | | ||
- | NODE_NAME: MY_NODE | ||
- | | ||
- | | ||
- | STATE: ACTIVE_VERSION | ||
- | TYPE: FILE | ||
- | HL_NAME: / | ||
- | LL_NAME: dsm.opt | ||
- | OBJECT_ID: 8091124 | ||
- | BACKUP_DATE: | ||
- | DEACTIVATE_DATE: | ||
- | OWNER: notesuser | ||
- | | ||
- | | ||
- | NODE_NAME: MY_NODE | ||
- | | ||
- | | ||
- | STATE: INACTIVE_VERSION | ||
- | TYPE: FILE | ||
- | HL_NAME: / | ||
- | LL_NAME: dsm.opt | ||
- | OBJECT_ID: 8091063 | ||
- | BACKUP_DATE: | ||
- | DEACTIVATE_DATE: | ||
- | OWNER: root | ||
- | | ||
- | </ | ||
- | |||
- | ==== Search a specific file from a node with more details ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT * FROM backups WHERE node_name=' | ||
- | AND hl_name='/ | ||
- | | ||
- | NODE_NAME: MY_NODE | ||
- | | ||
- | | ||
- | STATE: ACTIVE_VERSION | ||
- | TYPE: FILE | ||
- | HL_NAME: / | ||
- | LL_NAME: dsm.opt | ||
- | OBJECT_ID: 8395325 | ||
- | BACKUP_DATE: | ||
- | DEACTIVATE_DATE: | ||
- | OWNER: root | ||
- | | ||
- | | ||
- | NODE_NAME: MY_NODE | ||
- | | ||
- | | ||
- | STATE: INACTIVE_VERSION | ||
- | TYPE: FILE | ||
- | HL_NAME: / | ||
- | LL_NAME: dsm.opt | ||
- | OBJECT_ID: 8091063 | ||
- | BACKUP_DATE: | ||
- | DEACTIVATE_DATE: | ||
- | OWNER: root | ||
- | | ||
- | </ | ||
- | |||
- | ==== Objects backed up of a specific node in the last 24 hours ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT backup_date, | ||
- | WHERE node_name=' | ||
- | | ||
- | | ||
- | ---------------- | ||
- | 2008-11-19 | ||
- | | ||
- | 2008-11-19 | ||
- | | ||
- | 2008-11-19 | ||
- | | ||
- | | ||
- | | ||
- | </ | ||
- | |||
- | ====== Processes ====== | ||
- | |||
- | ==== Information about the currently running processes ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT process_num, | ||
- | substr(char(start_time), | ||
- | substr(char(current_timestamp - start_time), | ||
- | cast(float(bytes_processed) /1024/1024 AS DEC(8,2)) AS MB, - | ||
- | cast((cast(bytes_processed as dec(18, | ||
- | FROM processes | ||
- | | ||
- | PROCESS_NUM | ||
- | ----------- | ||
- | | ||
- | 12:00:29 | ||
- | | ||
- | 14:05:54 | ||
- | | ||
- | 14:05:54 | ||
- | | ||
- | 14:05:54 | ||
- | | ||
- | 14:05:54 | ||
- | | ||
- | 14:05:54 | ||
- | | ||
- | 14:05:54 | ||
- | </ | ||
- | |||
- | ====== Other ====== | ||
- | |||
- | ==== 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 | ||
- | </ | ||
- | |||
- | ==== Total client data stored (TB) (another way - auditocc is updated by audit lic command, take care) ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT CAST(FLOAT(SUM(total_mb)) / 1024 / 1024 AS DEC(8,2)) FROM auditocc | ||
- | | ||
- | Unnamed[1] | ||
- | ---------- | ||
- | 72.46 | ||
- | </ | ||
- | |||
- | ==== Some TSM Server information ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> SELECT server_name, | ||
- | VARCHAR(version)||' | ||
- | server_hla, server_lla, server_url, logmode, crossdefine, | ||
- | | ||
- | SERVER_NAME: | ||
- | | ||
- | | ||
- | | ||
- | | ||
- | | ||
- | LOGMODE: NORMAL | ||
- | CROSSDEFINE: | ||
- | LICENSECOMPLIANCE: | ||
- | </ | ||
- | |||
- | ==== SQL Table Catalog ==== | ||
- | |||
- | < | ||
- | tsm: SERVER1> | ||
- | | ||
- | TABSCHEMA | ||
- | --------- | ||
- | ADSM ACTLOG | ||
- | ADSM ADMINS | ||
- | ADSM ADMIN_SCHEDULES | ||
- | ADSM ARCHIVES | ||
- | ADSM AR_COPYGROUPS | ||
- | ADSM ASSOCIATIONS | ||
- | ADSM AUDITOCC | ||
- | ADSM BACKUPS | ||
- | ADSM BACKUPSETS | ||
- | ADSM BU_COPYGROUPS | ||
- | ... | ||
- | </ | ||
- | |||
- | **Other links about this topic:** | ||
- | |||
- | * [[http:// | ||
- | * [[http:// | ||
- | * [[http:// | ||
- | * [[http:// | ||
- | * [[http:// | ||
- | * [[http:// | ||
- | |||
- | **Selects V6.x** | ||
- | |||
- | * [[https:// | ||
- | * [[http:// | ||
- | * [[http:// |