C2090-549 by IBM Valid Free Exam Practice Test

Question 1

Click the Exhibit button.
In the exhibit, a customer has a two way data sharing group running with one internal coupling facility (ICF) and one external coupling facility (CF). The only CF structures allocated are the ones depicted in the exhibit. ICF1 is a volatile CF. No ARM policy is active. The customer experiences a power failure to CEC1. Which statement regarding the state of data sharing group DB2G is true?

A. Member DB2A will terminate, DB2B remains active and able to process work. Structure DB2G_SCA will be automatically rebuilt to the external CF. B. Member DB2A and member DB2B both abnormally terminate and are unable to process work until restarted. C. Member DB2A will automatically be restarted on CEC2 and work will continue to be processed by both members. D. Member DB2A will terminate but since this is a data sharing system, DB2B remains active and able to process work. DB2G_SCA will remain in CEC1 since it is in different partition than LPAR1.

Correct Answer: B

Question 2

What does the IMS control region do when a write I/O error occurs on a HDAM database?

A. IMS copies the error buffer contents into a virtual buffer and continues. B. A batch image copy of the affected data base is immediately started by IMS. C. The data base is immediately stopped until a recovery can be completed. D. The application which issued the call terminates with a U0731 abend.

Correct Answer: A

Question 3

In a DB2 non-data sharing system you want to activate changes to DB2 early code in DB2
9.Which command sequence would you issue to activate this code?

A. -STOP DB2; -REFRESH DB2,EARLY; -START DB2 B. -REFRESH DB2,EARLY C. -REFRESH DB2,EARLY; -STOP DB2; -START DB2 D. -START DB2; -REFRESH DB2,EARLY

Correct Answer: A

Question 4

A system is running low on active logs and you need to add active logs to provide some relief.
What would be the appropriate action to achieve this?

A. Allocate the new active log data sets using IDCAMS, stop DB2, add the active log names then start DB2. B. Allocate the new active log data sets using IDCAMS, change the ACTLGNUM DSNZPARM to a higher value, stop DB2, and add the active log names then start DB2. C. Allocate the new active log data sets using IDCAMS, change the ACTLGNUM DSNZPARM to a higher value, and issue the -SET SYSPARM RELOAD command. D. Allocate the new active log data sets using IDCAMS, change the ACTLGNUM DSNZPARM to a higher value, and issue the -SET SYSPARM LOAD (new-zparm-mod) command.

Correct Answer: A

Question 5

You are planning for the execution of multiple concurrent RECOVER jobs (e.g., during DB2 disaster recovery). Which DSNZPARM parameter allows for the most Fast Log Apply storage to be allocated to each RECOVER job?

A. FASTLOG=100M B. LOGAPSTG=0M C. LOGAPSTG=100M D. MEMLIMIT=100M

Correct Answer: C

Question 6

Before adding an active log data set to a subsystem, which utility should be executed in order to determine the current log configuration?

A. DSN1LOGP B. DSNJU004 C. DSN1CHKR D. DSNJU003

Correct Answer: B

Question 7

It is possible that the DBD in the directory is out of sync with the DBD information in the catalog for database DSN8D91
Which action should be performed to determine if this is the case?

A. Run DSN1COPY with the CHECK option. B. Run DSN1CHKR. C. Run CHECK DATA. D. Run REPAIR DBD TEST.

Correct Answer: D

Question 8

You want to audit activity against a table named owner.TABLEX. Which two actions are required?
(Choose two.)

A. Run ALTER owner.TABLEX LOG ALL. B. Run START TRACE AUDIT CLASS (4,5). C. Run ALTER owner.TABLEX AUDIT ALL. D. Run DSN1LOGP against the DB2 log data sets covering the timestamp being audited. E. Run ALTER owner.TABLEX DATA CAPTURE CHANGES.

Correct Answer: B,C

Question 9

Which two parameters are used for buffer pool page management? (Choose two.)

A. PGSTEAL B. PGFIX C. PGSAVE D. PGIO E. PGOPTION

Correct Answer: A,B

IBM Certified System Programmer - IBM IMS - C2090-549 Exam Practice Test