By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,886 Members | 1,123 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,886 IT Pros & Developers. It's quick & easy.

Is this an Invalid option? | db2pd -apinfo

P: n/a
Anybody with similar experience?

Thx U
Shree.
Nov 13 '08 #1
Share this Question
Share on Google+
5 Replies


P: n/a
On Nov 13, 9:51*am, Shree <shree...@gmail.comwrote:
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.
Nov 13 '08 #2

P: n/a
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".
>
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.
Nov 13 '08 #3

P: n/a
On Nov 13, 2:26*pm, Shree <shree...@gmail.comwrote:
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.
Nov 13 '08 #4

P: n/a
On Nov 13, 7:35*pm, 4.s...@mail.ru wrote:
On Nov 13, 2:26*pm, Shree <shree...@gmail.comwrote:
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.
Nov 15 '08 #5

P: n/a

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:
On Nov 13, 7:35*pm, 4.s...@mail.ru wrote:
On Nov 13, 2:26*pm, Shree <shree...@gmail.comwrote:
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.
Nov 16 '08 #6

This discussion thread is closed

Replies have been disabled for this discussion.