Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / DB2 Topics / February 2005

Tip: Looking for answers? Try searching our database.

Installation error with DB@ Personal Edition v8.1

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
azgoddess1@yahoo.com - 21 Feb 2005 21:56 GMT
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
azgoddess1@yahoo.com - 22 Feb 2005 14:44 GMT
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 - 24 Feb 2005 19:19 GMT
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>
Mark A - 24 Feb 2005 19:34 GMT
> well - i want to thank everyone for the prompt replies on my problem
> resolution. <yea right>
[quoted text clipped - 9 lines]
>
> 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.
Ian - 25 Feb 2005 06:51 GMT
> 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)?
azgoddess1@yahoo.com - 25 Feb 2005 19:15 GMT
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!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.