Instructions for the iSeries
This document describes installation of SequeLink Server for the iSeries. Throughout this document, the term iSeries refers to the IBM eServer iSeries 400 and AS/400. Installation instructions for SequeLink Client can be found on the SPSS Data Access Pack CD; in SPSS Data Access Pack Installation Instructions for a Windows client, and in SPSS Data Access Pack Installation Instructions for UNIX for a UNIX client. Important: Make sure that you are installing SequeLink Server on the iSeries hosting your DB2/400 database. Use the installation instructions in this document, not the DataDirect installation instructions, to perform the initial installation steps for SequeLink Server. Use the DataDirect SequeLink documentation to configure and manage SequeLink Server. The document
Documentation/Merant/Sequelink/books.pdf, located on the SPSS Data Access Pack CD, contains links to all of the SequeLink documentation.
Requirements
SequeLink Server requirements vary according to the operating system on which you run SequeLink Server and the database that you are using.
SequeLink Server 4.51 is the supported version for the iSeries. The supported iSeries database is DB2/400. For requirements details, see the documentation for your SPSS product and the DataDirect SequeLink documentation.
Installing SequeLink Server
Install SequeLink Server on the computer that is running your database.
Restore the installation and product components E Start an OS/400 terminal session.
E In theQGPLlibrary, create a save file calledSQINS405. On the OS/400 command line, type:
CRTSAVF QGPL/SQINS405 E PressEnter.
E In theQGPLlibrary, create a save file calledsqv3r7m0. On the OS/400 command line, type:
CRTSAVF QGPL/sqv3r7m0 E PressEnter.
E Copy theSQINS405save file from the CD-ROM to theSQINS405save file in the QGPLlibrary. On the OS/400 command line, type:
CPYFRMSTMF FROMSTMF('/QOPT/SPSS/Merant/SLServer/as400/SQINS405.SAV') tombr('/QSYS.LIB/ QGPL.LIB/SQINS405.FILE') MBROPT(*REPLACE)
E When installing from the Clementine product CD use:
CPYFRMSTMF FROMSTMF(’/QOPT/SQLNKS/SQINS405.SAV’) tombr(’/QSYS.LIB/ QGPL.LIB/SQINS405.FILE’) MBROPT(*REPLACE)
E PressEnter.
E Copy thesqv3r7m0save file from the CD-ROM to thesqv3r7m0save file in theQGPL library. On the OS/400 command line, type:
CPYFRMSTMF FROMSTMF('/QOPT/SPSS/Merant/SLServer/as400/sqv3r7m0.SAV') tombr('/QSYS.LIB/ QGPL.LIB/sqv3r7m0.FILE') MBROPT(*REPLACE)
E When installing from the Clementine product CD use:
CPYFRMSTMF FROMSTMF(’/QOPT/SQLNKS/SQV3R7M0.SAV’) tombr(’/QSYS.LIB/QGPL.LIB/ SQV3R7M0.FILE’) MBROPT(*REPLACE)
E PressEnter.
E Restore the installation program files library. On the OS/400 command line, type: RSTLIB SAVLIB(SQINST405) DEV(*SAVF) SAVF(QGPL/SQINS405)
Install SequeLink Server
Note: During installation, you will see a message that V5R2 is not a supported OS/400 release. You can safely ignore this message since you will apply a patch for V5R2 compatibility after installing SequeLink Server.
E Add theSQINST405library to your library list. On the command line, type: ADDLIBLE SQINST405
E Enter the SequeLink Server installation command. On the command line, type: SQINSTALL FROM(*FILE) SAVF(QGPL/sqv3r7m0)
E PressEnter.
E TheSequeLink for DB2/400 V 4.5 Installationscreen appears. To accept the default SQLNK45installation library, pressEnter. To choose another installation library, enter the library name and pressEnter.
E If SequeLink Server is already installed on the iSeries, aLibrary already exists message appears. To exit the installation, typeC. To install SequeLink Server over the current installation, typeI. To install SequeLink Server in another library, typeR. E PressEnter.
E ARestoring SequeLink Product Librarymessage appears. The install asksWhat type of network are you using? EnterTCP.
E TheINTERSOLV Product Registrationscreen appears. Enter the following values: Table 1
SequeLink Server 4.51 Registration Information
Name: Your name or company contact.
Company: Company where you are installing SequeLink Server.
Serial Number: 000000456829
IPE: Leave blank.
E PressEnter.
E TheLicense Agreementscreen appears. To accept the License Agreement, pressF10. E The messageINTERSOLV Product Registration successfulappears. To exit the
installation, pressF3.
E The messageStart TCPSPAWN listener job now?appears. TypeNOand pressEnter. Note: You can edit the SequeLink Server registration information after the install. On the OS/400 command line, type:
ADDLIBLE SQLNK45
whereSQLNK45is the SequeLink Server installation library. EDTIPEKEY
Apply the SequeLink Server Patch
Apply the latest patch for SequeLink Server for V5R2. The patch allows SequeLink Server to work with V5R2 and fixes several issues for support of Clementine. The patch is located in a zip file on the Data Access Pack CD at:
/QOPT/SPSS/Merant/SLServer/as400/V5R2ptch/sqv4r5m0.zip.
Note: Apply this patch after installing Sequelink Server but before starting the
TCPSPAWNlistener.
E In theQGPLlibrary, create a save file calledV5R2PATCH. On the OS/400 command line, type:
CRTSAVF QGPL/V5R2PATCH E PressEnter.
E Copy thesqv4r5m0file from the CD-ROM to theV5R2PATCHsave file in theQGPL library. On the OS/400 command line, type:
CPYFRMSTMF FROMSTMF('/QOPT/SPSS/Merant/SLServer/as400/V5R2ptch/sqv4r5m0') TOMBR('/QSYS.LIB/ QGPL.LIB/V5R2PATCH.FILE') MBROPT(*REPLACE)
E When installing from the Clementine product CD use:
CPYFRMSTMF FROMSTMF(’/QOPT/SQLNKS/V5R2PTCH/SQV4R5M0’) TOMBR(’/QSYS.LIB/ QGPL.LIB/V5R2PATCH.FILE’) MBROPT(*REPLACE)
E PressEnter.
E Rename theTCPandAPPCprogram objects within theSQLNK45library so they are not overwritten when the patch is installed. You will need these objects if you need to back out the patch.
E Restore objects from the save file to theSQLNK45library. On the OS/400 command line, type:
RSTOBJ OBJ(*ALL) SAVLIB(SQV4R5M0) DEV(*SAVF) SAVF(V5R2PATCH) RSTLIB(SQLNK45) MBROPT(*ALL) ALWOBJDIF(*ALL)
E Rename the existing objectsSSTCPNONEandSSTCPALLtoSSTCPNONE0and
SSTCPALL0, respectively.
E Copy theTCPobject to replace theSSTCPNONEandSSTCPALLobjects with these commands:
CRTDUPOBJ OBJ(TCP) FROMLIB(SQLNK45) OBJTYPE(*PGM) NEWOBJ(SSTCPNONE) CRTDUPOBJ OBJ(TCP) FROMLIB(SQLNK45) OBJTYPE(*PGM) NEWOBJ(SSTCPALL)
Start TCPSPAWN Listener
E Add the SequeLink Server installation library to your library list. On the OS/400 command line, type:
ADDLIBLE SQLNK45
whereSQLNK45is the SequeLink Server installation library. E On the OS/400 command line, type:
CALL STRTCPSPWN E PressEnter.
License SequeLink Server
Before you use SequeLink Server on the iSeries, you need to license it to run with SPSS products. To do so, follow these steps:
E Add the SequeLink Server installation library to your library list. On the OS/400 command line, type:
ADDLIBLE SQLNK45
whereSQLNK45is the SequeLink Server installation library. E Edit the service initialization file. On the command line, type:
EDTSQSRV TCPNONE
whereTCPNONEis the name of the service for which you want to set theOEMId. E In the[access control]section of the service initialization file, add the following key:
OEMId = 14804390