Betr: [DB2-L] DB2PM_STAT_BUFFER

Ralph van Zagten

Betr: [DB2-L] DB2PM_STAT_BUFFER



José,


execute following query on de DB2 Catalog :

SELECT NAME, REMARKS
FROM SYSIBM.SYSCOLUMNS
WHERE TBNAME = 'DB2PM_STAT_BUFFER'
AND TBCREATOR = 'DB2PM'
ORDER BY COLNO
WITH UR
;

In our shop the column descriptions of the DB2PM tables are listed in de
SYSIBM.SYSCOLUMNS


Regards Ralph.


------------------------------------------------------------------------
De Belastingdienst gebruikt e-mail niet voor de uitwisseling van
vertrouwelijke informatie met de burger of voor de bekendmaking
van beslissingen. De Belastingdienst hanteert conventies voor het
gebruik van e-mail. Deze zijn te vinden op www.belastingdienst.nl.


_____________________________________________________________________
* IDUG EMEA * Prague, Czech Republic * 14-18 November 2011 * http://IDUG.ORG/EMEA *
* If you are going to attend only one conference this year, this is it! *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Thanikachalam "Billy" Sundarrajan

Re: DB2PM_STAT_BUFFER
(in response to Ralph van Zagten)
The DGOSBBUF member in RKO2SAMP dataset should have the doc.

Cheers.




________________________________
From: Jose Antonio <[login to unmask email]>
To: [login to unmask email]
Sent: Thu, December 16, 2010 4:14:08 AM
Subject: [DB2-L] DB2PM_STAT_BUFFER

Hi list!

Does anyone have the description of every DB2PM_STAT_BUFFER columns?
I have tried everything but I couldn't find it!!!!

Thanks a lot!

__________________________
José A Morcillo Valenciano
Tfno.: +34 965 90 51 43
Arquitectura y Seguridad TI
Administración Base Datos
Caja Mediterráneo
__________________________



Este correo electronico es confidencial. Si lo ha recibido por error, por favor
contacte con el remitente y destruya su contenido. Toda la informacion relativa
a
la Proteccion de Datos de Caracter Personal, se encuentra a su disposicion en la
pagina web www.cam.es , en el apartado Aviso legal

This e-mail is confidential. If you have received this e-mail in error, please
contact
the sender and delete it from your system. All information about Personal Data
Protection can be found on the website www.cam.es , in the Legal Disclaimer
section

_____________________________________________________________________
* IDUG EMEA * Prague, Czech Republic * 14-18 November 2011 *
http://IDUG.ORG/EMEA *
* If you are going to attend only one conference this year, this is it! *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the
home of IDUG's Listserv





_____________________________________________________________________
* IDUG EMEA * Prague, Czech Republic * 14-18 November 2011 * http://IDUG.ORG/EMEA *
* If you are going to attend only one conference this year, this is it! *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Colin

Re: DB2PM_STAT_BUFFER
(in response to Thanikachalam "Billy" Sundarrajan)
José,

Have you tried looking in your prefix.SFPESAMP dataset ?
e.g.
Type of data Table name Table create Description
Table load
Buffer Pool DB2PM_STAT_BUFFER DGOSCBUF DGOSBBUF
DGOSLBUF

I'm afraid I can't confirm this as I'm at home right now. I'll check when
I'm back in the office.


Regards,
 
Colin Clayton

DB2 DBA  
Royal Bank of Scotland        
DB2 Projects
MMTS Databases
Central Infrastructure Services
Business Services
Grnd Floor,
34 Fettes Row,
Edinburgh
EH3 6UY
 
External       0131 523 2221
[login to unmask email]


-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Jose Antonio
Sent: 16 December 2010 09:14
To: [login to unmask email]
Subject: [DB2-L] DB2PM_STAT_BUFFER


Hi list!

Does anyone have the description of every DB2PM_STAT_BUFFER columns?
I have tried everything but I couldn't find it!!!!

Thanks a lot!

__________________________
José A Morcillo Valenciano
Tfno.: +34 965 90 51 43
Arquitectura y Seguridad TI
Administración Base Datos
Caja Mediterráneo
__________________________



Este correo electronico es confidencial. Si lo ha recibido por error, por
favor contacte con el remitente y destruya su contenido. Toda la informacion
relativa a la Proteccion de Datos de Caracter Personal, se encuentra a su
disposicion en la pagina web www.cam.es , en el apartado Aviso legal

This e-mail is confidential. If you have received this e-mail in error,
please contact the sender and delete it from your system. All information
about Personal Data Protection can be found on the website www.cam.es , in
the Legal Disclaimer section

_____________________________________________________________________
* IDUG EMEA * Prague, Czech Republic * 14-18 November 2011 *
http://IDUG.ORG/EMEA *
* If you are going to attend only one conference this year, this is it!
*
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
the home of IDUG's Listserv

_____________________________________________________________________
* IDUG EMEA * Prague, Czech Republic * 14-18 November 2011 * http://IDUG.ORG/EMEA *
* If you are going to attend only one conference this year, this is it! *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Thanikachalam &quot;Billy&quot; Sundarrajan

Re: DB2PM_STAT_BUFFER
(in response to Thanikachalam "Billy" Sundarrajan)
Please check RKO2SAMP member DGOSBBUF




________________________________
From: Jose Antonio <[login to unmask email]>
To: [login to unmask email]
Sent: Thu, December 16, 2010 4:14:08 AM
Subject: [DB2-L] DB2PM_STAT_BUFFER

Hi list!

Does anyone have the description of every DB2PM_STAT_BUFFER columns?
I have tried everything but I couldn't find it!!!!

Thanks a lot!

__________________________
José A Morcillo Valenciano
Tfno.: +34 965 90 51 43
Arquitectura y Seguridad TI
Administración Base Datos
Caja Mediterráneo
__________________________



Este correo electronico es confidencial. Si lo ha recibido por error, por favor
contacte con el remitente y destruya su contenido. Toda la informacion relativa
a
la Proteccion de Datos de Caracter Personal, se encuentra a su disposicion en la
pagina web www.cam.es , en el apartado Aviso legal

This e-mail is confidential. If you have received this e-mail in error, please
contact
the sender and delete it from your system. All information about Personal Data
Protection can be found on the website www.cam.es , in the Legal Disclaimer
section

_____________________________________________________________________
* IDUG EMEA * Prague, Czech Republic * 14-18 November 2011 *
http://IDUG.ORG/EMEA *
* If you are going to attend only one conference this year, this is it! *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the
home of IDUG's Listserv





_____________________________________________________________________
* IDUG EMEA * Prague, Czech Republic * 14-18 November 2011 * http://IDUG.ORG/EMEA *
* If you are going to attend only one conference this year, this is it! *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv