| As a DBA you will be creating databases as and | | | | There is also a directory for active logs. This directory |
| when needed. Especially when a new project is | | | | contains all the log files being used by the database. |
| started a database is created. The process starts with | | | | Three tablespaces syscatspace, tempspace and |
| the requirements gathering, entity relationship diagrams | | | | userspace are created at the time of database |
| and database design. Database design is a crucial step | | | | creation. Syscatspace is used to store all the catalog |
| as it would impact the performance of the database. | | | | tables which are used to store the metadata. |
| Database naming standards have to be followed | | | | Tempspace is used for sorting and joins. Userspace is |
| when you create the database. Once the database is | | | | the default tablespace used for any operations. So if |
| created, several files and default objects are created. | | | | you create a table without specifying the tablespace |
| Default database path as defined in the configuration is | | | | name then the table is created in userspace. |
| used to place the default files. There is a directory | | | | One default bufferpool IBMDEFAULTBP is created |
| created for the instance with the instance name and | | | | which is used by default when no bufferpool is |
| under that a directory with the partition name is | | | | specified. A database configuration file is also created |
| created. Under the partition directory, database | | | | which has all the configuration information. System |
| directory is created. | | | | catalog views and other system objects are created. |
| A directory for event monitors is created. This | | | | With version 9 you have the ability to use new system |
| directory has all the event monitor files that are | | | | views which greatly improves the monitoring process. |
| needed to monitor several events in the database. | | | | |