This discussion is archived
3 Replies Latest reply: Jul 10, 2013 4:24 PM by user13040671 RSS

DBRM for IO rationing...when does IO rationing kick in

user13040671 Newbie
Currently Being Moderated

Hi,

For inter-db or for category IORM, we know to turn it on with "alter iormplan dbplan=<> catplan=<> "command.

For intra-database IO rationing, what are we supposed to be doing? Nothing but just turning the DBRM at the database level?

 

Reason I ask is:

Let's say, we turn it at the DB, using our RESOURCE_MANAGER_PLAN='MY_EXA_PLAN'

What happens to the IO requests for that DB? They automatically are rationed according to the directives in the 'MY_EXA_PLAN'?

 

Or should we turn it on using: ALTER IORMPLAN ACTIVE?

How, then, to turn the IO rationing OFF? Because I get this when trying to turn it off:

 

CellCLI> alter iormplan inactive

IORMPLAN status cannot be set to inactive

IORMPLAN successfully altered

 

Thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points