You can also select * from syscat.bufferpools.
The columns for db2 7.1 fp2 are:
bpname, bufferpoolid, ngname, npages, pagesize, estore
Christi Fortier,MSAS,Certified DB2 DBA, Sybase DBA
DB Specialist(Admin/Architect/Performance/N-Tier/Web)
PO Box 6012, Lawrenceville, NJ 08648-0012
Phone: 609-912-0620
e: [EMAIL PROTECTED]
Fax: pending
URL: http://www.precise2spec.com/CRDB
---------- Original Message ----------------------------------
From: David Hayes <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Fri, 06 Apr 2001 08:29:30 +0100
Ragu
You could try:
get snapshot for bufferpools on dbname
This will give you a greater level of detail than it sounds like
you need, but it will at least be available from the CLP.
HTH
Dave Hayes
Raghu Raman wrote:
> What is the command to get the list of bufferpools associated
with a database ?
>
> I can get them from Control Center. But i want from Command
prompt. i see only create bufferpool and alter bufferpool command.
>
> I could also get it from SYSCAT.BUFFERPOOLS table...but is there
any command to get that.
>
> Thnx. in advance.
>
> Regards,
> Ragu
>
> Get 250 color business cards for FREE! at Lycos Mail
> http://mail.lycos.com/freemail/vistaprint_index.html
>
> =====
> To unsubscribe, send 'unsubscribe' to db2eug-
[EMAIL PROTECTED]
> For other info (and scripts), see
http://people.mn.mediaone.net/scottrmcleod
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
