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
