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 NEW RECOMMEND ♥♥
Free VCE & PDF File for IBM C2090-317 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW C2090-317 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/C2090-317-exam-dumps.html
Q1. In order to guarantee complete security for your DB2 subsystem, which statement is correct?
A. BSDS and catalog VSAM data sets should always be protected by the SYSADM authority.
B. BSDS and catalog VSAM data sets should always be protected by the MSTR address space.
C. BSDS and catalog VSAM data sets should always be protected by an external security profile.
D. BSDS and catalog VSAM data sets should always be protected by the BSDS system privilege
Answer: C
Q2. Which z/OS or DB2 component is required for stored procedures that run in a WLM-established address space?
A. Call attachment facility
B. TSO attachment facility
C. Distributed data facility
D. Resource recovery services
Answer: A
Q3. A member of a DB2 data sharing group (DB2A) has failed and is currently down. After a few minutes the phone starts ringing and people complain that transactions accessing table space TSA (in database DBA) get an SQLCODE -904 because of retained locks held by the member that just abended.
What is the recommended way to resolve this problem?
A. -START DB(DBA) SP(TSA) ACCESS(FORCE)
B. Restart the failed DB2 member with the LIGHT(YES) option.
C. Delete all the failed persistent connections to the lock structure with the SETXCFFORCE,CONNECTION,STRNAME=lock_strname.CONNAME=ALL command and force the deallocation of the lock structure by issuing SETXCFFORCE,STRUCTURE.STRNAME=lock_strname
D. Issue the MODIFY irlmproc.PURGE. DB2A command from an IRLM that is used by a DB2 member that is still running.}
Answer: C
Q4. How can you create a dynamic location alias?
A. Use the CREATE ALIAS statement.
B. Issue the -MODIFY DDF ALIAS ADD command.
C. INSERT a dynamic alias row into SYSIBM.LOCATIONS.
D. Execute the DSNJU003 utility with a DDF ALIAS statement.
Answer: D
Explanation:Reference:http://www-01.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/com.ibm.db2z10.doc.comref/src/tpc /db2z_cmd_modifyddf.dita
Q5. 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
Q6. 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
Explanation:Reference:http://www-01.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/com.ibm.db2z10.doc.ugref/src/tpc/d b2z_reportsyntax.dita
Q7. You use utility DSN1PRNT to print the header page of table space DB1TS1.
Where do you find information about the various header page fields?
A. DB2 Messages
B. DB2 Utility guide
C. DB2 Diagnosis guide
D. DB2 Administration guide
Answer: A
Explanation:Reference:http://www-01.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/com.ibm.db2z10.doc.ugref/src/tpc/d b2z_dsn1prntsyntax.dita
Q8. 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)
Q9. Your production DB2 subsystem is up and running, the following message is received:
DSNJ126I - BSDS ERROR FORCED SINGLE BSDS MODE
because one of the BSDS volumes is offline.
After the volume is back online, in order to ensure a securely running system, what is the least disruptive scenario to correct this error?
A. Run the recover BSDS utility.
B. Issue the -RECOVER BSDS command.
C. IDCAMS REPRO the correct BSDS VSAM replacing the corrupt BSDS VSAM.
D. Wait until the next stop and then start the DB2 subsystem to correct the problem.
Answer: C
Q10. You wish to enforce a system-wide limit on the maximum number of parallel subtasks for utilities REORG TABLESPACE, REBUILD INDEX. CHECK INDEX. UNLOAD, and LOAD, to 16 parallel subtasks per utility execution.
Which action, if anywill enforce this limit?
A. Set subsystem parameter PARAMDEG to 16.
B. Set subsystem parameter PARAMDEGJJTIL to 16.
C. Set subsystem parameter INDEX_IO_PARALLELISM to 16.
D. DB2 does not allow for a system level limit for parallel subtasks in these utilities. The limit can only be specified with the utility keyword PARALLEL n.
Answer: A