arsdb error on fresh install

[jsquizz]

I am creating a sandbox enviroment running 8.5 CMOD and 9.5 DB2...I know, old!

Installed db2
Created user archive, gave admin permissions
I created the instance archive, owner as root
I created the db archive
I activated the db
I verified I could connect to the db archive

when I go to run arsdbI get the following error: **********typo

arsdb -I archive -gcv

I get the following error:

Starting the DB2 archive database instance
Unable to start database archive.  SQLCODE = -1092
arsdb:  Unable to start the DB2 archive database instance

Has anyone seen this error before or know a resoluton?

[Michel de Kraker]

Hi

SQL code 1092 means there is something wrong with the permissions.
What user is executing the arsload and arsdb commands?

BTW , you say you are having problems with arsload command but in the example you mention arsdb?

Kind regards

Michel.

[jsquizz]

Didnt get that far with arsload.

per my ars.ini (as well as in other working environments)
Instance is archive
Owner is root

I am trying to execute via root

[Justin Derrick]

when I go to run arsload I get the following error:

That's what Michel is talking about. 

And if the instance is archive, run the database creation as archive.  Your root account probably doesn't belong to the SYSADM group defined in the database instance.  IBM wants to get people out of the habit of running things as root, because compromising CMOD or DB2 means compromising the entire OS.

-JD.

[jsquizz]

Heres what I am getting running this command as archive

Starting the DB2 archive database instance
The archive instance has already been started
Creating the DB2 archive database
Creating links for the following file:
        db2uext2
Do you wish to use DISK(1) or ADSM(2)?
Please specify 1 or 2:1
Unable to create the archive database.  err=-1326
arsdb:  Unable to create the DB2 archive database
$

[Justin Derrick]

It's not a magic bullet, but you can start here:

http://cmod.wiki/index.php/Unable_to_create_ARCHIVE_database

-JD.

[jsquizz]

Tried all that and still stuck here at

Starting the DB2 archive database instance
Unable to start database archive.  SQLCODE = -1092
arsdb:  Unable to start the DB2 archive database instance
[root@aix71lab4:/usr/lpp/ars/bin]#

[Justin Derrick]

Unable to start database archive.  SQLCODE = -1092

Still a file/user permissions issue. 

https://www-01.ibm.com/support/docview.wss?uid=swg21437767

-JD.

[jsquizz]

Unable to start database archive.  SQLCODE = -1092

Still a file/user permissions issue. 

https://www-01.ibm.com/support/docview.wss?uid=swg21437767

-JD.

JD- and this can cause this error when trying to run ARSDB?

[Justin Derrick]

That article is really, really old...  5 year is forever ago.  Check out the Message References to see if there's any hints.

https://cmod.wiki/index.php/Main_Page#IBM_DB2_Documentation

-JD.