Cause all that matters here is passing the IBM C2090-317 exam. Cause all that you need is a high score of C2090-317 DB2 11 System Administrator for z/OS exam. The only one thing you need to do is downloading Pass4sure C2090-317 exam study guides now. We will not let you down with our money-back guarantee.
♥♥ 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
Q21. When might image copies be needed in a data mirroring environment during disaster recovery?
A. To resolve outstanding units of recovery.
B. If the RBAinthe BSDS is higher than the RBA in the active log.
C. Image copies would never be needed when using data mirroring.
D. If a LOAD or RECOVER utility was active at the time of the disaster.
Answer: A
Q22. 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
Q23. Which two features are the motivation behind the conversion to extended RBA/LRSN format?
A. Greater RECOVER utility concurrency.
B. Reduction of the potential for an RBA rollover.
C. More precise PIT recovery of the DB2 system catalog and directory.
D. Potentially faster UPDATE performance due to greater LRSN granularity.
E. Reduced p-Lock contention in the coupling facility due to greater LRSN granularity.
Answer: C
Q24. 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
Q25. 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
Q26. In adata-sharingenvironment, what is the first step to prepare for a DB2 RESTORE SYSTEM to a point in time?
A. Stop all DB2 members.
B. Stop one DB2 member.
C. Do not stop any DB2 members.
D. Stop only the member where RESTORE SYSTEM will run.
Answer: D
Q27. 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
Q28. 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
Q29. 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
Q30. 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