I used to administer several OS/2 machines, some of which had DB2/2
     databases on them. Not sure if this can be done but have you tried=20
     having a rexx execute your manual backup (this provided you can get
     around the prompts) to another drive on the machine and then have
ADSM=20
     backup the 2 or 3 files created by the backup.=20
    =20
      I can't believe their isn't a way to create a backup on OS/2 =20
     programatically. I'll ask one of the guys in my old group to give
it a=20
     spin. . .=20
    =20
     Damon Taylor
     Amoco Corp.=20


______________________________ Reply Separator
_________________________________
Subject: Automating DB2/2 backups
Author:  ADSM-L (ADSM-L AT VM.MARIST DOT EDU) at unix,mime
Date:    5/29/97 9:48 AM


Hi ADSM-ers!
I have a customer who wants his DB2/2 v1.0 machine backed up by ADSM.
I have recently bought the manual "Using ADSM To Backup Databases" which
contain
s a whole chapter about backing up DB2/2 databases. My problem is that
all scena
rios covered are talking about manual backups. I want the backups done
automatic
ally, fully controlled by ADSM. So I want to schedule the backup through
ADSM wh
ich rules out the possibility of using the DB2/2 backup utility. The
only scenar
io I can come up with is the following:
Have ADSM execute a REXX file on the OS/2 client which:=20
1) Stops the database
2) Stops the database manager
3) Backs up all SQL00xxx directories=20
4) Start the database manager
This is one of the options described in the manual but IBM's DB2/2
people say th
is is NOT a reliable way to backup DB2/2! This because DB2/2 does some
administr
ation outside of the SQL00xxx directories which will be out of sinc when
doing a
 restore.
Is there somebody who has a successful scenario to backup DB2/2
databases using=20
ADSM?
Thanks in advance for your reply!
Kindest regards,
Eric van Loon