Exam Code : C100DBA
Exam Name : MongoDB Certified DBA Associate
Vendor Name :
"MongoDB"
C2090-317 Dumps
C2090-317 Braindumps C2090-317 Real Questions C2090-317 Practice Test C2090-317 Actual Questions
killexams.com
DB2 11 System Administrator for z/OS
https://killexams.com/pass4sure/exam-detail/C2090-317
A DDF thread with a token of 56 needs to be cancelled but due to a very tight processing loop in the thread, a regular cancel thread command might not work. What action(s) would provide the best chance to initially attempt to cancel this thread?
-CANCEL THREAD(56)
-CANCEL DDF THREAD(56) FORCE
-CANCEL THREAD(56)NOBACKOUT
-CANCEL DDF THREAD(56)
Reference:
http://www- 01.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/com.ibm.db2z10.doc.comref/src/tpc/ db2z_cmd_stopddf.dita
What is the minimum level of authority needed to use the DETAIL keyword on a - DISPLAY THREAD command?
DBADM
SYSADM
SYSOPR
SYSCTRL
Which information uniquely identifies a distributed thread?
The 'ID' field in the -DISPLAY THREAD output.
The 'REG' field in the -DISPLAY THREAD output.
The 'ASID' field in the -DISPLAY THREAD output.
The TOKEN' field in the -DISPLAY THREAD output.
Reference:
http://www- 01.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/com.ibm.db2z10.doc.comref/src/tpc/ db2z_cmd_cancelthread.dita(thread (token))
Which copy operation CANNOT be performed by DSN1COPY?
DB2 concurrent copies to DB2 VSAM data sets.
DB2 image copy data sets to DB2 VSAM data sets.
DB2 VSAM data sets to other DB2 VSAM data sets.
DSN1COPY sequential data sets to other sequential data sets.
Reference:
http://www- 01.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/com.ibm.db2z11.doc.ugref/src/tpc/d b2z_utl_dsn1copy.dita
For migration to DB2 11, we must implement the early code (ERLY). What DB2 library contains the early code for DB2?
prefix.SDSNLINK
prefix.SDSNEXIT
prefix.SDSNLOD2
prefix.SDSNLOAD
Reference:
http://www- 01.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/com.ibm.db2z11.doc.inst/src/tpc/db 2z_chooselinklistopts.dita
The statement cache table, DSN_STATEMENT_CACHE_TABLE. contains information about the SQL statements in the statement cache. Which SQL statement will NOT capture information from the DB2 dynamic statement cache into this table?
EXPLAIN STMTCACHE;
EXPLAIN STMTCACHE ALL;
EXPLAIN STMTCACHE STMTID integer;
EXPLAIN STMTCACHE STMTTOKEN string;
A z/OS Workload Manager (WLM) application environment must be created to enable which functionality in DB2?
Global dynamic SQL caching in the EDM pool
Service class assignments for dispatchable work in DB2
zllP redirect processing for enclave SRB workloads which are zllP redirect eligible
DB2 supplied routine SYSPROC.ADMIN_INFO_SYSPARM. which lists the settings of subsystem parameters
Which statement about the castout process in data sharing is true?
The castout process is initiated by the coupling facility.
The castout process is performed using BPO of the less active member of the group.
The castout process is performed by the first member to express write interest in the data set.
The castout process is performed using a private buffer pool in the first member to join the group.
What utility can benefit from the additional zllP (IBM System z Integrated Information Processor) enablement inDB2 11?
COPY
RUNSTATS
CHECK INDEX
MODIFY STATISTICS
Which z/OS or DB2 component is required for stored procedures that run in a WLM- established address space?
Call attachment facility
TSO attachment facility
Distributed data facility
Resource recovery services