For reasons of performance and storage, and with regard to the amount of data to be processed, you may want to limit the resources available for a database query. This description assumes that you have selected option Q from the "Database Maintenance Menu" to enter a Beta Query Language (BQL) command online. In the "Database Query" panel you have set the Resources Limit parameter to YES. When you press ENTER, the "Generic Command Interface - Resources Limitation" panel is displayed:
PEB5DQ01 --------------------------------------------------------------------- Command ===> _________________________________________________________________ Generic Command Interface - Resources Limitation Ssid : B93P Primary space for allocation of temporary dataset : Space ===> 50.. (0 - 2000 Cylinders) Memory used in address space : Memory ===> 10.. (0 - 2000 MBytes) Press the ENTER key to issue the request. Press the END key to return to the previous panel. |
You can now specify the resources that are to be available for the database query.
|
Field |
Description |
|---|---|
|
Space |
Enter the space allocation of the temporary dataset used for data storage in cylinders. If you specify Space=0, then no temporary dataset is created. |
|
Memory |
Specify a memory amount in megabytes. The entry in this field cannot be changed if only one address space is available for all users. |
The default value size is 50 cylinders for a temporary dataset and 2 MB of central storage under VDF. The system administrator can use the LST parameters BQL_QRY_MAXMEMORY and BQL_QRY_FILESPACE to change both these values for the system. For a description of these parameters, see "Global LST parameters for BQL" in BSA Installation and System Guide.