Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    6

    Unanswered: SQL10007N Message "-1390" could not be retrieved.

    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

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: SQL10007N Message "-1390" could not be retrieved.

    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


    Originally posted by solomoc
    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
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Oct 2003
    Posts
    6

    Re: SQL10007N Message "-1390" could not be retrieved.

    Originally posted by sathyaram_s
    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 !!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •