IBM C2090-317 Certification Exam Material - Free Download and Guaranteed Pass

IBM C2090-317 Certification Exam Material - Free Download and Guaranteed Pass



Exam code : C2090-317
Exam name : DB2 11 System Administrator for z/OS

QUESTION NO: 1
In complex DB2 recovery scenarios, it is important to understand the scope of which objects
require recovery.
Which DB2 utility provides a list of the names of all table spaces in the table space set that is
specified and a list of all the tables in those table spaces?
A. CHECK
B. REPORT
C. QUIESCE
D. RECOVER
Answer: D
Reference:http://www-
01.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/com.ibm.db2z10.doc.ugref/src/tpc/db2z_re
portsyntax.dita
QUESTION NO: 2
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
Reference:http://www-
01.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/com.ibm.db2z11.doc.admin/src/tpc/db2z_
monitronlineutilities.dita
QUESTION NO: 3
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
Explanation:
QUESTION NO: 4
Which combination of subsystem parameter values will enable connection pooling for idle
distributed database access threads?
A. Specify subsystem parameter CMTSTAT = ACTIVE and set CONDBAT = MAXDBAT.
B. Specify subsystem parameter CMTSTAT = INACTIVE and set CONDBAT < MAXDBAT.
C. Specify subsystem parameter CMTSTAT = ACTIVE and set CONDBAT > MAXDBAT.
D. Specify subsystem parameter CMTSTAT = INACTIVE and set CONDBAT >MAXDBAT.
Answer: C
Reference:http://db2onlinehandbook.com/?p=1263
QUESTION NO: 5
You wish to set the threshold at which data in the class castout queue is cast out to disk for group
buffer pool GBP10. You want the threshold to be 1000 pages.
Which parameter setting in the command -ALTER GBPOOL(GBP10) will accomplish this?
A. GBPOOLT(10)
B. CLASST(0.1000)
C. CLASST(10.1000)
D. GBPCHKPT(1000)
Answer: A
Explanation:
QUESTION NO: 6
Which action should you take to improve the performance of authorization checking for stored
procedures or user-defined functions?
A. Set subsystem parameter EXTSEC to YES.
B. Increase the value of subsystem parameter SECQTY.
C. Increase the value of subsystem parameter AUTHCACH.
D. Increase the value of subsystem parameter CACHERAC.
Answer: D