Can't start db2

[Edward Kessinger]

I just installed db2 on Windows 98. The installation went through
without error as far as I can tell.

However, when I try to start db2 with db2start, I get the following
error message:

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

Does anyone know what this error is about?

Ed Kessinger

[Hari]

Go to 'Command Window' using 'Update dbm/db cfg' command, update the
instance variable db2instance which generally is db2 or whatever it is in
your case. Then try starting the database. For the exact syntax for the
above command check out the DB2 Amdministration Guide. Hope that helps.

Edward Kessinger <eke...@attglobal.net> wrote in message
news:38408243...@attglobal.net...

[Edward Kessinger]

Hari,

Thanks for your response.

I have set DBINSTANCE=DB2 in autoexec.bat, but I'm still getting the same
error.

Ed

Hari wrote:

> Please disregard the earlier message its totally incorrect sorry to
> misguide you...
>
> Here is the right thing to do to get your problem fixed.
>
> Click on Windows START -> RUN ->
>
> Type ' edit c:\autoexec.bat ' and press ENTER
>
> in this particular file you need to add the following statement...
>
> set DBINSTANCE=DB2
>
> Where DB2 is the instance name if it is different then you may point it
> to the same.
> This should fix your problem.
> Have fun. :-)
>
> In article <81sh6r$bev$1...@birch.prod.itd.earthlink.net>,

> Sent via Deja.com http://www.deja.com/
> Before you buy.

[Hari]

[Michael Holzer]

obviously a spelling error, the variable is called:

DB2INSTANCE

ys Mike

[Blair Kenneth Adamache]

You need DB2INSTANCE set to = DB2 (or whatever the name of your instance
is). Installation normally creates an instance called DB2. You can
create your own instances from the command prompt with the db2icrt
command. From the command prompt, you can see what DB2INSTANCE is set
to by typing:

db2set db2instance

I'm not sure about W98, but you can check this on NT from the Control
Panel:
--> System
--> Environment
--> System Variables

[Blair Kenneth Adamache]

The instance is set with db2set and db2icrt. The instance is not set with
update dbm cfg or update db cfg. All of these commands (db2icrt, db2set, db2
update dbm cfg, db2 update db cfg) are documented with syntax in the Command
Reference manual.

Hari wrote:

> Go to 'Command Window' using 'Update dbm/db cfg' command, update the
> instance variable db2instance which generally is db2 or whatever it is in
> your case. Then try starting the database. For the exact syntax for the
> above command check out the DB2 Amdministration Guide. Hope that helps.
>
> Edward Kessinger <eke...@attglobal.net> wrote in message
> news:38408243...@attglobal.net...

[dav...@ca.ibm.com]

Hi Ed,
Another helpful command maybe db2ilist, to display all the instance
names. We also ship db2 APIs for querying/dropping/creating/etc.
db2 instances, see the API Refr.

Hope this helps,
David.

[Edward Kessinger]

Hari,

I finally got DB2 to start.

First, I created a new DB2INSTANCE, in my case EDSDB2, using db2icrt. Then I
updated the autoexec.bat with DB2INSTANCE=EDSDB2, and when shutdown and came
back in and went into the command line processor, DB2 started!

Thanks for your help.

Ed

Hari wrote:

> Please disregard the earlier message its totally incorrect sorry to
> misguide you...
>
> Here is the right thing to do to get your problem fixed.
>
> Click on Windows START -> RUN ->
>
> Type ' edit c:\autoexec.bat ' and press ENTER
>
> in this particular file you need to add the following statement...
>
> set DBINSTANCE=DB2
>
> Where DB2 is the instance name if it is different then you may point it
> to the same.
> This should fix your problem.
> Have fun. :-)
>
> In article <81sh6r$bev$1...@birch.prod.itd.earthlink.net>,

> "Hari" <omy...@earthlink.net> wrote:
> > Go to 'Command Window' using 'Update dbm/db cfg' command, update the
> > instance variable db2instance which generally is db2 or whatever it is
> in
> > your case. Then try starting the database. For the exact syntax for
> the
> > above command check out the DB2 Amdministration Guide. Hope that
> helps.
> >
> > Edward Kessinger <eke...@attglobal.net> wrote in message
> > news:38408243...@attglobal.net...
> > > I just installed db2 on Windows 98. The installation went through
> > > without error as far as I can tell.
> > >
> > > However, when I try to start db2 with db2start, I get the following
> > > error message:
> > >
> > > SQL1390C The environment variable DB2INSTANCE is not defined or is
> > > invalid.
> > >
> > > Does anyone know what this error is about?
> > >
> > > Ed Kessinger
> > >
> >
> >
>

[Edward Kessinger]

Mike,

Thanks for your response. I misspelled the variable in my note. I meant
DB2INSTANCE.

Please see my response to Hari about how I finally got DB2 to start.

Ed

[Edward Kessinger]

Blair,

I took your suggestion and created a new DB2INSTANCE with db2icrt. I also had to
change my autoexec.bat file to say DB2INSTANCE=<new db2instance>. When I shutdown
Windows 98 and came back in to the command line processor, db2 started.

Ed

Blair Kenneth Adamache wrote:

> The instance is set with db2set and db2icrt. The instance is not set with
> update dbm cfg or update db cfg. All of these commands (db2icrt, db2set, db2
> update dbm cfg, db2 update db cfg) are documented with syntax in the Command
> Reference manual.
>

[Edward Kessinger]

David,

Thanks for the tip. Please see my note to Hari about how I got DB2 to start.

Ed

"dav...@torolab.ibm.com" wrote:

> Hi Ed,
> Another helpful command maybe db2ilist, to display all the instance
> names. We also ship db2 APIs for querying/dropping/creating/etc.
> db2 instances, see the API Refr.
>
> Hope this helps,
> David.
>

[Edward Kessinger]

Just as an addendum, when I created a new db2instance, edsdb2, a new
directory, edsdb2, was created on my C: drive.

So, I wonder if I needed a directory called DB2 initially?