Sorry for replyin to my own mail but here some more info:

ADSM server version 3.1.2.30
ADSM client version 3.1.2.7
ADSM API client version 3.1.2.7

> -----Original Message-----
> From: Bijma, F [mailto:fbijma AT AEGON DOT NL]
> Sent: Tuesday, July 20, 1999 12:15 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: ADSM and DB2 backup schedule
>
>
> Can somebody help me with the following rpoblem:
>
> I am trying to backup DB2 UDB with the ADSM api and the following AIP
> environment settings:
>
> DSMI_CONFIG=/aebeheer/adsmdb2/dsm.opt
> DSMI_DIR=/usr/lpp/adsm/api/bin
> DSMI_LOG=/var/msgs/adsm
>
> The options file is:
> /home/root# cat /aebeheer/adsmdb2/dsm.opt
> Servername PDYL
>
> and the dsm.sys file is in /usr/lpp/adsm/api/bin
> /home/root# cat /usr/lpp/adsm/bin/dsm.sys
>
> Servername PDYL
> COMMmethod tcpip
> TCPPort 5500
> HTTPPort 5581
> TCPServeraddress I10154_en0.ada.aegon.nl
> inclexcl /usr/lpp/adsm/bin/inclexcl.lst
> SCHEDMOD prompted
> passworda generate
> schedlogretention 3
> schedlogname /var/msgs/adsm/sched.log
> ERRORLOGname /var/msgs/adsm/dsmerror.log
> tcpwindowsize 64
> tcpbuffsize 32
> txnb 25600
>
> We have added the ADSM password in the DB2 configuration and
> one of the
> databases can be backed up without a
> problem with a schedule: su - edxji -c db2  backup db edxj1d
> online use adsm
>
> All the other database instances go wrong. They use exactly
> the same backup
> command except with an other user but the same
> environment variables for the API.
>
> They all return the following in the sched.log:
>
> 07/20/99   11:37:48 TCP/IP accepted connection from server.
> 07/20/99   11:37:48 Querying server for next scheduled event.
> 07/20/99   11:37:48 Node Name: I10205_EN0
> 07/20/99   11:37:48 Session established with server PDYL: AIX-RS/6000
> 07/20/99   11:37:48   Server Version 3, Release 1, Level 2.30
> 07/20/99   11:37:48   Server date/time: 07/20/99   11:37:48
> Last access:
> 07/20/99   11:13:35
>
> 07/20/99   11:37:48 --- SCHEDULEREC QUERY BEGIN
> 07/20/99   11:37:48 --- SCHEDULEREC QUERY END
> 07/20/99   11:37:48 Next operation scheduled:
> 07/20/99   11:37:48
> ------------------------------------------------------------
> 07/20/99   11:37:48 Schedule Name:         @314
> 07/20/99   11:37:48 Action:                Command
> 07/20/99   11:37:48 Objects:               su - dhfsi -c db2 backup db
> dhfs1d online use adsm  > /home/root/logfile 2>&1
> 07/20/99   11:37:48 Options:
> 07/20/99   11:37:48 Server Window Start:   11:35:36 on 07/20/99
> 07/20/99   11:37:48
> ------------------------------------------------------------
> 07/20/99   11:37:48
> Executing scheduled command now.
> 07/20/99   11:37:48
> Executing Operating System command or script:
>    su - dhfsi -c db2 backup db dhfs1d online use adsm  >
> /home/root/logfile
> 2>&1
> 07/20/99   11:37:50 Finished command.  Return code is:
>    2048
> <<<===========================================================
> ==============
> ==============
> 07/20/99   11:37:50 Scheduled event '@314' completed successfully.
> 07/20/99   11:37:50 Sending results for scheduled event '@314'.
> 07/20/99   11:37:50 Results sent to server for scheduled event '@314'.
>
>
> As you can see it returns a returncode of 2048. Is this a DB2
> return code or
> an API return code?
> We have been trying and trying but where not able to get this
> to work for
> the other database instances on this same
> machine.
>
> I hope somebody can help me with this.
>
> Regards,
> Frans Bijma,
>
>
>
> fbijma AT aegon DOT nl
> fb AT solution6000 DOT com
> http://www.solution6000.com
>