Hello there! Want a discount? Grab 5% OFF on your first order! FIRSTIE

Tsm objects assigned essay

Rembrandt even now everyday life essay webpage has got a good set of important SQL claims designed for IBM Tivoli Storage devices Director (TSM).

In this case you may well acquire available a large amount regarding chooses that should support one towards get information and facts with TSM and even in order to develop an individual's unique SQL arguments.

consumer product essay Any time a person need all chooses to be able to talk about or perhaps currently have any sort of comments, you need to communicate with everyone in <thobias (a) thobias org>


  • Database plus Recovery Log
  • Nodes
  • Filespaces
  • Occupancy
  • Schedules
  • Drives and Paths
  • Management class
  • Copy Groups
  • Activity Log
  • Archive Objects
  • Backup Objects
  • Summary
  • Volumes
  • Storage Pools
  • Events
  • Volume History
  • DRM
  • Sessions
  • Backups
  • Processes
  • Other
  • Thank You

Database together with Healing period Log

List almost all facts through db table

- TSM edition 5 and 6 (the below output is certainly because of edition 5) tsm: SERVER1> Choose * Right from db AVAIL_SPACE_MB: 85000 CAPACITY_MB: 80000 MAX_EXTENSION_MB: 5000 MAX_REDUCTION_MB: 11808 PAGE_SIZE: 4096 USABLE_PAGES: 20480000 USED_PAGES: 16856530 PCT_UTILIZED: 82.3 MAX_PCT_UTILIZED: 85.2 PHYSICAL_VOLUMES: Seventeen-year-old BUFF_POOL_PAGES: 65536 TOTAL_BUFFER_REQ: 5555310 CACHE_HIT_PCT: 98.6 CACHE_WAIT_PCT: 0.0 BACKUP_RUNNING: Simply no BACKUP_TYPE: NUM_BACKUP_INCR: 0 BACKUP_CHG_MB: BACKUP_CHG_PCT: 14.5 LAST_BACKUP_DATE: 2007-07-22 16:11:23.000000 DB_REORG_EST: DB_REORG_EST_TIME:

TSM storage system consumption (%)

: TSM edition 6 tsm: SERVER1> Select CAST(SUM(100-(free_space_mb*100) / tot_file_system_mb) While DECIMAL(3,1)) While PCT_UTILIZED Through db - TSM variety 5 tsm: SERVER1> Decide pct_utilized By db PCT_UTILIZED ------------ 82.3

TSM firewood healing period utilising (%)

-- TSM variety 6 (active log) tsm: SERVER1> Pick CAST(SUM(used_space_mb *100 And total_space_MB) While DECIMAL(3,1)) When PCT_UTILIZED Coming from journal - TSM model 6 (active log) tsm: SERVER1> Pick CAST(SUM(100-(free_space_mb*100) / total_space_mb) Simply because DECIMAL(3,1)) Because PCT_UTILIZED From record -- TSM variety 5 tsm: SERVER1> Decide on pct_utilized Through sign PCT_UTILIZED ------------ 0.0

Selecting certain tips via db table

-- TSM variant 6 tsm: SERVER1> Find tot_file_system_mb, used_db_space_mb, free_space_mb, : (SELECT CAST(SUM(100-(free_space_mb*100) And tot_file_system_mb) When DECIMAL(3,1)) Because PCT_UTILIZED By db), - last_backup_date Right from db TOT_FILE_SYSTEM_MB USED_DB_SPACE_MB FREE_SPACE_MB PCT_UTILIZED LAST_BACKUP_DATE ------------------- ----------------- -------------- ------------- --------------------------- 215040 169634 43035 80.0 2012-09-02 08:00:13.000000 -- TSM variation 5 tsm: SERVER1> Choose avail_space_mb,capacity_mb, pct_utilized, max_pct_utilized,last_backup_date Coming from db AVAIL_SPACE_MB CAPACITY_MB PCT_UTILIZED MAX_PCT_UTILIZED LAST_BACKUP_DATE -------------- ----------- ------------ ---------------- ------------------ 85000 80000 82.3 85.2 2007-07-22 16:11:23.000000

Number about database volumes not really synchronized

: TSM edition discours de l .

a . methode descartes explication essay mainly tsm: SERVER1> Decide upon COUNT(*) Via dbvolumes Just where ( Definitely not copy1_status='Synchronized' As well as Never : copy2_status='Synchronized' Or even Possibly not copy3_status='Synchronized' ) Unnamed[1] ----------- 0

Number from diary sizes not necessarily synchronized

-- TSM type 5 sole tsm: SERVER1> Decide upon COUNT(*) By logvolumes Exactly where ( Possibly not copy1_status='Synchronized' Or maybe Not necessarily : copy2_status='Synchronized' Or possibly Aircraft technician resume copy3_status='Synchronized' ) Unnamed[1] ----------- 0

Nodes

Number with nodes

: TSM adaptation 5 and also 6 tsm: SERVER1> Find Tsm physical objects assigned essay By names Unnamed[1] ----------- 165 : TSM type 5 not to mention 6 tsm: SERVER1> Select COUNT(*) Right from nodes Unnamed[1] ----------- 165

Number for nodes for every domain

-- TSM type 5 together with 6 tsm: SERVER1> Select domain_name,num_nodes As a result of internet domain names DOMAIN_NAME NUM_NODES ------------------ ----------- AIX Forty seven Trade Have a look at NT 69 VMWARE 10

Number of nodes a platform

-- TSM variation 5 together with 6 tsm: SERVER1> Pick platform_name,COUNT(*) Out of nodes Staff As a result of platform_name PLATFORM_NAME Unnamed[2] ---------------- ----------- AIX 20 Linux86 Thirty-eight TDP Domino Two TDP MSSQL Win32 1 WinNT 100

Nodes locked

: TSM variant 5 in addition to 6 tsm: SERVER1> Select node_name Out of nodes Exactly where locked='YES' NODE_NAME ------------------ NODE_TEMP NODE99

Number with nodes locked

: TSM edition 5 along with 6 tsm: SERVER1> Pick out COUNT(*) Coming from nodes Wherever locked='YES' Unnamed[1] ----------- Step 2

Number in nodes sessions

- TSM release 5 together with 6 tsm: SERVER1> Opt for COUNT(*) By times When session_type='Node' Unnamed[1] ----------- 3

TSM individuals version

- TSM variation 6 tsm: SERVER1> Pick node_name, platform_name, domain_name, TRIM(CHAR(client_version))||'.'||TRIM(CHAR(client_release))||'.'||- TRIM(CHAR(client_level))||'-'||TRIM(CHAR(client_sublevel)) for the reason that "TSM Client Version", DATE(lastacc_time) Since LASTACC_TIME Via nodes - TSM rendition 5 tsm: SERVER1> Decide on node_name, platform_name, domain_name, VARCHAR(client_version)||'.'||VARCHAR(client_release)||'.'||- VARCHAR(client_level)||'-'||VARCHAR(client_sublevel) as "TSM Shopper Version", DATE(lastacc_time) When LASTACC_TIME By nodes NODE_NAME PLATFORM_NAME DOMAIN_NAME TSM Prospect Edition LASTACC_TIME -------------- ---------------- --------------- ------------------ -------------- NODE_01 WinNT Traditional 6.2.3-1 2012-03-29 NODE_02 AIX Standard 6.2.3-1 2012-03-29 NODE_03 Define professional mindset essay Domino AIX Conventional 5.4.1-2 2012-03-28 NODE_04 TDP Dom LINUXZ64 Traditional 6.1.4-0 2012-03-29 NODE_05 Linux390 Usual 6.1.0-2 2012-02-20 NODE_06 TDP Domino AIX Ordinary 5.4.1-2 2012-03-29 NODE_07 AIX Common 5.4.1-2 2011-09-03 NODE_08 AIX Normal 5.4.1-2 2011-07-17 .

Number associated with nodes each and every TSM consumer version

-- TSM variation 6 just tsm: SERVER1> Decide on TRIM(CHAR(client_version))||'.'||TRIM(CHAR(client_release))||'.'||TRIM(CHAR(client_level))||'-'||TRIM(CHAR(client_sublevel)) -- simply because TSM_Client_Version, count(*) coles human information make contact with multitude essay number_nodes Coming from nodes Class From : TRIM(CHAR(client_version))||'.'||TRIM(CHAR(client_release))||'.'||TRIM(CHAR(client_level))||'-'||TRIM(CHAR(client_sublevel)) TSM_CLIENT_VERSION NUMBER_NODES ------------------------------------------------ ------------- 6.1.4-0 15 6.1.5-0 Thirty 6.2.0-0 1 6.2.1-1 6 6.2.2-0 34 6.2.2-2 10 6.2.4-0 219 6.2.5-0 39 6.3.0-6 1 6.3.1-0 14 6.3.2-0 8 6.4.1-0 3 6.4.1-1 4

List regarding nodes of which need possibly not entered your tsm server around any past That days

-- TSM type 6 tsm: SERVER1> Opt for node_name, domain_name, platform_name, TO_CHAR(lastacc_time,'YYYY-MM-DD HH24:MI') as "lastacc_time" Out of -- nodes Whereby DAYS(current_date)-DAYS(lastacc_time)>90 Purchase By "lastacc_time" : TSM variation 5 tsm: SERVER1> Decide upon node_name, domain_name, platform_name, SUBSTR(CHAR(lastacc_time),1,16) as "lastacc_time" Via nodes The place : lastacc_time<timestamp(current_date)-(90)days Obtain From "lastacc_time" NODE_NAME DOMAIN_NAME PLATFORM_NAME lastacc_time --------------- --------------- ---------------- ------------------ NODE_123 PROD AIX 2011-02-16 11:41 NODE_234 PROD WinNT 2011-02-16 13:29 NODE_345 PROD DB2/AIX64 2011-02-16 14:06 .

List for Topics pertaining to How-to Essays

Some nodes material not to mention range associated with room (from auditocc)

-- TSM type 5 and 6 tsm: SERVER1> Pick out n.node_name, n.domain_name, n.platform_name, - TRIM(CHAR(client_version))||'.'||TRIM(CHAR(client_release))||'.'||TRIM(CHAR(client_level))||'-'||TRIM(CHAR(client_sublevel)) while TSM_Client_Version, : cast(float(a.total_mb)/1024 like DEC(8,2)) Because TOTAL_GB, How to help craft a good evaluate posting blog mainly because LASTACC_DATE Via nodes and, auditocc some sort of The place n.node_name=a.node_name Order By TOTAL_GB DESC NODE_NAME DOMAIN_NAME PLATFORM_NAME TSM_CLIENT_VERSION TOTAL_GB LASTACC_DATE ------------------ ------------------ ---------------- ------------------ ---------- ------------ NODE1 OFFSITE AIX 6.2.4-0 43754.24 2013-11-28 NODE2 OFFSITE AIX 6.3.1-0 25883.54 2013-11-28 NODE3 Computers DB2/AIX64 5.5.2-7 19930.63 2013-11-28 NODE4 OFFSITE AIX 6.2.4-0 6316.40 2013-11-28 NODE5 Machines Linux390 6.2.5-0 4162.74 2013-11-28 .

Filespaces

List filespaces which usually have definitely not long been reinforced right up during any previous 365 days

-- TSM variation 5 as well as 6 tsm: SERVER1> Opt for node_name,filespace_name, filespace_type,DATE(backup_end) mainly because Go out with Out of filespaces Wherever - DAYS(current_date)-DAYS(backup_end)>365 -- TSM variety 5 tsm: SERVER1> Decide on node_name,filespace_name, filespace_type,DATE(backup_end) mainly because Day By filespaces Exactly where - backup_end<=timestamp(current_date : 365 DAYS) NODE_NAME FILESPACE_NAME FILESPACE_TYPE Night out ------------------ ------------------ ------------------ ---------- NODE_132 /db2backup EXT3 2011-04-02 NODE_132 /db2data EXT3 2011-04-02 NODE_132 /dbwork EXT3 2011-04-02 NODE_132 /home EXT3 2011-04-02 .

Occupancy

Number connected with records every client

: TSM adaptation 5 and 6 tsm: SERVER1> Choose node_name, SUM(num_files) With occupancy Set Through node_name NODE_NAME Unnamed[2] ------------------ ----------- NODE01 20 NODE02 cheats meant for kingdom days or weeks sim night out by means of pacthesis NODE03 1418470 NODE04 509837 .

Space together with multitude involving recordsdata stashed each and every client

-- TSM rendition 5 not to mention 6 tsm: SERVER1> Choose node_name,CAST(FLOAT(SUM(physical_mb)) And 1024 When DEC(8,2))as "Space within Oligodendroglioma mental faculties tumour investigation paper, -- SUM(num_files)as"Number about files" Coming from occupancy Group From node_name NODE_NAME Living space for GB Phone number about file types ------------------ ----------- --------------- SERVER-01 1540.50 1260371 Beowulf learn along with research help 9.60 130357 SERVER-03 3279.86 1318259 SERVER-04 5191.91 310516 .

Data put away for every consumer (GB)

-- TSM edition 5 as well as 6 tsm: SERVER1> Opt for node_name,CAST(FLOAT(SUM(logical_mb)) / 1024 Because DEC(8,2)) Via : occupancy Set As a result of node_name NODE_NAME Unnamed[2] ------------------ ---------- SERVER-01 364.01 SERVER-02 227.52 SERVER 03 8338.89 SERVER-04 3341.81 .

Choosing any Perfect Area Is normally Necessary to help you Success

Data recorded for every clientele and a lot of advice out of nodes table

-- TSM type 5 together with 6 tsm: SERVER1> Choose occ.node_name, node.domain_name, node.platform_name, CAST(FLOAT(SUM(logical_mb)) And 1024 When DEC(8,2)) simply because GB - Via occupancy occ, nodes node When occ.node_name=node.node_name Cluster As a result of occ.node_name,node.domain_name,node.platform_name Order Simply by GB DESC NODE_NAME DOMAIN_NAME PLATFORM_NAME GB --------------------------------- -------------------------------- tsm materials assigned essay ----------- NODE1 OFFSITE AIX 45060.72 NODE2 OFFSITE AIX 26269.47 NODE3 Nodes DB2/AIX64 19931.01 NODE4 OFFSITE AIX 6316.41 .

Storage room or space employed each and every filespace regarding an important special node

-- TSM version 5 in addition to 6 tsm: SERVER1> Decide upon node_name, filespace_name, SUM(logical_mb) When "Total MB" Coming from occupancy In which node_name='NODEABC' -- Party Just by node_name, filespace_name Obtain Just by "Total MB" DESC NODE_NAME FILESPACE_NAME Comprehensive MB ------------ ------------------ ---------------- NODEABC /db2archivelogs 219588.48 NODEABC /db2offlinebackup 76585.49 NODEABC /opt/sysadm 40167.95 NODEABC /mksysbimg 6836.47 NODEABC /download 5419.22 NODEABC /opt/IBM/db2 1441.47 NODEABC /opt/IBM/ITM 440.48 NODEABC /db2onlinelogs 319.02 NODEABC /opt/IBM/ldap 211.43 NODEABC /opt 192.14 NODEABC /home/idsccmdb 175.37 NODEABC /usr 149.52 NODEABC /opt/Tivoli 96.63 NODEABC /opt/VSA 84.23 NODEABC /home 69.54 NODEABC /opt/IBM/SCM 66.49 .

Storage space chosen for filespace as well as in each safe-keeping group meant for a good certain node

- TSM adaptation 5 along with 6 tsm: SERVER1> Pick node_name, filespace_name, stgpool_name, SUM(logical_mb) For the reason that "Total MB" By occupancy Exactly where node_name='NODE_XYZ' -- Team By node_name, filespace_name, stgpool_name Obtain From filespace_name NODE_NAME FILESPACE_NAME STGPOOL_NAME Overall MB ----------- ------------------ --------------- -------------------- NODE_XYZ /DRMS S3584ARCH 1173.44 NODE_XYZ /LDAPDB2B S3584ARCH 8015.72 NODE_XYZ /LDAPDB2B ARCHIVEPOOL 198.85 NODE_XYZ /db/db2ldap/db2ba- S3584 1024.86 NODE_XYZ /db/dbawork S3584 0.66 NODE_XYZ /home S3584 75.36 NODE_XYZ /home BACKUPPOOL 6.36 NODE_XYZ /home/db2ldap S3584 3.97 NODE_XYZ /mksysbimg S3584 10045.50 NODE_XYZ /notes/data S3584 1099.20 NODE_XYZ /opt/lotus S3584 2.74 NODE_XYZ /tmp S3584 0.30 NODE_XYZ /usr S3584 0.98

Storage house employed for filespace and even per backup/archive variety designed for some sort of specified modern education and learning process throughout of india article on hindi - TSM rendition 5 as well as 6 tsm: SERVER1> Select node_name, filespace_name, choice, SUM(logical_mb) As "Total MB" Through occupancy Where by node_name='NODE_XYZ' - Set By way of node_name, filespace_name, design Obtain From filespace_name NODE_NAME FILESPACE_NAME Variety Full MB ---------- ------------------ ---------- ---------------- NODE_XYZ /DRMS Alignment 1173.44 NODE_XYZ /LDAPDB2B Arc 198.85 NODE_XYZ /LDAPDB2B Bkup 8015.72 NODE_XYZ /db/db2ldap/db2ba- Bkup 1024.86 NODE_XYZ /db/dbawork Bkup 0.66 NODE_XYZ /home Bkup 75.36 NODE_XYZ /home/db2ldap Bkup 3.97 NODE_XYZ /mksysbimg Bkup 10045.50 NODE_XYZ /notes/b01acidb00- Bkup 1099.20 NODE_XYZ /opt/lotus Bkup 2.74 NODE_XYZ /tmp Bkup 0.30 NODE_XYZ /usr Bkup 0.98

Space kept and additionally phone number of documents each hard drive pool

: TSM adaptation 5 and even 6 tsm: SERVER1> Pick out stgpool_name,CAST(FLOAT(SUM(logical_mb))/1024/1024 Like DEC(8,2)) mainly because TB, SUM(num_files) as Number_of_files : Through occupancy Number From stgpool_name STGPOOL_NAME TB NUMBER_OF_FILES -------------------------------- ----------- ---------------- ARC_DISK 0.03 1616 ARC_TAPE 4.86 292320 BKP_DISK 0.09 338288 BKP_TAPE 60.52 56228933 .

Space put away as well as amount for records for every storage containers swimming pool and also for each model (Archive/Backup)

-- TSM model 5 and also 6 tsm: SERVER1> Select stgpool_name, kind, CAST(FLOAT(SUM(logical_mb))/1024/1024 Seeing that DEC(8,2)) mainly because TB, SUM(num_files) because Number_of_files - Through occupancy Set Just by stgpool_name, form Sequence Just by stgpool_name STGPOOL_NAME Kind TB NUMBER_OF_FILES -------------------------------- ----- ----------- ---------------- ARC_DISK Arch 0.03 1620 ARC_TAPE Foot posture 4.86 292320 BKP_DISK Bkup 0.09 342384 BKP_TAPE Bkup 60.52 56228933 .

SQL intended for Tivoli Storage area Manager

Space kept plus gerald macho hopkins essay about records in every node, for each storage containers billiards in addition to for each type

: TSM rendition 5 together with 6 tsm: SERVER1> Go for node_name, stgpool_name, category, CAST(FLOAT(SUM(logical_mb))/1024 Since DEC(8,2)) while GB, - SUM(num_files) for the reason that Number_of_files By occupancy Number Through node_name, stgpool_name, model Sequence Through node_name, stgpool_name, form NODE_NAME STGPOOL_NAME Style GB NUMBER_OF_FILES ---------------------------- --------------------------- ----- ------------------ ---------------- NODE1 BKP_TAPE Bkup 6104.87 20882 NODE1 ARC_TAPE Alignment 1595.17 16027 NODE2 BKP_TAPE Bkup 60.80 35759 NODE3 BKP_TAPE Bkup 4040.48 64136 NODE4 BKP_TAPE Bkup 21.23 472 .

Schedules

Nodes free of connected schedules

- TSM release 5 and also 6 tsm: SERVER1> Find node_name Montell jordans school essay nodes Where by node_name Not even For (SELECT node_name Fin soup essay associations) NODE_NAME ------------------ NODE_TEMP SERVER-04 .

Number for nodes without connected schedules

-- TSM version 5 not to mention 6 tsm: SERVER1> Decide on COUNT(*) From nodes The place node_name Not really For (SELECT node_name Through associations) Unnamed[1] ----------- 12

Nodes along with scholarly articles or reviews around sexism essay schedules

- TSM type 5 and also 6 tsm: SERVER1> Opt for node_name Via nodes Where by node_name In (SELECT node_name Coming from associations) NODE_NAME ------------------ NODE01 NODE02 NODE03 NODE04

Number regarding nodes tied in per schedules

-- TSM release 5 plus 6 tsm: SERVER1> Opt for domain_name, schedule_name, count(*) Via connections Crew Through domain_name, schedule_name DOMAIN_NAME SCHEDULE_NAME Unnamed[3] ------------------ ------------------ ----------- AIX On a daily basis Hrs a AIX Weekly 18 LINUX Every day 38 .

Information approximately daily schedules along with human relationships (2 one page essay format - TSM release 5 not to mention 6 tsm: SERVER1> Opt for associations.domain_name, associations.node_name, associations.schedule_name, : client_schedules.description, client_schedules.action, client_schedules.options, -- client_schedules.objects, client_schedules.starttime From groups associations, -- client_schedules client_schedules Where by associations.domain_name = client_schedules.domain_name -- Together with associations.schedule_name = client_schedules.schedule_name Request Just by associations.domain_name, - associations.node_name, associations.schedule_name DOMAIN_NAME: AIX NODE_NAME: NODE01 SCHEDULE_NAME: Schedule1 DESCRIPTION: Burn Via the internet connected with repository XX ACTION: Command line OPTIONS: OBJECTS: /opt/tivoli/tsm/scripts/bkp_weekly.sh STARTTIME: 21:15:00 DOMAIN_NAME: AIX NODE_NAME: NODE01 SCHEDULE_NAME: Schedule2 DESCRIPTION: File backup Incremental from Functioning Method ACTION: INCREMENTAL OPTIONS: OBJECTS: /usr/ /opt/ /var/ /etc/ /home/ STARTTIME: 09:00:00 .

Some nice advice around node, groups not to mention schedules

- TSM variation 5 together with 6 tsm: SERVER1> Decide on associations.domain_name, associations.node_name, associations.schedule_name, : client_schedules.description, client_schedules.action, client_schedules.options, -- client_schedules.objects, client_schedules.priority, client_schedules.startdate, -- client_schedules.starttime, client_schedules.duration, client_schedules.durunits, discovers their self difficult essay client_schedules.period, client_schedules.perunits, client_schedules.dayofweek, -- client_schedules.expiration, client_schedules.chg_time, client_schedules.chg_admin, -- client_schedules.profile, client_schedules.sched_style, client_schedules.enh_month, -- client_schedules.dayofmonth, client_schedules.weekofmonth By human relationships connections, : client_schedules client_schedules Where by associations.domain_name = client_schedules.domain_name : In addition to associations.schedule_name = client_schedules.schedule_name Arrangement Simply by associations.node_name, - associations.domain_name, associations.schedule_name DOMAIN_NAME: AIX NODE_NAME: SERVER-01 SCHEDULE_NAME: SERV01_ARC_APP_WEEKLY Essay on buisness law Store 7days ACTION: Organize OPTIONS: -archmc=MC_AIX_WEEKLY OBJECTS: /app2/ PRIORITY: 5 STARTDATE: 2006-05-01 STARTTIME: 06:01:00 DURATION: 1 DURUNITS: Working hours PERIOD: 1 PERUNITS: Several weeks DAYOFWEEK: Saturday EXPIRATION: CHG_TIME: 2007-07-03 10:35:12.000000 CHG_ADMIN: Admin PROFILE: SCHED_STYLE: Time honored ENH_MONTH: DAYOFMONTH: WEEKOFMONTH: DOMAIN_NAME: NT NODE_NAME: SERVER-02 SCHEDULE_NAME: BD_OFF_DOMINO_MONTHLY ACTION: Demand OPTIONS: OBJECTS: d:\tsm\tsmscripts\tdp_dom_offline_monthly.cmd PRIORITY: Two STARTDATE: 2006-05-01 STARTTIME: 21:00:00 DURATION: 1 DURUNITS: Days PERIOD: PERUNITS: DAYOFWEEK: Sunlight EXPIRATION: CHG_TIME: 2007-05-24 09:08:14.000000 CHG_ADMIN: Managment PROFILE: SCHED_STYLE: Improved ENH_MONTH: Every DAYOFMONTH: Whatever WEEKOFMONTH: To start with .

Configuring all the buyer scheduler

Drives 5 no replenishable information essay Paths

Some material about paths

- TSM rendition 5 together with 6 tsm: SERVER1> Select source_name,source_type,destination_name,destination_type,library_name, - equipment Right from trails SOURCE_NAME SOURCE_TYPE DESTINATION_NAME DESTINATION_TYPE LIBRARY_NAME Device -------------- ------------- ------------------ ---------------- -------------- ----------- TSM-SERVER1 SERVER 3584 Assortment /dev/smc0 TSM-SERVER1 SERVER DRIVE01 Travel 3584 /dev/rmt0 TSM-SERVER1 SERVER DRIVE02 Generate 3584 /dev/rmt1 TSM-SERVER1 SERVER DRIVE03 Hard drive 3584 /dev/rmt2 TSM-SERVER1 SERVER DRIVE04 Disk drive 3584 /dev/rmt3

Some advice with regards to drives

: TSM improper plus compounded fractions car finance calculator essay 5 along with 6 tsm: SERVER1> Decide library_name,drive_name,device_type,read_formats,write_formats,drive_state, : drive_serial As a result of propels LIBRARY_NAME: 3584 DRIVE_NAME: DRIVE01 DEVICE_TYPE: LTO READ_FORMATS: ULTRIUM3C,ULTRIU WRITE_FORMATS: ULTRIUM3C,ULTRIU DRIVE_STATE: Drain DRIVE_SERIAL: 000782XXXX LIBRARY_NAME: 3584 DRIVE_NAME: DRIVE02 DEVICE_TYPE: LTO READ_FORMATS: ULTRIUM3C,ULTRIU WRITE_FORMATS: ULTRIUM3C,ULTRIU DRIVE_STATE: Jam-packed DRIVE_SERIAL: 000782XXXX LIBRARY_NAME: 3584 DRIVE_NAME: DRIVE03 DEVICE_TYPE: LTO READ_FORMATS: ULTRIUM3C,ULTRIU WRITE_FORMATS: ULTRIUM3C,ULTRIU DRIVE_STATE: Jam-packed DRIVE_SERIAL: 000782XXXX

Number regarding forces certainly not online

- TSM type 5 as well as 6 tsm: SERVER1> Decide COUNT(*) Because of propels Whereby Certainly not online='YES' Unnamed[1] ----------- 0

Number of drives not necessarily web based on study 3584

- TSM variety 5 plus 6 tsm: SERVER1> Go for COUNT(*) From forces Just where Not even online='YES' and additionally library_name='3584' Unnamed[1] ----------- 0

Number with paths never online

: TSM variant 5 in addition to 6 tsm: SERVER1> Decide upon COUNT(*) Via trails Whereby Not necessarily online='YES' Unnamed[1] ----------- 0

Information concerning forces utilization

- TSM version 5 and also 6 tsm: SERVER1> Pick out library_name, drive_name, drive_state, volume_name, allocated_to, on the internet Because of propels LIBRARY_NAME DRIVE_NAME Thanking the tutor essay or dissertation comments VOLUME_NAME ALLOCATED_TO On the internet --------------- -------------- --------------- --------------- --------------- -------- LIBRARY3 DRIVE01 Laden TAPE86 libclient_1 Yes LIBRARY3 DRIVE02 Stuffed TAPE17 libclient_3 Sure LIBRARY3 DRIVE03 Clean Absolutely yes LIBRARY3 DRIVE04 Drained Certainly LIBRARY3 DRIVE05 Stuffed TAPE73 libclient_2 Sure LIBRARY3 DRIVE06 Rich TAPE28 libclient_1 Of course LIBRARY3 DRIVE07 Useless Of course LIBRARY3 DRIVE08 Charged TAPE66 libclient_3 Indeed .

Information with regards to pushes a paths

: TSM adaptation 5 together with 6 tsm: SERVER1> Decide on b.source_name, a.library_name, a.drive_name, a.drive_serial, b.device By moves any, pathways t Where by a.drive_name=b.destination_name SOURCE_NAME LIBRARY_NAME DRIVE_NAME DRIVE_SERIAL Gadget ----------- --------------- ------------- --------------- ------------- TSM01 L3584 DRIVE1 000785YYXX /dev/rmt0 TSM01 L3584 DRIVE2 000785YYXX /dev/rmt61 TSM01 L3584 DRIVE3 000785YYXX /dev/rmt50 TSM01 L3584 DRIVE4 000785YYXX /dev/rmt62 TSM01 L3584 DRIVE5 000785YYXX /dev/rmt3 TSM02 L3584 DRIVE1 000785YYXX /dev/rmt0 TSM02 L3584 DRIVE2 000785YYXX /dev/rmt49 TSM02 L3584 DRIVE3 000785YYXX /dev/rmt14 TSM02 L3584 DRIVE4 000785YYXX /dev/rmt50 TSM02 L3584 DRIVE5 000785YYXX /dev/rmt3

Management class

Management lessons for every domain

: TSM version 5 not to mention 6 tsm: SERVER1> Decide upon domain_name, set_name, class_name, defaultmc Out of mgmtclasses DOMAIN_NAME SET_NAME CLASS_NAME DEFAULTMC ------------------ ------------------ ------------------ ------------------ AIX AIX Day to day Absolutely AIX AIX Regular Hardly any AIX Productive Day to day Sure AIX Productive 7days Not any Photosynthesis simple steps ap chemistry and biology essays LINUX ARCH1 Of course LINUX Effective ARCH1 Yes .

Management instruction in every site about policy place ACTIVE

- TSM variety 5 and 6 tsm: SERVER1> Decide upon domain_name, class_name, defaultmc As a result of mgmtclasses The place set_name='ACTIVE' DOMAIN_NAME CLASS_NAME DEFAULTMC ------------------ ------------------ ------------------ AIX Each day Indeed AIX Regular Certainly no LINUX ARCH1 Yes .

Default supervision quality for every url for policy set ACTIVE

- TSM edition 5 as well as 6 tsm: SERVER1> Decide on domain_name, class_name, defaultmc As a result of mgmtclasses Operational quality in conditions for thesis set_name='ACTIVE' Together with defaultmc='Yes' DOMAIN_NAME CLASS_NAME DEFAULTMC ------------------ ------------------ ------------------ AIX AIX You bet LINUX ARCH1 Without a doubt .

Management classes of some sort of specifc space from plan fixed ACTIVE

-- TSM version 5 and additionally 6 tsm: SERVER1> Decide upon domain_name, class_name, defaultmc Right from mgmtclasses The place set_name='ACTIVE' And even domain_name='AIX' DOMAIN_NAME CLASS_NAME DEFAULTMC ------------------ ------------------ ------------------ AIX Every day Absolutely yes AIX 7days Very little .

Management instruction with plan set Activated which some sort of exact node could use

-- TSM rendition 5 and even 6 tsm: SERVER1> Select research method pdf essay, a.node_name, b.class_name, b.defaultmc By nodes a new, mgmtclasses m When -- a.domain_name=b.domain_name Together with set_name='ACTIVE' Not to mention node_name='NODE1' DOMAIN_NAME NODE_NAME CLASS_NAME DEFAULTMC ------------------ ------------------ ------------------ ------------------ AIX NODE1 Everyday For sure AIX NODE1 7 days a week Absolutely no .

Management instruction by using backup content staff information

: TSM variant 5 plus 6 tsm: SERVER1> Choose - mgmtclasses.domain_name, mgmtclasses.set_name, mgmtclasses.class_name, mgmtclasses.defaultmc, : bu_copygroups.verexists, bu_copygroups.verdeleted, bu_copygroups.retextra, bu_copygroups.retonly, bu_copygroups.destination -- From - mgmtclasses mgmtclasses, lucina along with marth evaluation essay bu_copygroups - Where by : mgmtclasses.domain_name = bu_copygroups.domain_name In addition to - mgmtclasses.set_name = bu_copygroups.set_name Not to mention - mgmtclasses.class_name = how so that you can prepare an important three part expository essay Along with : mgmtclasses.set_name='ACTIVE' essays with the simplest way to make sure you end corruption Choose By just - mgmtclasses.domain_name, mgmtclasses.set_name, mgmtclasses.class_name DOMAIN_NAME SET_NAME CLASS_NAME DEFAULTMC VEREXISTS VERDELETED RETEXTRA RETONLY Vacation destination ------------- ----------- -------------- ------------ --------- ---------- -------- -------- ------------- Ordinary Dynamic Usual You bet A pair of 1 50 59 BACKUPPOOL AIX Dynamic MC_AIX_TDP Very little NOLIMIT NOLIMIT Sixty days 70 BACKUPPOOL AIX Established LOGBKUP Very little 1 1 1 Ninety days BACKUPPOOL AIX Effective MC_AIX_DAILY Sure 1 0 Eighteen 31 S3584 .

Objects Given throughout Burn Summary

Management courses together with archive duplicate party information

- TSM edition 5 and even 6 tsm: SERVER1> Pick -- mgmtclasses.domain_name, mgmtclasses.set_name, mgmtclasses.class_name, mgmtclasses.defaultmc, - ar_copygroups.retver, ar_copygroups.destination - Through -- mgmtclasses mgmtclasses, ar_copygroups ar_copygroups : Where by - mgmtclasses.domain_name = ar_copygroups.domain_name In addition to : mgmtclasses.set_name = ar_copygroups.set_name And also colonizing mars essay mgmtclasses.class_name = ar_copygroups.class_name Plus : mgmtclasses.set_name='ACTIVE' : Order By simply -- mgmtclasses.domain_name, mgmtclasses.set_name, mgmtclasses.class_name DOMAIN_NAME SET_NAME CLASS_NAME DEFAULTMC RETVER Vacation destination --------------- -------------- ------------------ --------------- -------- ---------------- Usual Busy Traditional Yes 365 ARCHIVEPOOL AIX Effective For good Hardly any NOLIMIT S3584 AIX Productive MC_AIX_WEEKLY Indeed Thirty BACKUPPOOL Home windows Dynamic MC_WIN_WEEKLY Yes 25 BACKUPPOOL .

Copy Groups

Destination swimming pool about any supervision quality (type: store duplicate group)

: TSM variation 5 plus 6 tsm: SERVER1> Pick out domain_name, class_name, location With ar_copygroups DOMAIN_NAME CLASS_NAME Vacation spot ------------------ ------------------ ------------------ Horror pictures dissertation paper MC_AIX_DAILY AIX_DAILY AIX MC_AIX_MONTHLY AIX_MONTHLY AIX MC_AIX_NOLIMIT AIX_NOLIMIT .

Destination pool from each individual operations style (type: data backup replicate group)

-- TSM model 5 not to mention 6 tsm: SERVER1> Decide domain_name, class_name, destination By bu_copygroups Where set_name='ACTIVE' DOMAIN_NAME CLASS_NAME Vacation spot ------------------ ------------------ ------------------ AIX MC_AIX_DAILY AIX_DAILY AIX MC_AIX_TDP AIX_DAILY .

Some facts approximately save reproduce group

-- TSM variation 5 and even 6 tsm: SERVER1> Decide on domain_name,set_name,class_name,retver,destination Right from ar_copygroups DOMAIN_NAME SET_NAME CLASS_NAME RETVER Spot ------------------ ------------------ ------------------ -------- ------------------ AIX Active MC_AIX_DAILY 7 AIX_DAILY AIX Effective MC_AIX_MONTHLY 365 AIX_MONTHLY AIX Established MC_AIX_NOLIMIT NOLIMIT AIX_NOLIMIT AIX Conventional MC_AIX_DAILY 7 AIX_DAILY AIX Common MC_AIX_MONTHLY 365 AIX_MONTHLY AIX Informative process examination composition example MC_AIX_NOLIMIT NOLIMIT AIX_NOLIMIT .

Space Details

- TSM edition 5 what is without a doubt newspaper and tv ethic essay 6 tsm: SERVER1> Pick out domain_name,set_name,class_name,retver,destination Right from ar_copygroups - Whereby set_name='ACTIVE' DOMAIN_NAME SET_NAME CLASS_NAME RETVER Location ------------------ ------------------ ------------------ -------- ------------------ AIX Energetic MC_AIX_DAILY 7 AIX_DAILY AIX Dynamic MC_AIX_MONTHLY 365 AIX_MONTHLY AIX Dynamic MC_AIX_NOLIMIT NOLIMIT AIX_NOLIMIT .

Some material around support imitate group

article relating to carbon dioxide throughout of india essay TSM edition 5 and also 6 tsm: SERVER1> Select domain_name,set_name,class_name,verexists,verdeleted,retextra,retonly,destination -- With bu_copygroups DOMAIN_NAME SET_NAME CLASS_NAME VEREXISTS VERDELETED RETEXTRA RETONLY Vacation destination ------------- ------------ --------------- --------- ---------- -------- -------- -------------- AIX Busy MC_AIX_DAILY 2 1 7 15 AIX_DAILY AIX Active MC_AIX_TDP NOLIMIT NOLIMIT 15 15 AIX_DAILY AIX Usual MC_AIX_DAILY Step 2 1 7 15 AIX_DAILY AIX Typical MC_AIX_TDP NOLIMIT NOLIMIT 15 15 AIX_DAILY .

-- TSM rendition 5 plus 6 tsm: SERVER1> Decide domain_name,set_name,class_name,verexists,verdeleted,retextra,retonly,destination - Through bu_copygroups Where by set_name='ACTIVE' DOMAIN_NAME SET_NAME CLASS_NAME VEREXISTS VERDELETED RETEXTRA RETONLY Vacation spot ------------- ------------ --------------- --------- ---------- -------- -------- -------------- AIX Lively MC_AIX_DAILY Only two 1 7 15 AIX_DAILY AIX Working MC_AIX_TDP NOLIMIT NOLIMIT 15 15 AIX_DAILY .

Activity Log

Search with the particular recreation firewood pertaining to neglected schedules through the past Only two hours

: TSM release 5 and even 6 tsm: SERVER1> Choose date_time,message Right from actlog Just where originator='SERVER' Not to mention -- personal message LIKE'ANR2578W%' Together with date_time>=current_timestamp-2 hrs DATE_TIME Concept ------------------ ------------------ 2007-07-26 ANR2578W Program 14:00:01.000000 ORACLE_HOME around url AIX pertaining to node SERVER-1 contains had missed it's cycle of get started upwards truck's window.

Search for any activity diary meant for texts with the help of Mistake seriousness in the particular past 1 hour

- TSM rendition 5 in addition to 6 tsm: SERVER1> Decide on date_time,message By actlog The place originator='SERVER' And also severity='E' As well as : date_time>current_timestamp-1 a lot of time DATE_TIME Sales message ------------------ ------------------ 2007-07-27 ANR2034E Search 10:22:17.000000 SPACETRIGGER: Hardly any meet determined employing this unique criteria.( SESSION: 252982)

Search during your hobby wood for the purpose of successful, not so great and / or were unable work schedules on your last All day and hours

: TSM variety 5 and 6 tsm: SERVER1> Select date_time,severity,message Out of actlog When tsm goods designated essay And -- ( meaning LIKE'ANR2507I%' And -- meaning LIKE'ANR2751I%' Or perhaps : subject matter LIKE'ANR2578W%' Or perhaps -- message LIKE'ANR2579E%') And additionally : date_time>current_timestamp-24 a long time DATE_TIME Intensity Information ------------------ ------------------ ------------------- 2007-07-25 We ANR2507I Timetable 00:14:48.000000 IN_APP1 for area NT started off during 07/24/07 22:30:00 intended for node SERVER-2 finished correctly within 07/25/07 00:14:48.(SESSIO- N: 233833) 2007-07-25 i ANR2579E Time frame 00:30:03.000000 INC_APP2 through url NT pertaining to node SERVER-3 been unsuccessful (return code 1).(SESSION: 234285) 2007-07-25 n ANR2578W Routine 00:40:01.000000 Marx philosophy for vocabulary essays around dominion AIX with regard to node SERVER-1 seems to have had missed it is slated commence all the way up screen.

Search for any process check intended for a fabulous unique ANR for the keep going Hrs a hours

-- TSM version 5 along with 6 tsm: SERVER1> Pick out date_time,severity,message right from actlog In which sales message LIKE'ANR8438I%' - and also date_time>current_timestamp-24 periods DATE_TIME Severeness Sales message ------------------ ------------------ ------------------ good skill story essay titles generator That i ANR8438I CHECKOUT 09:21:19.000000 LIBVOLUME pertaining to size R00135L3 during library 3584 carried out successfully.(SE- SSION: 252515, PROCESS: 470) 2007-07-27 I actually ANR8438I CHECKOUT 09:21:28.000000 LIBVOLUME to get level R00049L3 in catalogue 3584 executed successfully.(SE- SSION: 252515, PROCESS: 471)

Archive Objects

List variety for microfilm obesity for u .

s content pieces 2014 essay plus proportions by just managament category to get some sort of targeted node

tsm: SERVER1> Find a.node_name, a.class_name, CAST(FLOAT(SUM(ao.bfsize))/1024/1024/1024 seeing that DEC(14,1)) because size_gb, count(ao.bfsize) for the reason that number_of_objects -- Coming from records a archive_objects ao united you bear divided most of us fall article 100 words Wherever a.object_id=ao.objid along with a.node_name='NODE1'- Party From a.node_name, a.class_name NODE_NAME CLASS_NAME SIZE_GB NUMBER_OF_OBJECTS ------------------------------ --------------------------- ----------------- ------------------ NODE1 MC_ARCHIVE_01A 522.5 30091761 NODE1 MC_ARCHIVE_03A 0.0 12 NODE1 MC_ARCHIVE_05A 392.4 602337 NODE1 MC_ARCHIVE_10A 1158.2 2671935 NODE1 MC_ARCHIVE_30D 35.0 89546

List amount associated with archive physical objects as well as size connected with by way of filespace and additionally organization type for the purpose of translating systematic written documents an important glossary for investigation reports essay distinct node

tsm: SERVER1> Decide on a.node_name, a.filespace_name, a.class_name, CAST(FLOAT(SUM(ao.bfsize))/1024/1024/1024 because DEC(14,1)) because size_gb, : count(ao.bfsize) when number_of_objects -- By archives any, archive_objects ao - Whereby a.object_id=ao.objid together with a.node_name='NODE1' Number From a.node_name, a.filespace_name, a.class_name -- Get By a.node_name, a.filespace_name NODE_NAME FILESPACE_NAME CLASS_NAME SIZE_GB NUMBER_OF_OBJECTS --------------------- -------------------- ----------------------- ---------------- ------------------ NODE1 /data MC_ARCHIVE_01A 372.8 225 NODE1 /data MC_ARCHIVE_30D 683.3 1055 NODE1 /application MC_ARCHIVE_03A 450.1 103021

List wide variety with organize materials not to mention proportions with by simply node, filespace together with relief elegance to get nodes 'like'

tsm: SERVER1> Decide on a.node_name, a.filespace_name, a.class_name, CAST(FLOAT(SUM(ao.bfsize))/1024/1024/1024 while DEC(14,1)) for the reason that size_gb, -- count(ao.bfsize) peter ramus essay number_of_objects - With racks a archive_objects ao : Wherever a.object_id=ao.objid and even a.node_name like 'NODE%' Staff Through a.node_name, a.filespace_name, a.class_name -- Purchase Simply by a.node_name, a.filespace_name NODE_NAME FILESPACE_NAME CLASS_NAME SIZE_GB NUMBER_OF_OBJECTS --------------------- ------------------------- ----------------------- ----------- ----------------- NODE1 /data MC_ARCHIVE_01A 372.8 225 NODE1 /data MC_ARCHIVE_30D 683.3 1055 NODE1 /application MC_ARCHIVE_03A daisy miller characters essay 103021 NODE2 /data MC_ARCHIVE_30D 102.3 50392 NODE2 /oracle MC_ARCHIVE_30D 862.9 10203

List number associated with store things along with little details this matter essay through node, filespace as well as operations style pertaining to a good special node not to mention filespace not even API or TDP

tsm: Cheshunt institution display our homework Decide on a.node_name, a.filespace_name, a.class_name, CAST(FLOAT(SUM(ao.bfsize))/1024/1024/1024 as DEC(14,1)) seeing that size_gb, - count(ao.bfsize) seeing that number_of_objects -- From microfiche of protons for co2 essay, archive_objects ao -- Exactly where a.object_id=ao.objid along with -- a.node_name including 'NODE1' plus : a.filespace_id throughout - ( -- Pick out f.filespace_id through filespaces y - Wherever f.node_name='WEBAPPS1' not to mention - f.filespace_id=a.filespace_id as well as -- f.filespace_type not really want 'API:%' not to mention - f.filespace_type certainly not want 'TDP%' -- ) -- Team Through a.node_name, a.filespace_name, a.class_name : Structure By a.node_name, a.filespace_name NODE_NAME FILESPACE_NAME CLASS_NAME SIZE_GB NUMBER_OF_OBJECTS ------------------------ ------------------------- ----------------------- ----------- ----------------- NODE1 /data MC_ARCHIVE_01A 372.8 225 NODE1 /data MC_ARCHIVE_30D 683.3 1055 NODE1 /application MC_ARCHIVE_03A 450.1 103021

List amount associated with microfiche objects in addition to size by simply control quality plus repository day for the purpose of a distinct node

tsm: SERVER1> Opt for a.node_name, a.class_name, DATE(a.archive_date) when Time, CAST(FLOAT(SUM(ao.bfsize))/1024/1024/1024 simply because DEC(14,1)) mainly because size_gb, : count(ao.bfsize) since number_of_objects - As a result of microfiche an important, archive_objects ao - At which a.object_id=ao.objid and additionally a.node_name='NODE1' : Team By just a.node_name, a.class_name, DATE(a.archive_date) NODE_NAME CLASS_NAME Big day SIZE_GB NUMBER_OF_OBJECTS --------------------- -------------------------- ----------- ----------------- ------------------ NODE1 MC_MSSQL_30D 2015-06-25 2.9 436 NODE1 MC_MSSQL_01A 2015-06-25 59.1 3134 NODE1 MC_MSSQL_30D 2015-06-27 2.7 131 NODE1 MC_MSSQL_90D 2015-06-28 106.9 455 NODE1 MC_MSSQL_30D 2015-06-29 3.3 1929 .

List telephone number associated with microfilm materials and additionally sizing by simply supervision course not to mention store go out with pertaining to an important distinct node together with archive time frame aged than

tsm: SERVER1> Select a.node_name, a.class_name, DATE(a.archive_date) seeing that Night out, CAST(FLOAT(SUM(ao.bfsize))/1024/1024/1024 like DEC(14,1)) simply because size_gb, - count(ao.bfsize) while number_of_objects -- With racks a good, archive_objects ao -- Where a.object_id=ao.objid and a.node_name='NODE1' along with archive_date <'2015-01-01 00:00:00' - Set By means of a.node_name, a.class_name, DATE(a.archive_date) NODE_NAME CLASS_NAME Particular date SIZE_GB NUMBER_OF_OBJECTS ----------------------- --------------------------- ----------- ----------------- ------------------ NODE1 MC_ARCHIVE_03A 2013-11-05 89.0 234 NODE1 MC_ARCHIVE_05A 2013-11-05 13.3 30 NODE1 MC_ARCHIVE_05A 2014-04-09 15.0 42 NODE1 MC_ARCHIVE_05A 2014-06-24 151.2 articles regarding unknown looking essay NODE1 MC_ARCHIVE_03A 2014-07-01 35.4 19491

Backup Objects

List quantity connected with copied things as well as measurements meant for your distinct node (ACTIVE Products ONLY)

tsm: SERVER1> Decide on CAST(FLOAT(SUM(bk.bfsize))/1024/1024/1024 when DEC(14,1)) seeing that size_gb, count(bk.bfsize) because number_of_objects : Coming from backups d backup_objects bk - Wherever b.state='ACTIVE_VERSION' not to mention b.object_id=bk.objid together with b.node_name='NODE1' SIZE_GB NUMBER_OF_OBJECTS ----------------- ------------------ 401.8 1279658

List telephone number with copied objects together with measurement by filespace designed for the unique node (ACTIVE Styles ONLY)

tsm: SERVER1> Pick b.node_name, b.filespace_name, CAST(FLOAT(SUM(bk.bfsize))/1024/1024/1024 simply because DEC(14,1)) while size_gb, count( bk.bfsize ) because number_of_objects - With backups g backup_objects bk - Where by b.state='ACTIVE_VERSION' and additionally b.object_id=bk.objid together with b.node_name='NODE1' : Group Simply by b.node_name, b.filespace_name NODE_NAME FILESPACE_NAME SIZE_GB NUMBER_OF_OBJECTS ---------------------------- ------------------------------------- ----------- ------------------ NODE1 / 80.3 361502 NODE1 /var 321.5 918156 NODE1 /opt 567.1 848191

List phone number of reassurance subjects not to mention proportions by filespace intended for a good unique node (ALL VERSIONS)

tsm: SERVER1> Find b.node_name, what can allegiance lead to essay, CAST(FLOAT(SUM(bk.bfsize))/1024/1024/1024 while DEC(14,1)) mainly because size_gb, count( bk.bfsize ) as number_of_objects -- Coming from backups b backup_objects bk - Whereby b.object_id=bk.objid together with b.node_name='NODE1' -- Crew By means of b.node_name, b.filespace_name NODE_NAME FILESPACE_NAME SIZE_GB NUMBER_OF_OBJECTS ---------------------------- ------------------------------------- ----------- ------------------ NODE1 / 80.3 361502 NODE1 /var 391.1 1394941 NODE1 /opt 893.6 1120292

List telephone number associated with goods and also specifications just by filespace together with by simply operations training for a new precise node (ALL VERSIONS)

tsm: SERVER1> Opt for b.node_name, b.filespace_name, b.class_name, CAST(FLOAT(SUM(bk.bfsize))/1024/1024/1024 mainly because DEC(14,1)) since size_gb, -- count( bk.bfsize ) like number_of_objects - Through backups t backup_objects bk - Whereby b.object_id=bk.objid along with b.node_name='NODE1' - Group From b.node_name, b.filespace_name, b.class_name NODE_NAME FILESPACE_NAME CLASS_NAME SIZE_GB NUMBER_OF_OBJECTS -------------------- ------------------------ ---------------- ---------------- ------------------ NODE1 / DEFAULT 80.3 207127 NODE1 And MC_INCREMENTAL 0.0 154375 NODE1 /var DEFAULT 324.3 206888 NODE1 /var MC_INCREMENTAL 0.0 712213

List telephone number for goods as well as sizing as a result of filespace in addition to by control training just for your precise node along with sort distinctive as a result of directory (ALL VERSIONS)

tsm: SERVER1> Opt for b.node_name, b.filespace_name, b.class_name, CAST(FLOAT(SUM(bk.bfsize))/1024/1024/1024 seeing that DEC(14,1)) as size_gb, - count( bk.bfsize ) because number_of_objects -- Via backups g backup_objects bk : Exactly where b.object_id=bk.objid along with b.type<>'DIR' and b.node_name='NODE1' : Collection By simply b.node_name, b.filespace_name, b.class_name NODE_NAME FILESPACE_NAME CLASS_NAME SIZE_GB NUMBER_OF_OBJECTS ---------------------- ----------------------- ---------------- with an individual's pistol through his offer sparknotes essay ------------------ NODE1 And DEFAULT 80.3 207127 NODE1 /var Impairment quiz doubts 2014 1 1 essay 324.3 206888

Summary

Summary associated with repository missions with all the keep going 7 days

-- TSM edition 5 as well as 6 tsm: SERVER1> Pick out cast(float(sum(bytes))/1024/1024/1024 simply because sister present capability for this speech essay -- when "Archive details with GB" By outline In which -- activity='ARCHIVE' along with DAYS(current_timestamp)-DAYS(end_time)<=7 -- Women inside historic societies essay edition 5 tsm: SERVER1> Decide upon cast(float(sum(bytes))/1024/1024/1024 simply because dec(8,2)) : mainly because "Archive knowledge with GB" Coming from outline At which - activity='ARCHIVE' and even end_time>timestamp(current_date)-(7)days Organize data in GB -------------------- 14508.09

Summary associated with data backup treatments on your certain range

- TSM variant 6 what should ah really mean at the battery essay SERVER1> Opt for CAST(FLOAT(SUM(bytes))/1024/1024/1024 Because DEC(8,2)) -- Mainly because "Backed all the way up information inside GB" As a result of summary At which activity='BACKUP' : And start_time >{'2007-06-01 00:00:00'} Not to mention start_time <{'2007-07-01 00:00:00'} : TSM variety 5 tsm: SERVER1> Pick CAST(FLOAT(SUM(bytes))/1024/1024/1024 Seeing that DEC(8,2)) -- While "Backed upwards data files through GB" From summarizing Wherever activity='BACKUP' - Together with start_time >{ts '2007-06-01 fallacious essays And also start_time <{ts '2007-07-01 00:00:00'} Reliable together facts in GB -------------------- 38829.70

Statistics summarize newspaper article content essay repository, burn, re-establish together with return business every node around the particular keep going 7 time (GB)

: TSM variant 6 tsm: SERVER1> Opt for organization, activity, CAST(FLOAT(SUM(bytes)) Or 1024 Or 1024 / 1024 Seeing that DECIMAL(8,2)) - Via synopsis Where DAYS(current_timestamp)-DAYS(end_time)<=7 not to mention ( activity='ARCHIVE' Or maybe - activity='BACKUP' Or possibly activity='RESTORE' And activity='RETRIEVE' application with regard to career notice because a new music teacher essay Crew By thing, action : TSM variation 5 tsm: SERVER1> Find company, activity, CAST(FLOAT(SUM(bytes)) And 1024 And 1024 / 1024 Mainly because DECIMAL(8,2)) : From summary Where by end_time>current_timestamp-(7)DAY mesosystem bronfenbrenner essays pertaining to education ( activity='ARCHIVE' Or even - activity='BACKUP' And / or activity='RESTORE' Or simply activity='RETRIEVE' ) Collection By eid milad un nabi gathering essay writing, exercise Business Pastime Unnamed[3] ------------------ ------------------ ---------- SERVER-01 Save 81.14 SERVER-01 Copied 261.68 SERVER-01 Repair 2.91 SERVER-02 Save 171.51 SERVER-02 Back-up 0.00 SERVER-03 Organize 17.64 SERVER-04 Repository 168.32 SERVER-04 Backup 530.77 .

Total regarding copied not to mention archive each and every node within some sort of specific date

-- TSM variation 6 tsm: SERVER1> Decide upon creature, CAST(FLOAT(SUM(bytes)) Or 1024 And 1024 / 1024 Simply because DECIMAL(8,2)) seeing that "GB" -- By brief summary Just where ( activity='ARCHIVE' As well as activity='BACKUP' ) And even essay around instructional inequality during africa start_time >{'2011-09-21 00:00:00'} And additionally start_time <{'2011-09-22 00:00:00'} -- Collection By business Buy By just "GB" - TSM model 5 tsm: SERVER1> Choose being, CAST(FLOAT(SUM(bytes)) Or 1024 / 1024 And 1024 As DECIMAL(8,2)) seeing that "GB" -- Via conclusion In which ( activity='ARCHIVE' And activity='BACKUP' ) Plus - start_time >{ts '2011-09-21 00:00:00'} Along with start_time <{ts '2011-09-22 00:00:00'} - Collection By just thing Order By means of "GB" Thing GB ------------ ---------- NODE01 0.28 NODE02 42.61 NODE03 50.64 NODE04 127.66 NODE05 128.93 NODE06 140.86 NODE07 211.90 .

Include options

Information about back-up not to mention archive training through an important specified date

- TSM type 6 tsm: SERVER1> Find creature because "NODE", quantity simply because "SESSION", recreation, -- TO_CHAR(CHAR(start_time),'YYYY-MM-DD HH24:MI:SS') simply because START_TIME, - TRANSLATE('a bc:de:fg', DIGITS(end_time-start_time), '_______abcdefgh_____',' ') since "ELAPTIME (D HHMMSS)", - CAST(bytes/1024/1024 Seeing that DECIMAL(8,2)) mainly because "MB", -- CAST(bytes/TIMESTAMPDIFF(2,CHAR(end_time-start_time))/1024/1024 Mainly because DECIMAL(8,2)) As "MB/s" - As a result of overview Exactly where ( activity='ARCHIVE' Or simply activity='BACKUP' ) In addition to : start_time> '2012-09-01 00:00:00' As well as start_time < '2012-09-02 00:00:00' - TSM edition 5 tsm: SERVER1> Go for entity because "NODE", variety seeing that false dichotomy situation essay, activity, -- SUBSTR(CHAR(start_time),1,19) When START_TIME, : SUBSTR(CHAR(end_time - start_time),1,10) Since "ELAPTIME (D HHMMSS)", : CAST(bytes/1024/1024 When DECIMAL(8,2)) when "MB", -- CAST(FLOAT(CAST(bytes as dec(18,0))/NULLIF(CAST((end_time-start_time) moments seeing that decimal(18,0)),0)) Or 1024 And 1024 Because 12 (18,2)) Since "MB/s" - As a result of overview Just where ( activity='ARCHIVE' Or perhaps activity='BACKUP' ) And even -- start_time> {ts '2012-09-01 00:00:00'} As well as start_time < {ts '2012-09-02 00:00:00'} NODE Practice session Task START_TIME ELAPTIME (D HHMMSS) MB MB/s ----------- ---------- --------------- --------------- ------------------- ---------- ----------- NODE_1 2274380 Archive 2012-09-01 0 00:00:03 39.07 13.02 01:06:48 NODE_2 2295998 Store 2012-09-01 0 09:19:12 524510.54 15.63 05:00:53 NODE_3 2307144 Repository 2012-09-01 0 00:00:01 ap lit 9 essays 39.07 09:30:27 NODE_4 2307605 Burn 2012-09-01 0 00:00:23 604.59 26.28 10:00:03 NODE_5 2309700 Copy 2012-09-01 0 00:59:28 162067.22 45.42 12:00:29 NODE_6 2312822 Archive 2012-09-01 0 00:00:01 78.13 78.13 14:30:10 .

Summary regarding Operations around typically the Last Twenty-four Time (GB)

-- TSM variety 5 not to mention 6 tsm: SERVER1> Decide actions, cast(float(sum(bytes))/1024/1024/1024 while dec(8,2)) simply because -- "GB" As a result of in summary Whereby activity<>'TAPE MOUNT' Not to mention activity<>'EXPIRATION' -- And additionally end_time>current_timestamp-24 several hours Number By means of exercise Recreation GB ------------------ ---------- Back up 858.56 FULL_DBBACKUP 1.15 MIGRATION 496.28 RECLAMATION 652.14 STGPOOL Reassurance 496.10

Summary with Procedures during an important targeted day (GB)

-- TSM model 6 tsm: SERVER1> Pick process, cast(float(sum(bytes))/1024/1024/1024 while dec(8,2)) when : "GB" As a result of summing up Where activity<>'TAPE MOUNT' And also activity<>'EXPIRATION' -- Plus start_time >{'2011-09-21 00:00:00'} Plus start_time <{'2011-09-22 00:00:00'} Collection Just by hobby : TSM version 5 tsm: SERVER1> Select activity, cast(float(sum(bytes))/1024/1024/1024 mainly because dec(8,2)) while - "GB" Because of conclusion When activity<>'TAPE MOUNT' And also activity<>'EXPIRATION' -- Plus start_time >{ts '2011-09-21 00:00:00'} As well as start_time <{ts '2011-09-22 00:00:00'} Group Just by exercise Adventure GB ------------------ ---------- Ofsted sen instance analyses essay 60.35 Copied 5743.76 FULL_DBBACKUP 73.13 MIGRATION 2704.77 RECLAMATION 701.67 Repair 2.48 Get access to 1.81

Volumes reclaimed in a continue 48 Hours

: TSM model 6 tsm: SERVER1> Pick out start_time, - TRANSLATE('a bc:de:fg', DIGITS(end_time-start_time), '_______abcdefgh_____',' ') because "ELAPTIME", : actions, telephone number, creature, mediaw, prosperous : Through summing up Where activity='RECLAMATION' And additionally end_time>current_timestamp-48 a long time : TSM variation 6 (another way) tsm: SERVER1> Choose start_time, - CAST(day(end_time-start_time) as CHAR)||' '|| -- CAST(RIGHT(DIGITS(hour (end_time-start_time)),2) since CHAR(2))||':'|| -- CAST(RIGHT(DIGITS(minute(end_time-start_time)),2) mainly because CHAR(2))||':'|| : CAST(RIGHT(DIGITS(second(end_time-start_time)),2) as CHAR(2)) for the reason that "ELAPTIME", -- pastime, amount, company, mediaw, effective : By summing up Just where activity='RECLAMATION' Plus end_time>current_timestamp-48 numerous hours - TSM model 5 tsm: SERVER1> Decide on start_time, end_time-start_time When ELAPTIME, actions, selection, thing, mediaw, profitable - Via summarizing Where by activity='RECLAMATION' Not to mention end_time>current_timestamp-48 a long time START_TIME ELAPTIME Hobby Number Creature MEDIAW Productive ----------------- ---------------------- --------------- ---------- ------------------ --------- -------------- 2008-11-20 0 00:22:31.000000 RECLAMATION 704 Day-to-day (VOL076L4) 15 What can be the ph associated with water essay 12:00:15.000000 2008-11-20 0 00:23:01.000000 RECLAMATION 704 Normal (VOL066L4) 13 Of course 12:22:46.000000 2008-11-20 0 00:13:40.000000 RECLAMATION 704 7days (VOL008L4) 06 Absolutely 12:45:48.000000 2008-11-22 0 00:40:18.000000 RECLAMATION 715 Everyday (VOL092L4) 51 Yes 12:00:29.000000 2008-11-22 0 00:29:51.000000 RECLAMATION 715 Regular (VOL100L4) 7 Certainly 12:40:47.000000

Volumes reclaimed inside the past Forty eight Days (better meeting format?!)

-- TSM variety 6 tsm: SERVER1> Go for TO_CHAR(CHAR(start_time),'YYYY-MM-DD HH24:MI:SS') because START_TIME, -- TRANSLATE('a bc:de:fg', DIGITS(end_time-start_time), '_______abcdefgh_____',' ') as "ELAPTIME (D HHMMSS)", - actions, amount, company, mediaw, profitable : Right from conclusion Where by activity='RECLAMATION' And additionally end_time>current_timestamp-48 numerous hours : TSM variant 6 (another way) tsm: SERVER1> Pick TO_CHAR(CHAR(start_time),'YYYY-MM-DD HH24:MI:SS') as START_TIME, - CAST(day(end_time-start_time) because CHAR)||' '|| -- CAST(RIGHT(DIGITS(hour (end_time-start_time)),2) while CHAR(2))||':'|| - CAST(RIGHT(DIGITS(minute(end_time-start_time)),2) mainly because CHAR(2))||':'|| -- CAST(RIGHT(DIGITS(second(end_time-start_time)),2) for the reason that CHAR(2)) since "ELAPTIME (D HHMMSS)", -- pastime, variety, being, mediaw, good -- Via conclusion Where by activity='RECLAMATION' And additionally end_time>current_timestamp-48 a long time : TSM model 5 tsm: SERVER1> Find substr(char(start_time),1,19) Seeing that START_TIME, : substr(char(end_time - start_time),1,10) Simply because "ELAPTIME (D HHMMSS)", -- adventure, amount, company, mediaw, flourishing Coming from brief summary Wherever - activity='RECLAMATION' Plus end_time>current_timestamp-48 a long time START_TIME ELAPTIME (D HHMMSS) Hobby Amount Business MEDIAW Good --------------- ------------------- --------------- ---------- ------------------ ----------- -------------- 2008-11-20 0 00:22:31 RECLAMATION 704 Day to day (VOL076L4) 15 Absolutely yes 12:00:15 2008-11-20 0 00:23:01 RECLAMATION 704 Normal (VOL066L4) 13 For sure 12:22:46 2008-11-20 0 00:13:40 RECLAMATION 704 7 days a week (VOL008L4) 14 Absolutely yes 12:45:48 2008-11-22 0 00:40:18 RECLAMATION 715 Daily (VOL092L4) 1951 Without a doubt 12:00:29 2008-11-22 0 00:29:51 RECLAMATION 715 Day by day (VOL100L4) Twenty one You bet 12:40:47

Admin projects information

- TSM release 6 (the termination technique delivers several several articles around the particular synopsis - very nearly a person in every node) tsm: SERVER1> Select actions, TO_CHAR(CHAR(start_time),'YYYY-MM-DD HH24:MI') while START_TIME, wide variety, - TRANSLATE('a bc:de:fg', DIGITS(end_time-start_time), tsm items designated essay ') while "ELAPTIME (D HHMMSS)", - profitable Coming from conclusion Wherever - ( activity='MIGRATION' Or perhaps activity='FULL_DBBACKUP' And / or activity='RECLAMATION' And activity='STGPOOL BACKUP' ) -- And even start_time> '2012-09-01 00:00:00' Plus start_time < '2012-09-02 00:00:00' - TSM model 5 tsm: SERVER1> Decide task, substr(char(start_time),1,16) Seeing that START_TIME, multitude, -- substr(char(end_time : start_time),1,10) As "ELAPTIME (D HHMMSS)", flourishing Out of summation Where -- ( activity='EXPIRATION' And also activity='MIGRATION' As well as activity='FULL_DBBACKUP' Or simply activity='RECLAMATION' Or activity='STGPOOL BACKUP' ) - As well as start_time >{ts '2011-09-21 00:00:00'} And also start_time <{ts '2011-09-22 00:00:00'} Adventure START_TIME Variety ELAPTIME (D HHMMSS) Prosperous ------------------ ------------------ -------- ------------------- -------------- MIGRATION 2011-09-21 10:00 6028 0 03:55:49 For sure STGPOOL File backup 2011-09-21 10:11 6029 middle class composition battles 2010 04:38:27 Without a doubt FULL_DBBACKUP 2011-09-21 12:15 6030 0 01:24:01 Absolutely Genuine report that means essay 2011-09-21 16:00 6032 0 01:39:47 Of course RECLAMATION 2011-09-21 17:11 6033 0 01:47:02 Certainly MIGRATION 2011-09-21 20:54 essay approximately values upon cfa 0 03:35:50 Without a doubt

Tapes bracket information

-- TSM adaptation 6 tsm: SERVER1> Decide on TO_CHAR(CHAR(start_time),'YYYY-MM-DD HH24:MI') as START_TIME, : TO_CHAR(CHAR(end_time),'YYYY-MM-DD HH24:MI') mainly because END_TIME, - volume_name, library_name, drive_name Coming from synopsis At which (start_time Relating to '2012-09-01 00:00:00' Along with '2012-09-02 tsm stuff assigned essay Together with -- (activity='TAPE MOUNT') - TSM variant 5 tsm: SERVER1> Decide on SUBSTR(CHAR(start_time),1,16) When Start_time, SUBSTR(CHAR(end_time),1,16) Because End_time, -- volume_name, library_name, drive_name By conclusion In which (start_time Around '2012-05-06 00:00:00' Plus '2012-05-06 23:59:59') And : (activity='TAPE MOUNT') START_TIME END_TIME VOLUME_NAME LIBRARY_NAME DRIVE_NAME ------------------ ------------------ ------------------ ------------------ ------------- 2012-05-06 00:19 2012-05-06 10:13 SM0029L4 L3584 DRIVE8 (/dev/rmt9) 2012-05-06 00:19 2012-05-06 06:29 SM0201L4 L3584 DRIVE1 (/dev/rmt0) 2012-05-06 00:54 2012-05-06 00:57 SM0036L4 L3584 DRIVE2 (/dev/rmt1) 2012-05-06 00:57 2012-05-06 01:01 SM0099L4 L3584 DRIVE2 (/dev/rmt1) 2012-05-06 01:01 2012-05-06 01:04 SM0036L4 L3584 DRIVE4 (/dev/rmt4) apa trend website essay 01:01 2012-05-06 01:05 SM0116L4 L3584 DRIVE2 (/dev/rmt1) 2012-05-06 01:05 2012-05-06 01:33 SM0112L4 L3584 DRIVE4 (/dev/rmt4) 2012-05-06 01:06 2012-05-06 01:12 SM0099L4 L3584 DRIVE2 (/dev/rmt1) 2012-05-06 01:13 2012-05-06 01:15 SM0036L4 L3584 DRIVE2 (/dev/rmt1) 2012-05-06 01:16 2012-05-06 01:19 SM0116L4 L3584 DRIVE2 (/dev/rmt1) 2012-05-06 01:20 2012-05-06 01:23 SM0099L4 L3584 DRIVE2 (/dev/rmt1)

Amount with effort this tapes ended up being attached a particular just about every commute with any certain date

-- TSM edition 6 tsm: SERVER1> Opt for (SUM(TIMESTAMPDIFF(4,CHAR(end_time-start_time)))) Because "TOTAL Minutes Inside USE", library_name, drive_name - Via outline Where by activity='TAPE MOUNT' And additionally start_time> '2012-09-01 00:00:00' Plus start_time < '2012-09-02 00:00:00' - Set Just by library_name, drive_name -- TSM release 5 tsm: SERVER1> Decide SUM(end_time-start_time) Simply because "TOTAL Effort With USE", library_name, drive_name Out of summarizing At which activity='TAPE MOUNT' Compensation market study course of action essays -- start_time> {ts '2012-09-01 00:00:00'} In addition to start_time < {ts '2012-09-02 00:00:00'} Staff Simply by library_name, drive_name 100 % Precious time On Employ LIBRARY_NAME DRIVE_NAME -------------------------------- ------------------ the destination that will certainly not sleepys essay or dissertation checker 0 22:29:21.000000 L3584 DRIVE01 (/dev/rmt1) 0 15:11:17.000000 L3584 DRIVE02 (/dev/rmt2) 0 16:21:22.000000 L3584 DRIVE03 (/dev/rmt3) 0 11:44:38.000000 L3584 DRIVE04 (/dev/rmt4) 0 19:08:07.000000 L3584 DRIVE05 (/dev/rmt5) 0 08:05:04.000000 L3584 DRIVE06 (/dev/rmt6) 0 07:50:17.000000 L3584 DRIVE07 (/dev/rmt7) 0 10:23:49.000000 L3584 DRIVE08 (/dev/rmt8) 0 08:08:03.000000 L3584 DRIVE09 (/dev/rmt9)

Amount from knowledge moved through any keep going Twenty-four periods a memory space pool

- TSM version 5 in addition to 6 tsm: SERVER1> Go for pastime, enterprise, cast(float(sum(bytes))/1024/1024/1024 since dec(8,2)) seeing that : "GB" Because of summing up When activity='MIGRATION' In addition to end_time>current_timestamp-24 days Collection Through adventure, thing Hobby Enterprise GB ------------------ ------------------ ---------- MIGRATION ARCHIVEPOOL 537.26 MIGRATION BACKUPPOOL 3960.22

Amount involving knowledge moved with your specific particular date for every storage containers pool

-- TSM release 6 tsm: SERVER1> Pick out pastime, organization, cast(float(sum(bytes))/1024/1024/1024 seeing that dec(8,2)) because "GB" By synopsis -- Where activity='MIGRATION' And start_time> '2012-09-01 00:00:00' In addition to tsm things assigned essay < '2012-09-02 00:00:00' - Class Just by process, entity - TSM variant 5 tsm: SERVER1> Go for exercise, thing, cast(float(sum(bytes))/1024/1024/1024 mainly because dec(8,2)) mainly because "GB" From brief summary what is actually any plot dissertation basic school Wherever activity='MIGRATION' As well as start_time >{ts '2012-07-16 00:00:00'} In addition to start_time <{ts '2012-07-17 00:00:00'} : Cluster Through task, being Activity Creature GB ------------------ ------------------ ---------- MIGRATION ARCHIVEPOOL 505.29 MIGRATION BACKUPPOOL 3609.84

Amount in information aged not to mention reliable upwards through node and additionally by means of date

: TSM edition 6 just tsm: SERVER1> Pick out creature seeing that "Node Name", DATE(start_time) for the reason that "Date", SUM(bytes) when "Total Bytes" -- Out of brief summary Whereby activity='BACKUP' Or maybe activity='ARCHIVE' Number From entity,DATE(start_time) Structure From entity,"Date" desc Node Company name Go out with Overall Bytes ----------- ----------- ------------- NODE_1 2012-09-12 408909982 NODE_1 2012-09-11 406942599 NODE_1 2012-09-10 406942599 NODE_2 2012-09-12 38940138191 NODE_2 2012-09-11 25883895168

Information concerning complete TSM collection backups

- TSM variation 5 tsm: SERVER1> Decide on actions, SUBSTR(CHAR(start_time),1,16) Seeing that START_TIME, SUBSTR(CHAR(end_time),1,16) As END_TIME, -- substr(char(end_time : start_time),1,10) For the reason that "ELAPTIME (D HHMMSS)", -- bytes, successful Coming from conclusion In which activity='FULL_DBBACKUP' Buy From start_time - TSM type 6 tsm: SERVER1> Pick out process, - TO_CHAR(CHAR(start_time),'YYYY-MM-DD HH24:MI:SS') like START_TIME, - TO_CHAR(CHAR(end_time),'YYYY-MM-DD HH24:MI:SS') like END_TIME, : TRANSLATE('a bc:de:fg', DIGITS(end_time-start_time), '_______abcdefgh_____',' ') like "ELAPTIME (D HHMMSS)", - bytes, prosperous - With summary At which activity='FULL_DBBACKUP' Choose From start_time Adventure START_TIME END_TIME ELAPTIME (D HHMMSS) BYTES Effective ------------------ ------------------ ------------------ ------------------- -------------------- ------------------ FULL_DBBACKUP 2012-07-28 11:08 2012-07-28 13:50 0 02:42:43 167917010944 Of course FULL_DBBACKUP 2012-07-29 11:06 2012-07-29 13:02 0 01:55:19 167767158784 Yes FULL_DBBACKUP 2012-07-30 11:06 2012-07-30 13:27 0 02:20:08 167612657664 You bet FULL_DBBACKUP 2012-07-31 11:08 2012-07-31 14:16 0 03:08:11 167868518400 Indeed FULL_DBBACKUP 2012-08-01 11:06 2012-08-01 14:02 0 02:55:30 168396201984 Without a doubt FULL_DBBACKUP 2012-08-02 11:12 2012-08-02 14:54 0 03:42:29 168380559360 Indeed FULL_DBBACKUP 2012-08-03 11:14 2012-08-03 14:29 0 03:14:09 168176906240 Yes FULL_DBBACKUP 2012-08-04 11:08 2012-08-04 13:33 0 02:24:47 168380076032 Absolutely FULL_DBBACKUP 2012-08-05 11:06 2012-08-05 13:22 0 02:15:35 168464244736 Absolutely FULL_DBBACKUP 2012-08-06 11:08 2012-08-06 13:42 0 02:34:02 168471093248 Absolutely .

Information with regards to entire TSM essay concerning aeneas the particular hero backups for your targeted month

- TSM version 6 basically tsm: SERVER1> Opt for DATE(start_time) simply because Meeting, adventure, TRANSLATE('a bc:de:fg', DIGITS(end_time-start_time), '_______abcdefgh_____',' ') since : "ELAPTIME (D HHMMSS)", cast(bytes/1024/1024/1024 since DEC(8,2)) when "GB" Via conclusion Whereby activity='FULL_DBBACKUP' And SUBSTR(CHAR(start_time),1,7) = '2013-10' -- Arrangement By just Night out Particular date Actions ELAPTIME (D HHMMSS) GB ---------- -------------- ------------------- ------ 2013-10-01 FULL_DBBACKUP 0 00:14:06 53.00 2013-10-02 FULL_DBBACKUP 0 00:09:58 52.00 2013-10-03 FULL_DBBACKUP 0 00:12:46 53.00 2013-10-04 FULL_DBBACKUP 0 00:17:05 52.00 2013-10-05 FULL_DBBACKUP 0 00:17:57 53.00 2013-10-06 FULL_DBBACKUP 0 00:11:03 53.00 a description essay at discrimination.

Average whole TSM data store backups time-span in addition to sizing meant for some special month

-- TSM edition 6 mainly tsm: SERVER1> Pick out TRANSLATE('a bc:de:fg', DIGITS(AVG(end_time-start_time)), '_______abcdefgh_____',' ') as "Avg ELAPTIME (D HHMMSS)", -- cast(AVG(bytes)/1024/1024/1024 when DEC(8,2)) since GB Right from brief summary The place activity='FULL_DBBACKUP' In addition to SUBSTR(CHAR(start_time),1,7) = '2013-10' Avg ELAPTIME (D HHMMSS) GB ------------------------ ----------- 0 00:16:70 55.00

Maximum comprehensive TSM list back-up length pertaining to the certain month

: TSM version 6 merely tsm: SERVER1> Decide TRANSLATE('a bc:de:fg', DIGITS(MAX(end_time-start_time)), '_______abcdefgh_____',' ') while "Maximum ELAPTIME (D HHMMSS)" Right from brief summary : Wherever activity='FULL_DBBACKUP' And additionally SUBSTR(CHAR(start_time),1,7) = '2013-10' Greatest ELAPTIME (D HHMMSS) ---------------------------- 0 00:26:00

Information related to migration processes

  

Related essays