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.

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

On 2¿ù19ÀÏ, ¿ÀÀü10½Ã51ºÐ, Serge Rielau <srie...@ca.ibm.com> wrote:
> 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.

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

On Feb 19, 5:33*am, Serge Rielau <srie...@ca.ibm.com> wrote:
> 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

> 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