Free Preparation Discussions
MENU
IBM C2090-318 Exam Questions
- Topic 1: Describe role-based security and the advantage of deploying it/ Identify additional environments necessary
- Topic 2: Perform DB2 data sharing system operation and maintenance/ Describe use cases for program authorization, row and column access control
- Topic 3: Given a scenario, identify and resolve DB2 data sharing problems/ Evaluate appropriate subsystem parameter settings
- Topic 4: Identify the distributed thread that is causing a problem/ Given a scenario, describe the installation/migration plan
- Topic 5: Describe DB2 commands and traces for troubleshooting/ Given a scenario, describe how to monitor and control DB2 threads
- Topic 6: Describe Reorg in the context of system tuning and performance/ Describe how to manage DB2 components and processes
- Topic 7: Demonstrate the ability to use statistics, tools, and traces for monitoring/ Describe the concept of ownership in DB2 and how ownership can be transferred
- Topic 8: Given a scenario, describe which documentation can be used to solve a problem/ Demonstrate ability to execute DB2 commands
- Topic 9: Describe usage scenarios for diagnostic utilities/ Describe how to protect the DB2 subsystem using appropriate system authorities and external security means
- Topic 10: Describe the fundamental considerations of disaster recovery/ Describe how buffer pools and system parameters can affect performance/concurrency
Free IBM C2090-318 Exam Actual Questions
Note: Premium Questions for C2090-318 were last updated On 02-12-2021 (see below)
In which phase of SMP/E processing is the DB2 software installed into the target libraries?
In order to install the RACF access control module for a DB2 subsystem, to which of the following modules should DSNTIJEX refer?
A down level page set is identified by the following error message:
DSNB232I UNEXPECTED DATA SET LEVEL ID ENCOUNTERED
Which of the following should be performed to correct the condition?
Which one of the following buffer pool thresholds determines the percentage of the buffer pool that might be occupied by sequentially accessed pages?
Sequential Steal Threshold (VPSEQT) -- The percentage of pages that can be used for prefetch. Default is 70%. For pools with mostly sequential access, you can set this value as high as 100. For pools with mostly random access, set this value very low. Review the prefetch failure statistics to determine if applications attempt to use sequential processing against the objects allocated in this pool.
https://www.bmc.com/blogs/db2-for-zos-buffer-pools-the-basics/
Which stored procedures need to be set up in order to register an XML schema?
https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.xml.doc/doc/c0022711.html
When a database is created, the stored procedures used to register XML schemas are also created. To register XML schemas through the stored procedure method, invoke the XSR_REGISTER, XSR_ADDSCHEMADOC and XSR_COMPLETE stored procedures with the CALL statement.
- Select Question Types you want
- Set your Desired Pass Percentage
- Allocate Time (Hours : Minutes)
- Create Multiple Practice tests with Limited Questions
- Customer Support
Currently there are no comments in this discussion, be the first to comment!