Exam Code: C2090-737 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: DB2 9 System Administrator for z/OS Exam
Certification Provider: IBM
Free Today! Guaranteed Training- Pass C2090-737 Exam.
2021 May C2090-737 Study Guide Questions:
Q51. 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 setsare lost. A peer-to-peer remote copy (PPRC) is not available.
B. 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.
C. During restart, the back out phase is taking too long because a long running job that executedmany updates and never committed. The only way to bypass the long back out phase is toperform a conditional restart with BACKOUT=NO.
D. The system suffered an outage because of a DASD subsystem failure. The logs are availablebut not the table spaces and index spaces.
Answer: B
Q52. Which two accounting trace classes must be active when tracing package and DBRM related activity? (Choose two.)
A. class 1
B. class 2
C. class 3
D. class 5
E. class 7
Answer: A,E
Q53. A customer has just migrated their DB2 system to V9 new function mode. They currently use the BACKUP SYSTEM utility but want to restrict the system level backup for use only with the RESTORE SYSTEM utility. Which action should be performed to restrict the system level backup to only be used by the RECOVER SYSTEM utility during an object level recovery?
A. Set the SYSTEM_LEVEL_BACKUPS system parameter to NO.
B. Use the BACKUPUSE(RECSYSONLY) keyword on the BACKUP SYSTEM utility.
C. Use the BACKSYS NO keyword on the RECOVER utility.
D. Run the DSNJU003 utility and modify the systempoint in time backup record to have RESTSYS=ONLY.
Answer: A
Up to the immediate present C2090-737 exam answers:
Q54. 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?
A. On migration panel DSNTIPR, you have specified YES or AUTO as DDF startup option.
B. On migration panel DSNTIPX, you have not entered a default WLM environment name.
C. On migration panel DSNTIPX, you have entered a default WLM environment, which is not yetdefined.
D. On migration panel DSNTIPX, you have not entered a WLM procedure name.
Answer: B
Q55. Which statement is correct about the PGFIX buffer pool option?
A. PGFIX(YES) causes a reduction in virtual storage usage in the DBM1 address space.
B. PGFIX(YES) results in lower CPU usage in the DBM1 address space for I/O intensive bufferpools.
C. PGFIX(NO) causes an increase in real storage usage in the DBM1 address space.
D. PGFIX(NO) results in higher CPU usage in the MSTR address space for I/O intensive bufferpools.
Answer: B
Q56. Someone has issued a -STOP DATABASE(DB1) SPACE(TS1) command without previously checking if the page set is currently in use by any URs. The page set is ultimately placed in STOPP restrictive state. Using the DISPLAY THREAD(*) TYPE(SYSTEM) command, what can you do to reverse the –STOP DATABASE command and make the page set available without stopping?
A. Identify the token for the system agent thread performing the -STOP DATABASE command,execute command -CANCEL THREAD(token), and issue the -START DATABASE command.
B. Identify the token for the allied agent thread that issued the -STOP DATABASE command,execute command -CANCEL THREAD(token), and issue the -START DATABASE command.
C. Identify the token for the allied agent thread that issued the -STOP DATABASE command,execute command -CANCEL THREAD(token) FORCE, and issue the -START DATABASEcommand.
D. Identify the token for the system agent thread performing the -STOP DATABASE command,execute command -CANCEL THREAD(token) SUSPEND, and issue the -START DATABASEcommand.
Answer: A
High quality C2090-737 preparation exams:
Q57. In a data sharing system, a system programmer observes very high page p-lock contention.
Which two actions can they take to reduce this contention? (Choose two.)
A. Reduce row level locking for objects used in high volume transactions.
B. For table spaces defined with LOCKSIZE ANY, use ISOLATION(UR) for high volume querytransactions using these objects.
C. ALTER heavy used table spaces to use COMPRESS NO.
D. Ensure heavy used indexes are defined with COPY NO.
E. ALTER heavy used table spaces to use TRACKMOD NO.
Answer: A,E
Q58. 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. -ACCESS DATABASE(DB1) SPACENAM(TS1) MODE(OPEN)
B. -ARCHIVE LOG MODE(QUIESCE)
C. -SET LOG SUSPEND
D. -START DATABASE(DB1) SPACENAM(TS1)
E. -STOP PROCEDURE(PROD.SP1)
Answer: A,C,E
Q59. 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. DSN1CHKR
C. DSNJU003
D. DSNJU004
Answer: D
Q60. DB2 subsystem DB2A has been defined to run in dual active and dual archive logging modes with all archive log data sets written to disk. A DB2 archive log offload process on DB2A has terminated due to an out of space condition on one copy of the archive log. The message shown below is written to the JES log: DSNJ128I - LOG OFFLOAD TASK FAILED FOR ACTIVE LOG DB2A.LOGCOPY1.DS02 Which action does DB2 take and how are the copies of the archive log data sets recorded in the BSDS?
A. DB2 continues the offload task in single archive mode; if the offload is successful, only onecopy of archive log data set is recorded in the BSDS.
B. DB2 truncates both copies of the archive log; both archive data set copies are recorded in theBSDS.
C. DB2 attempts to allocate a new archive log data set with a smaller primary space allocation; ifthe offload is successful, both archive log data set copies are recorded in the BSDS.
D. DB2 terminates the offload operation immediately; no archive log data set copies are recordedin the BSDS.
Answer: A