You either add a bunch of logic to your script to issue 'q stg name'
commands to see when reclamation is done, or you can see which tapes need to
be reclaimed and issue 'mov data' against each one.

However, if your reuse delay on the offsite pool is > 0, then you don't need
to worry about the database backup being 100% current for things like
offsite tape reclamation.  The tapes that get reclaimed are "pending" and
could still be used for the recovery.  So, as long you take another database
backup before the reclaimed tapes become empty and available for reuse,
you'll be fine.  This is how we handle it.

Tina Hilton

> -----Original Message-----
> From: Pat Wilson [SMTP:paw AT NORTHSTAR.DARTMOUTH DOT EDU]
> Sent: Wednesday, August 19, 1998 12:17 PM
> To:   ADSM-L AT VM.MARIST DOT EDU
> Subject:      scheduling of copypool reclamation?
>
> I've set up a schedule for pool and db backup that runs nightly from cron
> and uses "wait=yes" on everything to ensure order.  Now I need to add in
> (offsite) copypool reclamation, and it seems to me that I want to have the
> reclamation complete before I do the db backup (so that the db backup
> going
> offsite is correct).  How do I ensure that the db backup doesn't happen
> until the copypool reclaim is done?  AIX 4.2.1, ADSM 3.1.1.3...
>
> Thanks.
>
> Pat Wilson
> paw AT dartmouth DOT edu
>
> PS My current cron script (just in case it's helpful) is
>
>         # ADSM tasks for 0500
>
>         # expire inventory, backup storage pools, backup database
>         /bin/dsmadmc -id=xxxx -pa=xxxx  expire inventory wait=yes
>         /bin/dsmadmc -id=xxxx -pa=xxxx  backup stg backuppool copypool
> wait=yes
>         /bin/dsmadmc -id=xxxx -pa=xxxx  backup stg autodlt_pool copypool
> wait=yes
>         /bin/dsmadmc -id=xxxx -pa=xxxx  backup db dev=autodlt_class
> type=full wait=yes
>
>         /bin/dsmadmc -id=xxxx -pa=xxxx  backup volhist
>         /bin/dsmadmc -id=xxxx -pa=xxxx  backup devconfig
>
>         # now clean up a bit; remove old DBB volumes
>         /bin/dsmadmc -id=xxxx -pa=xxxx  del volh tod=today-1 type=dbb
>
>         # and set up for DRM
>         /bin/dsmadmc -id=xxxx -pa=xxxx q drm wherest=mountable cmd="dism v
> &vol" cmdf=/tmp
>         /drm.mac f=c
>         /bin/dsmadmc -id=xxxx -pa=xxxx macro /tmp/drm.mac
>         /bin/dsmadmc -id=xxxx -pa=xxxx "mov drm * wherest=mountable rem=no
> wait=yes"
>         /bin/dsmadmc -id=xxxx -pa=xxxx set sqldisp w
>         /bin/dsmadmc -id=xxxx -pa=xxxx select message from actlog where
> msgno=8829
>         /bin/dsmadmc -id=xxxx -pa=xxxx set sqldisp n