Free IBM C9050-549 Practice Test & Real Exam Questions
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?
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?
Correct Answer: A
Vote an answer
Regarding SVC dumps for the DBM1 address space, what should be reviewed to determine the DB2
failing component?
failing component?
Correct Answer: C
Vote an answer
A non-data sharing DB2 subsystem is heavily using CPU resources. Which system parameter change
would have a positive effect on the CPU usage?
would have a positive effect on the CPU usage?
Correct Answer: A
Vote an answer
You are migrating your DB2 for z/OS subsystem to version 9 NFM. As part of the migration process, you
intend to step through the different IBM provided IVP phases to verify that everything is working well.
Looking at the generated jobs, you recognize that there is only one job that has been created for phase 6
(accessing data at a remote site) rather than the whole set of jobs. What is the reason for this happening?
intend to step through the different IBM provided IVP phases to verify that everything is working well.
Looking at the generated jobs, you recognize that there is only one job that has been created for phase 6
(accessing data at a remote site) rather than the whole set of jobs. What is the reason for this happening?
Correct Answer: B
Vote an answer
Using the change log inventory utility, which CRESTART parameters are used to indicate a cold start?
Correct Answer: B
Vote an answer
All members of a data sharing group can be accessed by the group attachment name GRP. Two
members (DB2A and DB2B) of the data sharing group are up on the same z/OS and you run a batch job
on this z/OS with the following DSN command: DSN SYSTEM(GRP). Which statement is true?
members (DB2A and DB2B) of the data sharing group are up on the same z/OS and you run a batch job
on this z/OS with the following DSN command: DSN SYSTEM(GRP). Which statement is true?
Correct Answer: A
Vote an answer
After migrating to DB2 9 for z/OS NFM you recognize that you need additional work file database page
sets. Which statement is correct?
sets. Which statement is correct?
Correct Answer: B
Vote an answer
Click the Exhibit button.
Referring to the exhibit, which statement related to DB2 storage usage is correct?
Referring to the exhibit, which statement related to DB2 storage usage is correct?
Correct Answer: A
Vote an answer
In a non data sharing system, prefetch is getting disabled due to available buffers. Which buffer pool
threshold parameter would you increase to reduce prefetch becoming disabled?
threshold parameter would you increase to reduce prefetch becoming disabled?
Correct Answer: A
Vote an answer
