Results 1 to 15 of 15
  1. #1
    Join Date
    Jan 2003
    Posts
    1,605

    Unanswered: Unable to start governor at node "0". rc = "2".

    Hi,

    I have got the error from DB2 v7.2 on Win2000 when trying to start the governor with the following command:
    db2gov start sample c:\test.gov c:\output.log

    Error
    OpenEvent1:The system cannot find the file specified.
    db2gov: GOV1062N Unable to start governor at node "0". rc = "2".

    Contents of c:\test.gov file:
    { Wake up once a second, the database name is sample
    do accounting every 30 minutes. }
    interval 1; dbname sample; account 30;

    desc "Allow no UOW to run for more than 10 secounds"
    setlimit uowtime 10 action force;


    Thanks,
    Grofaty

  2. #2
    Join Date
    Mar 2003
    Posts
    33

    Re: Unable to start governor at node "0". rc = "2".

    Somebody had same problem last year and someone answered:

    'You have to start service db2reggv.exe first. ("db2reggv i instance_owner psw_of_instance_owner")'

    Hope it helps.


    (http://dbforums.com/archives/t298189.html)
    -r-

  3. #3
    Join Date
    Jan 2003
    Posts
    1,605

    Re: Unable to start governor at node "0". rc = "2".

    Originally posted by raisa
    Somebody had same problem last year and someone answered:

    'You have to start service db2reggv.exe first. ("db2reggv i instance_owner psw_of_instance_owner")'

    Hope it helps.


    (http://dbforums.com/archives/t298189.html)
    Hi,

    I read the above link. I did this in DB2 Command Window:
    db2reggv i username password

    I got response:
    ok

    Then executed
    db2gov start sample test.gov test_gov.log

    I got error
    db2gov: GOV1018N Unable to retrieve instance path. RC = "-6646".
    db2gov: GOV1062N Unable to start governor at node "0". rc = "-6646".

    Any help?

    Thanks,
    Grofaty

  4. #4
    Join Date
    Mar 2003
    Posts
    343
    We start the Governor as follows everytime and it works fine. I hope it works for you too. Create the cfg file, say called db2gov.cfg and save it under $insthome/sqllib/

    Start the governor by issuing the command

    db2gov start <dbname> db2gov.cfg db2gov.log

    The log which is saved under $insthome/sqllib/log/ can be read with the db2govlg command.

    An example, if you want to read for rectype nice is

    db2govlg db2gov.log rectype nice

    The different rectypes are start, nice, force, error, warning, readcfg, stop and account.

    To stop the governor,

    db2gov stop <dbname>

    In and MPP system, there will be multiple logs in the log directory with the nodenumber at the end,

    ie db2gov.log.0, db2gov.log.1 etc
    and depending on the configuration and how busy the system is, these logs can grow, however, they cannot be truncated while the governor is running since db2 continues to write to the previous files(unlike the diag). In order to truncate, stop the governor, truncate, and then start again.

    Hope this helps.

  5. #5
    Join Date
    Jan 2003
    Posts
    1,605
    Hi,

    cchattoraj, thanks for reply. I have tested this on my secound test computer and it works file. Something must be wrong with my database settings on my first test computer.

    Thanks again, no help is needed.

    Just a short notice: On Windows 2000 the default governer log file location is on the path: path\sqllib\db2\log\db2gov.cfg.

    Thanks,
    Grofaty

  6. #6
    Join Date
    Mar 2003
    Posts
    343
    Thanks for sharing that - I was unaware. I work on AIX and kind of assume that it's all the same.

    Curious though, which database settings on the computer on which it doesn't work could be wrong?

  7. #7
    Join Date
    Jan 2003
    Posts
    1,605
    Hi,

    I don't know. If I would know that, I wouldn't be asking the forum.

    Thanks,
    Grofaty
    Originally posted by cchattoraj
    Thanks for sharing that - I was unaware. I work on AIX and kind of assume that it's all the same.

    Curious though, which database settings on the computer on which it doesn't work could be wrong?

  8. #8
    Join Date
    Jan 2003
    Posts
    1,605
    Hi,

    I fond out what was wrong with my first test computer.

    I executed the above commands on path: path\sqllib\bin (with returns error) instread of path\sqllib (witch is correct path)!

    Grofaty

  9. #9
    Join Date
    Mar 2003
    Posts
    343
    I think one of them is you need to have the dft_mon_uow on.

  10. #10
    Join Date
    Jan 2003
    Posts
    1,605
    Originally posted by cchattoraj
    I think one of them is you need to have the dft_mon_uow on.
    Hi,

    I have read about aft_mon_uow parameter in "Database Administrator - Performance" book.

    How can I check if this parameter is on or off?

    Thanks,
    Grofaty

  11. #11
    Join Date
    Mar 2003
    Posts
    343
    db2 get dbm cfg | grep -i dft_

  12. #12
    Join Date
    Jan 2003
    Posts
    1,605
    Hi,

    Thank you, cchattoraj. It helps me very much.

    BTW: On Windows just: db2 get dbm cfg. Grep command is Unix command witch doesn't work on Windows.

    Grofaty
    Last edited by grofaty; 07-28-03 at 02:31.

  13. #13
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    In Windows you can use find command

    db2 get dbm cfg | find "dft_"


    HTH

    Sathyaram

    Originally posted by grofaty
    Hi,

    Thank you, cchattoraj. It helps me very much.

    BTW: On Windows just: db2 get dbm cfg. Grep command is Unix command witch doesn't work on Windows.

    Grofaty
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  14. #14
    Join Date
    Jan 2003
    Posts
    1,605
    Hi,

    Thanks sathyaram_s.

    BTW: "dft_" parameter must be in upper case like "DFT_". Sintax - db2 get dbm cfg | find "DFT_" works fine.

    Grofaty

  15. #15
    Join Date
    Aug 2003
    Location
    austin,tx
    Posts
    104
    I came across this issue after upgrading from v9.1 to v9.7.

    Under 9.1 issuing:
    db2gov START MYDB db2gov.cfg db2gov.log

    would start the service. Under 9.7 it doesn't appear to on my machine.
    I now have to issue:
    net start DB2GOVERNOR
    db2gov START MYDB db2gov.cfg db2gov.log

    I have a scheduled task to start-restart it in case it dies, and I actually have to jump though several hoops with it:
    net stop DB2GOVERNOR doesn't seem to always stop the service.. so..

    db2gov STOP myDB
    net stop DB2GOVERNOR
    taskkill /IM db2govd.exe /F
    net start DB2GOVERNOR
    db2gov START MYDB db2gov.cfg db2gov.log

    PITA

Posting Permissions

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