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]

Re: db2pd API

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 "administra tive routines and views" section in the InfoCenter.

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

[andyw]

Re: db2pd API

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 "administra tive routines and views" section in the InfoCenter.
>
Cheers
Serge
>
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

thanks for your advice.

I checked "administra tive routines and views" out.

but, i got two problem.

1. "administra tive 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]

Re: db2pd API

andyw wrote:

1. "administra tive 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 InformationCent er.

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 InformationCent er. Just ask...

BTW, itGain parses db2pd output.

Cheers
Serge



--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

[t3chn0n3rd]

Re: db2pd API

On Feb 19, 5:33 am, Serge Rielau <srie...@ca.ibm .comwrote:

andyw wrote:

1. "administra tive 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 InformationCent er.
>

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 InformationCent er. 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]

Re: db2pd API

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]

Re: db2pd API

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 InformationCent er. 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]

Re: db2pd API

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)