What does the monitor element POOL_FAILED_ASYNC_TEMP_COL_REQS track?
What does the monitor element POOL_FAILED_ASYNC_TEMP_COL_REQS track?
Which command would be used to finish a rolling FixPack update to a two member DB2 pureScale cluster?
Which command would be used to finish a rolling FixPack update to a two member DB2 pureScale
cluster?
What is a DB2 Advanced Copy Services (ACS) script used for?
What is a DB2 Advanced Copy Services (ACS) script used for?
Which two HADR synchronization modes are supported in DB2 10.5 pureScale environments?
Which two HADR synchronization modes are supported in DB2 10.5 pureScale environments?
Which statement about Explicit Hierarchical Locking (EHL) for DB2 pureScale is true?
Which statement about Explicit Hierarchical Locking (EHL) for DB2 pureScale is true?
What will cause the creation of a column-organized table to fail?
What will cause the creation of a column-organized table to fail?
Which statement about expression-based indexes is true?
Which statement about expression-based indexes is true?
which type of database are column-organized tables supported?
In which type of database are column-organized tables supported?
Which command will create a statistics profile on the EMPLOYEE table?
An expression-based index named EMPJND1 and a statistical view named EMP_IND1_V have
been created for a table named EMPLOYEE.
If the following command is used to set up a statistics profile on the statistical view EMP_IND1_V:
RUNSTATS ON VIEW emp_ind1_v WITH DISTRIBUTION DEFAULT UM_FREQVALUES 50 SET
PROFILE ONLY
Which command will create a statistics profile on the EMPLOYEE table?
When does space reclamation for a column-organized table normally occur?
When does space reclamation for a column-organized table normally occur?