An active partitioned instance named DB2INST1 uses the following db2nodes.cfg file:
1 server1 0
2 server1 1
3 server1 2
4 server1 3
The following command is issued to add a new database partition:
db2start DBPARTITIONNUM 5 ADD DBPARTITIONNUM HOSTNAME server1 PORT 4
Upon successful completion of the db2start command, which statement is true regarding the status of the instance DB2INST1?

• A. Partitions 1, 2, 3, and 4 are active, but partition 5 is not.
• B. All partitions are active but partition 5 is not available until a temporary table space is defined.
• C. DB2 responds to the configuration change by stopping all partitions.
• D. Partitions 1, 2, 3, 4, and 5 are active and available.

Which description is correct when discussing the DB2_MEM_TUNING_RANGE registry variable?

• A. It is recommended that this variable be enabled at all times in order to prevent DB2 from taking too much physical memory.
• B. It is recommended to set this variable only when the Self-Tuning Memory Manager (STMM) is disabled.
• C. It is recommended to set this variable only when using STMM, when DATABASE_MEMORY is set to AUTOMATIC, and if insufficient system memory problems are occurring.
• D. It is recommended that this variable be used to set the maximum percentage of memory that DB2 can use on the system.

A batch application updates a large number of rows within a single transaction. What is one way to help the application complete quickly?

• A. Increase the group commit count.
• B. Increase the size of the lock list.
• C. Code the application to issue a LOCK ROW statement.
• D. Code the application to issue a LOCK TABLE statement.

The DBA needs to create a table with key columns YEARDAY, YEAR, and DAY. This table needs to be partitioned by column YEARDAY with three months per data partition. Additionally, data needs to be organized so that all rows within any three month date range are clustered together based on 12 months of data. Which CREATE TABLE statement will accomplish this objective?

• A. CREATE TABLE tab1
  (yearday INT,
  year CHAR(2),
  day INT))
  PARTITION BY RANGE (yearday) (STARTING 201001 ENDING 201012 EVERY 3)
  ORGANIZE BY DIMENSIONS (year, day))
• B. CREATE TABLE tab1
  (yearday INT,
  year CHAR(2),
  day INT))
  PARTITION BY RANGE (yearday) (STARTING 201001 ENDING 201012 EVERY 3)
  ORGANIZE BY DIMENSIONS (year))
• C. CREATE TABLE tab1
  (yearday INT,
  year CHAR(2),
  day INT))
  PARTITION BY RANGE (year) (STARTING 201001 ENDING 201012 EVERY 3)
  ORGANIZE BY DIMENSIONS (year, day))
• D. CREATE TABLE tab1
  (yearday INT,
  year CHAR(2),
  day INT))
  PARTITION BY RANGE (yearday) (STARTING 201001 ENDING 201012 EVERY 3)
  ORGANIZE BY DIMENSIONS (day))

What are the steps required to remove July 2005 data from a partitioned table and replace with it with July 2010 data?

• A. 1) Detach partition containing July 2005 data 2) Load July 2010 data into a new table 3) Attach the new table as a new partition in the existing partitioned table 4) Update statistics on the partitioned table
• B. 1) Detach partition containing July 2005 data 2) Load July 2010 data into a new table 3) Attach the new table as a new partition in the existing partitioned table 4) Rebind the partitioned table
• C. 1) Detach partition containing July 2005 data 2) Load July 2010 data into a new table 3) Attach the new table as a new partition in the existing partitioned table 4) Check constraint integrity for the partitioned table
• D. 1) Detach partition containing July 2005 data 2) Load July 2010 data into a new table 3) Attach the new table as a new partition in the existing partitioned table 4) Reorg the partitioned table