By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,549 Members | 1,717 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,549 IT Pros & Developers. It's quick & easy.

DB2 8.1 AIX Client Installation Problems

P: n/a
All-

Having a problem installing a DB2 client on a machine running AIX
version 5.0. Client appeared to install one time succesfully, then
was uninstalled and a reinstall was attempted. For some reasons, it
does not complete the reinstall. See the status report from the GUI
installer at the end of this note. Errors are towards the bottom.
Everything installed in /usr/opt for DB2 but the sqllib folder that is
supposed to be created in the home directory of the instance ownder is
not installed (in our case the instance ownder is db2inst1). Have
tried installing DB2 with the user db2inst1 already existing and not.
Same error seems to appear. The key errors from the output below
appear to be:

ERROR:Could not switch current DB2INSTANCE to "db2inst1". The return
code is
"-2029059916".
ERROR:DBI1122E Instance db2inst1 cannot be updated.

Thanks for any help!
Matt
Enabling Asynchronous I/O:.......Success
Checking license agreement acceptance:.......Success
Installing DB2 file sets:.......Success
Registering DB2 licenses:.......Success
Setting default global profile registry variables:.......Success
Initializing instance list:.......Success
Customizing DB2 instance configuration:.......Success
Creating DB2 instances:.......Success
Registering DB2 licenses:.......Success
Configuring the DB2 Administration Server:.......Success
Updating global profile registry:.......Success

================================================== ==========

DB2 Setup log file started at: Fri Jan 30 13:50:45 CST 2004 CST
================================================== ==========

Operating system information: AIX 5.1
Product to install: DB2 Run-Time Client
Installation type: Typical
Selected Components:
Product Messages - en_US.iso88591
Base Client Support
DB2 LDAP Support
Code Page Conversion Tables - Unicode Support
Code Page Conversion Tables
Product Signature for Run-Time Client
Java Support
Languages:
Languages: EN
Target directory: /usr/opt/db2_08_01
Space required: 82 MB

New instances:
Instance name: db2inst1
Authentication: SERVER
Start instance on reboot: Yes
Instance user information:
User name: db2inst1
Group name: db2admin
Home directory: /home/db2inst1
Enabling Asynchronous I/O:.......Success
Checking license agreement acceptance:.......Success
Command to be run: "/usr/sbin/installp -acgqX -d '/mnt/db2/aix'
'db2_08_01.msg.en_US.iso88591'".
SUCCESSES
---------
Filesets listed in this section passed pre-installation verification
and will be installed.

Selected Filesets
-----------------
db2_08_01.msg.en_US.iso88591 8.1.1.0 # Product Messages -
en_US.iso...

<< End of Success Section >>
+-----------------------------------------------------------------------------+
Pre-installation Verification...
+-----------------------------------------------------------------------------+
Verifying selections...done
Verifying requisites...done
Results...

FILESET STATISTICS
------------------
1 Selected to be installed, of which:
1 Passed pre-installation verification
----
1 Total to be installed

+-----------------------------------------------------------------------------+
Installing Software...
+-----------------------------------------------------------------------------+

installp: APPLYING software for:
db2_08_01.msg.en_US.iso88591 8.1.1.0
.. . . . . << Copyright notice for db2_08_01.msg.en_US.iso88591 >> . .
.. . . . .

Licensed Materials - Property of IBM

5648B9700

(C) Copyright International Business Machines Corp. 1993, 2002.

All rights reserved.
US Government Users Restricted Rights - Use, duplication or disclosure
restricted by GSA ADP Schedule Contract with IBM Corp.
.. . . . . << End of copyright notice for db2_08_01.msg.en_US.iso88591
. . . .


Finished processing all filesets. (Total time: 5 secs).

+-----------------------------------------------------------------------------+
Summaries:
+-----------------------------------------------------------------------------+

Installation Summary
--------------------
Name Level Part Event
Result
-------------------------------------------------------------------------------
db2_08_01.msg.en_US.iso8859 8.1.1.0 USR APPLY
SUCCESS

Command to be run: "/usr/sbin/installp -acgqX -d '/mnt/db2/aix'
'db2_08_01.client'".
SUCCESSES
---------
Filesets listed in this section passed pre-installation verification
and will be installed.

Selected Filesets
-----------------
db2_08_01.client 8.1.1.0 # Base Client Support

<< End of Success Section >>
+-----------------------------------------------------------------------------+
Pre-installation Verification...
+-----------------------------------------------------------------------------+
Verifying selections...done
Verifying requisites...done
Results...

FILESET STATISTICS
------------------
1 Selected to be installed, of which:
1 Passed pre-installation verification
----
1 Total to be installed

+-----------------------------------------------------------------------------+
Installing Software...
+-----------------------------------------------------------------------------+

installp: APPLYING software for:
db2_08_01.client 8.1.1.0
.. . . . . << Copyright notice for db2_08_01.client >> . . . . . . .

Licensed Materials - Property of IBM

5648B9700

(C) Copyright International Business Machines Corp. 1993, 2002.

All rights reserved.
US Government Users Restricted Rights - Use, duplication or disclosure
restricted by GSA ADP Schedule Contract with IBM Corp.
.. . . . . << End of copyright notice for db2_08_01.client >>. . . .

Restoring files, please wait.
113 files restored.
114 files restored.
Finished processing all filesets. (Total time: 1 mins 52 secs).

+-----------------------------------------------------------------------------+
Summaries:
+-----------------------------------------------------------------------------+

Installation Summary
--------------------
Name Level Part Event
Result
-------------------------------------------------------------------------------
db2_08_01.client 8.1.1.0 USR APPLY
SUCCESS

Command to be run: "/usr/sbin/installp -acgqX -d '/mnt/db2/aix'
'db2_08_01.ldap'".
SUCCESSES
---------
Filesets listed in this section passed pre-installation verification
and will be installed.

Selected Filesets
-----------------
db2_08_01.ldap 8.1.1.0 # DB2 LDAP Support

<< End of Success Section >>
+-----------------------------------------------------------------------------+
Pre-installation Verification...
+-----------------------------------------------------------------------------+
Verifying selections...done
Verifying requisites...done
Results...

FILESET STATISTICS
------------------
1 Selected to be installed, of which:
1 Passed pre-installation verification
----
1 Total to be installed

+-----------------------------------------------------------------------------+
Installing Software...
+-----------------------------------------------------------------------------+

installp: APPLYING software for:
db2_08_01.ldap 8.1.1.0
.. . . . . << Copyright notice for db2_08_01.ldap >> . . . . . . .

Licensed Materials - Property of IBM

5648B9700

(C) Copyright International Business Machines Corp. 1993, 2002.

All rights reserved.
US Government Users Restricted Rights - Use, duplication or disclosure
restricted by GSA ADP Schedule Contract with IBM Corp.
.. . . . . << End of copyright notice for db2_08_01.ldap >>. . . .

Finished processing all filesets. (Total time: 2 secs).

+-----------------------------------------------------------------------------+
Summaries:
+-----------------------------------------------------------------------------+

Installation Summary
--------------------
Name Level Part Event
Result
-------------------------------------------------------------------------------
db2_08_01.ldap 8.1.1.0 USR APPLY
SUCCESS

Command to be run: "/usr/sbin/installp -acgqX -d '/mnt/db2/aix'
'db2_08_01.cnvucs'".
SUCCESSES
---------
Filesets listed in this section passed pre-installation verification
and will be installed.

Selected Filesets
-----------------
db2_08_01.cnvucs 8.1.1.0 # Code Page Conversion
Tables ...

<< End of Success Section >>
+-----------------------------------------------------------------------------+
Pre-installation Verification...
+-----------------------------------------------------------------------------+
Verifying selections...done
Verifying requisites...done
Results...

FILESET STATISTICS
------------------
1 Selected to be installed, of which:
1 Passed pre-installation verification
----
1 Total to be installed

+-----------------------------------------------------------------------------+
Installing Software...
+-----------------------------------------------------------------------------+

installp: APPLYING software for:
db2_08_01.cnvucs 8.1.1.0
.. . . . . << Copyright notice for db2_08_01.cnvucs >> . . . . . . .

Licensed Materials - Property of IBM

5648B9700

(C) Copyright International Business Machines Corp. 1993, 2002.

All rights reserved.
US Government Users Restricted Rights - Use, duplication or disclosure
restricted by GSA ADP Schedule Contract with IBM Corp.
.. . . . . << End of copyright notice for db2_08_01.cnvucs >>. . . .

Finished processing all filesets. (Total time: 2 secs).

+-----------------------------------------------------------------------------+
Summaries:
+-----------------------------------------------------------------------------+

Installation Summary
--------------------
Name Level Part Event
Result
-------------------------------------------------------------------------------
db2_08_01.cnvucs 8.1.1.0 USR APPLY
SUCCESS

Command to be run: "/usr/sbin/installp -acgqX -d '/mnt/db2/aix'
'db2_08_01.conv'".
SUCCESSES
---------
Filesets listed in this section passed pre-installation verification
and will be installed.

Selected Filesets
-----------------
db2_08_01.conv 8.1.1.0 # Code Page Conversion
Tables

<< End of Success Section >>
+-----------------------------------------------------------------------------+
Pre-installation Verification...
+-----------------------------------------------------------------------------+
Verifying selections...done
Verifying requisites...done
Results...

FILESET STATISTICS
------------------
1 Selected to be installed, of which:
1 Passed pre-installation verification
----
1 Total to be installed

+-----------------------------------------------------------------------------+
Installing Software...
+-----------------------------------------------------------------------------+

installp: APPLYING software for:
db2_08_01.conv 8.1.1.0
.. . . . . << Copyright notice for db2_08_01.conv >> . . . . . . .

Licensed Materials - Property of IBM

5648B9700

(C) Copyright International Business Machines Corp. 1993, 2002.

All rights reserved.
US Government Users Restricted Rights - Use, duplication or disclosure
restricted by GSA ADP Schedule Contract with IBM Corp.
.. . . . . << End of copyright notice for db2_08_01.conv >>. . . .

Finished processing all filesets. (Total time: 5 secs).

+-----------------------------------------------------------------------------+
Summaries:
+-----------------------------------------------------------------------------+

Installation Summary
--------------------
Name Level Part Event
Result
-------------------------------------------------------------------------------
db2_08_01.conv 8.1.1.0 USR APPLY
SUCCESS

Command to be run: "/usr/sbin/installp -acgqX -d '/mnt/db2/aix'
'db2_08_01.rtsg'".
SUCCESSES
---------
Filesets listed in this section passed pre-installation verification
and will be installed.

Selected Filesets
-----------------
db2_08_01.rtsg 8.1.1.0 # Product Signature for
Run-Ti...

<< End of Success Section >>
+-----------------------------------------------------------------------------+
Pre-installation Verification...
+-----------------------------------------------------------------------------+
Verifying selections...done
Verifying requisites...done
Results...

FILESET STATISTICS
------------------
1 Selected to be installed, of which:
1 Passed pre-installation verification
----
1 Total to be installed

+-----------------------------------------------------------------------------+
Installing Software...
+-----------------------------------------------------------------------------+

installp: APPLYING software for:
db2_08_01.rtsg 8.1.1.0
.. . . . . << Copyright notice for db2_08_01.rtsg >> . . . . . . .

Licensed Materials - Property of IBM

5648B9700

(C) Copyright International Business Machines Corp. 1993, 2002.

All rights reserved.
US Government Users Restricted Rights - Use, duplication or disclosure
restricted by GSA ADP Schedule Contract with IBM Corp.
.. . . . . << End of copyright notice for db2_08_01.rtsg >>. . . .

Finished processing all filesets. (Total time: 2 secs).

+-----------------------------------------------------------------------------+
Summaries:
+-----------------------------------------------------------------------------+

Installation Summary
--------------------
Name Level Part Event
Result
-------------------------------------------------------------------------------
db2_08_01.rtsg 8.1.1.0 USR APPLY
SUCCESS

Command to be run: "/usr/sbin/installp -acgqX -d '/mnt/db2/aix'
'db2_08_01.jdbc'".
SUCCESSES
---------
Filesets listed in this section passed pre-installation verification
and will be installed.

Selected Filesets
-----------------
db2_08_01.jdbc 8.1.1.0 # Java Support

<< End of Success Section >>
+-----------------------------------------------------------------------------+
Pre-installation Verification...
+-----------------------------------------------------------------------------+
Verifying selections...done
Verifying requisites...done
Results...

FILESET STATISTICS
------------------
1 Selected to be installed, of which:
1 Passed pre-installation verification
----
1 Total to be installed

+-----------------------------------------------------------------------------+
Installing Software...
+-----------------------------------------------------------------------------+

installp: APPLYING software for:
db2_08_01.jdbc 8.1.1.0
.. . . . . << Copyright notice for db2_08_01.jdbc >> . . . . . . .

Licensed Materials - Property of IBM

5648B9700

(C) Copyright International Business Machines Corp. 1993, 2002.

All rights reserved.
US Government Users Restricted Rights - Use, duplication or disclosure
restricted by GSA ADP Schedule Contract with IBM Corp.
.. . . . . << End of copyright notice for db2_08_01.jdbc >>. . . .

Finished processing all filesets. (Total time: 5 secs).

+-----------------------------------------------------------------------------+
Summaries:
+-----------------------------------------------------------------------------+

Installation Summary
--------------------
Name Level Part Event
Result
-------------------------------------------------------------------------------
db2_08_01.jdbc 8.1.1.0 USR APPLY
SUCCESS

Installing DB2 file sets:.......Success
Registering DB2 licenses:.......Success
Setting default global profile registry variables:.......Success
ERROR:Could not switch current DB2INSTANCE to "db2inst1". The return
code is
"-2029059916".

Initializing instance list:.......Success
Customizing DB2 instance configuration:.......Success
ERROR:DBI1122E Instance db2inst1 cannot be updated.

Explanation:

An attempt was made to update an instance. This instance cannot
be updated because:

o This "db2iupdt" command cannot be used to update this
instance.

o The instance is still active.

User Response:

Ensure that you are using the correct version of the "db2iupdt"
command. Also ensure that there are no db2 processes running at
the instance. Retry the command.

DBI1079I Output is saved in the log file /tmp/db2iupdt.log.18406.

Explanation:

All processed and failed operations have been saved into this log
file.

User Response:

Do not modify this file in any way. This file is for IBM
Technical Support reference.
ERROR:Unable to find a Database Manager configuration file within
"/home/db2inst1/sqllib/db2systm".

Creating DB2 instances:.......Success
Registering DB2 licenses:.......Success
Configuring the DB2 Administration Server:.......Success
Updating global profile registry:.......Success
************************************************** *********

Output from the log file in tmp:

DBI1122E Instance db2inst1 cannot be updated.

Explanation:

An attempt was made to update an instance. This instance cannot
be updated because:

o This "db2iupdt" command cannot be used to update this
instance.

o The instance is still active.

User Response:

Ensure that you are using the correct version of the "db2iupdt"
command. Also ensure that there are no db2 processes running at
the instance. Retry the command.

DBI1079I Output is saved in the log file /tmp/db2iupdt.log.18406.
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
mb12036 wrote:
All-

Having a problem installing a DB2 client on a machine running AIX
version 5.0. Client appeared to install one time succesfully, then
was uninstalled and a reinstall was attempted. For some reasons, it
does not complete the reinstall. See the status report from the GUI
installer at the end of this note. Errors are towards the bottom.
Everything installed in /usr/opt for DB2 but the sqllib folder that is
supposed to be created in the home directory of the instance ownder is
not installed (in our case the instance ownder is db2inst1). Have
tried installing DB2 with the user db2inst1 already existing and not.
Same error seems to appear. The key errors from the output below
appear to be:

ERROR:Could not switch current DB2INSTANCE to "db2inst1". The return
code is
"-2029059916".
ERROR:DBI1122E Instance db2inst1 cannot be updated.


Most likely, when you uninstalled, you removed the ~db2inst1/sqllib via
rm -rf, rather than via db2idrop. There are crumbs still sticking
around in your system.

Install the product, don't bother with the instance. Run
/usr/opt/db2_08_01/instance/db2ilist (as root). If it shows db2inst1
in the list, this is your problem. The solution is to recreate the
~db2inst1/sqllib directory (just use mkdir), then try db2idrop. Once
the instance is properly dropped, you can use db2isetup (also in the
..../instance directory) to recreate the instance.

Hope this helps,
Nov 12 '05 #2

P: n/a
Works!! Thanks for your help!

Darin McBride <dm******@naboo.to.org.no.spam.for.me> wrote in message news:<ATzSb.343928$ts4.276567@pd7tw3no>...
mb12036 wrote:
All-

Having a problem installing a DB2 client on a machine running AIX
version 5.0. Client appeared to install one time succesfully, then
was uninstalled and a reinstall was attempted. For some reasons, it
does not complete the reinstall. See the status report from the GUI
installer at the end of this note. Errors are towards the bottom.
Everything installed in /usr/opt for DB2 but the sqllib folder that is
supposed to be created in the home directory of the instance ownder is
not installed (in our case the instance ownder is db2inst1). Have
tried installing DB2 with the user db2inst1 already existing and not.
Same error seems to appear. The key errors from the output below
appear to be:

ERROR:Could not switch current DB2INSTANCE to "db2inst1". The return
code is
"-2029059916".
ERROR:DBI1122E Instance db2inst1 cannot be updated.


Most likely, when you uninstalled, you removed the ~db2inst1/sqllib via
rm -rf, rather than via db2idrop. There are crumbs still sticking
around in your system.

Install the product, don't bother with the instance. Run
/usr/opt/db2_08_01/instance/db2ilist (as root). If it shows db2inst1
in the list, this is your problem. The solution is to recreate the
~db2inst1/sqllib directory (just use mkdir), then try db2idrop. Once
the instance is properly dropped, you can use db2isetup (also in the
.../instance directory) to recreate the instance.

Hope this helps,

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.