473,911 Members | 5,861 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 7836
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
3383
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
5056
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
3066
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
8111
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
1707
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
3565
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
5757
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
7155
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
1891
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
10038
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
11349
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
11057
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
10541
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
8099
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
7250
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
5940
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
4776
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
4341
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.