Use settings on the Batch Process tab to customize QAD BI in the following areas:
• Improve performance.
• Allow concurrent access to the data warehouse while the batch is run. • Use the Progress-supplied database server administration.
• Use custom scripts (batch files) to start and stop the data warehouse.
Fig. 1.55
Application Settings, Batch Process Tab
Database. Enter or browse to the location of the data warehouse file. By default, this is the dwh.db file in the directory where QAD BI is installed.
Repository. Enter or Browse to the location of the data warehouse repository. By default, this is the dwh-admin.db file in the directory where QAD BI is installed.
Database Management. Select the method to use to start and stop the data warehouse—Progress Explorer or Scripts. Depending on this setting, you can update the fields in the appropriate frame.
Single User Batch Process. Specify whether the data warehouse database is started in single-user mode when running the batch process. If selected, no other connections to the data warehouse are accepted until the batch process completes. This field is not available when parallel replication is selected on the AppServer tab—that is, the Use AppServer check box is selected.
Use non-integrity parameter. Specify whether the data warehouse is started in non-integrity mode. When this option is selected, Progress runs without using the database integrity or database recovery features.
Important Selecting this option can improve system performance. However, if Progress fails for any reason, you cannot recover the database. Use this feature with caution and make sure you have an adequate database backup strategy.
Log Language. Select the language in which the log information is written.
Log Level. Select the level of log information to be captured. Error: Displays functional errors
Warn: Displays activities that may cause errors, as well as errors Info: Displays trace of user activities, as well as errors and warnings
Debug: Displays debug information for developers, as well as errors and warnings
Log to DB. Specify whether to store log information in the administration database as well as write log files.
Note Whether or not you choose to log to the administration database, log files are always generated.
Start. If Database Management is Scripts, enter or browse to the appropriate script files that are used to start the data warehouse.
Stop. If Database Management is Scripts, enter or browse to the appropriate script files that are used to stop the data warehouse.
Database. Enter the data warehouse database name as defined in the Progress Explorer.
Host. Enter the Progress server defined in the Progress Explorer and assigned to manage the data warehouse.
Config. Enter the Progress Explorer Configuration to use to start and stop the data warehouse.
Port. Enter the port or service the data warehouse runs under. This is defined in the Progress Explorer Configuration.
User. Enter a user authorized to start and stop the data warehouse.
Password. Enter the password of the user authorized to start and stop the data warehouse.
AppServer
The AppServer tab includes the AppServer configuration information when parallel replication is used. For more details on parallel replication, see “QAD BI Parallel Replication Setup” on page 178.
Note When serial replication is used, all the fields under the AppServer tab are disabled.
Fig. 1.56
Application Settings, AppServer Tab
AppService. Enter the name of the AppServer broker. This is the same value that appears in the Progress Explorer tree under the AppServer folder. Also referred to as the AppServer name.
AppServer Host. Enter the name of the server where the AppServer has been installed.
NameServer Port. Specify the port to which the NameServer has been configured to listen. The default is 5162.
Pool Size of Script. Specify the number of AppServer processes that will be available to execute scripts. Four is a good starting value for testing. The value entered here must be one less than the value of the Minimum and Maximum Servers settings on the AppServer
properties screen. See “QAD BI Parallel Replication Setup” on page 178 for details.
Pool Size of Cube. Specify the number of AppServer processes that will be available to generate cubes. Four is a good starting value for testing. The value entered here must be one less than the value of the Minimum and Maximum Servers settings on the AppServer
properties screen. See “QAD BI Parallel Replication Setup” on page 178 for details.
Note Do not set this value too high. Entering a value that is too large can reduce performance on hardware that is insufficient to handle the processing load.
DWH-ADMIN Host. Specify the name of the server where the administration database is running.
DWH-ADMIN Service. Specify the port to which the administration database is configured to listen. The default is 24001.
DWH-ADMIN Network. Specify the protocol that the administration database is configured to use for communication. Default is TCP.
AppServer Log Directory. Specify the directory to which all log files will be written.
AppServer Error Log. Specify the name of the AppServer error log.
AppServer Replication Log. Specify the name of the AppServer replication log.
For additional information on using parallel replication with Data Transformer, see “QAD BI Parallel Replication Setup” on page 178.