473,734 Members | 2,724 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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\SQLLI B\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: "DB2Instanc e: -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\SQLLI B
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:.......Suc cess
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\cbac h". The return value is
"2415919251 ".

1: ERROR:sqloGetAc countSid : 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:.......F ailure
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:.......S uccess
1: Registering DB2 licenses:...... .Success
1: Configuring DB2 warehouse logger:.......S uccess
1: Configuring DB2 warehouse server:.......S uccess
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:.......S uccess
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\SQLLI B\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\IB M\SQLLIB\bin\iw h2regi.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: SelfRegisterDll sCA.
Action 14:31:21: InstallHotfixCA .
Action 14:31:23: DeferredAppendW ILogFileCA.
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 7822
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********@yah oo.com> wrote in message
news:11******** *************@l 41g2000cwc.goog legroups.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********@yaho o.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
3376
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 Standard Edition server components is not supported on this operating system. Only client components will be
4
5052
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. The following errors occured during installation of db2... Error during installation: C:\PROGRA~1\SQLLIB\bin\iwh2regi.exe 10 DWCTRLDB DWCTRLDB NULL 1252 EN : -1032. Error during installation: C:\PROGRA~1\SQLLIB\bin\iwh2regi.exe 12 DWCTRLDB...
19
3059
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 the session. If you are interested and feel that you are qualified, please send an e-mail to Karen Ball at kball@protocolusa.com. Or you can phone Sam Sellers or Flo Tassel at 800-615-9287. Protocol is a recruiting agency that IBM has hired to...
1
8100
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 catalog as a post installation task I get some java error. $ db2 CREATE TOOLS CATALOG SYSTOOLS USE EXISTING DATABASE TOOLSDB FORCE SQL22209N The DB2 Administration Server encountered an unexpected Java error on host "". I have jdk1.3 already...
2
1694
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 operating system is not compatible for this version. But in the readme file it says that this version supports Windows XP. So I would appreciate any help with this problem.
4
3554
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 following situation: - OS - Win XP Professional - HW has 192 MB Ram - Database - DB2 Personal Edition Version 8.1 Error:
4
5754
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 -----> # ./db2setup DBI1190I db2setup is preparing the DB2 Setup wizard which will guide you through the program setup process. Please wait.
1
7148
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
1885
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 well So what install should I have used to do so. Any information would greatly be appreciated.
0
8776
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9310
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9236
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8186
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6735
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6031
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4809
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3261
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2724
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.