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:[email protected]] On Behalf Of David E Ehresman Sent: Wednesday, May 25, 2011 11:52 AM To: [email protected] Subject: Re: Identify Duplicates Idle vs Active state? What does the "%1A." in "like ''%1A.%active%'' having count(*) < 1 '" test for? >>> "Colwell, William F." <[email protected]> 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:[email protected]] On Behalf Of Vandeventer, Harold [BS] Sent: Tuesday, May 24, 2011 2:59 PM To: [email protected] 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 [email protected]<mailto:[email protected]> (785) 296-0631
