DB2 - Activate Database




DB2 Activate Database

The ACTIVATE DATABASE command activates the specified database and starts up all necessary database services so that the database is available for connection and use by any application.

Activates the specified database and starts up all necessary database services, so that the database is available for connection and use by any application. This command activates the specified database on all nodes within the system.

If one or more of these nodes encounters an error during activation of the database, a warning is returned. The database remains activated on all nodes on which the command has succeeded.

What is DB2 Activate Database ?

This command activates the target database on all members in the instance. In a Db2® pureScale® environment, if the command was issued by a client using the TCP/IP protocol, this command activates only the members included in the member subset that is associated with the database alias.

If one or more of these members encounters an error during activation, a warning is returned. The database remains activated for all members on which the command succeeds.

A database is activated either implicitly or explicitly. The activation of a database driven by a first user connection is known as implicit activation. Activation of a database that is based on issuing the activate database command is known as explicit activation.

The "activate db" command is used to activate the database you have created once. It makes database available for the application.

Syntax

db2 activate db <db_name>

Here, db_name specifies the name of the database.

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.

Active database systems support mechanisms that enable them to respond automatically to events that are taking place either inside or outside the database system itself. Considerable effort has been directed towards improving understanding of such systems in recent years, and many different proposals have been made and applications suggested.

This high level of activity has not yielded a single agreed-upon standard approach to the integration of active functionality with conventional database systems, but has led to improved understanding of active behavior description languages, execution models, and architectures. This survey presents the fundamental characteristics of active database systems, describes a collection of representative systems within a common framework, considers the consequences for implementations of certain design decisions, and discusses tools for developing active applications.

In contrast to passive databases, in active databases, execution of actions can be triggered in response to some monitored events

  • database updates and inserts

  • points in time

  • etc

Triggers

Usually there are some rules in such databases that react on the external events.