SQL1390C during V8.2 installation

Miriam Goodwin

unread,

Sep 2, 2004, 4:28:42 PM9/2/04

to

During DB2 UDB ESE V8.2 installation on Windows and following installation
after a reboot, I received the following error message:

SQL1390C The environment variable DB2INSTANCE is not defined or is invalid.

I checked the Windows system environment variables and can see that
DB2INSTANCE is set to DB2.

Garfield Lewis

unread,

Sep 7, 2004, 12:37:38 PM9/7/04

to

Hi Miriam,

Could you provide some more information? Is this an upgrade? Where is the
message coming from (ie. is it a popup from systray)? If you run
db2ilist.exe does the instance actaully exist?

--
Garfield A. Lewis
DB2 UDB Development,
IBM Canada Laboratory

"Miriam Goodwin" <mir...@us.ibm.com> wrote in message
news:ch7vpo$619o$1...@news.boulder.ibm.com...

Craig Tobias

unread,

Sep 8, 2004, 11:16:35 AM9/8/04

to

Sounds like it is coming from the db2systray application, perhaps the
instance parameter passed to the systray is incorrect.

You can clean this up by running "db2systray -clean" from the CLP. This
will remove the db2systray registry entries from the RUN key (which will
prevent db2systray from starting when your system starts). To get the
db2systray icon back just type

"db2systray <instance-name>"

You can then re-enable the auto start option by right clicking the systray
icon and selecting the "Launch Tool at Startup" option.

This should solve your problem, but it doesn't explain why db2systray is
starting against an invalid instance.

If you open up the registry to...

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Run

you will see entries for db2systray (one per DB2 instance that is cofigured
to start at boot time).

From this list you will be able to see the instance-name parameter that
db2systray was configured to start.

You will see an entry similar to one of these...

db2systray.exe
db2systray.exe DB2

The first entry says to start the default instance (whatever your
DB2INSTANCE env. var is set to).
The second entry says to start db2systray for instance "DB2".

What do your entries read?

"Garfield Lewis" <gal...@SPAM-NO-MOREca.ibm.com> wrote in message
news:chko4n$1vv8$1...@news.boulder.ibm.com...

nchan...@yahoo.com

unread,

Oct 21, 2005, 11:16:35 AM10/21/05

to

after using db2systray -clean
it worked perfectly fine

thank you

pul...@gmail.com

unread,

Feb 3, 2006, 12:12:36 PM2/3/06

to

I am getting the same error message when I go to the First Steps menu and create a new database.

I tried: db2systray -clean as well as just db2systray.

What else can I try, I want to get this install setup so I can start testing stored procs before moving them to production servers.

Thanks in advance for your help and suggestions

klaus....@haller-software.at

unread,

Mar 22, 2006, 2:41:15 PM3/22/06

to

Hi Miriam,

i had the same problem installing the new DB2Express on WinXP-Pro.

I found a solution described in the logfile db2.log:

1.) Open a db2 command window and you are somewhere like \sqllib\bin

2.) type "db2icrt DB2" for manually creating an DB2-Instance

then everything works well.

Best Regards

Klaus Haller

na...@inbox.com

unread,

Jun 20, 2006, 8:27:58 AM6/20/06

to

Hi all,

Iam facing the same problem " SQL1390C The environment variable DB2INSTANCE i s not defined or is invalid" , we installaed DB2 successfully and even we set DB2INSTANCE and its showing up in environment.....but still when I tried to start the database.

We tried to bring up the database in order to bring up the SAP.

Please suggest me any tips to resolve this issue.

thanks in advance
Nara

Garfield Lewis

unread,

Jun 22, 2006, 9:35:53 AM6/22/06

to

In what context are you seeing this error? What command are you running?
What OS? Can you get a trace?

--
Garfield A. Lewis
DB2 UDB Development,
IBM Canada Laboratory

<na...@inbox.com> wrote in message
news:2128173752.1150806509163.JavaMail.wassrvr@ltsgwas010.sby.ibm.com...

andrea....@gmail.com

unread,

Nov 1, 2006, 1:41:32 PM11/1/06

to

Hello,
I'm having the same problem but i can't resolve with yours tips. I've installed DB2 Enterprise server edition but the installation hasn't complete succefully. Anyway, i've the DB2 installed into my machine but itsn't work due to "SQL1390C The environment variable DB2INSTANCE i s not defined or is invalid".
I've WinXP and the environment variable DB2INSTANCE is set to DB2.

Can you help me, pls?
thank you in advance,
andrea

Gert van der Kooij

unread,

Nov 2, 2006, 5:31:25 AM11/2/06

to

In article
<516993039.1162406525...@ltsgwas010.sby.ibm.com>,
andrea....@gmail.com says...

Can you run db2ilist to check if the DB2 instance was created?

Barm...@bcsberlin.de

unread,

Nov 5, 2006, 12:25:40 AM11/5/06

to

Hi DB2 community,
i have got the same problem:
OP: MS Server 2003 Standard Edition
DB2: DB2 8.2 Enterprise Server Edition

Suggestion of "Klaus.Haller":
db2systray -clean
db2icrt DB2
just works fine, however after reeboot it still says "Service could not be started"

PS: When I install the same database on Win XP SP2 all works fine.
But XP is not sufficient because i intent to install DB2 Content Manager
Rgds Uli

Barm...@bcsberlin.de

unread,

Nov 5, 2006, 1:04:46 AM11/5/06

to

One hour later I found out, DB2DAS00 could not be started, - recon we will need it to create a database.
LG Uli

Barm...@bcsberlin.de

unread,

Nov 24, 2006, 5:06:19 AM11/24/06

to

Barm...@bcsberlin.de schrieb:

Barm...@bcsberlin.de

unread,

Nov 24, 2006, 5:08:29 AM11/24/06

to

Barm...@bcsberlin.de schrieb:

> One hour later I found out, DB2DAS00 could not be started, - recon we will need it to create a database.
> LG Uli

The latest IBM DB2 Fixpack solved the Problem
FP13_WR21371_ESE.exe

LG Uli