Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2003
    Posts
    6

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

    Hi,

    I use Linux RedHat 7.3 and IBM db2 7.1, I have problem, I was set enviroment variable to /home/db2inst1/sqllib/db2profile (it's set default for owner db2 instance.
    When I run bash script, it's running correctly, but when rut the same script with cron, it's no run and write errorQL10007N Message "-1390" could not be retrieved. Reason code: "1".
    I don't know why.
    Cron tab is create under user db2inst1 and script look's like:
    20 08 * * * /path to script/script

    and script is for example: db2 force application all

    Cron use any other profile?

    Thanks Adrian

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

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

    Run the db2profile command as the first line of your script file ...

    Cheers

    Sathyaram

    Originally posted by adrin13
    Hi,

    I use Linux RedHat 7.3 and IBM db2 7.1, I have problem, I was set enviroment variable to /home/db2inst1/sqllib/db2profile (it's set default for owner db2 instance.
    When I run bash script, it's running correctly, but when rut the same script with cron, it's no run and write errorQL10007N Message "-1390" could not be retrieved. Reason code: "1".
    I don't know why.
    Cron tab is create under user db2inst1 and script look's like:
    20 08 * * * /path to script/script

    and script is for example: db2 force application all

    Cron use any other profile?

    Thanks Adrian

  3. #3
    Join Date
    Mar 2003
    Posts
    6

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

    Thanks for answer, but it's still don't work.

    I have script:
    /home/db2inst1/sqllib/db2profile
    db2 force application all
    ....
    ....
    and command db2 force application all write error SQL10007N....

    Thanks

    Originally posted by adrin13
    Hi,

    I use Linux RedHat 7.3 and IBM db2 7.1, I have problem, I was set enviroment variable to /home/db2inst1/sqllib/db2profile (it's set default for owner db2 instance.
    When I run bash script, it's running correctly, but when rut the same script with cron, it's no run and write errorQL10007N Message "-1390" could not be retrieved. Reason code: "1".
    I don't know why.
    Cron tab is create under user db2inst1 and script look's like:
    20 08 * * * /path to script/script

    and script is for example: db2 force application all

    Cron use any other profile?

    Thanks Adrian

  4. #4
    Join Date
    Mar 2003
    Posts
    6

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

    OK it's working good.

    Thanks

Posting Permissions

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