30 17 * * * /opt/IBM/db2/V8.1/bin/db2 backup db parks use tsm
above is what is in my db2inst1 crontab file Ralph > -----Original Message----- > From: Post, Mark K [mailto:[EMAIL PROTECTED] > Sent: Friday, January 09, 2004 3:38 PM > To: [EMAIL PROTECTED] > Subject: Re: Cron > > > This should be unnecessary. All that should be required is > to logon to the > system as db2inst1 (or su - db2inst1 from root), and then > crontab -e > add command to the schedule > :x > exit (from being db2inst1) > > Cron runs all cron jobs as the user that created the crontab > entry. I would > like to see the complete crontab entry to see if there is > anything else > wrong with it that might be causing some kind of problem. > > > Mark Post > > -----Original Message----- > From: Nix, Robert P. [mailto:[EMAIL PROTECTED] > Sent: Friday, January 09, 2004 4:15 PM > To: [EMAIL PROTECTED] > Subject: Re: Cron > > > 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 > >
