473,387 Members | 1,766 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Installation error with DB@ Personal Edition v8.1

During the installation I get these error messages:
*****
SQL1390C The environment variable DB2Instance is not defined or is
invalid

An error ocured while loading the command "C:\Program
Files\IBM\SQLLIB\bin\db2.exe CREATE TOOLS CATALOG SYSTOOLS USE
EXISITING DATABASE DWCTRLDB FORCE" to initialize and\or migrate the DB2
tools catalog database. The return value is "5104".

DB29501E DB2 has detected an inconsistent environment. Please
investigate the following: "DB2Instance: -2029059916"

*****
I checked to see if my services are running and all but these two are
started: DB2Warehouse Server and DB2 JDBC Applet Server

I also updated all DB2 services to use my local account which is a
domain account with admin privs. on my machine

*****
from the set-up log:
1: Product to install: DB2 Personal Edition
Installation type: Custom
Target directory: C:\Program Files\IBM\SQLLIB
Space required: 0 MB

New instances:
Instance name: DB2
Start instance on reboot: Yes
TCP/IP configuration:
Service name: db2c_DB2
Port number: 50000
Instance user information:
User name: cbach
Domain: ASTRO

DB2 Administration server:
Instance user information:
User name: cbach
Domain: ASTRO

Warehouse control database:
Name: DWCTRLDB
Schema: IWH
Instance: DB2
Location: Local
User name: sa

DB2 tools catalog:
Name: DWCTRLDB
Schema: SYSTOOLS
Instance: DB2
Location: Local
User name: sa
1: Configuring DB2 JDBC Applet Service:.......Success
1: Configuring DB2 Security Service:.......Success
1: Configuring DB2 Governor Service:.......Success
1: Setting environment variables:.......Success
1: Initializing instance list:.......Success
1: ERROR:An error occurred while updating the logon information for the
DB2
Administration Server in the Service Control Manager. Please update the
service
manually with the user name "ASTRO\cbach". The return value is
"2415919251".

1: ERROR:sqloGetAccountSid : The RPC server is unavailable.
1: ERROR:One or more errors occurred while creating the DB2
Administration Server.
The DB2 Administration Server may not function properly. Please create
the DB2
Administration Server manually. If the problem persists please contact
your
technical service representative.

1: Creating the DB2 Administration Server:.......Failure
1: Customizing DB2 instance configuration:.......Success
1: Setting default global profile registry variables:.......Success
1: ERROR:An error occurred while creating the instance "DB2". The
return code is
"-1960". Create the instance manually using the command 'db2icrt'.

1: ERROR:An error occurred while configuring the instance "DB2".

1: Creating/migrating DB2 instances:.......Failure
1: Configuring Remote Command Service:.......Success
1: Building list of databases to create:.......Success
1: Registering DB2 licenses:.......Success
1: Configuring DB2 warehouse logger:.......Success
1: Configuring DB2 warehouse server:.......Success
1: ERROR:An unknown error has occurred. The text associated with the
error is
"INSTANCE DOES NOT EXIST.". If you require additional assistance please
contact
a technical service representative.

1: Configuring DB2 for use with Informix data sources:.......Failure
1: ERROR:Could not switch current DB2INSTANCE to "DB2". The return code
is
"-2029059916".

1: ERROR:Could not switch current DB2INSTANCE to "DB2". The return code
is
"-2029059916".

1: ERROR:SQL1390C The environment variable DB2INSTANCE is not defined
or is invalid.
1: ERROR:An error occurred while configuring the database "DWCTRLDB".

1: Creating DB2 databases:.......Failure
1: Configuring the DB2 Administration Server:.......Success
1: Updating global profile registry:.......Success
1: ERROR:Could not switch current DB2INSTANCE to "DB2". The return code
is
"-2029059916".

1: ERROR:An error occurred while launching the command "C:\Program
Files\IBM\SQLLIB\bin\db2.exe CREATE TOOLS CATALOG SYSTOOLS USE EXISTING

DATABASE DWCTRLDB FORCE" to initialize and/or migrate the DB2 tools
catalog
database. The return value is "5104".

1: Creating DB2 tools catalog:.......Failure
1: Updating services file entries for DB2 Warehouse
Manager:.......Success
1: ERROR:Could not switch current DB2INSTANCE to "DB2". The return code
is
"-2029059916".

1: ERROR:An error occurred while launching the command
"C:\PROGRA~1\IBM\SQLLIB\bin\iwh2regi.exe 12 DWCTRLDB "IWH" sa ********
C:\PROGRA~1\IBM\SQLLIB\logging INSTALL" to initialize and/or migrate
the
information catalog. The return value is "5104".

1: Configuring the warehouse control database:.......Failure
1: Starting all DB2 services:.......Success
1: WARNING:A minor error occurred while installing "DB2 Personal
Edition" on this
computer. Some features may not function correctly.

1: Failed to start the up and running engine.
Action 14:28:41: SelfRegisterDllsCA.
Action 14:31:21: InstallHotfixCA.
Action 14:31:23: DeferredAppendWILogFileCA.
1: Install the DB2 documentation from the CD labeled "DB2 HTML
Documentation".
-

Can someone tell me what is going on PLEASE!!!! TIA

Nov 12 '05 #1
5 7793
Something I noticed in the log file - the first time I install DB2 - I
put in the incorrect username for the datawarehouse. Even though I
uninstalled the program and restarted my machine - then re-installed
DB2 -- AND even though the log date is the correct new install date --
it is still showing the datawarehouse login as the incorrect login -
even though I put in a correct login the second time around.

I went into services and put in the correct login but the services
still won't start.

I would like to know where this information is hidden on my machine so
this will not happen the next time around.

My operating system is Win XP - Thanks!

Nov 12 '05 #2
well - i want to thank everyone for the prompt replies on my problem
resolution. <yea right>

i finally figured out that for some reason - the install could not be
done under my domain account and so i created a local account - logged
into that account and installed db2, along with the sample databases.

i restarted my computer and logged back into my domain account - i can
get to the database but have to login in to the databases with the
local account to view anything. i tried to add the domain user thru
'authorities' - but it still gives me an error message.

again - thanks everyone! <NOT>

Nov 12 '05 #3
<az********@yahoo.com> wrote in message
news:11*********************@l41g2000cwc.googlegro ups.com...
well - i want to thank everyone for the prompt replies on my problem
resolution. <yea right>

i finally figured out that for some reason - the install could not be
done under my domain account and so i created a local account - logged
into that account and installed db2, along with the sample databases.

i restarted my computer and logged back into my domain account - i can
get to the database but have to login in to the databases with the
local account to view anything. i tried to add the domain user thru
'authorities' - but it still gives me an error message.

again - thanks everyone! <NOT>

I believe that if you go into Widows Services and change the startup owner
of the DB2 processes, then it will work with your domain account. You may
have add your domain account to the DB2 group, but I don't recall if I did
this or not when I had the same problem and got it to work.
Nov 12 '05 #4
Ian
az********@yahoo.com wrote:
well - i want to thank everyone for the prompt replies on my problem
resolution. <yea right>


Well, I guess you got what you paid for.

If you need urgent support for a problem, use your support contract, not
a usenet group.
Seriously, though, did you make sure the domain ID you told DB2 to use
meets the requirements (either belongs to *local* administrators group,
OR has the various operating system privileges assigned to it)?
Nov 12 '05 #5
in answer to both of your questions:

I went into services and changed it to run under my domain account -
still did not work.

my domain account has local admin on my computer...but for some reason
i was unable to install DB2 with this account.-- while my office mate
had no problem using his domain account (we are in the same domain)

Thanks for your replies!

Nov 12 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Thomas | last post by:
Hello, I received the error message below when i'm trying to install SQL Server 2000 standard edition into a Windows 2000 Professionale workstation. Error : Microsoft SQL server 2000...
4
by: vagrawal | last post by:
I'm trying to install "DB2 workgroup Edition" from "Dummies Test Engine DB2 UDB v7.1 evaluation copy" CD, which comes with DB2 fundamentals certification for Dummies for db2 certification exam 512....
19
by: Blair Adamache | last post by:
IBM is hosting a user focus session to get feedback on a new design concept for installing software products and maintenance. The information below gives a brief summary of the information about...
1
by: srihari | last post by:
Hai, I am trying to install IBM DB2 8.1 on Red Hat linux 8.0. My machine is Intel XEON 64bit. The installation went well except for the creation of tools catalog. When I tried to install the tools...
2
by: Ecohouse | last post by:
I am trying to install DB2 v8.2 Universal Database Express Edition on my standalone computer using Windows XP Home Version. Everytime I try to run the setup I receive an error message that my...
4
by: cboccio | last post by:
Hi everybody !! I am new in DB2 database word, and I am trying to install a DB2 Personal Edition in my notebook to study it, but I have some problems during the installation. I have the...
4
by: Maroon | last post by:
Hello all I want to install db2 universal Database Personal Edition in my Linux Fedora core 3. But the following error has occured. When i gave the following command for install -----> #...
1
by: QLD_AU | last post by:
Has anyone see the following error ? VS 2005 Installs ok, however the SQL Mobile Edition (part of a full install) fails with the following error ? With Thanks Jason
2
by: cjayp | last post by:
I have installed SQL Sever 2000 on my Windows XP Pro machine from the Enterprise Edition setup and it prompts you that only the client tools can be installed. I wanted to have a local database as...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.