Active IQ Unified Manager Discussions

WFA How to create reservations


Looking at WFA's existing commands with reservations I'm trying to understand what part of a SQL statement is supported in order to triggers or causes a reservation to ocurr. Can I use an UPDATE or does it have to be an INSERT? Also, what is the definition of a reservation? Is it a temporariy update to database until the data source updates it?



I'm trying to update the quota on an existing qtree or user. So I need to modify the value for cm_storage.qtree.disk_limit_mb or from my custom data source cm_user_quota.user_rule.disk_limit.



Reservation script in WFA commands can be treated as a way to simulate the effect of the particular command on the WFA cache. Since the commands effect can only be really seen after the next cache acquisition, reservation script is used till then. When the next cache acquisition occurs and the data is present in that(this validation is done using the Verification script), the reservation entry is removed. Yes, you are right, you can see reservations as a temporary update to cache until, cache acquisition occurs. You can use INSERT and UPDATE commands as necessary. For example, if you look at 'Create Volume' command's reservation script, you can see that there is an 'INSERT' statement to insert the entry into the 'volume' table. And an 'UPDATE' statement to update the 'used/available' space columns in 'aggregate' table.


Thank you. This clears it up.


Will there be a feature in future to allow the reservations to take place automagically based on the parameter mappings which you choose?

NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner