IBM Certified System Programmer - IBM IMS (C2090-549) Free Practice Test

Question 1

A customer is planning on using the BACKUP SYSTEM utility. The DB2 systems programmer works with the storage administrator to establish the correct SMS definitions. Which configuration is correct for use of the BACKUP SYSTEM utility?

A. SMS copy pool 1 that contains the catalog and directory SMS copy pool 2 that contains the user data

B. SMS copy pool 1 that contains the catalog, directory, BSDS and active logs SMS copy pool 2 that contains the user data

C. SMS copy pool 1 that contains the catalog and directory SMS copy pool 2 that contains the BSDS and active logs SMS copy pool 3 that contains the user data

D. SMS copy pool 1 that contains the catalog, directory and user data SMS copy pool 2 that contains the BSDS and active logs

Correct Answer: D

Question 2

DB2 commands in data sharing can have a scope of group or a scope of member. Which
three commands have a scope of member? (Choose three.)

A. -START DATABASE(DB1) SPACENAM(TS1)

B. -ACCESS DATABASE(DB1) SPACENAM(TS1) MODE(OPEN)

C. -ARCHIVE LOG MODE(QUIESCE)

D. -STOP PROCEDURE(PROD.SP1)

E. -SET LOG SUSPEND

Correct Answer: B,D,E

Question 3

A DB2 subsystem is set up to take a checkpoint every two minutes. Applications that use this DB2 subsystem are supposed to adhere to an IT standard where a commit should be issued by the application at least every 200 SQL changes (INSERTs, UPDATES, or DELETEs). Which system parameter would be used to help implement the IT standard?

A. CHKFREQ

B. URLGWTH

C. MAXDBAT

D. LRDRTHLD

Correct Answer: B

Question 4

DB2 audit class trace records are externalized to which SMF record type?

A. 110

B. 100

C. 101

D. 102

Correct Answer: D

Question 5

Which statement is true regarding disaster recovery scenarios?

A. When using an advanced disk mirroring solution, a conditional restart of DB2 must still be performed at the disaster site.

B. When using the RESTORE SYSTEM utility, each DB2 member must use the same SYSPITR value when creating conditional restart control records (CRCR).

C. A backup taken from the BACKUP SYSTEM utility cannot be used for object level recovery for the catalog/directory during a disaster recovery scenario.

D. With a synchronous peer to peer replication solution, a group restart is not required for a data sharing group since everything is synchronously mirrored.

Correct Answer: B

Question 6

One of your Units of Recovery (URs) needs to be backed out. The back out fails due to a read I/O error on both copies of the archive log which is needed for the b ck out. DB2 issues a critical log read error indicating that a "must complete" operation could not be completed. Which statement is true?

A. The error generates a write to operator with reply on the console asking you if DB2 should shut down. All other URs are put on hold until you answer the write to operator reply.

B. The error generates a write to operator with reply on the console asking you if you would like to CANCEL this UR with NOBACKOUT option and leave it in REFP restrictive state.

C. The error generates a write to operator with reply on the console asking you if DB2 should shut down. Other URs are not directly impacted and can continue to run.

D. The error does not generate any write to operator with reply and DB2 abends automatically.

Correct Answer: C

Question 7

Which two actions must be performed for a data sharing traditional image copy disaster recovery? (Choose two.)

A. Modify the IRLM start up proc to specify SCOPE=LOCAL.

B. Use DEFER=ALL in the system parameters during the first restart.

C. Use the SETXCF FORCE command to delete DB2 CF structures.

D. Start DB2 using the LIGHT(YES) keyword.

E. Use STARTRBA=ENDRBA for the conditional restart control record.

Correct Answer: B,C

Welcome to TestSimulate

IBM Certified System Programmer - IBM IMS (C2090-549) Free Practice Test