Solutions

• Question 1:
  The correct answers are 2 and 3. When you set the instance aggregated registry variable DB2_WORKLOAD=ANALYTICS, all databases created with this setting in place will have the following parameters:
  • Degree of parallelism (DFT_DEGREE) = ANY
  • Default tablespace extent size (pages) (DFT_EXTENT_SZ) = 4
  • Default table organization (DFT_TABLE_ORG) = COLUMN
  • Database page size = 32768
• Question 2:
  The correct answers are 1 and 3.
  The database cluster health check is made easier with one single command, db2cluster -verify, checking:
  
  • Configuration settings in the peer domain and GPFS cluster
  • Communication between members and CFs
  • The replication setting for each filesystem
  • The status of each disk in the filesystem
  • Remote access with db2sshid among all nodes through db2locssh and db2scp

• The cluster command db2cluster -list returns details about the following:

  • -tiebreaker...