commands used in real time

  commands required to work in real time

CHECKIN COMMANDS

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

Ø  CHECKIN libvol <LIBNAME> search=yes status=scratch/Private (Tapes in slots)

 

Ø  CHECKIN libvol <LIBNAME> search=bulk status=scratch/Private (Tapes in I/O slots)

 

Ø  checkin libvol <LIBNAME> search=yes/bulk status=scratch/Private checkl=barcode (Does not mount the tape)

 

Ø  Label libvol <LIBNAME> checkin=scratch search=yes/bulk labelsource=barcode (new tapes)

 

Ø  Label libvol <LIBNAME> checkin=scratch search=yes/bulk labelsource=barcode overwrite=yes (old tapes)

 

Ø  Label libvol lb1.1.0.4 checkin=scratch search=bulk  labelsource=barcode

 

Ø  Label libvol TS3573 checkin=scratch search=yes labelsource=barcode

 

Ø  Label libvol IBM3582 checkin=scratch search=yes labelsource=barcode

 

Ø  checkout libvol IBM3582 phc702 remove=yes checklabel=no

 

Ø  checkin libv IBM3582 search=yes status=scratch checkl=barcode (for whole libr )

 

Ø  checkin libv IBM3582 search=bulk status=Scratch checkl=barcode ( If tapes in I/O stations )

 

Ø  checkin libv overland search=yes status=scr

 

Ø  checkin libv 3584atl status=scratch search=bulk devt=lto checklabel=barcode

 

Ø  Label libvol IBM3582 checkin=scratch search=yes labelsource=barcode (new tapes)

 

Ø  Label libvol IBM3582_2 checkin=scratch search=yes labelsource=barcode overwrite=yes (old tapes)

 

Ø  Label libvol IBM3582 checkin=scratch search=yes labelsource=barcode overwrite=yes (old tapes)

 

CHECKOUT

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

Ø  checkout libv <LIB NAME> <VOLUME NAME> remove=yes/no (mounts the tape)

 

Ø  checkout libv <LIB NAME> <VOLUME NAME> remove=yes/no checklabel=yes

 

Ø  checkout libv 3584atl UJ0211 remove=yes checklabel=no

 

DRM

-------

Ø  move drm UJ0211 tostate=vault

 

Ø  move drm * wherestate=vaultretreive tostate=onsiteretreive

 

Ø  select count(*) from drmedia where state='VAULTRETRIEVE'

 

Ø  select count(*) from drmedia where state='MOUNTABLE'

 

Ø  select volume_name,state,stgpool_name  from drmedia

 

Ø  select volume_name from drmedia where state= 'VAULT' and volume_name in (select volume_name from volumes)

 

Ø  select volume_name as Tapes from drmedia where state='COURIERRETRIEVE' (RETRIEVE)

 

Ø  select volume_name as Tapes from drmedia where state='VAULTRETRIEVE'   ( RETURN )

 

Ø  select volume_name as Tapes from drmedia where state='MOUNTABLE'      ( TAPE)

 

 

AUDIT  LIBRARY

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

 

Ø  AUDIT LIBR  ibm3582 checklabel=barcode

 

 

 

VOLUMES

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

 

Ø  select  stgpool_name, sum(physical_mb) from occupancy group by stgpool_name

 

Ø  Select count(*) from libvolumes where status='Scratch' 

 

Ø  select volume_name from libvolumes where status='Scratch'

 

Ø  select volume_name from libvolumes where status='Private'

 

Ø  select stgpool_name,volume_name,pct_utilized from volumes where stgpool_name='STANDARD_TAPEPOOL' and pct_utilized < 10

 

Ø  select volume_name,pct_utilized,stgpool_name,status from volumes where access='READONLY' and volume_name in (select volume_name from libvolumes )

 

Ø  select volume_name,stgpool_name from volumes where volume_name in (select volume_name from libvolumes )

 

Ø  select volume_name,access, status,  pct_utilized from volumes where pct_utilized>50 and volume_name in (select volume_name from libvolumes )

 

Ø  select volume_name, pct_utilized from volumes where pct_utilized>90 and stgpool_name='NW_DISKPOOL' and volume_name in (select volume_name from libvolumes )

 

Ø  select volume_name,access,status from volumes where stgpool_name='OS2_TAPEPOOL' and upper(status)='FULL' and volume_name in (select volume_name from libvolumes)

 

Ø  select volume_name, pct_utilized, pct_reclaim from volumes where PCT_RECLAIM >90 and STGPOOL_NAME=’ < stgpool name>

 

Ø  select volume_name as Tapes from volumes where stgpool_name='ARCHIVE_TAPEPOOL' and location is null and status='FULL' 

 

Ø  move media * stgpool=archive_tapepool wherestate=mountableinlib wherestatus=full append=no ovflocation=onsite_archives checklabel=no

 

Ø  select platform_name,count(*) from nodes group by platform_name

 

Ø  select stgpool_name,devclass_name,count(*) as "VOLUMES" from volumes group by stgpool_name,devclass_name

 

Ø  select volume_name,stgpool_name,pct_utilized,status from volumes order by stgpool_name asc

 

Ø  select volume_name,stgpool_name,pct_utilized,state from media

 

Ø  select volume_name,stgpool_name,pct_utilized,status from volumes where volume_name in (select volume_name from libvolumes ) order by stgpool_name asc

 

Ø  select volume_name,stgpool_name,pct_utilized,access from volumes where volume_name in (select volume_name from libvolumes ) order by stgpool_name asc

 

Ø  select volume_name,stgpool_name,pct_utilized,status  from volumes where volume_name in (select volume_name from libvolumes where library_name='IBM3582_2') order by stgpool_name asc

 

Ø  select a.library_name,b.volume_name,b.stgpool_name,b.pct_utilized,b.status from libvolumes a,volumes b where a.volume_name=b.volume_name order by stgpool_name asc

 

Ø  select volume_name,stgpool_name,pct_utilized,status from volumes where volume_name in (select volume_name from libvolumes ) and stgpool_name='OFFSITE_COPYPOOL'

 

Ø  select volume_name,access,pct_utilized,STATUS from volumes where stgpool_name='STANDARD_TAPEPOOL' and volume_name in (select volume_name from libvolumes)

 

Ø  select volume_name,state,stgpool_name from drmedia where upd_date>'2006-08-20'

 

Ø  select volume_name,stgpool_name,pct_utilized,access from volumes where pct_utilized<20 order by stgpool_name asc

 

Ø  select volume_name,stgpool_name,pct_utilized,STATUS from volumes where stgpool_name='STANDARD_TAPEPOOL'

 

Ø  select volume_name,stgpool_name,pct_utilized,status  from volumes where stgpool_name='OFFSITE_COPYPOOL' and volume_name not in (select volume_name from libvolumes )

 

 

LIBRARY

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

Ø  select library_name as "Library", count(*) as "Number of Scratch" from libvolumes where status='Scratch' group by library_name

 

Ø  select count(*) as IBM3582_Scratch from libvolumes where status='Scratch' and library_name='IBM3582'

 

Ø  select count(*) as IBM3582_2_Scratch from libvolumes where status='Scratch' and library_name='IBM3582_2'

 

 

TAPES

--------

 

Ø  set sqldisplay wide

 

Ø  select count(*) as "Total tapes in Libray" from libvolumes

 

Ø  select volume_name as " ",status as "All Tapes in Library" from libvolumes order by status by asc

 

Ø  select volume_name,pct_utilized,status,access from volumes where stgpool_name='ARCHIVE_TAPEPOOL' and status='Empty'

 

Ø  select volume_name as "Full Archive Tapes in Library" from volumes where stgpool_name='ARCHIVE_TAPEPOOL' and location is null and status='FULL'

 

Ø  select count(*) as "Total Archive Tapes in Library" from volumes where stgpool_name='ARCHIVE_TAPEPOOL' and location is null and status='FULL'

 

Ø  select volume_name,stgpool_name,access,write_errors,read_errors,pct_utilized from volumes where write_errors <> 0 or read_errors <> 0 order by stgpool_name

 

Ø  select volume_name,status,cleanings_left from libvolumes where status='Cleaner'

 

Ø  select volume_name,STGPOOL_NAME, PCT_UTILIZED,STATUS from volumes where stgpool_name='STANDARD_TAPEPOOL' and status='FULL'

 

  

 

 

ARCHIVE MEDIA :

________________

 

Ø  move media * stg=archive_tapepool wherest=mountableinlib wherestatus=full remove=no

 

Ø  move media 067AHWL2 stg=ARCHIVE_TAPEPOOL wherestate=mountablenotinlib wherestatus='Empty'

 

Ø  q media stg=Archive_tapepool wherestate=mountablenotinlib wherestatus='Empty'

 

 

Schedules

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

Ø  select schedule_name,starttime,active from admin_schedules order by starttime asc

 

Ø  select starttime,schedule_name from client_schedules order by schedule_name asc

 

Ø  UPDATE SCHEDULE BKUP-NOTESMAIL-TAPEPOOL TYPE=ADMIN ACTIVE=YES

Ø  UPDATE SCHEDULE BKUP-STANDARD-DISKPOOL TYPE=ADMIN ACTIVE=YES

Ø  UPDATE SCHEDULE BKUP-STANDARD-TAPEPOOL TYPE=ADMIN ACTIVE=YES

Ø  UPDATE SCHEDULE REC-OFFSITE-NOTESMAIL-START TYPE=ADMIN ACTIVE=YES

Ø  UPDATE SCHEDULE REC-OFFSITE-TAPEPOOL-START TYPE=ADMIN ACTIVE=YES

Ø  DELETE SCHEDULE NOTESMAIL_DOMAIN RERUN_NOTEMAIL_BACKUP

Ø  DELETE SCHEDULE NT_DOMAIN W2K_RERUN

 

 

IMMEDIATE SCHEDULE:

____________________

 

Ø  DEFINE CLIENTACTION SHSPAPP001 DOMAIN=NT_DOMAIN ACTION=INCREMENTAL

Ø  DEFINE SCHEDULE NT_DOMAIN @325 ACTION=INCREMENTAL PRIORITY=1 PERUNITS=ONETIME DURATION=5 DURUNITS=DAYS

Ø  DEFINE ASSOCIATION NT_DOMAIN @325 SHSPAPP001

 

DB

-----

Ø  select pct_utilized as "DB % Utilized",cache_hit_pct as "Cache Hit %",last_backup_date as "Last DB Backup" from db   

 

Ø  delete volhist todate=-30 type=dbbackup

 

Ø  select  count(*) from drmedia where voltype='DBBackup'

 

Ø  select  count(*) from drmedia where voltype='CopyStgPool'

 

  

RESTORE

-----------

Ø  RESTORE -SU=YES -INACTIVE -PICK -PRESERVEPATH=NONE -FROMNODE=FLUF1P1E_FS (or FLUF2P1E) "/FLRLNMXX/MAIL5/ABC12345.NSF"  /FLRLNADM01/RESTORE/

 

Ø  restore -su=yes -inactive -pick -preservepath=none -fromnode=fluf2p1e_fs04 "/flrlnm04/mail8/ter12881.nsf" /flrlnadm01/restore/

 

Ø  restore -su=yes -inactive -pick -preservepath=none -fromnode=fluf2p1e_fs "/flrlnm06/mail8/rep95427.nsf" /flrlnadm01/restore/

 

Ø  restore -pitd=8/17/2013 -pitt=13:00:00 c:\mydir\

 

Ø  RESTORE -SU=YES -INACTIVE -PICK  "source"  "destination"  -pitd=8/17/2013 -pitt=13:00:00

 

 

 

BACKUPS

-----------

 

Ø  select node_name, filespace_name, backup_date from backups

 

Ø  select node_name,summary.activity,sum(cast(summary.bytes/1024/1024/1024 as decimal(6,2))) as GB from nodes, summary where (end_time between current_timestamp - 24 hours and current_timestamp) and activity='BACKUP' and ((nodes.node_name=summary.entity)) group by node_name,summary.activity order by activity,node_name asc

 

Ø  select * from summary where activity='BACKUP'

 

Ø  Select node_name, filespace_name, summary. activity, sum(cast(summary.bytes/1024/1024/1024 as decimal(6,2))) as GB from backups, summary where summary.activity='BACKUP' AND BACKUP_DATE='2009-10-07'

 

Ø  select node_name,filespace_name,summary.bytes from backups, summary where summary.activity='BACKUP' AND BACKUP_DATE='2009-10-07' and node_name='CJSPDFP001'

 

Ø  select node_name,filespace_name,summary.bytes from backups, summary where backups.BACKUP_DATE='2007-03-07' and backups.node_name=summary.entity

 

Ø  select entity, sum(cast(summary.bytes/1024/1024/1024 as decimal(6,2))) as GB from summary

 

SESSIONS:

___________

 

Ø  select session_id,client_name,wait_seconds,(bytes_received/1024/1024) as DATA_MB  from sessions order by client_name

 

Ø  select session_id,client_name,state,wait_seconds,cast(bytes_received/1024/1024 as decimal(9,2)) as DATA_MB  from sessions order by client_name

 

 

 

FILESPACES

__________

 

Ø  select filespace_name,backup_start,backup_end from filespaces where node_name like GV%FIL%'

 

Ø  select filespace_name,backup_start,backup_end from filespaces where node_name='GvPPFIL001'

 

Select statement for obtaining the total amount of data backed up for all the nodes for 1 month:

 

Ø  "select ENTITY,ACTIVITY,(BYTES/1024/1024) as BACKUP_MB,time(START_TIME) as START_TIME,date(START_TIME) as START_DATE,time(END_TIME) as END_TIME,date(END_TIME) as END_DATE from summary where ACTIVITY='BACKUP' AND date(START_TIME) >= CURRENT_DATE - 30 days"

Ø

 

 

For Archive

 

Ø  "select ENTITY,ACTIVITY,(BYTES/1024/1024) as BACKUP_MB,time(START_TIME) as START_TIME,date(START_TIME) as START_DATE,time(END_TIME) as END_TIME,date(END_TIME) as END_DATE from summary where ACTIVITY='ARCHIVE' AND date(START_TIME) >= CURRENT_DATE - 30 days"

 

Ø  select distinc(volume_name) from volumeusage where node_name='XXXXX'

 

Ø  ba stg Standard_tapepool offsite_copypool

 

Ø  ba stg notesmail_tapepool notesmail_offsite_copypool

 

Ø  ba stg notesmail_diskpool notesmail_offsite_copypool

 

Ø  backup db devclass=ltoclass1 t=f s=y

 

LIBRARY AND DRIVES

___________________

 

Ø  define path SMSPAPP002 mt3.0.0.3 srctype=server desttype=drive device=mt3.0.0.3  library=LB1.1.0.4'

 

Ø  define drive LB1.1.0.4 mt4.0.0.3 element=89'

 

EXPORT AND IMPORT

__________________

 

Ø  export node DECOMM_EN-BDC2-20-06-05-23 files="\\en-bdc2\d$" filedata=all toserver='PESPBAK001' previewimport=yes

Ø  export node DECOMM_EN-BDC2-20-06-05-23 filesdata=backup previewimport=yes devclass=ltoclass1 scratch=yes

 

MONTHLY REPORT:

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

 Ø  select server_name from status

 

Ø  select activity as "Backup/Archive",count (*) as "Monthly Count" from summary where activity='BACKUP' AND start_time !< '$1' and end_time !>'$2'or activity='ARCHIVE' AND start_time !< '$1' and end_time !> '$2' group by activity

Ø  select count (*) as "Total" from summary where activity='BACKUP'AND start_time !< '$1' and end_time !>'$2'or activity='ARCHIVE' AND start_time !< '$1' and end_time !> '$2'

 

Ø  Select cast ((sum (affected)) as varchar(25)) as "Total No. Objects Backed Up", case when sum(bytes) > 1073741824 then cast(sum(bytes)/1073741824 as varchar(10))||' Gb' when sum(bytes) > 1048576 then cast(sum(bytes)/1048576 as varchar(10))||' Mb' when sum(bytes) > 1024 then cast(sum(bytes)/1024 as varchar(10))||' Kb' else cast(sum(bytes) as varchar(10)) end as "Total Size" from summary where activity='BACKUP'AND start_time !< '$1' and end_time !>'$2'or activity='ARCHIVE' AND start_time !< '$1' and end_time !> '$2'

 

Ø  select SESSION_ID,CLIENT_NAME,STATE,current_timestamp-START_TIME as "Elapsed Time",BYTES_RECEIVED/1024/1024/1024,CLIENT_PLATFORM,OUTPUT_VOL_ACCES            S from sessions where OUTPUT_VOL_ACCESs is not null

 

 Ø  SELECT NODE_NAME,CLIENT_VERSION,CLIENT_RELEASE,CLIENT_LEVEL,CLIENT_OS_LEVEL from NODES where NODE_NAME in (select Node_name from ASSOCIATIONS)

 Ø  select volume_name,STGPOOL_NAME,(current_timestamp-LAST_READ_DATE) as "last accessed" from volumes where volume_name in (select volume_name from libvolumes) and stgpool_name='STANDARD_TAPEPOOL' and (current_timestamp-LAST_READ_DATE)> 90 days order by 3

 

Ø  q ev * *mon* begind=-30 endd=today