IBM C2090-317 Online Practice Questions and Exam Preparation

IBM C2090-317 Online Questions & Answers

• Question 31:

  Which combination of subsystem parameter values will enable connection pooling for idle distributed database access threads?

  A. Specify subsystem parameter CMTSTAT = ACTIVE and set CONDBAT = MAXDBAT.
  B. Specify subsystem parameter CMTSTAT = INACTIVE and set CONDBAT < MAXDBAT.
  C. Specify subsystem parameter CMTSTAT = ACTIVE and set CONDBAT > MAXDBAT.
  D. Specify subsystem parameter CMTSTAT = INACTIVE and set CONDBAT >MAXDBAT.
  C. Specify subsystem parameter CMTSTAT = ACTIVE and set CONDBAT > MAXDBAT.

• Question 32:

  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
  A. Call attachment facility

• Question 33:

  When might image copies be needed in a data mirroring environment during disaster recovery?

  A. To resolve outstanding units of recovery.
  B. If the RBA in the BSDS is higher than the RBA in the active log.
  C. Image copies would never be needed when using data mirroring.
  D. If a LOAD or RECOVER utility was active at the time of the disaster.
  A. To resolve outstanding units of recovery.

• Question 34:

  A member of a data sharing group is suffering from elongated response times. You suspect that sysplex workload balancing (WLB) is not working properly for the DDF work (not evenly distributing the work among the different members). What is the simplest way to verify how the DDF threads are distributed amongst the different members?

  A. Execute the-DIS GROUP command.
  B. Execute the -DIS DDF DETAIL command on each member.
  C. Execute the -DIS THDO DETAIL SCOPE(GROUP) command.
  D. Executed the -DIS LOCATION(') DETAIL command on each member.
  B. Execute the -DIS DDF DETAIL command on each member.

• Question 35:

  What will occur if the parameter PAGE PROTECT is set to YES?

  A. MSTR log buffers (OUTBUFF) will be placed in page-protected storage.
  B. IRLM is to load its common storage modules into page-protected storage.
  C. DIST buffers related to TCPIP connectivity are loaded into page-protected storage.
  D. DBM1 pages belonging to a buffer pool defined with PGFIX(YES) will be placed in page- protected
  D. DBM1 pages belonging to a buffer pool defined with PGFIX(YES) will be placed in page- protected

• Question 36:

  Which DB2 system table can limit the amount of resources that can be consumed based on client or IP address of the client?

  A. SYSIBM.IPLIST
  B. SYSIBM.IPNAMES
  C. SYSIBM.DSNRLST01
  D. SYSIBM.DSNRLMT01
  D. SYSIBM.DSNRLMT01

• Question 37:

  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?

  A. EXPLAIN STMTCACHE;
  B. EXPLAIN STMTCACHE ALL;
  C. EXPLAIN STMTCACHE STMTID integer;
  D. EXPLAIN STMTCACHE STMTTOKEN string;
  A. EXPLAIN STMTCACHE;

• Question 38:

  A z/OS Workload Manager (WLM) application environment must be created to enable which functionality in DB2?

  A. Global dynamic SQL caching in the EDM pool
  B. Service class assignments for dispatchable work in DB2
  C. zllP redirect processing for enclave SRB workloads which are zllP redirect eligible
  D. DB2 supplied routine SYSPROC.ADMIN_INFO_SYSPARM. which lists the settings of subsystem parameters
  A. Global dynamic SQL caching in the EDM pool

• Question 39:

  Which command can be used to adjust the system checkpoint frequency?

  A. -SET LOG
  B. -SET ARCHIVE
  C. -ARCHIVE LOG
  D. -RECOVER BSDS
  A. -SET LOG

• Question 40:

  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.
  A. Gaps may exist.