Administration Getting Started

Events Associated with Creating a Database

When you create a database, the following events automatically occur:

• All the system catalog tables are created

• The database recovery log is allocated

• The database configuration file is created and its default values set

• The database is cataloged in the system database directory file

• The default table spaces are created

• Finally, the DB2 utilities are bound to the database. This makes the utilities available for use. If you wish to use these utilities from a client, and the client is running a different operating system than the server or is at a different service level, you must bind them explicitly. Binding a utility creates a package, which is an object that includes all the information needed to process specific SQL statements from a single source file. See the Quick Beginnings for your platform for more information about binding and packages.

Unless you override the defaults, the user tables, system tables, and temporary tables will be stored on the same drive you selected in the SmartGuide. The database configuration file and the database recovery log will also be stored on the same drive.

[ DB2 List of Books | Search the DB2 Books ]