Consultando todas as tabelas do TSM.
select * from syscat.tables
Consultando nós por parte de nomes. Neste exemplo, nodes com nome com ARCH
select cast(NODE_NAME as varchar (20)), cast(OPTION_SET as varchar (10)) from nodes -
where node_name like '%ARCH%'
Select para mostrar schedules de um determinado Dominio. Neste exemplo domínio com nome SQL.
select SCHEDULE_NAME from client_schedules where DOMAIN_NAME='SQL'
Volume de dados totalizado copiados por nó em uma range de data
SELECT cast(entity as varchar(20)) as ENTITY, cast(activity as varchar(20)) as -
ACTIVITY, CAST(FLOAT(SUM(bytes)) / 1024 / 1024 / 1024 AS DECIMAL(8,2)) as -
GB FROM summary WHERE start_time>timestamp('2010-08-01 00:00:00') -
and end_time activity='BACKUP') GROUP BY entity, activity
Volume de dados copiados por domínio nos últimos X dias
select cast(domain_name as varchar(15)) as DOMAIN_NAME,cast(summary.activity as
varchar(10)) as ACTIVITY, sum(cast(summary.bytes/1024/1024/1024 as decimal(6,2)
)) as GB from nodes, summary where (end_time between current_timestamp - 30
days and current_timestamp) and (activity='BACKUP' or activity='ARCHIVE') and
((node_name=summary.entity)) group by domain_name,summary.activity order by
activity,domain_name asc
Volume de dados copiados por domínio em uma range de datas
select cast(domain_name as varchar(15)) as DOMAIN_NAME,cast(summary.activity
as varchar(10)) as ACTIVITY, sum(cast(summary.bytes/1024/1024/1024 as
decimal(6,2))) as GB from nodes, summary where (start_time>timestamp('2010-
08-01 00:00:00') and end_time
(activity='BACKUP' or activity='ARCHIVE') and ((node_name=summary.entity)) group
by domain_name,summary.activity order by activity,domain_name asc
Backup por dia, volume e nó nos últimos X dias (No exemplo o nó denomina-se CLPMAIL001)
select Schedule_name as "Schedule",cast(bytes/1024/1024 as decimal (14,2))
as "Total Backup MB", date(start_time) as data_inicio, time(start_time) as start,'______'
as N____N,date(end_time) as data_final, time(end_time) as end,SUCCESSFUL from
summary where schedule_name='CLPMAIL001' and (start_time>=current_timestamp-20
days) order by DATA_INICIO
Backup por dia, volume e nó em uma range de data especificada (No exemplo o schedule denomina-se ZINGARA1SQL_DIFF)
select Schedule_name as "Schedule ",cast(bytes/1024/1024 as decimal
(14,2)) as "Total Backup MB", date(start_time) as data_inicio, time(start_time)
as start,'______' as N____N,date(end_time) as data_final, time(end_time) as
end,SUCCESSFUL from summary where schedule_name='ZINGARA1SQL_DIFF' and start_time>timestamp('2010-08-01 00:00:00') and end_time
23:59:00') order by DATA_INICIO
Backup totalizado por range de data
select cast(float(sum(bytes))/1024/1024/1024 as dec(8,2)) as "Archive data in GB" from
summary where activity='BACKUP' and end_time>timestamp(current_date)-(30)days
ou
select cast(float(sum(bytes))/1024/1024/1024/1024 as dec(8,2)) as "Archive data in
TB" from summary where activity='BACKUP' and start_time>timestamp('2010-08-01
00:00:00') and end_time
Fitas na library que começam com o nome "AA" e porcentagem de utilização abaixo de 5%
select cast(volume_name as varchar (10)) as Volume_Name,cast(stgpool_name as varchar
(10)) as Stgpool_name,pct_reclaim, pct_utilized, cast(status as varchar (7)) as Status,
cast(access as varchar (7)) as ACCESS, cast(WRITE_ERRORS as varchar(12)) as
Write_errors, cast(read_ERRORS as varchar(11)) as read_errors from volumes
where pct_utilized< 5 and volume_name like '%AA%' order by pct_reclaim asc
0 responses to "[TSM Commands] - Dicas de uso de select no TSM"