Re: [ADSM-L] Identify Duplicates Idle vs Active state?

I have 2 pools to receive the backups, and I flip/flop them daily.  So
the
%1A etc is to test for the processes associated with the pool which is
now idle,
which is the one I want to migrated down to the sata based storagepools.

There are other lines in the script which test for %1B etc.

Here it the output of a script which makes a consolidate display of
processes.  It reformats
the status column from 'select * from processes' -

Num       Process        Status
-----     ----------
------------------------------------------------------------------------
------------------------------------
1         Identify D      BKP_1A. Volume: NONE. State: idle. Total
Duplicate Bytes Found: 932,910,685,096.
2         Identify D      BKP_1A. Volume: NONE. State: idle. Total
Duplicate Bytes Found: 788,584,107,631.
3         Identify D      BKP_1A. Volume: NONE. State: idle. Total
Duplicate Bytes Found: 736,142,766,941.
4         Identify D      BKP_1B. Volume: /tsm_es115/win1/00072EF1.BFS.
State: active. Total Duplicate Bytes Found: 803,112,627,190.
5         Identify D      BKP_1B. Volume: /tsm_es118/win1/00072FE3.BFS.
State: active. Total Duplicate Bytes Found: 625,537,450,389.
6         Identify D      BKP_1B. Volume: /tsm_es123/win1/00072E56.BFS.
State: active. Total Duplicate Bytes Found: 521,743,380,790.



Thanks,

Bill Colwell
Draper Lab



-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
David E Ehresman
Sent: Wednesday, May 25, 2011 11:52 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Identify Duplicates Idle vs Active state?

What does the "%1A." in "like ''%1A.%active%'' having count(*) < 1 '"
test for?

>>> "Colwell, William F." <bcolwell AT DRAPER DOT COM> 5/25/2011 11:17 AM >>>
Hi Harold,



I am running 6.1 with dedup and have coded scripts to check the id dup
processes before proceeding.

Here is a snippet -



upd scr start_migration 'select count(*) from processes where
substr(process,1,1)=''I'' -'

upd scr start_migration '                                 and status
like ''%1A.%active%'' having count(*) < 1 '

upd scr start_migration 'if(rc_notfound) goto reschedule'



The sql is looking for any still id dup processes still active - I run
3
processes

for each 'landing zone' pool.  If none are active, the select returns
a
value (0) and the logic

falls thru to start migration.



Hope this helps,



Bill Colwell

Draper Lab



-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf
Of
Vandeventer, Harold [BS]
Sent: Tuesday, May 24, 2011 2:59 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Identify Duplicates Idle vs Active state?



I'm working up scripting for our TSM 6.2 system where dedup will be
implemented.



Is there a way to test for the IDLE state of an IDENTIFY DUPLICATES
process?



I'd like to have our script test for the idle state to allow the next
set of work to proceed as soon as possible.



We've used  IF(RC_OK) in TSM 5.x scripts to test for upper(process) =
"BACKUP STORGE POOL" or upper(session_type) = "NODE", but I don't see
a
way to detect that idle vs. active state on identify duplicates
processes.



Thanks...





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

Harold Vandeventer

Systems Programmer

State of Kansas - DISC

Harold.Vandeventer AT da.ks DOT gov<mailto:Dane.Woodring AT da.ks DOT gov>

(785) 296-0631