Online Documentation for SQL Manager for DB2

Setting DB name and node info


Use this step of the wizard 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.

 

Create Database wizard - Setting DB name and Node info

 

 

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

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 drop-down list, 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.