READ Free Dumps For IBM- C2090-612
Question ID 20474 | You take image copies ofyour table spaces every night. Since you cannot afford any data |
Option A | Every FLASHCOPY generated with SHRLEVEL CHANGE will automatically be consistent. |
Option B | If you use the generated SHRLEVEL CHANGE option with RECOVER .. TOCOPY later on, DB2 determines the open URs and backs them out so that in the end your data will be consistent. |
Option C | You can use keywords FLASHCOPY CONSISTENT to generate consistent flashcopy image copies with SHRLEVEL CHANGE. Sequential copies generated during the same utility execution will be inconsistent. |
Option D | You can use keywords FLASHCOPY CONSISTENT to generate consistent flashcopy image copies with SHRLEVEL CHANGE. Sequential copies generated during the same utility execution will also be consistent. |
Correct Answer | D |
Question ID 20475 | In determining whether a REORG on an index space would improve performance, which |
Option A | Column CLUSTERING in SYSIBM.SYSINDEXES |
Option B | Column LEAFDIST in SYSIBM.SYSINDEXPART |
Option C | Column CLUSTERRATIOF in SYSIBM.SYSINDEXES |
Option D | Column LASTUSED in SYSIBM.SYSINDEXSPACESTATS |
Option E | Column LASTUSED in SYSIBM.SYSINDEXSPACESTATS |
Correct Answer | A,D |