MASTER_CONTROL

Determines which Control server is the SARM server in the ASAP system.

Default = $MASTER_CONTROL

SYSMON_ALWAYS_ON

Boolean flag. If set to 1, activates system monitoring upon startup. Default = 0.

Default = $MASTER_CONTROL

SYSMON_LOG_ENABLED

Records work order logging information. This feature significantly increases the memory and CPU overhead.

Default = 0

SYSMON_DUMP_TRANSACTIONS

Dumps transaction details to a file. This feature significantly increases the memory and CPU overhead.

Default = 0

SYSMON_SHOW_DESCRIPTIONS

Shows descriptions of various sections of the generated report.

Default = 0

SYSMON_DELIMITED_OUTPUT

Generates ASCII formatted file (0) or comma-delimited spreadsheet file (1).

Default = 0

ASAP_DEVELOPMENT_MODE

Boolean flag. If set to 1, it is used during the development process to aid in debugging and tuning the system. It should be set to 0 in production environments.

Default = 0

CONNECT_TO_CTRL

Boolean flag. If set to 1, it instructs the client application to open a connection to the Control server to log system events.

Default = 1

CPM_OPTIMIZE_POOLS

Boolean flag. If set to 1, it enables auto-tuning of connection pools by the CPM. The algorithm that CPM_OPTIMIZE_POOLS uses does not guarantee that the oldest unused connection in the pool is closed first. This flag must not be used in a large scale production environment.

Default = 0

CORE_DEBUGGING

SARM

The logical name of the SARM server.

Default = $SARM

SRP_EMUL

The logical name of the SRP Emulator.

Default = $SRP_EMUL

APPL_USERID

The primary SQL Server user ID the application process uses to connect to the APPL_SQL_SERVER SQL Server. The user ID defaults to the primary application database, and therefore, the application does not need database names because the definition of the user in the SQL Server specifies that user's default database. Maximum length is 20 alphanumeric characters.

Default = $APPL_USER

APPL_SQL_SERVER

The SQL Server in which the primary application database resides. If you specify this, the database can reside on a separate SQL Server from other ASAP databases if required. Maximum length eight alphanumeric characters.

Default = $DSQUERY

CONTROL_USERID

The SQL Server user ID the application process uses to connect to the Control database in the CONTROL_SQL_SERVER SQL Server. Maximum length is 20 alphanumeric characters.

Default = $CTRL_USER

CONTROL_SQL_SERVER

The SQL Server where the Control database resides. If specified, the Control database can reside on a separate SQL Server from the application databases, if required. Maximum length is eight alphanumeric characters.

Default = $DSQUERY

RPC_ERROR_SLEEP

The time interval, in seconds, of the RPC retries when an error condition other than database deadlock is encountered (for example, transaction logs full). This time interval should be large enough to allow the system administrator time to determine the problem and resolve the problem between retries.

Default = 300

RPC_RETRY_COUNT

The number of times the RPC is retried by the RPC API functions. If after the number of retries the RPC is still unsuccessful, the calling function returns a failure condition, and the API issues a system event.

Default = 5

RPC_RETRY_SLEEP

The sleep interval, in seconds, for the RPC retries for the database deadlock condition.

Default = 1

RPC_SHOW_OUTGOING_PARAMS

N/A

Default = 1

MAX_CONN_PER_CONTEXT

The number of Client and Server (CS) library connections that may be opened per context. It may be specified if using a global context; that is, USE_GLOBAL_CONTEXT = 1.

Default = 25

MAX_CONNECT_RETRY

The maximum number of retry attempts an application will perform when attempting to asynchronously connect to a TCP/IP server using the UNIX connect() API call. These retries may be necessary as the application can be interrupted during the connection attempt. This parameter is generally not set to a value other than its default.

Default = 10

SOCK_REUSEADDR

Boolean flag. If set to 1, will set the re-use address TCP/IP option on a socket when acting as a TCP/IP socket listener.

Default = 1

USE_GLOBAL_CONTEXT

This specifies whether each Client (CT)-Library connection should use the global context or allocate a context for each connection. See also MAX_CONN_PER_CONTEXT.

Default = 0

CONNECT_ERROR_LOGGING

Boolean flag. If set to 1, causes applications to log messages to their diagnostic files upon unsuccessful connection attempts to servers.

Default = 0

DIAG_FILE_COUNT

When the current diagnostic file associated with an ASAP server reaches its maximum size (see MAX_DIAG_FILE), it creates a new current diagnostic file, and rolls over the old diagnostic file with a time stamped files. The DIAG_FILE_COUNT parameter specifies the number of time stamped diagnostic files to maintain in addition to the current file.

In addition, if the ASAP server or process associated with the diagnostic files stops and restarts, ASAP creates new time stamped files, keeping the old time stamped files without updating them.

Default = 1

DIAG_LINE_FLUSH

Boolean flag. Determines whether the diagnostic file output is flushed to disk at the end of each diagnostic line. If set to 0, the diagnostics are only flushed to the diagnostic file if a PROGRAM or SANITY level diagnostic message is written, or if the I/O buffer is flushed by the operating system. You can change this diagnostic parameter by either adjusting this configuration parameter or changing the diagnostic line flush flag of the application server by using the diag_line_flush() API RPC/Registered Procedure to the particular server.

Default = 0

This option should be set to 0 in a production environment because the option causes considerable performance overhead in disk activity.

MAX_DIAG_FILE

Application process diagnostic file size in megabytes. It is located in the $LOGDIR/yymmdd directory, where $LOGDIR is $ASAP_BASE/DATA/logs. After this file size is reached, this file can be copied to a time stamped file and a new diagnostic file opened. You can modify the diagnostic file growth by either adjusting this configuration parameter or modifying the diagnostic level of the application server (statically in the Control database or, if a server process, dynamically by means of the diag_level() API RPC/Registered Procedure). For more information on diagnostic levels, see ASAP System Administrator's Guide.

Default = 3

OS_ERROR_LOGGING

Boolean flag. If set to 1, logs operating system client messages to the diagnostic file. This should be set to 0 in most implementations.

Default = 0

SBT_ELEMENTS_PER_NODE

The number of self-balancing elements per node within the ASAP self-balancing binary trees. This should generally not be set to a value other than the default. This parameter is referenced whenever an application process initializes.

Default = 3

CONTROL_POOL_SIZE

This parameter is used for tuning. This parameter sets the number of CT-Library connections to the Control database.

If the configured number is not sufficient, the following error message is logged:

>> 181540.988:41:PROG:ASC cppalloc :153:     ctlib.c
Waiting for Connection from 'Control Pool', (2 In Use). Auto-tuning will increase connection pool if problems persist.

You can run the following sample code from the diagnostic directory to locate error messages in the log file:

export TARGET= "Waiting for connection from 'Control Pool'"
echo "searching for $TARGET (APPL_POOL_SIZE)"
grep "$TARGET" *.diag*

Default = 2

Recommended initial values are based on system size:

• Small : 5

• Medium : 7

• Large : 10

APPL_POOL_SIZE

This parameter is used for tuning. This parameter sets the number of CT-Library connections to the component database that you are tuning.

Larger system sizes are required only for the SARM section of the configuration file. The smaller value can usually be used for all other ASAP servers regardless of the size of the ASAP system.

If the configured number is not sufficient, the following error message is logged:

>> 181540.988:41:PROG:ASC cppalloc :153:     ctlib.c
Waiting for Connection from 'Application Pool', (2 In Use). Auto-tuning will increase connection pool if problems persist.

You can run the following sample code from the diagnostic directory to locate error messages in the log file:

export TARGET= "Waiting for connection from 'Application Pool'"
echo "searching for $TARGET (APPL_POOL_SIZE)"
grep "$TARGET" *.diag*

Default = 2

Recommended initial values are based on system size:

• Small : 5

• Medium : 25

• Large : 100

ASAP_IS_ALIVE_INTERVAL

The Control server can also be configured to issue "Keep Alive" notifications to an external operations centre signifying that ASAP is functioning correctly. The absence of this periodic notification may indicate an ASAP outage.

ASAP_IS_ALIVE_INTERVAL is the check-time interval, in seconds, during which application servers validate existing connections to the SQL Server. This parameter also determines the time period between connection retries between application servers in the event a server is unavailable for some reason.

Default = 60

DBERROR_TIME_INTERVAL

Threshold time frame. See also NUM_DBERROR_ALLOWED.

Default = 60

MAX_DBPROCS

The maximum number of database processes per application.

Default = 25

NUM_DBERROR_ALLOWED

DB library error threshold. If more than this number of DB library errors occur in a specified time interval, the application server will stop. This is to avoid recursive error situations. See also DBERROR_TIME_INTERVAL.

Default = 40

MAX_CONNECTIONS_TO_POLL

The initial number of network connections for which the poll manager polls. This configuration parameter is used to determine the initial poll list size. This list is automatically resized as additional connections are added to the poll list.

Default = 1

MAX_POLL_REQUESTS

This specifies the maximum initial number of poll requests to the server API poll manager thread at one time. If more than this number of requests are received, the poll manager automatically resizes the poll request list.

Default = 1

MAX_POLL_RETRY

This is the number of retries that the server API poll manager will attempt.

Default = 10

DB_ADMIN_ON

Boolean flag. If set to 1, it enables the database administration thread operation in the application server. This can be disabled in particular servers in situations where multiple servers share the same application database (for example, multiple NEPs) and then only one server is required to perform this database administration.

Default = 0

LANGUAGE_DUMP_ON

Boolean flag. If set to 1, it determines whether the language buffer being transmitted or received should be logged as a low-level diagnostic in the server's diagnostic log file. The primary use is for debugging such language buffers, and is therefore, generally used in non-production environments.

Enables the logging of diagnostic details of language requests being transmitted to and from application servers.

Default = 1

REGISTERED_PROCS

Defines the behavior of a particular API call to create a registered/remote procedure call in an application server. The parameters enable diagnostic output of the RPCs and language requests being transmitted to and from application servers.

Boolean flag. If set to 1, it determines whether procedures added with the add_appl_rpc(). The advantage to adding them as registered procedures is that there is less overhead in determining the procedure handler. The disadvantage of using registered procedures is that they do not allow optional parameters. Therefore, any such procedures should be added using the API function, add_rpc(), which adds them as remote procedures regardless of this configuration setting. In general, to register a procedure with fixed number of parameters as a registered procedure, call ASC_define_rpc(). To register a procedure with variable number of parameters as an RPC, call add_rpc().

Default = 0

CLIENT_SECURITY_ON

Determines whether client processes connecting to server processes have their user IDs and passwords verified against the SQL Server (APPL_SQL_SERVER SQL). If this connection fails, the client is denied access to the server.

Default = 0

NE_DIALOG_OFF

Controls the NE dialog message in the diagnostic file.

Default = 0

Possible values are:

• 0 – NE dialog messages appear in the diagnostic file.

• 1 – Secures the NE dialog. No NE dialog messages appear in the diagnostic file.

SYSTEM_NAME

Name of the current system.

Default = $ASAP_SYSTEM

TERRITORY_NAME

Name of the current territory.

Default = $ASAP_TERRITORY

PERF_POLL_PERIOD

Time period, in seconds, that the application servers wait to update the Control database with periodic performance information related to the operation of the application server.

Default = 600

SIG_IGNORED

Boolean flag. If set to 1, it instructs the client application to ignore any received signals that are not explicitly handled by the application. If set to 0, reception of such a signal results in the termination of the client application.

Default = 1

ASAP_STATS_ON

Boolean flag. If set to 1, the NEP saves ASAP statistics in the core database statistics table.

Default = 0

DEFAULT_ASDL_ESTIM

The default estimate (in seconds) for an ASDL to be processed. This value is used by the NEP to initially estimate the processing times of ASDLs in the NEP.

Default = 10

NE_CMD_LOG_ON

Boolean flag. If set to 1, it indicates whether the NEP should save each Man-Machine Language (MML) command issued by the SEND action in the core database for user viewing.

Default = 1

CONNECT_FAIL_DELAY

Time interval, in seconds, the NEP waits between login retries after establishing a successful connection to an external system.

Default = 120

NEP_MAINTENANCE_INTERVAL

Time interval, in seconds, before the NEP retries the NE connection after the NEP have determined that the NE is in maintenance mode.

Default = 600

NEP_PORT_BIND_INTERVAL

Time interval, in seconds, the NEP waits between attempts to bind to an NEP port in order to establish a connection to an external system. This generally occurs when there are fewer ports available than connection requests and the bind attempt fails. In such circumstances, the binding operation is retried on the assumption that a port will become available.

Default = 60

NEP_PORT_CONNECT_INTERVAL

Time interval, in seconds, between primary connection attempts to an external system. If the NEP is requested to establish a primary connection and that connect attempt fails, this is the time interval the NEP will wait between attempts to establish the primary connection.

Default = 60

PORT_ENABLE_TIMER

The time interval, in seconds, after the disabling of an NEP port that the NEP will automatically re-enable the port. A port can be disabled by the NEP if the connect attempt to the external system fails. This avoids manual intervention to re-enable the port in such circumstances.

Default = 600

SARM

The logical name of the SARM server to which the NEP opens network connections.

Default = $SARM

NEP_PORT_UNBIND_TIMEOUT

Time in seconds, the NEP waits for the ports to unbind before issuing SYS_TERM. After SARM starts up, it establishes a connection to each underlying NEP. As part of the initial handshake, SARM invokes sarm_startup_unbport_rpc on each NEP. This RPC waits for all the NEP's ports to be disconnected within the specified threshold timeout before returning. If the ports are still not disconnected after this timeout, NEP raises the SYS_TERM so that restart of NEP/JNEP would resolve the ports disconnection issue.

Default = 300

NEP_HOST_IPADDR

This is the NEP IP address upon which the NEP is running. It must be set to support Switch Direct functionality. See also SWD_SESSIONS_SUPPORTED.

Default = $NEP_HOST_IPADDR

NEP_HOST_NAME

Host name of the machine on which the NEP is running. See also SWD_SESSIONS_SUPPORTED.

Default = $NEP_HOST_NAME

SWD_SESSIONS_SUPPORTED

Boolean flag. If set to 1, it enables switch direct functionality in the NEP.

Default = 0

DCE_IF_SUPPORTED

Boolean flag. If set to 1, it enables the DCE option.

Default = 1

FTP_IF_SUPPORTED

Boolean flag. If set to 1, it enables the FTP device driver in the communications interface.

Default = 1

LDAP_IF_SUPPORTED

Indicates whether LDAP is supported or not.

Default = 1

SERIAL_IF_SUPPORTED

Boolean flag. If set to 1, it enables the serial device driver in the communications interface.

Default = 1

SNMP_IF_SUPPORTED

Boolean flag. Specifies whether the NEP SNMP Option should be enabled. If set to 1, it enables the NEP SNMP option.

Default = 0

SOCKET_IF_SUPPORTED

Boolean flag. If set to 1, it enables the TCP/IP socket device driver in the communications interface.

Default = 1

TELNET_IF_SUPPORTED

Boolean flag. If set to 1, it enables the TCP/IP telnet device driver in the communications interface.

If telnet is supported, the ALLOW_TELNET_EXTENDED_CHAR_SET Boolean flag specifies whether to print extended ASCII characters.

Default = 1

Possible values are:

• 1 – All characters (1-255) will print except the NULL character.

• 0 – Only standard ASCII characters (32-127) are printable.

X25_IF_SUPPORTED

Boolean flag. If set to 1, it enables the generic device driver in the communications interface.

Default = 1

MAX_GR_CONNECTIONS

Identifies the maximum number of connections that the Generic Router (GR) thread will be polling (including the connection used by the command processors to communicate with the GR). This parameter is used by the GR to set up the initial data structures for polling. If more command processor connection requests are received, the queue is automatically resized.

Default = 20

MPM_READ_BUF_SIZE

Specifies the size of the buffer, in bytes, used by the GR thread to read data from terminal-based ports. This value can be tuned depending upon the length of the communication.

Default = 512

IGNORE_MODEM_ST

Boolean flag. If set to 1, it instructs the serial device driver to treat the serial connection as a local direct connection with no modem control. If set to 0, modem control (dial-up) is assumed.

Default = 0

MAX_QUERY_RESULTS

A limiting parameter on query result sets. Query results for work orders, CSDL history responses, ASDL history responses and such are limited to this configurable maximum so as not to overload the caller with a potentially large result set. Large result sets can require a lot of memory and CPU resources to maintain and manage.

Default = 250

The default value of 250 is also the maximum value.

QUERY_POOL_SIZE

Number of database connections to the query database to maintain in the connection pool. The number of simultaneous work order queries supported by the database. The queries exceeding the number will wait until a database connection is available.

Default = 7

QUERY_SQL_SERVER

Name of the database server, an Oracle database instance, where the QUERY_USERID is located.

Default = $DSQUERY

QUERY_USERID

Database user ID for the Work Order query component. Normally this is the login name for the SARM database.

Default = $SARM_USER

WO_AUDIT_LEVEL

ASAP provides the ability to audit all transactions involved in provisioning a work order. All work order auditing messages are stored in an audit table in the SARM database (tbl_wo_audit). The user can query work order audit trail records through Order Control Application (OCA).

Set the audit level for transactions performed by the work order.

See ASAP Developer's Guide for more information on ASAP auditing features.

If you want to log error messages (SRQ_ERROR_EVENTS) for service requests events (srq_evt) in tbl_srq_log, you must set WO_AUDIT_LEVEL to 2.

Default = 1

Possible values are:

• 0 – No auditing occurs. No information is placed in the tbl_wo_audit table.

• 1 – There is one audit entry per work order as it is traced through the system.

• 2 – Provides all functions of level 1 plus the audit level entries for all error states.

• 3 – Provides all functions of level 2 plus it tracks the provisioning of a work order through the entire provisioning process. For example, when the ASDL was started, when it was placed in the pending queue, where in the pending queue it is, when it was sent to the NEP, etc.

• 4 – All events are inserted into the tbl_wo_audit table. This level is intended to debug the work order auditing process.

  Audit level 4 should not be used in production environments because this level of auditing may result in degraded performance.

BEA_CONN_TYPE

Sets the type of connection that WebLogic Server is expecting.

Default = http

Possible values are:

• http

• https

BEA_WLS_HOST

Sets the host name or IP address of the system on which WebLogic Server is running.

Default = localhost

BEA_WLS_PORT

Sets the port number for WebLogic Server.

Default = 7001

BEA_WLS_USER

Sets the name of the WebLogic Server administrative user login.

Default = system

SECURITY_SERVICE

Sets the name of the Security Web service deployed in WebLogic Server.

Default = security

ALARM_RETRIES

The number of times the Control server will attempt to generate an alarm program.

Default = 3

ALARM_TIME_INTERVAL

The time interval, in seconds, between unsuccessful alarm program generations.

Default = 10

DB_MONITOR_TIME

The time interval, in minutes, when the Control server monitors the database and logs segment sizes and then issues a system event if they exceed a predetermined threshold value. This functionality can be enabled within the Control server by populating the database threshold monitoring table in the Control database.

Default = 10

FS_MONITOR_TIME

The time interval, in minutes, when the Control server monitors the UNIX file system sizes and issues a system event if they exceed a predetermined threshold value. This functionality can be enabled within the Control server by populating the file system threshold monitoring table in the Control database.

Default = 5

DB_ADMIN_ON

Boolean flag. If set to 1, it enables the database administration thread operation in the application server. This can be disabled in particular servers in situations where multiple servers share the same application database and then only one server is required to perform this database administration.

Default = 0

DB_ADMIN_PROC_PARAM

The integer parameter passed to the database administration procedure. For example, this can specify a purge interval for a particular database.

Default = 100

DB_ADMIN_PROC

The procedure the database administration thread calls at a specified time in the day. This procedure could perform many tasks, including archiving and purging of dynamic data.

All stored procedures in the database are recompiled and the statistics updated after this administration procedure has been called.

Default = CSP_db_admin

DB_ADMIN_TIME

The number of minutes after midnight when the database administration tasks are to be performed. This is usually performed at a time of low system activity.

Default = 300

DB_PCT_ANALYZE

This parameter applies to Oracle Database only. It is used to update statistics on all user-defined tables. The updates are done when the database administrations tasks are performed. (See also DB_ADMIN_TIME.) This parameter is used to optimize the database query performance.

The Oracle SQL statement is "analyze table table_name estimate statistics sample DB_PCT_ANALYZE percent". See the discussion on the Analyze command in Oracle SQL Reference Manual.

Default = 20

VNO_ENABLED

This VNO configuration parameter is designed to activate the OCA client to perform VNO security checking on OCA users and to un-authorize users who are not members of any VNO group in WebLogic Server security.

The value of this configuration parameter is obtained by the OCA SRP server and is provided to the OCA client.

Default = 0

VNO_ID_DEFAULT

This parameter controls the specification of a default VNO ID at the OCA SRP.

If VNO_ID_DEFAULT is not set, no default VNO ID will be added to work orders, even if they do not include a VNO ID.

If VNO_ID_DEFAULT is set to the VNO ID, the VNO ID specified will be added to work orders that do not already have a VNO ID specified.

When a default VNO ID is added to an order and the order is submitted successfully, a record is inserted to tbl_usr_wo_prop in the SARM database for that order, with VNO ID in the name field and the default value in the value field.

Default = no value

VNO_ID_STRIP

This parameter controls whether the VNO ID is stripped.

If VNO_ID_STRIP is set to 0, the VNO ID will not be stripped before returning the information upstream.

If VNO_ID_STRIP is set to 1, the information being returned upstream is filtered by removing the VNO ID. The OCA SRP maintains the VNO ID in its memory and databases for this order. For example, tbl_usr_wo_prop still contains the VNO ID for the order.

Default = 0

EXTERNAL_VALIDATION_JNDI

This parameter configures the WO extended validation server. It works only when VNO_ENABLED is set to 1.

To enable WO extended validation, set the full JNDI path of external Validation EJB.

To disable WO extended validation with VNO filter enabled, do not define this parameter.

An external validation sample can be found in $ASAP_BASE/oca_sys_if/sample/validationServer/.

With the sample validation logic, if a work order contains the CSDL C-ADD_POTS_LINE and its parameter DN is not equal to 6742727, the InvalidOrderException message is thrown.

Default = abc/Comp/SampleExternalOrderValidation

ASDL_TIMEOUTS

Each ASDL has a timeout value that governs how long it can remain in the pending queue without being successfully provisioned. All ASDLs within the same work order must have the same timeout value. When the work order has timed out and failed, the final status is WO_TIME_OUT.

Boolean flag. For SARM to support ASDL timeout, set the following:

• ASDL_TIMEOUTS to 1 in ASAP.cfg (Default = 0)

• asdl_timeout to desired value on the work order

Each ASDL can time out based on the configuration parameters. The timer must be set for each ASDL, and it starts once the ASDL is in pending queue.

If the value of the ASDL_TIMEOUTS is 0 (zero), the ASDL timeout feature is not used, regardless of the asdl_timeout value.

Timeout and retry attributes are configurable at the ASDL level, at the NE level, at the work-order level, and at the system level. If no ASDL timeout parameters are defined, other settings may apply. See ASAP Cartridge Development Guide.

The way the ASDL timeout is applied to the first ASDL differs from the way it applies to all subsequent ASDLs. If an ASDL timeout occurs during the provisioning of the first ASDL, a grace period is given. For the second, and subsequent ASDLs, no grace period is given. The value of the grace period is the same as the asdl_timeout value.

When the first ASDL times out during provisioning, the ASDL does not fail and the work order remains in an In Progress status. The SARM sends an event notification to the SRP, gives the timed out ASDL a grace period, and continues provisioning. If the same ASDL times out again, the SARM fails the ASDL. Then the work order fails.

When both the work order and the ASDL timeouts are set for a particular work order, only the first occurrence of timeout is processed and the other is ignored.

The following notification events are triggered to inform the SRP of the state of the work order for both the work order and ASDL timeouts:

• Executing : Informs the SRP of first ASDL timeout that occurred during provisioning.

• Failed : Informs the SRP of the work order failure.

Default = 0

BATCH_SLEEP_INTERVAL

The time period, in seconds, between SARM database queries for future dated orders that:

• Are ready to be provisioned

• Have had a state change (for example, from HELD to INITIAL)

• Can now be provisioned due to the completion of a PARENT order.

Default = 20

CORE_SQL_SERVER

The SQL Server in which the SARM database resides. This is the same as APPL_SQL_SERVER for the SARM. Maximum length is eight alphanumeric characters.

Default = $DSQUERY

DELAYED_FAIL_FOR_RETRY_ON

Boolean flag. If set to 1, then the asdlDelayFail flag of the order is taken into account when an ASDL reaches the maximum number of retries for RETRY/RETRY_DIS. If asdlDelayFail is enabled, then the ASDL failure is treated as DELAYED FAIL, and the remaining CSDLs in the order are processed.

If set to 0, then the order fails after the first ASDL fails and exceeds its retry count, and the remaining CSDLs in the order are not processed.

Note: For delayed failure to work for retry failures, set the work order properties rollbackIfFail parameter to false and maximumDelayFail to 0.

Default = 0

EXP_ONLY_COMP_DEFINED_PARM

This parameter controls the evaluation logic of ASDL spawning expressions within the SARM. If set to 1, the (sub)expression returns false if a label is not provided, except for DEF/NOTDEF cases.

If set to 0, the legacy logic is used. When a label is not provided, the label name is used as the value of the label in the expression.

Default=0

FAIL_WO_ON_EMPTY_CSDL

Boolean flag. If set to 1, the CSDL triggers a work order failure if it fails to spawn any ASDLs.

Default=0

INPROC_CHK_INT

The time interval, in seconds, the SARM waits between checks of the internal queues to determine whether there are any orders in progress beyond the specified in progress threshold. See also MAX_IN_QUEUE_TM.

Default = 900

MAX_IN_QUEUE_TM

This is the time interval, in seconds, for which the SARM allows a work order to be in progress before calling the WOINPROC system event, which notifies the user that at least one work order is still in progress beyond the defined threshold.

The order is not automatically failed by this mechanism. For example, a work order that requires provisioning at two different NEs, one of which is presently unavailable, could result in the SARM issuing a system event. See also INPROC_CHK_INT.

Default = 3600

MAX_ORDERS_IN_GM_Q

Limits the number of work orders the SARM keeps in memory. During each BATCH_SLEEP_INTERVAL, the Batch Handler attempts to load work orders from the SARM database that are due for provisioning. The Batch Handler does not fetch work orders from the SARM database when the number of new or reloaded messages in the Group Manager common queue exceeds MAX_ORDER_IN_GM_Q. You must correlate MAX_ORDER_IN_GM_Q with BATCH_SLEEP_INTERVAL. To do this, use the following formula:

BATCH_SLEEP_INTERVAL (in seconds) x <max.# of WO per sec.>= MAX_ORDER_IN_GM_Q

where: <max.# of WO per sec.> is the maximum number of work orders that the ASAP instance can provision.

Examples of typical values:

• BATCH_SLEEP_INTERVAL: 200 (seconds)

• <max.# of WO per sec.>: 3.5 WO/s

• MAX_ORDER_IN_GM_Q: 800 (>200 x 3.5)

Each time you add 100 to any of the above values, MAX_ORDER_IN_GM_Q can increase the amount of memory the SARM uses by up to 1 MB. A smaller value can affect performance during peak hours. If you set a smaller value, the SARM and NEPs request fewer work orders from the SARM database.

Default = 500

MAX_ORDERS_IN_PROGRESS

The maximum number of orders that the SARM allows to be in progress at any given time. This is to limit the memory requirements of the SARM should there be large numbers of orders in progress for long periods of time. If zero, this check is disabled.

In production environments, ensure that the MAX_ORDERS_IN_PROGRESS parameter is not set to 0. A setting of 0 specifies no upper limit on memory consumption and can have a significant impact on performance.

Default = 10000

NUM_TIMES_RETRY

The number of times the SARM sends an ASDL to the NEP to be processed after the NEP returned it with a Fail but Retry status. A work order is failed when the number of retries equals the value specified for NUM_TIMES_RETRY.

Default = 5

ORDER_TIMEOUT

The number of seconds a particular work order can remain in progress before the SARM fails the order. The work order timer starts after the work order has been submitted and started. This threshold can be exceeded if, for example, the connection to an NE is interrupted after the connection has been established.

You can set the system-wide parameter ORDER_TIMEOUT in the ASAP.cfg file. If you are using the SRP Emulator, you can also set the wo_timeout value in the tbl_wo_def table in the SRP database.

The order timeout behavior is governed by two parameters: the wo_timeout parameter on the work order and the ORDER_TIMEOUT configuration parameter in ASAP.cfg.

Default = 0

Possible values are:

• If wo_timeout has a value greater than 1, it is used.

• If wo_timeout has a value of 0, work orders do not time out.

• If wo_timeout has a value less than 0, ORDER_TIMEOUT is used.

• If wo_timeout has a value less than 0 and ORDER TIMEOUT has a value of 0 or less, work orders do not time out.

REPLAY_WO_DELAY_FAIL_ON

Boolean flag. If set to 1, the asdl_delay_fail flag is enabled for replay work orders.

Default = 0

REPLAY_WO_MAX_DELAY_FAIL

The number of ASDL delayed failures before failing replay work orders.

Default = 0

RETRY_TIME_INTERVAL

Time, in seconds, the SARM waits between retries of an ASDL command returned to the SARM with 'Fail but Retry' status.

Default = 120

SECURITY_CHECK

Boolean flag. Indicates whether security checking is enabled in the SARM. If set to 1, whenever the SARM receives the WO from the SRP, it checks to see if the user ID and password passed on the work order are present in the SARM database user/password table. If so, the work order is accepted, otherwise it is rejected. If security checking is 0, the work order is accepted by default.

Default = 0

WO_HANDLER_TIMEOUT

The time interval, in seconds, the SARM waits for the transmission of a work order from the SRP to the SARM before canceling the transaction. If the SRP were to terminate when it is transmitting work orders to the SARM, this condition might occur.

Default = 60

WO_TIME_ESTIMATE_ON

Boolean flag. If set to 1, it instructs the SARM to calculate the rough time estimate for completing the work order. If WO estimate notifications back to the SRP are enabled, this parameter should be set. If no WO estimate notifications are required, this parameter should not be set.

Default = 0

WO_TIMEOUT_EVENT_TWICE

Boolean flag. If set to 1, then two timeout events are generated, whenever a work order gets times out. If set to 0, then only one timeout event is raised, whenever a work order gets times out.

This parameter must be added manually to set it to 0. Otherwise ASAP uses the default setting of 1.

Default = 1

MAX_GROUP_MGRS

The number of group manager threads to be started by the SARM upon startup.

Default = 5

MAX_PROVISION_HANDLERS

The number of provisioning handler threads to be started by the SARM.

Default = 5

SRP_READY_WAIT_TIME

This is the time required by the SRP drivers to complete initializing before SARM starts processing work orders. If this parameter is not present, SARM may not wait for the SRP drivers to complete initializing and may begin processing work orders earlier.

Default = 0

MAX_SRP_DRIVERS

The number of SRP driver threads to be started by the SARM to communicate with each SRP server.

Default = 2

MAX_WO_HANDLERS

The number of work order handler threads to be started by the SARM.

Default = 5

MAX_WO_MGRS

The number of work order manager threads to be started by the SARM.

Default = 5

MAX_MSGPOOL

This parameter is used for tuning. The number of message structures available to the Open server. This parameter sets the number of message structures to be allocated at the time of start up. This number must always be greater than or equal to the value of MAX_MSGQUEUES times 256.

Default = 106752

Recommended initial values are based on system size:

• Small : 106752

• Medium :164352

• Large : 241152

BATCH_DELETE_DELAY

After all the orders in the batch group are processed, the SARM does not delete the batch group until the time interval that is specified by the configuration parameter expires.

Orders are released from the batch group upon completion or batch failure. Any order in the same batch group that is sent after the time interval expires is not treated as part of the batch.

You can specify an error threshold for the number of failures that can occur in the batch before the SARM stops activation of that batch. The batch failure threshold value is based on the SARM configuration parameter and is not configurable by the SRP using the Batch Order Delay fail threshold.

The time interval, in seconds, after the processing of the last order in the batch, that the SARM waits to remove the batch details from memory.

Default = 60

BATCH_THRESHOLD

Defines the maximum number of errors that can occur within a batch of loosely coupled requests. Batch orders are defined by means of the SRP batch order property that identified the batch to which the order belongs. Should the batch error threshold be exceeded for a particular batch, the batch as a whole will be suspended.

This parameter is set for all batch work orders. You cannot set this parameter on a per work order basis.

Default = 0

LANGUAGE_OF_MSG

The language code to determine the language in which the Service Request (SRQ) Log messages are written to the database. These messages are detailed in message conversion tables in the SARM database and allow substitution of data fields in their expansion. To use a language other than the default, insert all the relevant messages into this table with the new language code, while ensuring the same placeholder positions within the data string. Any new messages added to the SARM are added under the default language.

Default = USA

MAX_MAINT_INTERVAL

This parameter is not used.

Default = 0

MESSAGE_NUMBERS

Boolean flag. If set to 1, it causes the SARM to write only the message IDs from the message conversion table to the SARM database. This is used primarily in system testing and should be set to 0 in all other environments.

Default = 0

SOURCE_ROUTING

This parameter is not used.

Default = 1

USER_UNID_1

Must be set to OCA to enable the OCA_WOID_MASK parameter.

Default = OCA

ASDL_LOG_UNID_JUMP_INTERVAL

Number of ASDL LOG UNIDs to cache per work order. Reduces number of secondary to primary UNID fetch RPCs called.

Default = 5

UNID_JUMP_INTERVAL

Number of unique integers to cache in the SARM. The larger the value, the fewer stored procedures are called to the SARM databases. This can cause UNIDs to be unused in the event that the SARM is shut down.

Default = 1000

SWD_HOST_IPADDR

Used for Switch Direct support. This is the Host IP Address for the machine where the SARM is running.

Default = $SWD_HOST_IPADDR

SWD_HOST_NAME

Used for Switch Direct support. This is the Host Name for the machine where SARM is running.

Default = $SWD_HOST_NAME

SWD_IDLE_TIMEOUT

Used for Switch Direct support. This is the idle timeout period, in seconds, for automatically disconnecting the Switch Direct Interface (SWD) session if no activity is detected.

Default = 120

SWD_LISTEN_PORT

Used for Switch Direct support. The TCP/IP port number for the SARM server for Switch Direct support. The SWD client connects to this port.

Default = $SWD_LISTEN_PORT

SWD_SESSIONS_SUPPORTED

Boolean flag. If set to 1, it determines whether Switch Direct sessions are supported by the SARM. This parameter is also used by NEP applications.

Default = 0

ADM_SQL_SVR

The database where ADM tables reside.

Default = $DSQUERY

ADM_USER

The database user ID for ADM_SQL_SVR.

Default = $ADM_USER

LOAD_PERSISTENT_DATA

Boolean flag. If set to 1, it loads the last known data from the ADMIN database into the SARM's memory. This prevents jumps or gaps in the statistical data.

Default = 1

MAX_CLIENT_CONN

This parameter defines the maximum number of socket connections that the SARM can create to receive RPC requests from the SRP. This value can be tuned to meet the actual need of the connections.

One connection corresponds to one thread in SARM, so this value should be less than MAX_SERVER_PROCS (default = 512)

Also, the maximum capacity of the connection pool is defined in the jconnector in the JSRP and should not exceed the value of MAX_CLIENT_CONN.

To configure the Maximum Capacity parameter through the WebLogic Server Administration Console:

1. In the Oracle WebLogic Server 12c Administration Console, click Lock & Edit if not already clicked. See the Administration Console Online Help for more information.

2. In the Domain Structure panel of the Change Center in the Oracle WebLogic Server 12c Administration Console, expand Services.

3. In the Domain Structure panel expand JDBC and then select Data Sources.

   The Summary of JDBC Data Sources screen appears.

4. Click the name of the data source to be configured.

5. Select the Configuration tab, and the Connection Pool sub-tab.

6. Set Maximum Capacity to 50.

7. Click Save.

8. Click Release Configuration.

You can determine whether the maximum connections threshold is reached through the SARM diagnostic file.

Default = 100

DB_ADMIN_ON

Boolean flag. If set to 1, it enables the database administration thread operation in the application server. This can be disabled in particular servers in situations where multiple servers share the same application database and then only one server is required to perform this database administration.

Note: If you are using purgeOrders scripts for purging the SARM database, set this parameter to 0. For more information, see ASAP System Administrator’s Guide.

Default = 0

DB_ADMIN_PROC_PARAM

The integer parameter passed to the database administration procedure. For example, this can specify a purge interval for a particular database.

Default = 100

DB_ADMIN_PROC

The procedure the database administration thread calls at a specified time in the day. This procedure could perform many tasks, including archiving and purging of dynamic data.

All stored procedures in the database are recompiled and the statistics updated after this administration procedure has been called.

Default = SSP_db_admin

DB_ADMIN_TIME

The number of minutes after midnight when the database administration tasks are to be performed. This is usually performed at a time of low system activity.

Default = 300

DB_PCT_ANALYZE

This parameter applies to Oracle Database only. It is used to update statistics on all user-defined tables. The updates are done when the database administrations tasks are performed. (See also DB_ADMIN_TIME.) This parameter is used to optimize the database query performance.

The Oracle SQL statement is "analyze table table_name estimate statistics sample DB_PCT_ANALYZE percent". See the discussion on the Analyze command in Oracle SQL Reference Manual.

Default = 20

DB_PURGE_DAYS

Number of days to keep the updated orders. The orders that were updated older than this number of days are purged. Orders are not purged if the value is 0.

Default = 100

DB_PURGE_THREADS

Number of threads to use. The purge application spawns this number of threads and runs the purge stored procedure in each thread. This allows you to run the purge procedure at different times of the day using different levels of parallelism.

Note: The -t parameter in the command line overrides this value specified in ASAP.cfg.

Valid Range: 1 to 50

Default: 10

DB_PURGE_COMMIT_ROWS

Number of rows to be deleted before a COMMIT is issued.

Default: 1000

DB_PURGE_ORPHANS_ENABLED

Boolean flag. If set to 1, it enables the SSO_orphan_purge procedure which removes orphaned data definitions in the SARM database.

Default: 0

DB_PURGE_MAX_TIME

Maximum purge time. The maximum amount of time in minutes that the purge operation is allowed to run. If this parameter is set to 0, the purge operation is run without a time limit.

Default: 0

DB_PURGE_GET_RANGE_PROC

The stored procedure that the purge application should call to get the SRQ_ID range (MIN, MAX) of the orders to be purged.

Default: SSP_get_srqid_purge_range

DB_PURGE_RANGE_PROC

The stored procedure that each thread should call to purge the work orders in an SRQ_ID range.

Default: SSP_purge_wo_in_srqid_range

DB_PURGE_LOG_INTERVAL

The interval, in minutes, to log messages about the progress of the purge operation.

Default: 5