Online Documentation for SQL Manager for DB2

Creating new database


This step of the wizard allows you to create a new database on your DB2 system.

Here you are to provide the necessary Database and Node information for the new database in the corresponding boxes: Database name, Database alias, Path/Drive, Database comment, Node name, User name, Password.

 

Project Interaction - Create new database

 

 

Database name

Enter the database name in this box. This value must be unique to differentiate the database from any other database the local database directory or the system database directory.

 

Database alias

Provide any database alias that is convenient for you (by default NEW_DB). If no alias is provided, the specified database name is used. This alias will be displayed in the DB Explorer window.

 

Path/Drive

Use the ellipsis EllipsisButton button to specify the location where the new database will reside. If a path is not specified, the database will be created on the default database path specified in the database manager configuration file (dftdbpath parameter).

 

Supply a Database comment, if necessary.

 

Node info

Select the node for the new database using the Node name combo-box, and supply the User name and Password.

 

CheckBox Restrict access

If this option is selected, the RESTRICT_ACCESS database configuration parameter is set to YES and no privileges are automatically granted to PUBLIC.

 

CheckBox Automatic storage

Specifies that automatic storage is being explicitly disabled or enabled for the database.

 

Click the Next button to proceed to the Setting connection properties step of the wizard.