C2090-317 Online Practice Questions and Answers

The -ALTER UTILITY command changes the values of certain parameters of a utility.

Which two utilities can this command be issued against?

A. COPY

B. REORG

C. MODIFY

D. REBUILD

E. RECOVER

Which subsystem parameter is used to enable the RECOVER utility to use system-level backups as a recovery base?

A. RESTORE_TAPEUNITS

B. SYSTEM_LEVEL_BACKUPS

C. UTILS_DUMP_CLASS_NAME

D. RESTORE _ RECOVER_ FROMDUMP

You wish to enable automatic clean-up of committed pseudo-deleted index entries for all indexes in the DB2 subsystem. You have verified that system table SYSIBM.SYSINDEXCLEANUP has no rows.

Without taking any other action, which action will accomplish this?

A. Set subsystem parameter INDEX_CLEANUP_THREADS to 10.

B. Set subsystem parameter INDEX_CLEANUP_THREADS to YES.

C. Issue an ALTER INDEX statement against all indexes with ERASE YES.

D. Issue an ALTER INDEX statement against all indexes with FREEPAGE 0.

Which statement regarding DSN1LOGP is FALSE?

A. DSN1 LOGP does not require DB2 privileges.

B. DSN1 LOGP runs on archive data sets when DB2 is running.

C. DSN1 LOGP can read logs that have been compressed by DFSMS.

D. DSN1 LOGP can print the log records for both base and clone table objects.

How can conditional restarts affect sequence objects?

A. Gaps may exist.

B. Duplicate entries will be deleted.

C. All values will be reset beginning from 1.

D. All values will be reset beginning from 0.

Local buffer pool updated pages are queued by data set until they are written out to DASD when which event occurs?

A. A page is added.

B. A COMMIT is executed.

C. When VPSEQT is reached.

D. A system checkpoint is taken.g

Which statement is true regarding DB2 definitions for SMF collection?

A. SMF collection is not required for DB2.

B. At the minimum, DB2 statistics class 1 trace is required.

C. At the minimum. DB2 accounting classes 1.2.3 are required.

D. The SMF subsystem does not have to be active for DB2 to write SMF trace records.

You wish to enforce a system-wide limit on the maximum number of parallel subtasks for utilities REORG TABLESPACE, REBUILD INDEX. CHECK INDEX. UNLOAD, and LOAD, to 16 parallel subtasks per utility execution.

Which action, if any will enforce this limit?

A. Set subsystem parameter PARAMDEG to 16.

B. Set subsystem parameter PARAMDEGJJTIL to 16.

C. Set subsystem parameter INDEX_IO_PARALLELISM to 16.

D. DB2 does not allow for a system level limit for parallel subtasks in these utilities. The limit can only be specified with the utility keyword PARALLEL n.

What job will check for changes to DB2 that might impact your migration to Version 11 conversion mode?

A. DSNTIJIC

B. DSNTIJXA

C. DSNTIJTC

D. DSNTIJPM

You wish to set the maximum allocation of sort storage to 5000 kilobytes for a query that contains an ORDER BY clause.

Which action will accomplish this?

A. Set subsystem parameter MAXRBLK to 5000.

B. Set subsystem parameter MAXSORTJNJV1EMORY to 5000.

C. Issue command-ALTER BUFFERPOOL(BP7) VPSIZE(5000).

D. DB2 does not allow for user control of this maximum allocation.

One of your applications is experiencing long elapsed times. You notice from DB2 accounting data that 90% of the class 2 elapsed time consists of class 3 suspension time.

Which statement describes the behavior of the application?

A. The application is the victim of excessive performance tracing.

B. The application spends the majority of its time waiting on the network.

C. The application contains complex SQL statements that are CPU intensive.

D. The application spends the majority of its time waiting for buffer pool I/O and log I/O.

Which DB2 system table can limit the amount of resources that can be consumed based on client or IP address of the client?

A. SYSIBM.IPLIST

B. SYSIBM.IPNAMES

C. SYSIBM.DSNRLST01

D. SYSIBM.DSNRLMT01

How can you create a dynamic location alias?

A. Use the CREATE ALIAS statement.

B. Issue the -MODIFY DDF ALIAS ADD command.

C. INSERT a dynamic alias row into SYSIBM.LOCATIONS.

D. Execute the DSNJU003 utility with a DDF ALIAS statement.

What is the minimum level of authority needed to use the DETAIL keyword on a -DISPLAY THREAD command?

A. DBADM

B. SYSADM

C. SYSOPR

D. SYSCTRL

Which statement about the castout process in data sharing is true?

A. The castout process is initiated by the coupling facility.

B. The castout process is performed using BPO of the less active member of the group.

C. The castout process is performed by the first member to express write interest in the data set.

D. The castout process is performed using a private buffer pool in the first member to join the group.