Print Page - arsdb error on fresh install

Title: arsdb error on fresh install
Post by: jsquizz on April 12, 2016, 01:02:32 PM

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?

Title: Re: arsdb error on fresh install
Post by: Michel de Kraker on April 12, 2016, 07:21:15 PM

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.

Title: Re: arsdb error on fresh install
Post by: jsquizz on April 12, 2016, 08:13:57 PM

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

Title: Re: arsdb error on fresh install
Post by: Justin Derrick on April 13, 2016, 08:40:27 AM

Quote from: jsquizz on April 12, 2016, 01:02:32 PM
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.

Title: Re: arsdb error on fresh install
Post by: jsquizz on April 13, 2016, 11:24:13 AM

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
$

Title: Re: arsdb error on fresh install
Post by: Justin Derrick on April 13, 2016, 06:40:56 PM

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

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

-JD.

Title: Re: arsdb error on fresh install
Post by: jsquizz on April 13, 2016, 07:31:17 PM

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]#

Title: Re: arsdb error on fresh install
Post by: Justin Derrick on April 13, 2016, 11:35:13 PM

Quote from: jsquizz on April 13, 2016, 07:31:17 PM
Unable to start database archive. SQLCODE = -1092

Still a file/user permissions issue. :)

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

-JD.

Title: Re: arsdb error on fresh install
Post by: jsquizz on April 14, 2016, 11:20:12 AM

Quote from: Justin Derrick on April 13, 2016, 11:35:13 PM
Quote from: jsquizz on April 13, 2016, 07:31:17 PM
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?

Title: Re: arsdb error on fresh install
Post by: Justin Derrick on April 14, 2016, 12:31:31 PM

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.

OnDemand Users Group

Support Forums => CMOD for Multiplatforms => Topic started by: jsquizz on April 12, 2016, 01:02:32 PM