HTH, Pierre.
nek iv wrote:
Thanks for this Pierre.
For some reasons, I still could not make it work.
Here is what I did:
I created user (db2admin) as suggested connect to SAMPLE db2gov start sample samplecfg.txt samplelog.txt
This returned exactly the same 3-line errors from db2govlg as below.
I went further to uninstall/re-install DB2 8.1. This time I let DB2 create the user (db2admin).
Logon W2K as db2admin (db2admin is made member of Administrators now) and execute 'db2gov start' after connecting to SAMPLE. Still, the same error prevails.
I'm perplexed. Any more help is appreciated.
Nek.
From: "P. Saint-Jacques" <[EMAIL PROTECTED]> Reply-To: "P. Saint-Jacques" <[EMAIL PROTECTED]> To: nek iv <[EMAIL PROTECTED]> CC: [EMAIL PROTECTED] Subject: Re: [DB2EUG] DB2 Governor Start error Date: Sun, 10 Aug 2003 23:19:52 -0400
Your problem is with your id
"administrator" is more than 8 chars. and In V8 I think you're still limited to 8 chars for the sysadmin id for DB2.
The "db2admin" id should have been generated by your install. Try loggong on with it, the pw is the same db2admin. Once logged on, you should be able to start the governor.
If the id does not exist, log on as administrator, create the id, make sure it is and Administrator and then log on with it.
HTH, Pierre. nek iv wrote:
Hi list,
I tried to start the db2 governor but encountered the following error message from db2govlg command:
2003-08-09-19.33.41 0 START Database = SAMPLE
2003-08-09-19.33.41 0 READCFG Config = C:\samplecfg.txt
2003-08-09-19.33.41 0 ERROR (15005) GOV1053N "SQLMON" error: SQLCODE = "-567"
The message from (db2 "? sql567") says:
SQL0567N "(authorization-ID) is not a valid authorization ID.
I logged on W2K as 'administrator', installed (DB2 V8.1, fixpak 2), created SAMPLE databaseas and started db2gov as 'administrator':
db2 start sample samplecfg.txt samplelog.txt (Also tried full path for the 2 text files)
From C:\db2 connect:
Database Connection Information
Database server = Db2/NT 8.1.2 SQL authorization ID = ADMINISTRATOR Local database alias = SAMPLE
Here is content of gov configure file (from DB2 admin example):
------------------------------------------------------------------------------------
{wake up once a second. Do accounting every 5 mins} interval 1; dbname sample; account 5;
setlimit uowtime 3600 action force;
----------------------------------------------------------------------------------
I first thought it was due to the location of file, but shufflled it around still led me nowhere. For example, I created the configure file in:
C:\samplecfg.txt (Also where samplelog.txt is) or
C:\Program Files\IBM\SQLLIB\samplecfg.txt (Also where samplelog.txt is)
Also check db2reggov.exe is started.
Would someone please shed some light on this appearing simple task? Much appreciated.
Nek
_________________________________________________________________
Hot chart ringtones and polyphonics. Go to http://ninemsn.com.au/mobilemania/default.asp
- ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
- ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
_________________________________________________________________
ninemsn Extra Storage is now available. 30MB of storage on ninemsn Groups - great for sharing photos and documents. Click here http://join.msn.com/
- ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
- ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
