You can manage a mixed workload in part by tuning sessions that run specific applications. To simplify resource management for mixed-use workloads, the database sever provides the following features:
In addition, you can use Informix I-Spy to trap queries submitted by specific users and perform various actions. For example, you might modify the query SQL code and then pass the query on for execution, or you might prevent the query from running and return an appropriate message to the user. I-Spy can also collect statistical information about queries so that you can analyze both the queries that a specific user runs and all queries.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]