Learning Visually with Examples [Electronic resources] نسخه متنی

The DB2INSTANCE environment variable determines the current active instance.

You can set up your DB2 environment in Linux/UNIX by adding the db2profile (for the Bourne and Korn shells) or db2cshrc (for the C shell) in the .login or .profile initialization files. You should also modify the db2profile file to set the DB2INSTANCE variable to the name of the instance you want active by default.

db2set DB2COMM= -g

db2ilist

To create a new instance with the

db2icrt command on Linux or UNIX you must have root authority.

To create a new instance with the

db2icrt command on Windows you must have Administrator authority.

The

db2idrop command will remove the DB2 instance from the list, and remove all DB2-related executables and libraries from the instance owner's home directory.

No. Executing the command once from any database partition will start all of the other database partitions.

Issue the

db2start command with the

ADMIN MODE USER

userID option.

An attachment is required to perform operations at the instance level, while a connection is required to perform operations at the database level.

C . The

db2set lr command lists all of the registry variables that DB2 recognizes.

A and

D . Sort heap threshold (SHEAPTHRES) and maximum query degree of parallelism (MAX_QUERYDEGREE) are both database manager (instance)-level configuration parameters.

D . Each instance is a separate DB2 operating environment, so errors in one instance cannot affect the other instances. Therefore, to ensure that problems that you normally encounter in development do not affect your production system, put these databases in separate instances.

B . To get the current, effective setting for each configuration parameter along with the value of the parameter the next time the instance is stopped and restarted, use the

show detail option of the

get dbm cfg command.

D . To update the DAS configuration use the command

db2 update admin cfg .

D . To change the DAS configuration back to its default values, use the command

db2 reset admin cfg .

C.db2stop force forces all applications off the databases and prevents new connections from happening. Then it stops the active instance.

A . The

list applications command requires an instance attachment.

D . The

db2 get db cfg command is used to review the contents of the database configuration (db cfg) file. If you are not connected to the database, you need to specify the name of the database in the command.

B and

D . The values of YES and ON are equivalent, but a

1 is not allowed. Also, INTRA_PARALLEL is a Database Manager Configuration parameter; therefore,

D is incorrect.