QRYGOVEXECBLK

Sets the maximum number of blocks that a query can access before the query is terminated.

This setting does not apply to aggregate storage databases.

Syntax

QRYGOVEXECBLK [appname [dbname]]

appname This optional parameter applies the query block limit to the application specified. If you specify appname, you must also specify a value for n, or Analytic Server ignores QRYGOVEXECBLK. If you do not specify an application, you cannot specify a database, and the query block limit applies to all applications and databases on the server. If you specify a value for appname and do not specify a value for dbname, the query time limit applies to all databases in the specified application.
dbname This optional parameter must be used with appname and n, or Analytic Server ignores QRYGOVEXECBLK. If you specify dbname, appname, and n, the query block limit is applied only to the specified database.
n The value of n specifies the number of blocks that Analytic Server allows a query to access before the query is terminated. You must specify this parameter or the server ignores QRYGOVEXECBLK. If you do not specify appname or dbname, the query block limit applies to the entire server.

Description

QRYGOVEXECBLK specifies the maximum number of blocks that a query can retrieve before Analytic Server terminates that query (a request for information sent to a database). You can apply this setting to an entire server, to all the databases in a single application, or to a single database.

When a query exceeds the block limit and is terminated, an error message is written to the application log of the application accessed for the query.

Restarting Analytic Server after adding or changing this setting activates the new setting values.

Use QRYGOVEXECBLK to prevent these types of queries:

Use QRYGOVEXECBLK, for example, if you have users who try to retrieve so much data in a single query that their query appears to hang for minutes at a time. A query launched against the database involving attribute dimensions, for example, may be larger than the user realizes.

Notes

Example

QRYGOVEXECBLK Sample Basic 3
Sets three blocks as the maximum number of blocks that a query to Sample Basic can access before being terminated. A block is created for each unique combination of sparse dimension members. If a user issues a query that accesses four unique combinations of sparse dimensions, Analytic Server terminates the query and writes a message to the application log.
QRYGOVEXECBLK 5
Sets five blocks as the maximum number of blocks that a query can access before being terminated. The query time limit applies to all applications and databases on Analytic Server that correspond to the essbase.cfg file containing this setting.

See Also

QRYGOVEXECTIME
HAMAXQUERYROWS
HAMAXQUERYTIME

For more information about the application log, see the Database Administrator's Guide.

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com