Have cron execute the following command, or similar: su - db2inst1 /opt/IBM/db2/V8.1/bin/db2 backup db parks use tsm
---- Robert P. Nix internet: [EMAIL PROTECTED] Mayo Clinic phone: 507-284-0844 RO-CE-8-857 page: 507-270-1182 200 First St. SW Rochester, MN 55905 ---- "Codito, Ergo Sum" "In theory, theory and practice are the same, but in practice, theory and practice are different." > -----Original Message----- > From: Noll, Ralph [SMTP:[EMAIL PROTECTED] > Sent: Friday, January 09, 2004 3:03 PM > To: [EMAIL PROTECTED] > Subject: Cron > > I am trying to execute a cron job to backup db2.. > > my db2 user is db2inst1 > > i setup the crontab job as db2inst1 > > when i run it i get an error > > Output from command /opt/IBM/db2/V8.1/bin/db2 backup db parks use tsm .. > > SQL10007N Message "-1390" could not be retrieved. Reason code: "1". > > If I run the backup job logged in as db2inst1 no problem > > if i run the job logged in as root i get the same above error > > > so what i am asking is how do i setup a cron job to execute as user db2inst1?? > > thanks > > Ralph
