"Gradual db2--d B2 system Management, operation and application case" reading essays

Once the instance instance directory is created, it cannot change its location. In order to have an instance directory in Linux/unix, a user with the same instance name must be created, with the ultimate purpose of using the user's home directory as the instance directory. On Windows, the instance is a service, and on Linux/unix, the instance is a background process. Therefore, in the UN*X environment, there is an automatic start of a Db2iauto command management instance

db2iauto-on <instance_name>  #-off <instance_name>  #关闭自启动.

Db2instance variable

The environment variable specifies the current active instance. All commands are applied to the instance.

Gets the current active instance name with DB2 get instance. This environment variable is similar to the variable Oracle_sid in Oracle, and the variable informixserver in Informix. Primarily used to switch between multiple instances. This variable is very common in Windows, and in Linux/unix, because each instance has a user with the same name, the instance is implicitly connected when using this user login, so it is relatively rare to use this variable in Linux/unix. Configuration instance

Each instance is created with an instance configuration file (db2systm) that controls the security, communication, administration, and allocation of resources for the instance. This configuration file is binary. can only be modified by command.

DB2 get dbm CFG #查看当前实例的配置参数. DB2 update dbm CFG using ... #修改实例配置文件db2 reset dbm cfg #恢复实例配置文件为默认值

"Gradual db2--d B2 system Management, operation and application case" reading essays