Table 7 Sybase ASE attributes (continued)
Sybase ASE Attributes | Description |
ASE_SERVER | Name of the Sybase ASE instance set during installation or configuration of the ASE. |
| This uniquely identifies an ASE instance |
ALERT_MAIL ID | Sends an |
| is generated only when packages fail, and not when a package is halted by the operator. |
| To send this |
| and specified for this parameter. When an |
| the script does not send out this |
SALOGIN | ASE Login with system administrator capability |
SAPASSWD | ASE Password for Login with system administrator capability. |
| NOTE: Along with other package attributes, the ASE password is also stored in the |
| Cluster Database. If users are not restricted access based on their roles, this password |
| can be viewed by unauthorized users using the cmviewcl command. It is highly |
| recommended to grant access to users based only on their roles in managing the cluster |
| and packages. See “Configuring Access Roles” (page 67) in this chapter for more |
| details on configuring Role Based Access (RBA). |
ASE_RUNSCRIPT | Path of the script to start ASE instance. |
USER_SHUTDOWN_MODE | This parameter is used to specify the instance shutdown mode only when a shutdown |
| is initiated by the user and not due to a failure of a service. This parameter can take |
| values "wait" or "nowait". If "wait" is specified, the instance is shutdown using the wait |
| option, which will be a clean shutdown. If "nowait" is specified, the instance is shutdown |
| using the nowait option. The default value is "wait". |
MONITOR_INTERVAL | The interval of time, in seconds, which this script should wait between checks to ensure |
| of the Sybase database running. Default value is 30 seconds. |
TIME_OUT | The interval of time, in seconds, to wait for Sybase abort to complete before killing the |
| Sybase processes defined in MONITOR_PROCESSES. The TIME_OUT variable is used |
| to protect against a worst case scenario where a hung database prevents the halt script |
| from completing, therefore preventing the standby node from starting the database. The |
| value of TIME_OUT must be less than the |
| TIME_OUT variable has no effect on package failover times. Default value is 30 seconds. |
RECOVERY_TIMEOUT | The maximum amount of time in seconds to wait for an ASE to complete recovery before |
| determining that the server has failed to start up. This value must be set to allow enough |
| time for all the databases to recover and come online. |
MONITOR_PROCESSES | The names of all processes that must be executing to ensure this instance is up and |
| running. |
MAINTENANCE_FLAG | Maintenance flag will enable or disable the maintenance mode for the Sybase package. |
| By default this is set to "yes". In order to disable this feature, MAINTENANCE_FLAG |
| should be set to "no". If the Sybase ASE instance needs to be maintained, a file |
| $TKIT_DIR/sybase.debug needs to be touched. During this maintenance period |
| the Sybase ASE instance's monitoring is paused. Even if the ASE instance is brought |
| down, the package will not be failed over to the standby node. To continue monitoring |
| and come back from the maintenance mode, the sybase.debug file should be removed. |
| It is the user's responsibility to ensure that the ASE instance is running properly after the |
| maintenance phase. |
•Module Script (tkit_module.sh)
This script contains a list of internally used variables and functions that support the starting and stopping of an Sybase ASE database instance. This script is called by the Master Control Script to perform the following:
Setting up the Toolkit 63
