IBM Certified System Programmer - IBM IMS - C9050-549 Exam Questions [2026]

QUESTION NO: 1
Which statement is correct about the PGFIX buffer pool option?

A. PGFIX(NO) causes an increase in real storage usage in the DBM1 address space. B. PGFIX(YES) causes a reduction in virtual storage usage in the DBM1 address space. C. PGFIX(NO) results in higher CPU usage in the MSTR address space for I/O intensive buffer pools. D. PGFIX(YES) results in lower CPU usage in the DBM1 address space for I/O intensive buffer pools.

Correct Answer: D

QUESTION NO: 2
Your accounting report shows that a large component of class 3 wait time for an application is service task
switch time. For which type of contention should you be looking?

A. asynchronous read B. open/close data set C. system catalog D. logging

Correct Answer: B

QUESTION NO: 3
What is the recommended relative address space (highest to lowest) dispatching priority for these
components?

A. IRLM, MSTR, DB2 performance monitors, DBM1 B. MSTR, IRLM, DB2 performance monitors, DBM1 C. IRLM, DB2 performance monitors, DBM1, MSTR D. DBM1, IRLM, MSTR, DB2 performance monitors

Correct Answer: C

QUESTION NO: 4
Regarding SVC dumps for the DBM1 address space, what should be reviewed to determine the DB2
failing component?

A. the GRS summary B. the RMM Control Block Analysis C. the LOGREC symptom string D. the RSM summary

Correct Answer: C

QUESTION NO: 5
The total number of threads accessing data that can be allocated concurrently is the sum of which
combination of DB2 parameters?

A. MAXDBAT and CONDBAT B. IDBACK and IDFORE C. MAXKEEPD and MAXOFILR D. MAXDBAT and CTHREAD

Correct Answer: D

QUESTION NO: 6
Which case would require you to perform a DB2 conditional restart?

A. The DASD subsystem has experienced a major problem and the primary active log data sets are lost.
A peer-to-peer remote copy (PPRC) is not available. B. The system suffered an outage because of a DASD subsystem failure. The logs are available but not
the table spaces and index spaces. C. The DB2 system fails during normal processing because of an exceptional peak in the workload.
Normal restart abends in the log apply phase whenever DB2 is started. D. During restart, the back out phase is taking too long because a long running job that executed many
updates and never committed. The only way to bypass the long back out phase is to perform a conditional
restart with BACKOUT=NO.

Correct Answer: C

QUESTION NO: 7
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. -START DB2; -REFRESH DB2,EARLY B. -STOP DB2; -REFRESH DB2,EARLY; -START DB2 C. -REFRESH DB2,EARLY; -STOP DB2; -START DB2 D. -REFRESH DB2,EARLY

Correct Answer: B

QUESTION NO: 8
DB2 issues a message indicating that the subsystem is in single BSDS mode. Which stepsshould be
performed after the damaged BSDS has been deleted and defined?

A. Use -STOP DB2, then use -START DB2. B. Issue the -RECOVER BSDS command. C. REPRO the single BSDS being used by the DB2 subsystem. D. REPRO the most recent archived copy of the BSDS to the new data set.

Correct Answer: B

QUESTION NO: 9
Which two statements are correct in DB2 9? (Choose two.)

A. TEMP database is used for storing external (user-defined) declared global temporary tables. B. WORKFILE database supports 4 KB, 8 KB, 12 KB or 32 KB page sizes. C. WORKFILE database is used for processing SQL with materializing views, triggers, nested table
expressions. D. In a data sharing environment, all data sharing members use a single WORKFILE database. E. WORKFILE database is used for storing DB2 global temporary tables.

Correct Answer: C,E