Use the COMPUTE_QUOTA environment option to allow the optimizer to use only one CPU VP (virtual processor) on each coserver for each query operator instead of using all CPU VPs of each coserver.
To turn on this environment option, execute the following statement:
SET ENVIRONMENT COMPUTE_QUOTA ONEnterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]