Is this an Invalid option? | db2pd -apinfo 
November 13th, 2008, 06:55 AM
| | | |
Anybody with similar experience?
Thx U
Shree. | 
November 13th, 2008, 10:05 AM
| | | | re: Is this an Invalid option? | db2pd -apinfo
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. | 
November 13th, 2008, 11:35 AM
| | | | re: Is this an Invalid option? | db2pd -apinfo
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.
| | 
November 13th, 2008, 02:45 PM
| | | | re: Is this an Invalid option? | db2pd -apinfo
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. | 
November 15th, 2008, 04:05 AM
| | | | re: Is this an Invalid option? | db2pd -apinfo
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. | 
November 16th, 2008, 06:55 AM
| | | | re: Is this an Invalid option? | db2pd -apinfo
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: 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.
| |  | | | | /bytes/about
We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights.
Get the best answers to your questions from over 225,662 network members.
|