db2pd API

[andyw]

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.

[Serge Rielau]

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

[andyw]

On 2¿ù19ÀÏ, ¿ÀÀü10½Ã51ºÐ, Serge Rielau <[e-mail]:

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.

[Serge Rielau]

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

[t3chn0n3rd]

On Feb 19, 5:33*am, Serge Rielau <[e-mail]:

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

[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

[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

[stefan.albert]

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)