I am trying to get to the bottom of getting my understanding right
on the database and tablespace creations:
I did suffer a bit in trying to search for the right documentation
from the varius redbooks...but I manage to get lost everytime!
Here's what I am out to do:
1. Create a database.
- This would be have to be code set UTF-8
- Setup archive logging of the LOG files
- know how to specify the location for the archive log files.
I have managed the first sub-step with the following command:
CREATE DATABASE TEST USING CODESET UTF-8 I am not sure of the other two. I shall later on create separate tablespaces for all my objects and 2. What is a bufferpool? Any points would be greatly appreciated. Many Thanks.
CATALOG TABLESPACE MANAGED BY SYSTEM
USING ( '/dsk0/db2/TEST/ts/syscat/containers/catalog0.dbf',
EXTENTSIZE 64 PREFETCHSIZE 32
TEMPORARY TABLESPACE MANAGED BY SYSTEM
USER TABLESPACE MANAGED BY DATABASE
USING (FILE '/dsk0/db2/TEST/ts/user/containers/user00.dbf' 5000)
EXTENTSIZE 24 PREFETCHSIZE 48 ;
assign them accordingly.
I have seen that there is an IBMDEFAULTBUFFERPOOL created when I do a
'create database'... Is there a way I can create my own? What is it
I am not sure of the other two.
I shall later on create separate tablespaces for all my objects and
2. What is a bufferpool?
Any points would be greatly appreciated.