Prev: SQL1091C The release number of the database is not valid. SQLSTATE=08004
Next: [IBM][JDBC Driver] CLI0601E
From: Knut Stolze on 12 Jan 2007 04:37
xiaoning.sunx(a)gmail.com wrote:

>
> Knut Stolze wrote:
>> xiaoning.sunx(a)gmail.com wrote:
>>
>> > after download and gzip, tar, i had used ./db2setup to lauch the
>> > procedure of installation, no problem.
>>
>> What exactly does the installation log show?
>
> There were not problems with the procedure of installation.

Given that your environment is _not_ properly set up, and also given that
you don't provide us the details of the installation log (for example),
it's hard to say anything about this issue. So all we can do is guessing.

>> Have you set up the profile for db2inst1?
>> How exactly did you start DB2?
> I have done: db2iupdt
> db2istrt
> with the db2inst1: ./db2admin start
> and I have created the base sample
> and I can see it on SQL: ./db2


Since you are using "./" in front of "db2", I assume that you are executing
this from the sqllib/bin/ directory, correct? Isn't the "db2" executable
found in your PATH? If not, then your environment/instance is
_definitively not_ set up correctly. Which brings me back to this question
that you have not yet answered:

>> Have you set up the profile for db2inst1?


> but the probleme is: when I try to start ./db2cc with db2inst1 I got an
> error: db2javit not found

Assuming that I'm right and your PATH is not set to include the DB2 instance
directories because you did not source ~/sqllib/db2profile, I'm not
surprised at all about this error.

Note that DB2 will give you a warning if it cannot modify your .profile to
include the sourcing of ~/sqllib/db2profile. Hence, we are back to the
installation log which will show you this detail as well if you ignored it
in the db2setup output.

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany
From: xiaoning.sunx on 12 Jan 2007 06:00
Hi,

Where are the logs files for DB2 ?
If I find the log, I will send it to you.
I didn't find the directory.
Thank you for your help.

Knut Stolze wrote:
> xiaoning.sunx(a)gmail.com wrote:
>
> >
> > Knut Stolze wrote:
> >> xiaoning.sunx(a)gmail.com wrote:
> >>
> >> > after download and gzip, tar, i had used ./db2setup to lauch the
> >> > procedure of installation, no problem.
> >>
> >> What exactly does the installation log show?
> >
> > There were not problems with the procedure of installation.
>
> Given that your environment is _not_ properly set up, and also given that
> you don't provide us the details of the installation log (for example),
> it's hard to say anything about this issue. So all we can do is guessing.
>
> >> Have you set up the profile for db2inst1?
> >> How exactly did you start DB2?
> > I have done: db2iupdt
> > db2istrt
> > with the db2inst1: ./db2admin start
> > and I have created the base sample
> > and I can see it on SQL: ./db2
>
>
> Since you are using "./" in front of "db2", I assume that you are executing
> this from the sqllib/bin/ directory, correct? Isn't the "db2" executable
> found in your PATH? If not, then your environment/instance is
> _definitively not_ set up correctly. Which brings me back to this question
> that you have not yet answered:
>
> >> Have you set up the profile for db2inst1?
>
>
> > but the probleme is: when I try to start ./db2cc with db2inst1 I got an
> > error: db2javit not found
>
> Assuming that I'm right and your PATH is not set to include the DB2 instance
> directories because you did not source ~/sqllib/db2profile, I'm not
> surprised at all about this error.
>
> Note that DB2 will give you a warning if it cannot modify your .profile to
> include the sourcing of ~/sqllib/db2profile. Hence, we are back to the
> installation log which will show you this detail as well if you ignored it
> in the db2setup output.
>
> --
> Knut Stolze
> DB2 z/OS Utilities Development
> IBM Germany

From: Knut Stolze on 12 Jan 2007 06:10
xiaoning.sunx(a)gmail.com wrote:

> Hi,
>
> Where are the logs files for DB2 ?
> If I find the log, I will send it to you.
> I didn't find the directory.

I suggest that you read the respective sections about installation in the
manuals.

>> Since you are using "./" in front of "db2", I assume that you are
>> executing
>> this from the sqllib/bin/ directory, correct? Isn't the "db2" executable
>> found in your PATH? If not, then your environment/instance is
>> _definitively not_ set up correctly. Which brings me back to this
>> question that you have not yet answered:
>>
>> >> Have you set up the profile for db2inst1?
>>
>>
>> > but the probleme is: when I try to start ./db2cc with db2inst1 I got an
>> > error: db2javit not found
>>
>> Assuming that I'm right and your PATH is not set to include the DB2
>> instance directories because you did not source ~/sqllib/db2profile, I'm
>> not surprised at all about this error.
>>
>> Note that DB2 will give you a warning if it cannot modify your .profile
>> to
>> include the sourcing of ~/sqllib/db2profile. Hence, we are back to the
>> installation log which will show you this detail as well if you ignored
>> it in the db2setup output.

How about the points I mentioned here? Have you verified those?

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany
From: xiaoning.sunx on 12 Jan 2007 06:28
Yes I have done those points: ./db2profile loggin as an instance
but now I have a new problem: I cannot execut ./db2admin start , it
awnsers that the DAS encoutered an error when trying to execut this
command.
When I am logged as an instance. And this morning, before doing this
../db2profile command, I was still able to do this.
Bst rgrds.

Knut Stolze wrote:
> xiaoning.sunx(a)gmail.com wrote:
>
> > Hi,
> >
> > Where are the logs files for DB2 ?
> > If I find the log, I will send it to you.
> > I didn't find the directory.
>
> I suggest that you read the respective sections about installation in the
> manuals.
>
> >> Since you are using "./" in front of "db2", I assume that you are
> >> executing
> >> this from the sqllib/bin/ directory, correct? Isn't the "db2" executable
> >> found in your PATH? If not, then your environment/instance is
> >> _definitively not_ set up correctly. Which brings me back to this
> >> question that you have not yet answered:
> >>
> >> >> Have you set up the profile for db2inst1?
> >>
> >>
> >> > but the probleme is: when I try to start ./db2cc with db2inst1 I got an
> >> > error: db2javit not found
> >>
> >> Assuming that I'm right and your PATH is not set to include the DB2
> >> instance directories because you did not source ~/sqllib/db2profile, I'm
> >> not surprised at all about this error.
> >>
> >> Note that DB2 will give you a warning if it cannot modify your .profile
> >> to
> >> include the sourcing of ~/sqllib/db2profile. Hence, we are back to the
> >> installation log which will show you this detail as well if you ignored
> >> it in the db2setup output.
>
> How about the points I mentioned here? Have you verified those?
>
> --
> Knut Stolze
> DB2 z/OS Utilities Development
> IBM Germany

From: Darin McBride on 12 Jan 2007 16:32
xiaoning.sunx(a)gmail.com wrote:

> Yes I have done those points: ./db2profile loggin as an instance

No, the command is ". ~db2inst1/sqllib/db2profile" - note that there is a
space after the dot. And the ~db2inst1/sqllib/db2profile is the path to
your db2profile, which, if you're already in sqllib, could all just
be ". ./db2profile". But that dot-space is important.

> but now I have a new problem: I cannot execut ./db2admin start , it

Please stop using "./" in front of your DB2 commands. If your environment
is set up properly, you don't need it. If you get "command not found" when
skipping the "./", then your environment isn't set up, and we should
concentrate on getting your environment set up.

> awnsers that the DAS encoutered an error when trying to execut this
> command.
> When I am logged as an instance. And this morning, before doing this
> ./db2profile command, I was still able to do this.

First  |  Prev  |  Next  |  Last
Pages: 1 2 3 4
Prev: SQL1091C The release number of the database is not valid. SQLSTATE=08004
Next: [IBM][JDBC Driver] CLI0601E