C2090-317 Online Practice Questions and Answers

You wish to set the threshold at which data in the class castout queue is cast out to disk for group buffer pool GBP10. You want the threshold to be 1000 pages.

Which parameter setting in the command -ALTER GBPOOL(GBP10) will accomplish this?

A. GBPOOLT(10)

B. CLASST(0.1000)

C. CLASST(10.1000)

D. GBPCHKPT(1000)

Given a subsystem parameter of SEPARATE_SECURITY=YES, what level of security has the authority to create and start audit policies?

A. SYSOPR

B. SYSADM

C. SECADM

D. SQLADM

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.

Program Authorization does NOT work in which environment?

A. IMS

B. CICS

C. DSN command processor

D. Programs that run in stored procedure address spaces

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.

When might image copies be needed in a data mirroring environment during disaster recovery?

A. To resolve outstanding units of recovery.

B. If the RBA in the BSDS is higher than the RBA in the active log.

C. Image copies would never be needed when using data mirroring.

D. If a LOAD or RECOVER utility was active at the time of the disaster.

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

A member of a DB2 data sharing group (DB2A) has failed and is currently down. After a few minutes the phone starts ringing and people complain that transactions accessing table space TSA (in database DBA) get an SQLCODE -904 because of retained locks held by the member that just abended.

What is the recommended way to resolve this problem?

A. -START DB(DBA) SP(TSA) ACCESS(FORCE)

B. Restart the failed DB2 member with the LIGHT(YES) option.

C. Delete all the failed persistent connections to the lock structure with the SETXCFFORCE,CONNECTION,STRNAME=lock_strname.CONNAME=ALL command and force the deallocation of the lock structure by issuing SETXCFFORCE,STRUCTURE.STRNAME=lock_strname

D. Issue the MODIFY irlmproc.PURGE. DB2A command from an IRLM that is used by a DB2 member that is still running.}

A DDF thread with a token of 56 needs to be cancelled but due to a very tight processing loop in the thread, a regular cancel thread command might not work. What action(s) would provide the best chance to initially attempt to cancel this thread?

A. -CANCEL THREAD(56)

B. -CANCEL DDF THREAD(56) FORCE

C. -CANCEL THREAD(56)NOBACKOUT

D. -CANCEL DDF THREAD(56)

Which information uniquely identifies a distributed thread?

A. The 'ID' field in the -DISPLAY THREAD output.

B. The 'REG' field in the -DISPLAY THREAD output.

C. The 'ASID' field in the -DISPLAY THREAD output.

D. The TOKEN' field in the -DISPLAY THREAD output.