This is the README file for SQLXPress 2.01. System Requirements PC * Windows 2000 Professional (SP2 or later), Windows XP, or Windows Vista. * Internet Explorer version 4, or later. * A TCP/IP connection to an HP NonStop system. * A monitor that supports a resolution of 1024 x 768 or higher is recommended. NonStop Server * HP NonStop server running G06.26 or later, or H04.03 or later. * NonStop SQL/MX release 2.1 or later. * NonStop SQL/MP, release 350 or later. * TCP/IP. Downloading The Installer Download the installer as follows: 1. Go to the Merlon web page at: www.merlon.com 2. On the right hand side of the page, click on the link to Downloads 3. Click the SQLXPress link near the top of the page. Your browser will ask if you wish to run the program, or save it to disk. You want to save the program to disk. The Save As dialog box will appear. Select a directory on your PC's hard drive in which to save the file. You can use any directory. Click Save to save the file. The program will be saved with the name SQLXxxx.EXE. (Note: xxx is the SQLXPress version number, for example, for version 2.01, the file is called SQLX201.EXE.) Special note: The other download option is: SQLXPress Client This link allows you to download the client (PC) code only. You can use this version if SQLXPress is already installed on the NonStop system. Install SQLXPress To Install SQLXPress you will need a LICENSE file. Contact us at sales@merlon.com to request a license. If SQLXPress is already installed on your PC, you have two choices: Either Keep the previous version, and install this version. Or Replace the previous version with this version. If you wish to keep the previous version, install this version in a different directory, and use a different Start Menu folder. To replace the previous version, install this version in the same directory as the existing version. The previous version will be uninstalled automatically. You can manually uninstall SQLXPress as described below under Uninstall. Once the installation program has been downloaded, run it as follows: 1. Select Run from the Start Menu 2. Enter the program name, including the path of the directory, for example: C:\TEMP\SQLX200.EXE 3. The program will ask for a setup password, enter the password supplied to you by Merlon. If you don’t have the password, contact us at sales@merlon.com. The setup program installs the SQLXPress client, follow the instructions on the screen. By default, the SQLXPress client is installed in: C:\Program Files\Merlon\SQLXPress You can choose another directory, but we recommend you use the default. The SQLXPress setup program adds a shortcut in the Windows Start menu. When the setup program has finished installing the client components, it gives you the option to launch the client. You should check this option. When the client program is started for the first time, it will prompt you for configuration information, and will optionally install the NonStop server components of SQLXPress. Configuration Information. Important Notes: If you are installing an upgrade to the server components to the same location as the existing version, we strongly advise you to delete all background tasks for all users before you proceed with the installation. The server setup program will attempt to delete all existing jobs, but this may fail due to security violation errors. This is particularly important for the standard background tasks which run every day. For SQL/MX versions prior to 2.3, the user id you choose must have permission to write to this OSS directory: /usr/tandem/sqlmx/USERMODULES This is where the SQL/MX module file is placed by the setup program. For release 2.3 and later, the module file is placed in the Guardian install subvolume. In order to configure SQLXPress, you will need to know the following: * A Guardian user name and password. This will be used when installing the NonStop server components * The name of a TCP/IP process running on the NonStop system that can be used to connect from your PC. The default is $ZB01C, you may use a different value on your system. Check with your system administrator. * The TCP/IP address used by this TCP/IP process, for example 192.168.1.2. (Use the SCF command INFO SUBNET $.* to display the IP address of the TCP/IP process.) * A TCP/IP port number which is available for use by SQLXPress. A port number is used to make a connection between a PC client and an SQLXPress server. Note that the port number you choose must not be used by any other applications that share the same TCP/IP process with SQLXPress. Port numbers that are less than 1024 are reserved for special services like FTP and TELNET. Therefore, you must use port numbers greater than 1023. (To find out which port numbers are in use, use the SCF STATUS PROCESS command for the TCP/IP process you plan to use.) If you are unsure about the TCP/IP configuration, contact your system administrator. * A home term name. This should be a permanent device or process name (like $ZHOME, or $VHS). Do not use a dynamic terminal name, for example a dynamic Telnet terminal name. * The name of an SQL/MP catalog in which to register the SQL/MP components of SQLXPress. * The name of an SQL MX catalog and schema for the SQLXPress database. You should set aside a schema for use by SQLXPress, it is not recommended that you share a schema with other applications. * The Task Manager uses a batch scheduling system to control the execution of background tasks. You can choose the batch system to use at setup time. The batch systems that can be used by the task manager are: * NetBatch. This is the standard HP batch scheduler. We recommend that you use NetBatch. * BM (Batch Monitor). This is a simple batch scheduler supplied by Merlon. Important Note: The Merlon Batch Monitor must be licensed to operate correctly. If you do not wish to license the batch monitor, you can use an evaluation copy instead. It does not need to be licensed. The difference between the full version and the evaluation version is that with the evaluation version, only the user who installed the server components will be able to submit batch jobs. Uninstall To uninstall SQLXPress, select the Uninstall option from the Start Menu SQLXPress folder. Alternatively, you can use the Add / Remove Program option in the Windows control panel. Note however, that Add / Remove can only uninstall the most recently installed version. To use Add / Remove Program: 1. From the Windows Start menu, select Settings, Control Panel. 2. Double click on the Add/Remove Programs icon. 3. Select SQLXPress from the list of applications. 4. Click Add / Remove. Release Notes If the client program experiences an unrecoverable error it will create a problem report. You will be prompted to send the problem report to Merlon. Reports should be sent to support@merlon.com. Changes Since 1.00 Note: Items marked with a plus + are available as add-on options, and are subject to additional licensing requirements, contact Merlon for more information. * The setup and configuration wizard has been simplified. * A new session connection mechanism has been implemented. * +Support has been added for Database Administration function for SQL/MP objects. * +Support has been added for an SQL/MP visual query builder. * +Support has been added for MP execution plan management. * An SQL scripting language, called MSL is now included. See the online help for details. * The copy MX Statistics function has been added. This allows you to copy statistics from one set of tables to another. * Backup / Restore statistics enables you to save the statistics for a set of objects, and to restore the saved statistics at a later time. * A Privileges for Tables in a Schema page has been added. From this page you can display (or print) a summary of the privileges granted to the tables and views in a schema. * Support has been added for installing the server components from the client without re-installing the client components. * An SQL Command window is now supported. * Limited support for USC2 columns has been added. Specifically, the data browser page can display and edit USC2 columns. * The user can now configure the standard background tasks. * The task manager now supports saving task specifications to an edit file. This file can then be used to submit a task. For example, this would allow a DBA to run a wizard and save the task specification to a file, without submitting the task. Later on, an operator could use the file to submit the task to the task manager, under his or her user id. * Support has been added for the shared access option for partition management for hash partitioned objects. (Requires SQL/MX 2.3 or later). * Support has been added for the shared access option for populate index. (Requires SQL/MX 2.3 or later). * Support for the reclaim data option for partition managements functions has been added. (Requires SQL/MX 2.3 or later). * Support for the on commit error shared access option has been added. (Requires SQL/MX 2.3 or later). * The performance of the visual query builder has been greatly improved for queries involving a large number of columns. * Various user interface improvements have been made. * Running the server setup program on XYGATE/AC-protected terminals is now supported. * The SQLXPress server can be run under control of the XYGATE/AC product from XYPRO. * The Merlon Batch Monitor now supports the submission of batch jobs by multiple users. * The client now runs under Windows Vista. * A number of defects have also been corrected in this release.