invoking db2diag tool on win32 (UDB 8.1 version)

Gio Galma

how I can invoke the db2diag utility in a Windows environment?
in my D:\Program Files\IBM\SQLLIB\BIN directory I can see only
db2diag.dll, and it seems there isn't the command line version; which is
the DB2 tool that uses this dll, in order to analyze the db2diag.log?

thank you in advance for help (and please, excuse my bad english)
Jo
--
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG

Oct 9 '06 #1

situ

Gio Galma wrote:

how I can invoke the db2diag utility in a Windows environment?
in my D:\Program Files\IBM\SQLLIB\BIN directory I can see only
db2diag.dll, and it seems there isn't the command line version; which is
the DB2 tool that uses this dll, in order to analyze the db2diag.log?

thank you in advance for help (and please, excuse my bad english)
Jo
--
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG

actually diag file located in D:\Program Files\IBM\SQLLIB\DB2

and there is a utilty like

db2diag -g db=SAMPLE -o out.txt

check for other formats comes along with db2diag facility

Oct 9 '06 #2

Gio Galma

tank you Situ, but in the whole file system there isn't a db2diag.exe,
but there is only a db2diag.dll

actually diag file located in D:\Program Files\IBM\SQLLIB\DB2

and there is a utilty like

db2diag -g db=SAMPLE -o out.txt

check for other formats comes along with db2diag facility

--
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG

Oct 9 '06 #3

Knut Stolze

Gio Galma wrote:

>
tank you Situ, but in the whole file system there isn't a db2diag.exe,
but there is only a db2diag.dll

Have you opened a DB2 command window and simply tried to start "db2diag"?
It may be a batch file or something.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

Oct 10 '06 #4

Gio Galma

"Knut Stolze" <st****@de.ibm.comwrote in message
news:eg**********@lc03.rz.uni-jena.de

Have you opened a DB2 command window and simply tried to start "db2diag"?
It may be a batch file or something.

yes, it was the first thing I tried to do :(
I always work with command line tools


--
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG

Oct 10 '06 #5

Pierre Saint-Jacques

I believe that when you issue the db2diag command your working directory has
to be the dir where the file actually resides.
So, go to D:\Program Files\IBM\SQLLIB\DB2 as a prompt and then issue the
command.
By the way, if you save the db2diag.log file daily under a new name, the
command will also work on that name.
This other little tool is also very helpful:
db2diag -h
HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Gio Galma" <ga******@yahoo.ita écrit dans le message de news:
f2**********************************...mail gate.org...

"Knut Stolze" <st****@de.ibm.comwrote in message
news:eg**********@lc03.rz.uni-jena.de

>Have you opened a DB2 command window and simply tried to start "db2diag"?
It may be a batch file or something.

yes, it was the first thing I tried to do :(
I always work with command line tools


--
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG

Oct 11 '06 #6

Knut Stolze

Pierre Saint-Jacques wrote:

I believe that when you issue the db2diag command your working directory
has to be the dir where the file actually resides.
So, go to D:\Program Files\IBM\SQLLIB\DB2 as a prompt and then issue the
command.

That shouldn't be necessary if you have a DB2 command window open. Then the
PATH is appropriately set and the DB2 executables are found, regardless of
the current directory.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

Oct 11 '06 #7

Knut Stolze

Gio Galma wrote:

>Have you opened a DB2 command window and simply tried to start "db2diag"?
It may be a batch file or something.

yes, it was the first thing I tried to do :(
I always work with command line tools

In that case, I suspect that something with your installation is not in
order. What's the output of "db2level"? You may also want to install the
latest pixpak.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

Oct 11 '06 #8

Gio Galma

thank you, Knut.

the db2level output are (I have the same problem on two different
servers)

DB21085I Instance "DB2" uses "32" bits and DB2 code release "SQL08012"
with
level identifier "02030106".
Informational tokens are "DB2 v8.1.2.169", "s030508", "WR21318", and
FixPak
"2".
Product is installed at "C:\PROGRA~1\IBM\SQLLIB".

DB21085I Instance "DB2" uses "32" bits and DB2 code release "SQL08013"
with
level identifier "02030106".
Informational tokens are "DB2 v8.1.3.132", "s030728", "WR21324", and
FixPak
"3".
Product is installed at "C:\PROGRA~1\IBM\SQLLIB".

after executing db2level command, I tried again to run db2diag and I
obtained the usual:
'db2diag' is not recognized as an internal or external command,
operable program or batch file.

when I check my C:\PROGRA~1\IBM\SQLLIB\BIN directory, I find just a
db2diag.dll

thank you in advance

"Knut Stolze" <st****@de.ibm.comwrote in message
news:eg**********@lc03.rz.uni-jena.de

Gio Galma wrote:

Have you opened a DB2 command window and simply tried to start "db2diag"?
It may be a batch file or something.

yes, it was the first thing I tried to do :(
I always work with command line tools

In that case, I suspect that something with your installation is not in
order. What's the output of "db2level"? You may also want to install the
latest pixpak.

--
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG

Oct 11 '06 #9

Knut Stolze

Gio Galma wrote:

thank you, Knut.

the db2level output are (I have the same problem on two different
servers)

DB21085I Instance "DB2" uses "32" bits and DB2 code release "SQL08012"
with
level identifier "02030106".
Informational tokens are "DB2 v8.1.2.169", "s030508", "WR21318", and
FixPak
"2".
Product is installed at "C:\PROGRA~1\IBM\SQLLIB".

That really looks like V8. Have you tried to reinstall DB2, i.e. install
FP2 or FP3 again over the existing installation?

p.s: I don't use Windows (if I can avoid it), so I can't help a lot with
install issues.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

Oct 11 '06 #10

Pierre Saint-Jacques

I get you, but I was referring to the actual file.
The db2diag command will execute but mu experience (maybe something was
wrong in my set up!) was that I got an error accessing the file when not in
the working directory.
Puzzled, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Knut Stolze" <st****@de.ibm.coma écrit dans le message de news:
eg**********@lc03.rz.uni-jena.de...

Pierre Saint-Jacques wrote:

>I believe that when you issue the db2diag command your working directory
has to be the dir where the file actually resides.
So, go to D:\Program Files\IBM\SQLLIB\DB2 as a prompt and then issue the
command.

That shouldn't be necessary if you have a DB2 command window open. Then
the
PATH is appropriately set and the DB2 executables are found, regardless of
the current directory.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

Oct 11 '06 #11

Knut Stolze

Pierre Saint-Jacques wrote:

I get you, but I was referring to the actual file.
The db2diag command will execute but mu experience (maybe something was
wrong in my set up!) was that I got an error accessing the file when not
in the working directory.

Either way you don't have to be in a specific directory. The actual
file "db2diag.log" is found by "db2diag" using the DIAGPATH setting of your
DB2 instance's DBM CFG.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

Oct 11 '06 #12

Ian

Gio Galma wrote:

thank you, Knut.

the db2level output are (I have the same problem on two different
servers)

DB21085I Instance "DB2" uses "32" bits and DB2 code release "SQL08012"
with
level identifier "02030106".
Informational tokens are "DB2 v8.1.2.169", "s030508", "WR21318", and
FixPak
"2".
Product is installed at "C:\PROGRA~1\IBM\SQLLIB".

DB21085I Instance "DB2" uses "32" bits and DB2 code release "SQL08013"
with
level identifier "02030106".
Informational tokens are "DB2 v8.1.3.132", "s030728", "WR21324", and
FixPak
"3".
Product is installed at "C:\PROGRA~1\IBM\SQLLIB".

after executing db2level command, I tried again to run db2diag and I
obtained the usual:
'db2diag' is not recognized as an internal or external command,
operable program or batch file.

when I check my C:\PROGRA~1\IBM\SQLLIB\BIN directory, I find just a
db2diag.dll

The db2diag utility was released until Fixpack 7.

Oct 11 '06 #13

Knut Stolze

Ian wrote:

The db2diag utility was released until Fixpack 7.

That's it!!

I initially expected this myself, too. I had a look at the docs and
couldn't find the "7" (or some other number) on the left side. But I
accidentely looked at the V9 docs and not V8 - without noticing it. So I
thought it was available in FP2/3 already, which is not true:
http://publib.boulder.ibm.com/infoce...e/r0011728.htm ;-)

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

Oct 11 '06 #14

Gio Galma

thank you very much :)
"Knut Stolze" <st****@de.ibm.comwrote in message
news:eg**********@lc03.rz.uni-jena.de

Ian wrote:

The db2diag utility was released until Fixpack 7.

That's it!!

I initially expected this myself, too. I had a look at the docs and
couldn't find the "7" (or some other number) on the left side. But I
accidentely looked at the V9 docs and not V8 - without noticing it. So I
thought it was available in FP2/3 already, which is not true:
http://publib.boulder.ibm.com/infoce...e/r0011728.htm ;-)

--
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG

Oct 20 '06 #15