Description
The create command is utilized for creating a new database from the instance of database directory. In DB2, each and every the database tables are put away in tablespaces, which utilize their separate group of storage. DB2 Activate Database
command begins with every single vital administration for a specific database so that the database is accessible for utilization. A DB2 Activate Database a client describes a collection of tables as a part of the database. The RDBMS is a database programming language that can performed with the accompanying operations.
Syntax
The syntax for DB2 Activate Database is as follows:
db2 activate db <db_name>
Activate => Is used to activate a database.
db_name => Accurate table in the db2 database.
Examples
By viewing the below example, the concept of DB2 Activate Database
can be easily understands.
[c]
DB2 => Activate db Company
DB20000I The Company database has been successfully activated.
[/c]
Here the database by name company has been successfully activated.
Description
In DB2, each and every database tables are put away in tablespaces, which utilize their separate group of storage. DB2 Deactivating The Database command begins with every single vital administration for a specific database so that all the features of the database get halted.
Syntax
The syntax for DB2 Deactivating The Database is as follows:
db2 deactivate db <db_name>
Deactivate => Is used to deactivate a database.
db_name => Accurate table in the db2 database.
Examples
By viewing the below example, the concept of deactivating a database can be easily understands.
[c]
DB2 => deactivate db Company
DB20000I The Company database has been successfully deactivated.
[/c]
Here the database by name company has been successfully deactivated.
Key Points
- DB2 Activate Database - Used for activating the existing database.
- DB2 Deactivating The Database - Used for deactivating the existing database.