Answers

QUESTION 31
The correct answer is D. The AUTOCONFIGURE command is designed to capture specific information about your database environment and recommend and/or make changes to configuration parameters based upon the information provided. The basic syntax for this command is:

AUTOCONFIGURE
USING [ [Keyword] [Value] ,...]
APPLY [DB ONLY | DB AND DBM | NONE]

where:

Keyword represents one or more special keywords recognized by the AUTOCONFIGURE command. Valid values include: mem_percent, workload_type, num_stmts, tpm, admin_priority, is_populated, num_local_apps, num_remote_apps, isolation, and bp_resizable.
Value identifies the value associated with the keyword provided.

If the APPLY DB ONLY clause is specified with the AUTOCONFIGURE command, database configuration and buffer pool changes recommended by the Design Advisor will be applied to the appropriate database configuration file; if the APPLY DB AND DBM clause is specified, database configuration and buffer pool changes recommended will be applied to the database configuration file and instance configuration changes recommended will be applied to the appropriate DB2 Database Manager configuration file. If the APPLY NONE clause is specified instead, change recommendations will be displayed, but not applied.

QUESTION 32
The correct answer is D. The syntax for the CREATE DATABASE command used is this example can be broken down into something that looks like this:

         CREATE [DATABASE | DB] [DatabaseName]

	< AUTOMATIC STORAGE [YES | NO]>

	< ON [StoragePath ,...] <DBPATH [DBPath]> >

	< COLLATE USING [CollateType]>

	< CATALOG TABLESPACE [TS_Definition]>

	

where:

DatabaseName identifies the unique name that is to be assigned to the database to be created.

StoragePath ,if AUTOMATIC STORAGE YES is specified (which is the default), identifies one or more storage paths that are to be used to hold table space containers used by automatic storage. Otherwise, it identifies the location (drive and/or directory) where the directory hierarchy and files associated with the database to be created are to be physically stored.

DBPath, if AUTOMATIC STORAGE YES is specified (the default), identifies the location (drive and/or directory) where the directory hierarchy and metadata files associated with the database to be created are to be physically stored. (If this parameter is not specified and automatic storage is used, the metadata files will be stored in the first storage path specified in the StoragePath parameter.)

CollateType specifies the collating sequence (i.e., the sequence in which characters are ordered for the purpose of sorting, merging, and making comparisons) that is to be used by the database to be created. The following values are valid for this parameter: COMPATABILITY, IDENTITY, IDENTITY_16BIT, UCA400_NO, UCA400_LSK, UCA400_LTH, NLSCHAR, and SYSTEM.

TS_Definition specifies the definition that is to be used to create the table space that will be used to hold the system catalog tables (SYSCATSPACE).

So in this case, automatic storage is enabled by default, and the storage paths /mnt/data1 and /mnt/data2 will be used to hold table space containers used by automatic storage. And, since no database path was specified, the metadata files associated with the database will be stored in the first storage path specified (/mnt/data1).