Prepare these C2090-317 dumps and pass your exam. C2090-317 practice exam questions answers are collected from real paper. Keep visiting for C2090-317 study material or C2090-317 dumps.
Q31. Which information uniquely identifies a distributed thread? A. The 'ID' field in the -DISPLAY THREAD output. B. The 'REG' field in the -DISPLAY THREAD output. C. The 'ASID' field in the -DISPLAY THREAD output. D. The TOKEN' field in the -DISPLAY THREAD output. Answer: D Explanation:Reference:http://www-01.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/com.ibm
Q21. One of your applications is experiencing long elapsed times. You notice from DB2 accounting data that 90% of the class 2 elapsed time consists of class 3 suspension time. Which statement describes the behavior of the application? A. The application is the victim of excessive performance tracing. B. The application spends the majority of its time waiting on the network. C. The application
Q11. Program Authorization does NOT work in which environment? A. IMS B. CICS C. DSN command processor D. Programs that run in stored procedure address spaces Answer: C Q12. 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
Q1. How can conditional restarts affect sequence objects? A. Gaps may exist. B. Duplicate entries will be deleted. C. All values will be reset beginning from 1. D. All values will be reset beginning from 0. Answer: A Q2. 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.LO
Q31. 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) Q32. When might image copies be needed in a data mirroring environment during disaster rec
Q21. 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/knowledgecente
Q11. Which statement regarding migration from DB2 10 for z/OS to DB2 11 for z/OS is true? A. All packages must be rebound with application compatibility set to V10R1. B. The DB2 catalog and directory must be changed to reside on SMS managed DASD. C. All packages last bound prior to DB2 9 for z/OS must be rebound in DB2 10 or DB2 11. D. The size of the DB2 bootstrap datasets must be increased
Q11. 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) Q12. A member of a DB2 data sharing group (DB2A) has failed and is currently down. After a few minutes the p
Q21. 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 Explanation:Reference:http://www.redbooks.
Q31. 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_PARALLELIS