Controls how many invalid block-header messages are returned to the client or server log, relative to the number of level-0 blocks written to disk.
This setting does not apply to aggregate storage databases.
IBHFIXTHRESHOLD appName|xxxx dbName|xxxx percentage
appName | Optional parameter. If you supply an application name but use xxxx in place of dbName, the setting applies to all databases within the named application. If you use xxxx in place of appName and dbName, the setting applies to all applications and databases on the server.
|
dbName | Optional parameter. If you supply a database name and an application name, the setting applies only to the named database. If you use xxxx in place of dbName, the setting applies to all databases within the named application. If you supply a database name, you must also supply an application name.
|
xxxx
|
If used in place of appName, and dbName, specifies all databases on the Analytic server. If used in place of dbName, specifies all databases on the application. |
percentage | Percentage of invalid block-header errors to report, relative to the number of level-0 blocks on disk. Once the threshold is reached, a message is sent to the client requesting that the user rebuild the database, and the Analytic Server shuts down. Valid values are integers 0 to 100. |
You must set the server configuration setting IBHFIXTHRESHOLD in the server essbase.cfg file and restart Analytic Server before you can find and fix invalid block-header problems.
This setting controls how many invalid block-header messages are returned to the client or server log, relative to the number of level 0 blocks written to disk. After the threshold is reached, no corrective action can be performed, and a message is sent to the client suggesting that the database be rebuilt.
If messages are written to the client or server log indicating the presence of invalid block-header errors, but the threshold that requires the database be rebuilt is not reached, you can either rebuild the database or you can find and fix the errors using MaxL: alter database DBS-NAME validate data to local|server logfile FILE-NAME
.
IBHFIXTHRESHOLD sample basic 10
Specifies that on Sample Basic, if 10% of the data blocks have invalid block-header errors, it is time to rebuild the database.
IBHFIXTHRESHOLD sample xxxx 15
Specifies that for any database in the Sample application, if 15% of the data blocks have invalid block-header errors, it is time to rebuild the database.
IBHFIXTHRESHOLD xxxx xxxx 5
Specifies that for any database, if 5% of the data blocks have invalid block-header errors, it is time to rebuild the database.
alter database (MaxL statement)
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |