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.
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:
Update Instance Database Manager
Reset previous configurations
Database Configuration Parameter
To get the information of database
To Update the database configuration
To Reset the previously configured values in database configuration
To check the size of Current Active Database
To verify the size of Currently Activate Database