You are examining the existing IORM configuration on the cells of Database Machine, to see if
they require my modifications based on recent changes to various workloads.
All seven cells in your X3-2 half-rack shown the following:
Which two are true about I/O to the cells using this plan?
A.
I/O requests in the batch category may use flashcache if the I/O is from the sales finance
database, and these I/O requests are guaranteed to get 80% of the I/O if the interactive category
I/Os use no more than 20%.
B.
I/O requests made by sessions in the marketing database may use flashing and flashcache if
no other categories or database or database are using flashing and flashcache at the same time.
C.
I/O requested in the interactive category may use flashdns if the I/O is from the sales or finance
databases, and these I/O requests are guaranteed to get 90% of the I/O if the enough I/Os are
issued in this category.
D.
I/O requests from the sales database may use flashing regardless of the I/O category.
E.
No I/Os in any category or from any database may use flashing or flashcache because the
objective is off.
Explanation:
list iormplan detail
Note:
*The I/O Resource Manager (IORM) extends the concept of resource groups with a new attribute
known as a category. While resource groups allow DBRM to manage resources within a a
database, categories provide I/O resource management among multiple databases.
*cellcli> alter iormplan objective=’balanced’
— {balanced | off | low_latency | high_throughput | auto
“off” simply turns off the IORM plan’s IO metering.
D and E are contradictions of each other. B is incorrect. E is incorrect. D is correct. So A or C one must be right, I’m not sure which.
A and D
d e
C&D
I like C D
A is wrong. batch category is level 2 90%. it won’t be guaranteed 80%. it is remaining 80%. so in this case, it is 64%.
B is wrong. Marketing is other DB, which no flashcache and no flash log.
C is right. for interactive category, 90%, in total. and if from sales and finance DB, flash cache is on.
D is right. flash cache is DB related.
E is wrong. plan is active.
So C.D. are correct.
objective=off disables iormplan so….E is wrong
With X4, when objective is set to off:
CellCLI> alter iormplan objective=off
IORMPLAN objective ‘off’ is deprecated. Setting objective to ‘basic’
IORMPLAN successfully altered
So according to this
With X4, when objective is set to off:
CellCLI> alter iormplan objective=off
IORMPLAN objective ‘off’ is deprecated. Setting objective to ‘basic’
IORMPLAN successfully altered
if it is set to basic the iormplan does not consider what you have defined in the dbplan and cat plan.
Besides the flash cache and flash logs is always available withour a iormplan definition so E is still wrong.
A&D are rigth. A because “there is not iormplan” since it is set to basic. D because for the same reason all databases can use flashcache
Anyone has a testking updated and reviewed?
So many answers . which one is the correct one
CD L. Zhu explanation is perfect.