I also issue arsdb -gkv but IBM pointed out a technote:
http://www-01.ibm.com/support/docview.wss?uid=swg21206602QuestionWhen I run arsdb -gkv, I receive the following error:
> arsdb -gkv
Starting the DB2 ARCHIVE database instance
Activating the DB2 ARCHIVE database
Unable to activate database ARCHIVE. SQLCODE = -1031
CauseThe arsdb -k command issues an activate database DB2 CLI call to DB2. Starting in DB2 version 6 or 7, DB2 automatically activates and de-activates all databases upon db2start and db2stop.
AnswerThe -k parameter is unnecessary now, since arsdb -g issues the DB2 equivalent of a db2start, therefore omit the -k parameter when running arsdb.
---- Now the above being said, I'm going around with level 1 on this because what happens (I'm at 8.5.0.5 now), is if I issue a db2start, the db comes up, then I issue arssockd start and everything is fine. But if I shut it all down, then issue arsdb -gv or arsdb -gkv, I get the same error:
oddevsb:/usr/lpp/ars/bin>arsdb -gkv
arsdb: Unable to initialize environment. The return code is 1
This error is what originally drove the PMR I opened.
-walt