====================================================================== SQL/R A.01.60 - INSTALLATION ====================================================================== The installation procedure has been changed for the SQL/R product starting with release A.01.40. The installation procedure as described in the printed manual no longer applies. The new installation procedure is described in this document for HP-UX 9.x and HP-UX 10.x. Major changes of SQL/R release A.01.40 include: o SQL/R A.01.40 can only be installed and run on the HP-UX operating system release 9.0 or later. o SQL/R no longer needs its own installation or update tools, as it is now installed and updated by the usual operating system tools. o SQL/R A.01.40 uses a new licence scheme. Instead of "branding" the executable files with a system id, a licence file is now present at /etc/opt/sqlr/licence (HP-UX 10.x) or /opt/sqlr/etc/licence (HP-UX 9.x). The licence file is a plain text file which contains all licences which apply to the SQL/R product. The /opt/sqlr/etc/chklic utility may be used to check the licence file. o The SQL/R server is no longer installed separately. All files related to the SQL/R product will be installed automatically. Please note, that you need an apropriate licence entry in the licence file in order to use optional extensions. o SQL/R A.01.40 has a different file structure than recent SQL/R releases in order to be HP-UX 10.x compliant. This new file structure is also provided on HP-UX 9.x. Please refer to /opt/sqlr/newconfig/ReleaseNotes/A.01.40 for details. ______________________________________________________________________ Installation ============ NOTE: Hard disk minimum available space for installation: 20 Mbytes. Installing on HP-UX 9.x: ------------------------ As "superuser," follow the steps below to install the SQL/R software. 1. Insert the SQL/R DDS tape into your tape drive and extract the software from tape to a temporary location. cd /tmp tar xf /dev/rmt/0m SQLR.updt where /dev/rmt/0m is your DDS tape device file. 2. To install SQL/R, run "update(1m)" by typing: /etc/update 3. Select "Change Source or Destination ->". 4. Select "From Tape Device to Local System ...". 5. Tab to the "Source" field and enter the following: /tmp/SQLR.updt 6. Press "Done". 7. Select "Select/View Partitions and Filesets ..." 8. Activate the SQLR partition and additional either the SQLR-E (for English localisation) or the SQLR-G (for German localisation) partition. 9. Select "Start Loading". 10. Type "y" to "Start loading filesets now?". 11. Check /tmp/update.log to make sure installation completed with no error. 12. You may want to include /opt/sqlr/bin in your PATH. To achieve this for all users, you may edit the /etc/profile. Append the the following line: PATH=$PATH:/opt/sqlr/bin To include SQL/R in the path of an individual user, you may add the line to the .profile in the home directory. Installing on HP-UX 10.x: ------------------------- As "superuser," follow the steps below to install the SQL/R software. 1. Insert the SQL/R DDS tape into your tape drive and extract the software from tape to a temporary location. cd /tmp tar xf /dev/rmt/0m SQLR.sd where /dev/rmt/0m is your DDS tape device file. 2. To install SQL/R, run "swinstall" by typing: /usr/sbin/swinstall -s /tmp/SQLR.sd where /tmp/SQLR.sd is the path to the file extracted from DDS tape 5. In the Software Selection Window, highlight to select either the "SQLR-E" product (for English localisation) or the "SQLR-G" product (for German localisation) then choose the "Mark for Install" item from the Actions Menu. The "Marked?" column will be automatically be set to "Yes". 6. Select the "Install (analysis...)" item from the Actions Menu. When the analysis is finished with no error, i.e. Status:Ready, click OK. 7. Click Yes in the Confirmation window to begin the actual installation. 8. When the installation is completed, a dialog is displayed to notify you that the install task is completed. You may exit then. Deleting the old SQL/R Version ------------------------------ If this is an update of SQL/R you have to manually delete the old software which is stored under /usr/sqlr. Deleting the old SQL/R software may acomplished by the following commands: 1. Login as root 2. cd /usr 3. rm -rf sqlr 4. rm /usr/lib/nls/C/sqlr.cat rm /usr/lib/nls/german/sqlr.cat Please Note: The procedure above will remove all files stored in the tree under /usr/sqlr. If you installed you own files you should move them to a save location first. Please check for references to the former SQL/R location in your PATH variable. You might want to check /etc/profile and .profile in the users home directories. If your software depends on the old location -------------------------------------------- If your software depends on the old pathes, it is possible to create a symbolic link. 1. Login as root 2. ln -s /opt/sqlr/bin /usr/sqlr ______________________________________________________________________ Starting the SQL/R ODBC server on HP-UX 10.x. On HP-UX 10.x it is possible to specify in a configuration file, if the SQL/R ODBC server should be started automatically on system startup. The configuration file is /etc/rc.config.d/sqlr. If you set the START_SQLRODBCD to 1, then HP-UX will startup the SQL/R ODBC server on transition into run level 2. If you configured the START_SQLRODBCD variable, you may use the followings commands to manually startup/shutdown the SQL/R ODBC server: /sbin/init.d/sqlr start /sbin/init.d/sqlr stop ______________________________________________________________________ Starting the SQL/R server on HP-UX 10.x. The SQL/R server is required in order to use the SQL/R Windows Client option. If you don't use it, there is no need to start this server. On HP-UX 10.x it is possible to specify in a configuration file, if the SQL/R server should be started automatically on system startup. The configuration file is /etc/rc.config.d/sqlr. If you set the START_SQLRD to 1, then HP-UX will startup the SQL/R server on transition into run level 2. If you intend to start the SQL/R server by inetd, you must set the START_SQLRD variable to 0. If you configured the START_SQLRD variable, you may use the followings commands to manually startup/shutdown the SQL/R server: /sbin/init.d/sqlr start /sbin/init.d/sqlr stop ______________________________________________________________________ Please refer to directory /opt/sqlr/newconfig/ReleaseNotes, file A.01.40 for further documentation about fixed problems or enhancement documentation. Directory /opt/sqlr/newconfig/ReleaseNotes contains the following files: README.g - Release Notes in German Lanaguage README.e - Release Notes in English Language INSTALL - How to install or update SQL/R A.01.35 - SQL/R A.01.35 release notes A.01.40 - SQL/R A.01.40 release notes A.01.41 - SQL/R A.01.41 release notes A.01.42 - SQL/R A.01.42 release notes A.01.50 - SQL/R A.01.50 release notes A.01.51 - SQL/R A.01.51 release notes README.srv - SQL/R Server release notes README.odbc - SQL/R ODBC release notes Files with the extension 'g' are in german language, files with extension 'e' are english language. ______________________________________________________________________ New product structure ===================== With the release of HP-UX 10.0, Hewlett-Packard has introduced a new filesystem layout paradigm, modelled after SVR4 and OSF. The model provides many benefits, such as separating the operating system from applications and aligning HP with an industry-accepted file system layout. SQL/R A.01.40 follows the HP-UX 10.0 file system conventions and provides a similar file structure with HP-UX 9.x and HP-UX 10.x. /opt/sqlr/ Base directory | |--- etc/ Utility programs | HP-UX 9.x: Application specific | configuration files | |--- bin/ Executable programs | |--- lib/ Libraries | | | |--- nls/ | | | |--- C/ Default message catalog | |--- german/ German message catalog | |--- newconfig/ | | | |--- ReleaseNotes/ Release Notes | | | |--- etc/ Example licence file | | | |--- startup/ HP-UX 10.0 startup/shutdown scripts | |--- share/ | | | |--- map/ Character set mappings | | | |--- sample/ Example scripts (from manual) | | Linked to a language dependend directory | |--- sample.e/ o English example scripts | |--- sample.g/ o German example scripts | | | |--- db/ Example database | | Linked to a language dependend directory | |--- db.e/ o English example database | |--- db.g/ o German example database | | | |--- example/ Example programs The following directories are only present with HP-UX 10.x: /etc/opt/sqlr/ Application specific configuration files /var/opt/sqlr/ Application specific temporary files /etc/rc.config.d/ Startup configuration files /sbin/ | | --- init.d/ Startup and shutdown scripts | | --- rc1.d/ Startup and shutdown link files | --- rc2.d/ for script sequencing