← Back to exam page

C2090-312 – IBM DB2 11 DBA for z/OS

Loading demo links...

Showing 4–6 of 7 questions

Question 4

Which technique can be utilized for the reporting of real-time statistics?

Select an option, then click Submit answer.

  • ○

    Call stored procedure SYSPROC. DSNACCOX.
  • ○

    Call stored procedure SYSPROC. ADMINJNFOJHOST.
  • ○

    Query the SYSI BM.SYSTABSTATS system catalog tablE.

  • ○

    Query the SYSIBM.SYSTABLES_PROFILES system catalog tablE.

Question 5

As part of a health check, it is determined that the statistics feedback should be externalized more frequently. Optimizer statistics recommendations can be immediately externalized to the DB2 catalog by performing what action?

Select an option, then click Submit answer.

  • ○

    Issue the ACCESS command with appropriate keywords.
  • ○

    Issue the ARCHIVE command with the appropriate keywords.
  • ○

    Issue the STOP command for the appropriate set of statistics.
  • ○

    Issue the ALTER command with the appropriate memory location.
Question 6

What subsystem parameter in DDF specifies the maximum number of inactive or new connections queued that can be waiting for a DBAT to process the request?

Select an option, then click Submit answer.

  • ○

    IDTHTOIN

  • ○

    MAXDBAT

  • ○

    CONDBAT
  • ○

    MAXCONQN