which table, is causing heavy utilization of the disk process?
ViewSys indicates that a processor is 95% busy. Measure shows that a disk process ($DB451) is
utilizing 70% of this processor. Which Measure entity and counters would you use to determine
which process, accessing which table, is causing heavy utilization of the disk process?
When is the data removed from the row?
A column is dropped from a TABLE using ALTER TABLE. When is the data removed from the
row?
Which SQL object alters the standard ASCII sort order?
Which SQL object alters the standard ASCII sort order?
Use of the SQL compile options CHECK INVALID PLANS, RECOMPILEONDEMAND ensures that when the program runs state
The objects accessed by a particular program have been created with SIMILARITY CHECK
enabled. Use of the SQL compile options CHECK INVALID PLANS, RECOMPILEONDEMAND
ensures that when the program runs statements that _______.