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

db2pd API

P: n/a
hi all

I'm trying to make the application which use a db2pd facility.

so, I am looking for db2pd api.

where can i find db2pd api ?

thanks for advance.
Feb 19 '08 #1
Share this Question
Share on Google+
7 Replies


P: n/a
andyw wrote:
I'm trying to make the application which use a db2pd facility.
so, I am looking for db2pd api.
where can i find db2pd api ?
Some of the db2pd capabilities can be access through SQL. Take a look at
the "administrative routines and views" section in the InfoCenter.

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Feb 19 '08 #2

P: n/a
On 2월19일, 오전10시51분, Serge Rielau <srie...@ca.ibm.comwrote:
andyw wrote:
I'm trying to make the application which use a db2pd facility.
so, I am looking for db2pd api.
where can i find db2pd api ?

Some of the db2pd capabilities can be access through SQL. Take a look at
the "administrative routines and views" section in the InfoCenter.

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
thanks for your advice.

I checked "administrative routines and views" out.

but, i got two problem.

1. "administrative routines and views" looks like only for DB2 9.x. my
application using db2pd capacility should support DB2 8.x ~ 9.x

2. db2pd should access memory of DB2, so no overload DB2. but
accessing through SQL should overload DB2.

Feb 19 '08 #3

P: n/a
andyw wrote:
1. "administrative routines and views" looks like only for DB2 9.x. my
application using db2pd capacility should support DB2 8.x ~ 9.x
The number of functions was indeed increased in DB2 9/9.5.
Many of them do exist in DB2 8.2 however, even if they ra enot grouped
as such in the InformationCenter.
2. db2pd should access memory of DB2, so no overload DB2. but
accessing through SQL should overload DB2.
Overload is such a strong word.
Would you mind telling us what yuou are trying to achieve?
Do you represent a tools vendor? If so, are you an IBM Partner?
You would not be the first partner getting acccess to APIs not part of
the InformationCenter. Just ask...

BTW, itGain parses db2pd output.

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Feb 19 '08 #4

P: n/a
On Feb 19, 5:33*am, Serge Rielau <srie...@ca.ibm.comwrote:
andyw wrote:
1. "administrative routines and views" looks like only for DB2 9.x. my
application using db2pd capacility should support DB2 8.x ~ 9.x

The number of functions was indeed increased in DB2 9/9.5.
Many of them do exist in DB2 8.2 however, even if they ra enot grouped
as such in the InformationCenter.
2. db2pd should access memory of DB2, so no overload DB2. but
accessing through SQL should overload DB2.

Overload is such a strong word.
Would you mind telling us what yuou are trying to achieve?
Do you represent a tools vendor? If so, are you an IBM Partner?
You would not be the first partner getting acccess to APIs not part of
the InformationCenter. Just ask...

BTW, itGain parses db2pd output.

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Yes I know IBM really supports DB2 well
Feb 19 '08 #5

P: n/a
Udo
Yes I know IBM really supports DB2 well

Hey - We are not IBM ! :-)

Regards
Udo

--
Speedgain for DB2 - The DB2 Monitor
http://www.itgain.de/en/produkte/speedgain.html

Feb 19 '08 #6

P: n/a
Udo
Do you represent a tools vendor? If so, are you an IBM Partner?
You would not be the first partner getting acccess to APIs not part of
the InformationCenter. Just ask...
Serge,

we already met one of the db2pd guys and he refused to provide an API.
The current db2pd implementation is a big monolith. It interprets the
shared memory itself.
Regards
Udo

--
Speedgain for DB2 - The DB2 Monitor
http://www.itgain.de/en/produkte/speedgain.html
Feb 19 '08 #7

P: n/a
anyway - there IS a file : libdb2pdapi.a
but I can't find any docs for it...
may be its used "internally" by db2pd ?
And parsing the output is currently the only method (which I know)
Feb 20 '08 #8

This discussion thread is closed

Replies have been disabled for this discussion.