Date: 08-09-2010 Subject: PATCH RELEASE 9.4C DATA Manager Files These release notes pertain to the following programs or files: SUNDM.EXE 9.4C 09 Aug 2010 9,4,3,500 *============================================================================== Notes for DOCUMENTATION: - In the Sunbelt Data Manager reference manual under the 'SUNDM Command Line' section, change the 'tx' command line option description as follows: "Terminates a currently executing data manager task. When this command line is executed at the primary server, the server is terminated and replication primary control is transferred to the next available secondary server. When this command is executed for a secondary server that has the replication primary control, the server is terminated and the replication primary control is transferred to the original primary server if it is on line. Otherwise, the replication primary control is transferred to the next available secondary server. When this command is executed at a secondary server without replication primary control, only that secondary server is terminated." *============================================================================== The following files have been changed as noted: ------------------------------------------------------------------------------- SUNDM - The Data Manager has been modified to support the MAILSEND instruction. This capability allows end-user applications to send email via the Data Manager. - The Data Manager has been modified to support HTTP capabilities that allow GPF information to be posted to a Web Server. When transferring the GPF information, this data is compressed and encrypted to provide secure communications with the target Web Server. In addition, the Sunbelt CGI utility named 'suncgi' must be installed at the target Web Server to process the HTTP communications data as received from the Data Manager. In addition, a new command line option named '-ht' has been added for the Data Manager. When the '-ht' command line option is executed, a test HTTP message is posted to Web Server configured for the Data Manager. In this case, a file named 'test.txt' is transferred to the Web Server. This command line option is used to verify that the HTTP communications is working as expected. The following keywords are optional. When used, they can be placed in the [Environment] section of the Data Manager '.cfg' configuration file. These keywords can be used to configure for situations that may require special setup to access a Web Server that is used to collect the GPF data using the HTTP interface. ADMIN_HTTP_ADDR={i/p address}[:{port}] This keyword is optional. If it is not specified, the default 'www.sunbelt-plb.com' URL is used to access the Web Server. This keyword is only needed to specify the URL/IP address for special configurations where the default URL can not be used. For example, this keyword may be required when a proxy server is used by an end-user. The default port number is 80. However, the optional {port} can be specified with a ':' character delimiter to set a port number other than the default. ADMIN_HTTP_COMMAND={command} This keyword is optional. If this keyword is not specified, the default command 'http://www.sunbelt-plb.com/cgi-bin/suncgi.exe' is used to access the Web Server for transferring the GPF data. Normally, this keyword is not required to access the Sunbelt Web Server. This keyword is only need for special situations where the default command can not be used. ADMIN_REPORT_GPF=[ON|OFF] This keyword is used to enable the GPF logging support. If this keyword is not specified, the default is the same as OFF. Example of CFG entries: [Environment] ADMIN_REPORT_GPF=ON ADMIN_HTTP_ADDR=192.168.0.102 ADMIN_HTTP_COMMAND=/suncgi.exe - The Data Manager has been modified to allow administrative email messages to be sent for specialized events that occur during the execution of the server. This capability has been implemented in the ADMIN support services to provide maximum flexibility and usage in the Sunbelt products. The end-user can enable the ADMIN email functionality by setting keywords in the Data Manager configuration file. Appropriate entries are logged in the server log file that reflect actions executed by the server for email event processing. In addition, a new command line option named '-mt' has been added for the Data Manager. When the '-mt' command line option is executed, the Data Manager mail parameters are reloaded and a test email message is sent if the email configuration is valid. The following ADMIN mail keywords can be put in the [Environment] section of the Data Manager '.cfg' configuration file. ***Required Keywords*** ADMIN_MAIL={on|off} ;Required This keyword is required to enable/disable the administrative email services. If the keyword is not specified, the default action is the same as being set to 'off'. ADMIN_MAIL_OUT={out} ;Required This keyword is required to allow an administrative email to be sent for a Data Manager. The {out} string for this keyword specifies the SMTP outgoing mail server name (URL) or IP address. ADMIN_MAIL_TO={to} ;Required This keyword is required to allow an administrative email to be sent for a Data Manager. The {to} string for this keyword specifies the email address(es) of the recipients. ADMIN_MAIL_FROM={from} ;Required This keyword is required to allow an administrative email to be sent for a Data Manager. The {from} string for this keyword specifies a single email address of the sender. ***Optional Email Event Keywords*** ADMIN_MAIL_REPLICATION=[off] ;Configurable email Event By default this administrative email event is enabled for the Data Manager. If this keyword is set to 'off', this email event is disabled. When this email event is enabled, an email is sent for the following replication events: 1. An email is sent when a secondary server becomes a rollover primary. 2. An email is sent when there are any startup failures that prevent Data Manager replication from starting. ADMIN_MAIL_MAXUSERS=[off] ;Configurable email Event By default this administrative email event is enabled for the Data Manager. If this keyword is set to 'off', this email event is disabled. When this email event is enabled, an email is sent that identifies when the maximum number of user connections has been exceeded. ADMIN_MAIL_STARTUP=[on] ;Configurable email Event By default this administrative email event is disabled for the Data Manager. If this keyword is set to 'on', this email event is enabled. When this email event is enabled, an email is sent that identifies when the Data Manager enters the startup phase that accepts user logons. ADMIN_MAIL_SHUTDOWN=[on] ;Configurable email Event By default this administrative email event is disabled for the Data Manager. If this keyword is set to 'on', this email event is enabled. When this email event is enabled, an email is sent that identifies when the Data Manager main logon process is terminated. ***Optional Keywords*** ADMIN_MAIL_SUBJECT={subject} ;Optional If this keyword is not specified, a default email subject is sent as follows: "SunDm Administrator Message" When the ADMIN_MAIL_SUBJECT keyword is specified, the {subject} string is sent as the subject for the email message. The {subject} string length is limited to 200 bytes. If the {subject} string contains a '%s' substitution parameter, the '%s' is replaced with the body text being sent for the message. The intended use of the '%s' is to allow the subject for the email to give the specific reason for the server event without having to open the email body. ADMIN_MAIL_BCC={bcc} ;Optional This optional keyword specifies the email address or addresses of the Blind Copy recipients. The {bcc} string may contain one or more recipient addresses. If more than one email recipient is specified, a comma separates the email addresses. ADMIN_MAIL_CC={cc} ;Optional This optional keyword specifies the email address or addresses of the Copy recipients. The {cc} string may contain one or more recipient addresses. If more than one email recipient is specified, a comma separates the email addresses. ADMIN_MAIL_USER={user} ;Optional This optional keyword specifies the username used for the login to the {out} email server specified by the ADMIN_MAIL_OUT keyword. ADMIN_MAIL_PASSWORD={password} ;Optional This optional keyword specifies the password for the login to the {out} email server specified by the ADMIN_MAIL_OUT keyword. ADMIN_MAIL_PORT={port} ;Optional This optional keyword specifies the port number used when logging on to the {out} email server specified by the ADMIN_MAIL_OUT keyword. If this keyword is not specified, the default port number of twenty-five (25) is used. The {port} string must be specified as decimal digits that identify the email server port number to be used. ADMIN_MAIL_SSL={on|off} ;Optional This optional keyword enables the SSL ( Secure Sockets Layer ) support if the OpenSSL libraries have been installed on the system where the Data Manager is executing. ADMIN_MAIL_TIMEOUT={timeout} ;Optional This optional keyword specifies the timeout value used when communicating with the {out} email server specified by the ADMIN_MAIL_OUT keyword. If this keyword is not specified, the default timeout of sixty (60) seconds is used. There are no restrictions placed on the value specified. The {timeout} string must be specified as decimal digits that identify the timeout value to be used. ADMIN_MAIL_TRACE={trace} ;Optional This optional keyword specifies the file name created to store all data messages sent and received when communicating with the {out} email server specified by the ADMIN_MAIL_OUT keyword. Note that a trace file is overwritten for a each email that is sent. This keyword is normally only needed to provide debug information when email problems are being researched. Otherwise, this keyword should not be used. The ADMIN_MAIL_TRACE keyword takes precedence over the ADMIN_MAIL_TRACEAPPEND keyword if both keywords are specified in the configuration file. ADMIN_MAIL_TRACEAPPEND={traceappend} ;Optional This optional keyword allows the trace data to be appended to an existing trace log file. This keyword is normally only needed to provide debug information when email problems are being researched. Otherwise, this keyword should not be used. The ADMIN_MAIL_TRACE keyword takes precedence over the ADMIN_MAIL_TRACEAPPEND keyword if both keywords are specified in the configuration file. ADMIN_MAIL_DSNRECEIPT={dsn} ;Optional This optional keyword specifies that this email requires a Delivery Service Notification as specified by the {dsn} string. The {dsn} string can be specified as follows: DSNRECEIPT=Never or DSNRECEIPT=Success,Failure,Delay Where: Never No return receipts are returned. This string option cannot be combined with other options. Success There will a notification on the successful delivery of message. This option can be combined with Failure/Delay. Failure There will be a notification when a delivery failure occurs. This option can be combined with Success/Delay. Delay This will be a notification when the delivery of a message is delayed. This option can be combined with Success/Failure. When combining options in the {dsn} string, the options are separated with a comma delimiter. ADMIN_MAIL_MDNRECEIPT={on|off} ;Optional This optional keyword requests that a client program receipt will be returned when the recipient reads this email. ADMIN_MAIL_RETURN={return} ;Optional This optional keyword is only valid when the DSNRECEIPT keyword is used. This keyword specifies the recommended format of the return receipt that is being requested by the DSNRECEIPT keyword. The {return} string can be specified as follows: RETURN=Full or RETURN=Hdrs Where: Full The full message will be returned with the receipt. This option is not combined with the other option. Hdrs The returned receipt should only contain the message headers. The options Full and Hdrs are mutually exclusive. ADMIN_MAIL_REPLYTO={replyto} ;Optional This optional keyword specifies the email address that a recipient is to send a reply to when responding to this email. Example CFG entries for EMAIL Setup: [Environment] ADMIN_MAIL=ON ADMIN_MAIL_REPLICATION=ON ADMIN_MAIL_MAXUSERS=ON ADMIN_MAIL_STARTUP=ON ADMIN_MAIL_SHUTDOWN=ON # ADMIN_MAIL_OUT=mail.server.com ADMIN_MAIL_TO=user@somemail.com ADMIN_MAIL_FROM=userSundm@somemail.com # ADMIN_MAIL_SUBJECT=Sundm Server: '%s' # ADMIN_MAIL_PORT=465 ADMIN_MAIL_USER=userSundm@somemail.com ADMIN_MAIL_PASSWORD=userPassword ADMIN_MAIL_SSL=ON ------------------------------------------------------------------------------- SUNDM REPLICATION SUPPORT - Added a new keyword named 'BYPASS={on|off}' that can be used to invoke the replication bypass mode. This keyword specifies the default bypass mode. If this keyword is set to be 'ON' when the Data Manager is started, the replication is started the same as when the '-b' command line option has been specified. The implementation of this keyword has been done to allow the replication bypass mode to be invoked when the Data Manager is started as an OS Service. The keyword must be placed in the 'Replication' section in the Sundm CFG file. - Modified the execution of the PLB AAMDEX, INDEX, and SORT verbs to optimize the performance of these instructions when replication is being used. These changes have been made to eliminate a problem where the execution of these verbs was degrading the performance of end-user applications when replication was being used. -------------------------------------------------------------------------------