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
