Installation error with DB@ Personal Edition v8.1

azgoddess1@yahoo.com · *nix forums beginner Joined: 21 Feb 2005 Posts: 6

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!

Ian · *nix forums Guru Wannabe Joined: 02 Aug 2005 Posts: 262

azgoddess1@yahoo.com wrote:

Vincent M · *nix forums Guru Joined: 22 Feb 2005 Posts: 1332

<azgoddess1@yahoo.com> wrote in message
news:1109272887.928963.67140@l41g2000cwc.googlegroups.com...

azgoddess1@yahoo.com · *nix forums beginner Joined: 21 Feb 2005 Posts: 6

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>

azgoddess1@yahoo.com · *nix forums beginner Joined: 21 Feb 2005 Posts: 6

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!

azgoddess1@yahoo.com · *nix forums beginner Joined: 21 Feb 2005 Posts: 6

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

Google