Personal tools
You are here: Home → DB2 → How To's → Which are the Buffepools from one Tablespace ?
Navigation
Log in


Forgot your password?
 
Document Actions

Which are the Buffepools from one Tablespace ?

To view all buffepools from one tablespace


To view Which are the Buffepools from one tablespace you can use the SQL below:


Before, you have to connect on database:

db2 connect to <dbname>

Then, execute the select below:

db2 "select substr(a.TBSPACE,1,10) as TBSPACE, \
substr(b.BPNAME,1,10) as BPNME from SYSCAT.TABLESPACES a, \
SYSCAT.BUFFERPOOLS b where a.BUFFERPOOLID=b.BUFFERPOOLID"
Security Awareness
Would you like your company to implement gamification into your security awareness program?





Polls