Note:
The 
button above the table
in detail-view allows switching from regular layout of the tables to expert
layout. Expert layout will list also list Adabas nucleus parameters ADARUN for
mainframe databases and ADANUC for open systems databases.
To review the parameter settings for an
Adabas database:
Select an Adabas database in tree-view and expand it.
Select Active Parameters in tree-view.
The Active Parameters for the database are displayed in tables in detail-view:
Pools and Queues
Time Limits
Logging
Options
User Exits to be Used (for open systems databases only)
Note:
The sections in the table can be collapsed and expanded by clicking
the arrow in the section heading.
The information is organized under the following headings:
When Active Parameters is selected in tree-view, the following table is displayed in detail-view:
Pools and Queues
Time Limits
Logging
Options
The meaning of ON/OFF options in the Logging section of the active parameters panel are explained in the following table:
| Parameter | Action |
|---|---|
| Command Logging | Enable command logging. |
| Log Adabas Control Block | Enable Adabas control block logging. |
| Log Format Buffer | Enable format buffer logging. |
| Log Record Buffer | Enable record buffer logging. |
| Log Search Buffer | Enable search buffer logging. |
| Log Value Buffer | Enable value buffer logging. |
| Log ISN Buffer | Enable ISN buffer logging. |
| Log I/O Activity | Enable I/O activity logging. |
| Log User Exit B Data | Log User Exit B data (only available if CLOGLAYOUT=5 (the default) is also used). |
| Merge Cluster Command Logs automatically | Enable automatic merging of cluster command logs. |
The meaning of ON/OFF options in the Options section of the active parameters panel are explained in the following table:
| Parameter | Action |
|---|---|
| Log AOS/DBS Update | Log commands that update the active nucleus coming from AOS or ADADBS. |
| Batch Support | Enable batch support. |
| Async. by Vol-Ser | Flush buffers asynchronously based on volume serial number. |
| Cache Facility | Enable support for Dynamic Caching. |
| Delta Save Facility | Enable support for the Delta Save Facility. |
| Resource Manager | Enable distributed transaction processing as a resource manager with other resource managers (databases) coordinated by a transaction manager. |
| Transaction Manager | Enable distributed transaction processing as a transaction manager. |
| Ignore DIB Entry | Ignore and delete an existing data integrity block (DIB) entry in the Associator and initiate a new session. |
| Ignore Work Part 4 | Ignore data related to the recovery of previously incomplete transactions that resides in the two-phase commit area (Work part 4) and start the nucleus anyway. For emergency use only: contact your Software AG technical support center before using. |
| LOCAL Nucleus | Restrict a nucleus to local use only (no connection to other Entire Net-Work nodes). |
| Non-DE Search | Restrict searches to descriptors only in search buffers (no searches on nondescriptors). |
| OPEN Required | Require an OPEN command as the first command of a user session. |
| Read-Only Session | Restrict a database session to reading data only (no updates allowed). |
| Ext. Error Recovery | Enable extended error handling and message buffering. |
| Triggers and Procedures | Enable use of triggers and stored procedures. |
| UTI-only Session | Restrict a database session to running utilities only. |
| TCP/IP Access Control | Enable a direct TCP/IP link to the Adabas nucleus (UES-enabled databases only). |
| 64 Bit Support | Enable 64 Bit support. |
| Large Page Support | Enable Large Page Support. |
To modify the parameter settings for an
Adabas mainframe database:
Click .
The parameter tables are displayed. Where settings can be modified, text boxes allow you to enter the required values; where options can be selected, check boxes can be marked.
The following parameter values can be modified:
Sort Area
Int. User Buffer
Parallel LFIOP I/O
Hold Queue Limit
Active Command IDs per User
ISN per TBI Element
Command Time
Bufferflush Duration
Time Limit Sx-Commands
Nonactivity ACC-User
Nonactivity ET-User
Nonactivity EXU-User
Transaction Time
The following parameters can be set:
Command Logging
Log Adabas Control Block
Log Format Buffer
Log Record Buffer
Log Search Buffer
Log Value Buffer
Log ISN Buffer
Log I/O Activity
Log User Exit B Data
Merge Cluster Command Logs automatically
The following options can be checked:
Log AOS/DBS Update
Batch Support
Async by Vol-Ser (the default is )
Read-Only Session
UTI-Only Session
For detailed information about ADARUN parameters and their possible values, see ADARUN Control Statement in the Adabas Operations documentation.
Modify the settings in the table as required and click to confirm your changes and to return to the Active Parameters display.
When Active Parameters is selected in tree-view, the following table is displayed in detail-view:
Pools and Queues
Time Limits
Logging
Options
User Exits to be Used
Note:
A dropdown menu allos the user to alternate the display between the
current and the default parameters.
The meaning of ON/OFF options in the Logging section of the active parameters panel are explained in the following table:
| Parameter | Action |
|---|---|
| Log Adabas Control Block | Enable Adabas control block logging. |
| Log Format Buffer | Enable format buffer logging. |
| Log Record Buffer | Enable record buffer logging. |
| Log Search Buffer | Enable search buffer logging. |
| Log Value Buffer | Enable value buffer logging. |
| Log ISN Buffer | Enable ISN buffer logging. |
| Log I/O Activity | Enable I/O activity logging. |
| Log Buffer Description | Enable buffer description logging. |
| Command Log Layout | New CLOG Layout |
| Protection Log required | Indicates whether a protection log is required for this session (the default is ). |
The meaning of ON/OFF options in the Options section of the active parameters panel are explained in the following table:
| Parameter | Action |
|---|---|
| Truncation | Enable truncation of alphanumeric field values. |
| Utilities Only | If this is enabled, all non-utility calls are rejected and the DBA has exclusive control over all database files. |
| Local Utilities | If Local Utilities is
enabled, remote utilities cannot be executed.
|
| Open Required | If Open Required is
enabled, an open (OP) command must be issued as the first command of a user
session. This option should be set if lnk_set_adabas_id is used when calling
Adabas from application servers, and also when using Net-Work, otherwise in
these cases Adabas cannot guarantee transaction integrity following an ADANUC
restart.
|
| Fault Tolerant AR | When Fault Tolerant AR is
enabled, the nucleus behaviour in the event of an Adabas
error during autorestart can be controlled. If an error occurs
for a given file, a detailed entry is made in the nucleus log, but the
autorestart continues. When the autorestart completes, the DBA can restore and
regenerate the file by using ADABCK RESTORE and ADAREC REGENERATE for the
affected file. If however the error occurred for the index of a file, it is
sufficient to rebuild the file's index by using the REINVERT function of
ADAINV. If Fault Tolerant AR is not selected,
Adabas aborts an autorestart if an error is
detected, and this can cause the database to be in an inconsistent state.
Note: |
| Autorestart Only | The AUTORESTART_ONLY keyword shuts down the nucleus immediately after its startup sequence has completed. If an autorestart is pending, the autorestart will be performed. No user commands or utility calls will be accepted by the nucleus. |
| Read Only | The READONLY option causes ADANUC to run in read-only mode. Refer to the Adabas for Open Systems Administration documentation for more details. |
| XA | The keyword XA indicates that the server will support distributed transaction processing according to the X/Open XA specification. If the Adabas XA interface is to be used by an application, OPTION=XA must be used. See XA Support in the Adabas for Open Systems Administration documentation for further information. |
| Auto Expand | Enable auto expand when the database becomes full. You can specify reserved and temporary locations for database auto expand by right-clicking the database name and selecting in the dropdown menu. For detailed information see the Adabas Extended Operation documentation. |
| Write Before Image to PLOG | Enable Write Before Image to
PLOG.
|
| Behaviour on Conflict During AUTORESTART | If is enabled, the autorestart will continue even in case of a conflict (the default is ). |
For more information on the nucleus parameters see the Adabas Open Systems Utilities documentation.
To modify the parameter settings for an
Adabas open systems database:
Click .
The parameter tables are displayed. Where settings can be modified, text boxes allow you to enter the required values; where options can be selected, check boxes can be marked.
The following parameter values can be modified:
Number of Threads
User Queue
Hold Queue Limit
Group Commits Limit
Number of Client Threads Elements
Max. Usage of Buffer Pool Before Flushed to Disk
Attached Buffer Length
Attached Buffer Length Extended
Buffer Pool
Work Pool
XA Area Limit
Parallel I/O Request Limit
Parallel Records Read Limit
Parallel Blocks Read Limit
Parallel Total Read Limit
Nonactivity ACC-User
Nonactivity ET-User
Nonactivity EU-User
Transaction Time
The following parameters can be set:
Log Adabas Control Block
Log Format Buffer
Log Record Buffer
Log Search Buffer
Log Value Buffer
Log ISN Buffer
Log Fault Tolerant Auto Activity
Log I/O Activity
Log Buffer Description
Maximum Command Log Size
Command Log Layout (New CLOG Layout)
Protection Log Required (the default is )
The following options can be checked:
Utilities Only
Local Utilities
Open Required
Fault Tolerant AR
Autorestart Only
Read Only
XA
Auto Expand
Write Before Image to PLOG (the default is )
Behaviour on Conflict During AUTORESTART (the default is )
User exits can be activated or deactivated as required.
Modify the settings in the table as required and click to confirm your changes and to return to the Active Parameters display.
To display the environment extensions for an
Adabas database:
Select an Adabas database in tree-view and expand it.
Right-click Active Parameters in tree-view and choose in the dropdown menu.
The Environment Extensions for the database are displayed in detail-view.
To add extensions, click .
Enter name and value of the extensions as required and click to confirm your settings.
To add an action user:
Select an Adabas database in tree-view and expand it.
Right-click Active Parameters in tree-view and choose in the dropdown menu.
The Add Action User panel is displayed in detail-view.
Enter the user name and click to confirm your settings.
To display the node parameters for an
Adabas database:
Select an Adabas database in tree-view and expand it.
Right-click Active Parameters in tree-view and choose in the dropdown menu.
The Node Parameters for the database are displayed in detail-view:
Adabas Operations
Logging
Archive Log Files
Alerts
In the table you can activate/deactivate and enable/disable these parameters according to your requirements and browse to the locations where the reports should be written to.
Click to save your new settings.
To display the database actions for an
Adabas database:
Select an Adabas database in tree-view and expand it.
Right-click Active Parameters in tree-view and choose in the dropdown menu.
The Database Actions for the database are displayed in detail-view:
Nucleus Startup
Nucleus Termination
Delete Checkpoints
Increase Size of ASSO
Increase Size of DATA
Increase Nucleus Parameter LBP
Increase Nucleus Parameter LS
Increase Nucleus Parameter LWP
Increase Nucleus Parameter NH
Increase Nucleus Parameter NT
Increase Nucleus Parameter NU
Observe Number of Offline Checkpoint
Recover Lost Blocks Required
Reorder File
Backup Database
Nucleus Termination Using 'adastop'
In the table you can enable or disable these parameters according to your requirements and browse to scripts you may wish to use.
Click to save your new settings.
