Printable PDF
Vendor: IBM
Exam Code: C2090-317
Exam Name: DB2 11 System Administrator for z/OS
Certification: IBM Certified System Administrator
Total Questions: 60 Q&A
Updated on: Nov 13, 2024
Note: Product instant download. Please sign in and click My account to download your product.
You wish to set the maximum allocation of sort storage to 5000 kilobytes for a query that contains an ORDER BY clause.
Which action will accomplish this?
A. Set subsystem parameter MAXRBLK to 5000.
B. Set subsystem parameter MAXSORTJNJV1EMORY to 5000.
C. Issue command-ALTER BUFFERPOOL(BP7) VPSIZE(5000).
D. DB2 does not allow for user control of this maximum allocation.
Having to deal with data inconsistency during a disaster recovery can significantly impact the length of time needed to recover. One of the actions that could be taken to prevent this from occurring is to not take an image copy of a data set that contains inconsistent data.
Which two options can be used to help prevent taking an image copy of inconsistent data?
A. Run the DIAGNOSE utility before making an image copy.
B. Run the CHECK DATA utility before making an image copy.
C. Use the CHECKPAGE option when running the COPY utility.
D. Prior to making an image copy, run DSN1 COPY with the CHECK option.
E. At install time, use the DSNTIJIC install job to take a full image copy of the DB2 catalog and directory.
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
Roosevelt
I passed the exam today with 9xx. Dump is valid.
Younan
Passed this exam with a score of 941.Most of them are in this dumps.
Kevin
The Dumb is valid 100%.
Ziaul huque
This study material is very useful and effective, if you have not much time to prepare for your exam, this study material is your best choice.
Marlin Erick
I studied this dumps, took some online trainings. At last I pass my exam today.
Branden
I passed. Good luck to you.
Anna
Passed exam today with 989/1000. All questions were from this dumps. It's 100% valid. Special thanks to my friend Lily.
Karel
passed the exam today. all the question from this dumps,so you can trust on it.
zel
I'm so happy that I passed exam this week. Thanks for this study material and my friend's recommendation.
Jack
This dumps is still valid. Just took my CCNA today and passed it. Every question i got on the test was in the dumps.
The following table comprehensively analyzes the quality and value of IBM Certified System Administrator C2090-317 exam materials.