First Dish in the making....Data base creation

CREATE DATABASE Command - Very Useful recipe..may be eat only when doing Party.. ;)

999 INGREDIENTS
* Authorization
You must have one of the following:
* 9 sysadm
* 9 sysctrl

* Required connection

999 Prepared Ness

This command is not valid on a client.

Instance. 9 To create a database at another (remote) node, you must first attach to that node. 9 A d


The CREATE DATABASE command initializes a new database with an optional user-defined collating sequence,
creates the three initial table spaces,
creates the system tables,
and allocates the recovery log file.
-> When you initialize a new database, you can specify the AUTOCONFIGURE option to <> display and optionally apply the initial values for the buffer pool size, <> database and database manager parameters.
The AUTOCONFIGURE option 9 is not available in a partitioned database environment.



Scope

In a partitioned database environment, this command affects all database partitions that are listed in the db2nodes.cfg file.

The database partition from which this command is issued becomes the catalog database partition for the new database.
Authorization

9

9 Instance. 9 To create a database at another (remote) node, you must first attach to that node. 9 A database connection is temporarily established by this command during processing.
Command syntax