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:
Q11. 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. system catalog
C. logging
D. open/close data set
Answer: D
Q12. By examining a DB2 accounting report, how can you determine if DASD I/O contention is a factor in a poor performing application?
A. Divide the number of get pages by the number of synchronous I/Os.
B. Divide the synchronous I/O wait time by the number of synchronous I/Os.
C. Divide the asynchronous I/O wait time by the number of synchronous I/Os.
D. Divide the class 2 elapsed time by the number of synchronous I/Os.
Answer: B
Q13. A normally well running application using packages is experiencing longer than normal elapsed times because of a possible wait. Other DB2 applications are running within acceptable limits.
Which trace output could be analyzed to determine the change in behavior?
A. performance class 10
B. accounting class 8
C. accounting class 2
D. statistics class 6
Answer: B
Renewal C2090-737 question:
Q14. What are three characteristics of DB2 9 native SQL procedures? (Choose three.)
A. Runs entirely within DB2.
B. Requires a WLM-managed address space.
C. Could be zIIP eligible if it is a DDF request using DRDA.
D. Ability to define multiple versions.
E. Requires SPAS.
Answer: A,C,D
Q15. Which two statements are true regarding a traditional image copy disaster recovery in a data sharing environment? (Choose two ) A. All members defined to the data sharing group must be restarted at the disaster recovery site.
B. When using change log inventory (DSNJU003), the latest log record sequence number thatcan be used is the oldest last written log record of all members participating in the restart.
C. Only one conditional restart control record (CRCR) needs to be created for the data sharinggroup and all DB2 members will utilize this CRCR during restart.
D. SETXCF FORCE commands should be used to purge DB2 coupling facility structures prior tostaring the first DB2 member.
E. The catalog and directory must be recovered by first data sharing member brought up at thedisaster recovery site and all other members must not be started before this recovery isfinished.
Answer: B,D
Q16. A customer is having performance problems with a particular statically bound batch package.
This batch program is processing transactions from a sequential file where each input record ends up updating one row in a 10 million row table. The sequential file contains 5000 records.
The customer reviews the accounting record information and notices that class 1 elapsed time is 2 hours, class 2 elapsed time is 1 hour 50 minutes and class 3 elapsed time is 1 hour, 45 minutes. Which statement regarding the problem could be true?
A. DASD contention could be the result of the poor performance problem.
B. The access path for the package is not optimal; high CPU is causing the problem.
C. The batch program appears to have a logic error; the difference between class 2 elapsed andclass 3 elapsed shows only 5 minutes of time actually executing in DB2.
D. The scenario as described does not indicate that there is a performance problem; all of theelapsed time figures appear to be normal.
Answer: A
Pinpoint C2090-737 ebook:
Q17. Click the Exhibit button.
Referring to the exhibit, which statement related to DB2 storage usage is correct?
A. The system is over committed on virtual storage as it has more than 2 GB of real storageallocated in the DBM1 address space.
B. The system is doing ok on virtual storage but is clearly short on real storage because the totalamount of real storage is more than 2 GB.
C. The DBM1 address space does not seem to do any paging, but the MSTR address spaceseems to suffer from paging.
D. DB2 statistics do not provide accurate information about the real storage usage. The onlyreliable source of information are RMF statistics.
Answer: C
Q18. DB2 has written the following message to the system log: DSNP007I DSN3 DSNPXTN0 -
EXTEND FAILED FOR 229 DSNP.DSNDBD.DSNDB07.DSN4K03.I0001.A001. RC=00D70027
CONNECTION-ID=SERVER, CORRELATION-ID=java.exe, LUW
ID=A49CA1E4.C350.623F6A48E28B=120701 Which action would you take to correct the problem?
A. Alter the primary and/or secondary space quantity of the DSNDB07.DSN4K03 table space,and then execute the REORG utility.
B. Use SQL to create an additional 4K table space in DSNDB07.
C. Use SQL to create a new 32K table space in DSBDB07.
D. Alter the primary and/or secondary space quantity of the DSNDB07.DSN4K03 table space,and then execute the RECOVER utility.
Answer: B
Q19. A number of jobs are waiting for an allied connection to access a DB2 subsystem. What should be done to increase the number of allied connections that can be allocated concurrently?
A. Increase the value of MAXDBAT.
B. Increase the value of CTHREAD.
C. Increase the value of MAXKEEPD.
D. Increase the value of MAXDS.
Answer: B
Q20. Which authority is required for the creation of a database role?
A. DBADM
B. SYSOPR
C. SYSADM
D. DBMAINT
Answer: C