Which two are true about I/O to the cells using this plan?

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?

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.



Leave a Reply 11

Your email address will not be published. Required fields are marked *


Miles

Miles

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.

L. Zhu

L. Zhu

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.

antonio

antonio

objective=off disables iormplan so….E is wrong

Syed Jaffer Hussain

Syed Jaffer Hussain

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

antonio

antonio

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?

hisham

hisham

So many answers . which one is the correct one

max

max

CD L. Zhu explanation is perfect.