QUESTION: 17

Which options are valid for an online reorganization operation?

FULL and RECLAIM EXTENTS
CLASSIC and RECLAIM EXTENTS
FULL and CLEANUP OVERFLOWS
CLEAN OVERFLOWS and RECLAIM EXTENTS

Answer(s): A

A DBA has observed that queries executed against SALES table have poor performance. DB2 tools have indicated that the level of data fragmentation in the SALES table is very high. Similar results were detected for indexes defined on the SALES table.

Which of the following commands should be used by the DBA to improve the performance of the queries run against the SALES table?

REORG TABLE sales AND INDEXES ALL;RUNSTATS ON TABLE sales AND INDEXES ALL;
REORG TABLE sales INPLACE;
REORG INDEXES ALL FOR TABLE sales;
RUNSTATS ON TABLE sales AND INDEXES ALL;
RUNSTATS ON TABLE sales AND INDEXES ALL;REORGCHK ON TABLE sales;
RUNSTATS ON TABLE sales INPLACE AND INDEXES ALL;

Answer(s): A

Reveal Solution Next Question

QUESTION: 19

Which of the following are valid Explain operators? (Choose two.)

CTQ
XSCAN
IXSCAN
SELECT
COLSCAN

Answer(s): B,C

Reference:

https://www.ibm.com/support/knowledgecenter/en/SSEPGG_9.7.0/com.ibm.db2.luw.admin.explain.doc/doc/r0052023.html

Reveal Solution Next Question

QUESTION: 20

Which is the correct way to back up only metadata about database backups, table space backups, and table load operations for database MYDB?

CONNECT TO mydb
PRUNE HISTORY TO /outdir
db2trc on –db mydb –m “backup,load”run the desired operations db2tc dump db2trc.dmp db2tc format db2tc.dmp db2tc.fmt db2tc off
BACKUP DATABASE mydb NO TABLESPACE TO /outdir
db2set DB2_BCKP_PAGE_VERIFICATION=TRUE must be issued first (no instance restart is needed). Run the desired operations.
Afterwards, issue db2trc dump <outfile>

Answer(s): B

Reveal Solution Next Question

Free C2090-600 Exam Braindumps (page: 6)

QUESTION: 17

QUESTION: 18

QUESTION: 19

Reference:

QUESTION: 20

C2090-600 Discussions & Posts