Exam Code: C2090-317 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: DB2 11 System Administrator for z/OS
Certification Provider: IBM
Free Today! Guaranteed Training- Pass C2090-317 Exam.
2021 May C2090-317 Study Guide Questions:
Q21. The ALTER BUFFERPOOL command specifying the AUTOSIZE(YES) option enables DB2 to use WLM services to fine tune the buffer pools.
What is the result of issuing this ALTER?
A. The immediate write threshold can be increased by 25%.
B. A pool size can be increased by up to 25% over original pool size.
C. The pool size can be increased in 25% increments base on sequential read hit ratio.
D. Depending on the type of I/O performed, pool size can be increased or decreased.
Answer: B
Explanation:Reference:http://www-01.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/com.ibm.db2z11.doc.perf/src/tpc/db 2z_enableautobpsize.dita
Q22. What job will check for changes to DB2 that might impact your migration to Version 11 conversion mode?
A. DSNTIJIC
B. DSNTIJXA
C. DSNTIJTC
D. DSNTIJPM
Answer: C
Explanation:Reference:https://dhrmf.hr.state.or.us/public/pdfs/IBM/DB2/V9_Installation_Guide_dsnigk1 5.pdf(page 322)
Q23. The -ALTER UTILITY command changes the values of certain parameters of a utility.
Which two utilities can this command be issued against?
A. COPY
B. REORG
C. MODIFY
D. REBUILD
E. RECOVER
Answer: B,D
Explanation:Reference:http://www-01.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/com.ibm.db2z11.doc.admin/src/tpc/ db2z_monitronlineutilities.dita
Updated C2090-317 braindumps:
Q24. Which subsystem parameter is used to enable the RECOVER utility to use system-level backups as a recovery base?
A. RESTORE_TAPEUNITS
B. SYSTEM_LEVEL_BACKUPS
C. UTILS_DUMP_CLASS_NAME
D. RESTORE _RECOVER_FROMDUMP
Answer: D
Q25. Which subsystem parameter setting allows connection queuing?
A. IDTHTOIN>0
B. CONDBAT>0
C. POOLINAC>0
D. MAXCONGN > 0
Answer: D
Explanation:Reference:http://www-01.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/com.ibm.db2z10.doc.inst/src/tpc/db 2z_zparmnotonpanels.dita(see MAXCONQN)
Q26. You execute the following SQL against the CDB (Communications Database) of your DB2 subsystem:
INSERT INTO SYSIBM.IPNAMES
(UNKNAME.SECURITY_OUT.USERNAMES,IBMREQD.IPADDR) VALUES ('REMOTEDB'. 'P 'O'. 'N', *123.34.45.56');
INSERT INTO SYSIBM.IPLIST (LINKNAMEJPADDRJBMREQD) VALUES ('REMOTEDB', '123.34.45.56', *N');
INSERT INTO SYSIBM.IPLIST (LINKNAMEJPADDRJBMREQD) VALUES C REMOTEDB', '123.34.45.57', 'N');
INSERT INTO SYSIBM.USERNAMES (TYPE,AUTHID.LINKNAME,NEWAUTHID.PASSWORD,IBMREQD) VALUES (T, 'USER1'. 'USER2 ", ,PWD2,1 *N');
INSERT INTO SYSIBM.USERNAMES (TYPE,AUTHID.LINKNAME,NEWAUTHID.PASSWORDJBMREQD) VALUES ('O', 'USER1'. 'USER3', *', 'PWD3', 'N');
There is no trusted connection to REMOTEDB. USER1 issues a query addressing remote data source REMOTEDB on your DB2 subsystem.
Which authorization id will be used on the remote data source REMOTEDB?
A. USER1
B. USER2
C. USER3
D. USER4
Answer: A
Pinpoint C2090-317 :
Q27. What is the minimum level of authority needed to use the DETAIL keyword on a -DISPLAY THREAD command?
A. DBADM
B. SYSADM
C. SYSOPR
D. SYSCTRL
Answer: A
Q28. Which DB2 catalog or directory table space CANNOT be reorganized?
A. DSNDB01.SCT02
B. DSNDB01.SYSUTILX
C. DSNDB06.SYSTSCPY
D. DSNDB06.SYSTSPDO
Answer: D
Q29. Which DB2 system table can limit the amount of resources that can be consumed based on client or IP address of the client?
A. SYSIBM.IPLIST
B. SYSIBM.IPNAMES
C. SYSIBM.DSNRLST01
D. SYSIBM.DSNRLMT01
Answer: D
Q30. A member of a data sharing group is suffering from elongated response times. You suspect that sysplex workload balancing (WLB) is not working properly for the DDF work (not evenly distributing the work among the different members).
What is the simplest way to verify how the DDF threads are distributed amongst the different members?
A. Execute the-DIS GROUP command.
B. Execute the -DIS DDF DETAIL command on each member.
C. Execute the -DIS THDO DETAIL SCOPE(GROUP) command.
D. Executed the -DIS LOCATION(') DETAIL command on each member.
Answer: B