Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- CREATE a Bufferpool of page size 8K
- CREATE BUFFERPOOL ITMBUF8K IMMEDIATE SIZE 2501 PAGESIZE 8K;
- -- CREATE a Regular Tablespace using the 8K Bufferpool
- CREATE REGULAR TABLESPACE ITMREG8K PAGESIZE 8K
- MANAGED BY SYSTEM
- USING (’itmreg8k’)2 BUFFERPOOL ITMBUF8k;
- -- CREATE a System tablespace using the 8K Bufferpool
- CREATE SYSTEM TEMPORARY TABLESPACE ITMSYS8K PAGESIZE 8K
- MANAGED BY SYSTEM
- USING (’itmsys8k’)2 BUFFERPOOL ITMBUF8k;
- -- CREATE a User tablespace using the 8K Bufferpool
- CREATE USER TEMPORARY TABLESPACE ITMUSER8K PAGESIZE 8K
- MANAGED BY SYSTEM
- USING (’itmuser8k’)2 BUFFERPOOL ITMBUF8k;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement