472,326 Members | 1,539 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,326 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 7663
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...
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...
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...
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...
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...
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...
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...
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...
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...
0
by: tammygombez | last post by:
Hey fellow JavaFX developers, I'm currently working on a project that involves using a ComboBox in JavaFX, and I've run into a bit of an issue....
0
by: tammygombez | last post by:
Hey everyone! I've been researching gaming laptops lately, and I must say, they can get pretty expensive. However, I've come across some great...
0
by: concettolabs | last post by:
In today's business world, businesses are increasingly turning to PowerApps to develop custom business applications. PowerApps is a powerful tool...
0
by: teenabhardwaj | last post by:
How would one discover a valid source for learning news, comfort, and help for engineering designs? Covering through piles of books takes a lot of...
0
by: CD Tom | last post by:
This happens in runtime 2013 and 2016. When a report is run and then closed a toolbar shows up and the only way to get it to go away is to right...
0
by: CD Tom | last post by:
This only shows up in access runtime. When a user select a report from my report menu when they close the report they get a menu I've called Add-ins...
0
jalbright99669
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
0
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
0
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...

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.