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:
