I have seen this error in the db2 forum but not a finalized resolution

SQL10007N Message "-1390" could not be retrieved.

here is my problem:

I am using Udb 8.1 on Red Hat Linux v8.

I created a crontab entry for my script under the db2 user.

crontab entry:

37 16 * * 1-5 /data/DB2BackupData/config/dia_backup

where dia_backup is my script.

Contents of the dia_backup script:

/home/db2inst3/sqllib/db2profile
/home/db2inst3/sqllib/bin/db2 force applications all
/home/db2inst3/sqllib/bin/db2 backup db dia to '/data/arraya/bck'


Whenever the job is executed from the crontab it fails with the above error.

If I run the script from the os command line it works.

Any suggestions?

NOTE:
I verified that my DB2INSTANCE paramter is set and I have also
checked the file permissions for where the backup file is
suppose to end up.



Thanks in Advance
CS

Try using
. /home/db2inst3/sqllib/db2profile

instead of
/home/db2inst3/sqllib/db2profile

Note: there is a space between . and / in the former case

Let us know how it goes

sathyaram

Thanks that did the trick !!