"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
