You analyze an accounting report. You see a high "NOT ACCOUNTED" time. Which two events can contribute to this high value? A. CPU wait time. B. I/O read wait time. C. Log write wait time. D. Real storage paging wait…
You want to convert a segmented table space into a partition-by-growth table space. You execute the following ALTER statement ALTER TABLESPACE DB1TS1 MAXPARTITIONS 5; What should be your next step? A. COPY the table space B. REORG the table space.…
Given the following output: DSNV4011 _DB2D DISPLAY THREAD REPORT FOLLOWS – DSNV402I _DB2D ACTIVE THREADS – NAME ST A REQ ID AUTHID PLAN ASID TOKEN DB2CALL T 17039 BBISS BBISS 00AF 19855 TSO T * 3 KSTTEST KSTTEST 0135 20172…
Consider a logical data model that includes an Employees entity and a Projects entity. In this model, employees work on many projects and projects are worked on by many employees. The Employees and Projects entity is considered what kind of…
In order to use a literal replacement for a dynamic SQL caching statement what must be true about the statement? A. It cannot be a join. B. The authids do not have to match. C. It must include more than…
When defining a check constraint on a populated table and the value of the special register CURRENT RULES is ‘DB2’. What is the result of executing the DDL statement? A. It is rejected by the database system. B. The table…
Which SQL statement can be used to create a data type that will represent possible speed limit values, with valid values not greater than 99, and to create a table that contains route numbers and the maximum speed limit for…
When would DB2 NOT use list prefetch? A. Fast log apply operations. B. Reading leaf pages of a disorganized index. C. RUNSTATS TABLESPACE without table sampling. D. Incremental image copies of a table space defined with TRACKMOD YES
Which DB2-supplied stored procedure captures statistics and DDL for DB2 objects, extracts subsystem parameters and explain information for queries and applications, and returns the results in a data set or as a result set? A. ADMIN_INFO_SQL B. ADMIN_JOB_QUERY C. ADMIN_INFO_SYSPARM…
What is required before you begin your installation of DB2 11? A. Data sets for catalog and directory tables must be user-managed. B. Data sets for only the catalog tables must be SMS-managed and include a data class for allocating…