Home » DB2 Verify Database

DB2 Verify Database

by Online Tutorials Library

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 Database


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:

Verify Database

You can see that it is not restrictive.

Now check if XYZ2 is restrictive database or not:

Verify Database

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:

Configure Database

Update Instance Database Manager

Syntax:

Reset previous configurations

Syntax:


Database Configuration Parameter

To get the information of database

Syntax:

Configure Database

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:

Configure Database

To verify the size of Currently Activate Database

Syntax:

Configure Database

You may also like