---

Verify Databases

When you have run the make database order, you can check if the databases are made or not by utilizing the accompanying order: 

db2 list db directory  

Verify if database is restrictive

By utilizing the above order, you can just check the rundown of databases. It can't be resolved that the database is prohibitive or not prohibitive. 

Utilize the accompanying order to check if the database is prohibitive or not. 

Syntax:

db2 get db cfg for <db_name> | grep -i restrict  

Example:

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

db2 get db cfg for XYZ | grep -i restrict   

You can see that it isn't prohibitive. 

Presently check if XYZ2 is prohibitive database or not: 

db2 get db cfg for XYZ2 | grep -i restrict    

You can see that XYZ2 is prohibitive database. 

Configure the Database Manager and Database

Example is likewise called Database director. Occurrence setup (Database director arrangement) is put away in a document named 'db2system' and the database related design is put away in a record named 'SQLDBCON'. You can't alter these records legitimately. These documents just can be altered utilizing devices which call API. 

You the accompanying order to arrange the database director. 

To fetch information of instance database manager:

Syntax:

db2 get database manager configuration     
  
OR  
  
db2 get dbm cfg     

Update Instance Database Manager 

Syntax:

db2 update database manager configuration     
  
OR  
  
db2 update dbm cfg    

Reset previous configurations

Syntax:

db2 reset database manager configuration    
  
OR  
  
db2 reset dbm cfg    

 

Database Configuration Parameter

To get the information of database

Syntax:

db2 get database configuration     
  
OR  
  
db2 get db cfg    

To Update the database configuration

Syntax:

db2 update database configuration      
  
OR  
  
db2 update db cfg    

To Reset the previously configured values in database configuration

Syntax:

db2 reset database configuration       
  
OR  
  
db2 reset db cfg     

To check the size of Current Active Database

Syntax:

db2 "call get_dbsize_info(?,?,?,-1)"  

To verify the size of Currently Activate Database

Syntax:

db2 "call get_dbsize_info(?,?,?,-1)"