Verify Databases

Once you have run the create database command, you can check if the databases are created or not by using the following command:

Verify if database is restrictive

By using the above command, you can only check the list of databases. It cannot be determined that the database is restrictive or not restrictive.

Use the following command to check if the database is restrictive or not.

Syntax:

Example:

Let's check if XYZ is restrictive database or not:

You can see that it is not restrictive.

Now check if XYZ2 is restrictive database or not:

You can see that XYZ2 is restrictive database.

Configure the Database Manager and Database

Instance is also called Database manager. Instance configuration (Database manager configuration) is stored in a file named 'db2system' and the database related configuration is stored in a file named 'SQLDBCON'. You cannot edit these files directly. These files only can be edited using tools which call API.

You the following command to configure the database manager.

To fetch information of instance database manager:

Syntax:

Update Instance Database Manager

Syntax:

Reset previous configurations

Syntax:

Database Configuration Parameter

To get the information of database

Syntax:

To Update the database configuration

Syntax:

To Reset the previously configured values in database configuration

Syntax:

To check the size of Current Active Database

Syntax:

To verify the size of Currently Activate Database

Syntax: