Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

IBM C2090-318 Exam

Status: RETIRED
Certification Provider: IBM
Exam Name: DB2 12 System Administrator for z/OS
Duration: 90 Minutes
Number of questions in our database: 60
Exam Version: 02-12-2021
C2090-318 Exam Official Topics:
  • 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
Disscuss IBM C2090-318 Topics, Questions or Ask Anything Related

Currently there are no comments in this discussion, be the first to comment!

Free IBM C2090-318 Exam Actual Questions

The questions for C2090-318 were last updated On 02-12-2021

Question #1

In which phase of SMP/E processing is the DB2 software installed into the target libraries?

Reveal Solution Hide Solution
Correct Answer: B

Question #2

In order to install the RACF access control module for a DB2 subsystem, to which of the following modules should DSNTIJEX refer?

Reveal Solution Hide Solution
Question #3

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?

Reveal Solution Hide Solution
Question #4

Which one of the following buffer pool thresholds determines the percentage of the buffer pool that might be occupied by sequentially accessed pages?

Reveal Solution Hide Solution
Correct Answer: C

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/


Question #5

Which stored procedures need to be set up in order to register an XML schema?

Reveal Solution Hide Solution
Correct Answer: B

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.



Unlock all C2090-318 Exam Questions with Advanced Practice Test Features:
  • Select Question Types you want
  • Set your Desired Pass Percentage
  • Allocate Time (Hours : Minutes)
  • Create Multiple Practice tests with Limited Questions
  • Customer Support
Get Full Access Now

Save Cancel