Gentlemen,
Find all unique agid?s from ARSHOLDMAP
Find all unique load id name for each of the load id.
Build loadid?s using below query.
db2 -x "select agid, pri_nid, sec_nid, name, start, stop from arsload where agid=5223 and name=?$name?? | awk 'BEGIN { OFS="-" } { print $1, $2, $3, $4, $5, $6 }'
build the query to extract the file from CMOD folder based on load id. We need to find a way to know which folder to query. I guess an application group could get mapped to 2 different folders? If not, that step will also be easy.
arsdoc get ?h hostname ?u user ?p password ?G $Appgroup ?f $FOLDERNAME ?d $DIR ?caN ?X $LOADID
Store the file into CMOD.
Once we make sure all files are there for each group, we can release the holds.
ANY suggestion? Is there another way of doing this?