Is this an Invalid option? | db2pd -apinfo

Anybody with similar experience?

Thx U
Shree.

On Nov 13, 9:51*am, Shree <shree...@gmail.comwrote:

Quote:

Anybody with similar experience?
>
Thx U
Shree.

db2pd -db your_db -apinfo
should be valid since v9.1.5 or v9.5.1
Which db2 version and fixpack do you use?

Sincerely,
Mark B.

DB21085I Instance "db2inst4" uses "64" bits and DB2 code release
"SQL09050"
with level identifier "03010107".
Informational tokens are "DB2 v9.5.0.0", "s071001", "LINUXAMD6495",
and Fix
Pack "0".
Product is installed at "/opt/ibm/db2/V9.5".

Quote:

>
db2pd -db your_db -apinfo
should be valid since v9.1.5 or v9.5.1
Which db2 version and fixpack do you use?
>
Sincerely,
Mark B.

On Nov 13, 2:26*pm, Shree <shree...@gmail.comwrote:

Quote:

DB21085I *Instance "db2inst4" uses "64" bits and DB2 code release
"SQL09050"
with level identifier "03010107".
Informational tokens are "DB2 v9.5.0.0", "s071001", "LINUXAMD6495",
and Fix
Pack "0".
Product is installed at "/opt/ibm/db2/V9.5".
>

So you have to apply at least FP1 (and it's better - the latest FP2a)
and you will get this option of db2pd.

On Nov 13, 7:35*pm, 4.s...@mail.ru wrote:

Quote:

On Nov 13, 2:26*pm, Shree <shree...@gmail.comwrote:
>

Quote:

DB21085I *Instance "db2inst4" uses "64" bits and DB2 code release
"SQL09050"
with level identifier "03010107".
Informational tokens are "DB2 v9.5.0.0", "s071001", "LINUXAMD6495",
and Fix
Pack "0".
Product is installed at "/opt/ibm/db2/V9.5".

>
So you have to apply at least FP1 (and it's better - the latest FP2a)
and you will get this option of db2pd.

Performance of the WAS/DB was not upto the expectations. We have been
experiencing some out of the body performance degradation when we
applied FP1..did not try FP2, so far. Anybody with similar
experiences?????

Regards,
Shree.

Hi Shree,

apinfo works only if u are connected to the database.
so try this

db2 "connect to db"
db2 -apinfo -db dbname

thx
Sivaswami Jeganathan
------------------------------------------------------------------------------------------------------------------------
On Nov 15, 3:55*am, Shree <shree...@gmail.comwrote:

Quote:

On Nov 13, 7:35*pm, 4.s...@mail.ru wrote:
>

Quote:

On Nov 13, 2:26*pm, Shree <shree...@gmail.comwrote:

>

Quote:

DB21085I *Instance "db2inst4" uses "64" bits and DB2 code release
"SQL09050"
with level identifier "03010107".
Informational tokens are "DB2 v9.5.0.0", "s071001", "LINUXAMD6495",
and Fix
Pack "0".
Product is installed at "/opt/ibm/db2/V9.5".

>

Quote:

So you have to apply at least FP1 (and it's better - the latest FP2a)
and you will get this option of db2pd.

>
Performance of the WAS/DB was not upto the expectations. We have been
experiencing some out of the body performance degradation when we
applied FP1..did not try FP2, so far. Anybody with similar
experiences?????
>
Regards,
Shree.

Is this an Invalid option? | db2pd -apinfo

re: Is this an Invalid option? | db2pd -apinfo

re: Is this an Invalid option? | db2pd -apinfo

re: Is this an Invalid option? | db2pd -apinfo

re: Is this an Invalid option? | db2pd -apinfo

re: Is this an Invalid option? | db2pd -apinfo

Similar DB2 Database bytes

/bytes/development

/bytes/it

/bytes/about