Installing and configuring SPSS

If you want to run the SPSS-based analytics, install and configure SPSS®.

About this task

Install and extract the SPSS files in the following order:
  • spss_mod_svr_17.0_lx86_ml.bin that contains SPSS Modeler Server 17
  • spss_mod_btch_17.0_Lx86_ml.bin that contains SPSS Modeler Batch 17
  • SPSS_DATA_ACCESS_PACK_7.1.1_MP_EN.zip that contains SPSS Data Access Pack 7.1.1
For the SPSS installation, complete the following steps. For further information, see the SPSS Modeler 17.0 Documentation.

Procedure

  1. Extract and install Modeler Server. Follow the instructions in the installer, and set the installation directory to the following value: 
    /opt/IBM/SPSS/ModelerServer/17.0
  2. Extract and install Modeler Batch. Follow the instructions in the installer, and set the installation directory to the following value: 
    /opt/IBM/SPSS/ModelerBatch/17.0
  3. Install Data Access Pack. Follow the instructions in the installer, and set the installation directory to the following value: 
    /opt/IBM/SPSS/DataAccessPack/7.1
    1. If a second installer is not launched automatically, navigate to the /opt/IBM/SPSS/DataAccessPack/7.1 directory and run setup to complete the installation. If the second installer requests an installation directory, set the directory to the following value: 
      /opt/IBM/SPSS/DataAccessPack/7.1

To create the SPSS ODBC data sources, complete the following steps:

  1. Run the setodbcpath.sh script in the following directory: 
    /opt/IBM/SPSS/DataAccessPack/7.1
  2. Back up the odbc.ini file in the following directory: 
    /opt/IBM/SPSS/DataAccessPack/7.1
  3. Edit the odbc.ini file. After the text TraceDll=/opt/IBM/SPSS/DataAccessPack/7.1/lib/XEtrc27.so, enter the following content: 
    [IOCDB]
 Driver=/opt/IBM/SPSS/DataAccessPack/7.1/lib/XEdb227.so
 Description=IBM Corp. 7.1 DB2 Wire Protocol
 AccountingInfo=
 AddStringToCreateTable=
 AlternateID=
 AlternateServers=
 ApplicationName=
 ApplicationUsingThreads=1
 AuthenticationMethod=0
 BulkBinaryThreshold=32
 BulkCharacterThreshold=-1
 BulkLoadBatchSize=1024
 BulkLoadFieldDelimiter=
 BulkLoadRecordDelimiter=
 CatalogSchema=
 CharsetFor65535=0
 ClientHostName=
 ClientUser=
 #Collection applies to z/OS and iSeries only
 Collection=
 ConcurrentAccessResolution=0
 ConnectionReset=0
 ConnectionRetryCount=0
 ConnectionRetryDelay=3
 CurrentFuncPath=
 #Database applies to DB2 UDB only
 Database=IOCDB
 DefaultIsolationLevel=1
 DynamicSections=1000
 EnableBulkLoad=0
 EncryptionMethod=0
 FailoverGranularity=0
 FailoverMode=0
 FailoverPreconnect=0
 GrantAuthid=PUBLIC
 GrantExecute=1
 GSSClient=native
 HostNameInCertificate=
 IpAddress=localhost
 KeyPassword=
 KeyStore=
 KeyStorePassword=
 LoadBalanceTimeout=0
 LoadBalancing=0
 #Location applies to z/OS and iSeries only
 Location=
 LogonID=
 MaxPoolSize=100
 MinPoolSize=0
 Password=
 PackageCollection=NULLID
 PackageNamePrefix=DD
 PackageOwner=
 Pooling=0
 ProgramID=
 QueryTimeout=0
 ReportCodePageConversionErrors=0
 TcpPort=50002
 TrustStore=
 TrustStorePassword=
 UseCurrentSchema=0
 ValidateServerCertificate=1
 WithHold=1
 XMLDescribeType=-10 

[IOCDATA]
 Driver=/opt/IBM/SPSS/DataAccessPack/7.1/lib/XEdb227.so
 Description=IBM Corp. 7.1 DB2 Wire Protocol
 AccountingInfo=
 AddStringToCreateTable=
 AlternateID=
 AlternateServers=
 ApplicationName=
 ApplicationUsingThreads=1
 AuthenticationMethod=0
 BulkBinaryThreshold=32
 BulkCharacterThreshold=-1
 BulkLoadBatchSize=1024
 BulkLoadFieldDelimiter=
 BulkLoadRecordDelimiter=
 CatalogSchema=
 CharsetFor65535=0
 ClientHostName=
 ClientUser=
 #Collection applies to z/OS and iSeries only
 Collection=
 ConcurrentAccessResolution=0
 ConnectionReset=0
 ConnectionRetryCount=0
 ConnectionRetryDelay=3
 CurrentFuncPath=
 #Database applies to DB2 UDB only
 Database=IOCDATA
 DefaultIsolationLevel=1
 DynamicSections=1000
 EnableBulkLoad=0
 EncryptionMethod=0
 FailoverGranularity=0
 FailoverMode=0
 FailoverPreconnect=0
 GrantAuthid=PUBLIC
 GrantExecute=1
 GSSClient=native
 HostNameInCertificate=
 IpAddress=localhost
 KeyPassword=
 KeyStore=
 KeyStorePassword=
 LoadBalanceTimeout=0
 LoadBalancing=0
 #Location applies to z/OS and iSeries only
 Location=
 LogonID=
 MaxPoolSize=100
 MinPoolSize=0
 Password=
 PackageCollection=NULLID
 PackageNamePrefix=DD
 PackageOwner=
 Pooling=0
 ProgramID=
 QueryTimeout=0
 ReportCodePageConversionErrors=0
 TcpPort=50002
 TrustStore=
 TrustStorePassword=
 UseCurrentSchema=0
 ValidateServerCertificate=1
 WithHold=1
 XMLDescribeType=-10
  4. Copy the odbc.ini file to the following directory: 
    /opt/IBM/SPSS/DataAccessPack/7.1
    Note: This file defines two new ODBC data sources, IOCDB and IOCDATA, on localhost. If the databases are hosted on different servers, update the IP address and TCP port properties for each data source to point to the appropriate server.
  5. In the /opt/IBM/SPSS/ModelerServer/17.0/bin directory, enter the following commands: 
    rm -f libspssodbc.so
ln -s libspssodbc_datadirect.so libspssodbc.so
  6. Edit the modelersrv.sh file in the following directory: 
    /opt/IBM/SPSS/ModelerServer/17.0
    1. Add the following line to the file after the line SCLEMDNAME=modelersrv_17_0: 
      . /opt/IBM/SPSS/DataAccessPack/7.1/odbc.sh
  7. Edit the options.cfg in the following directory: 
    /opt/IBM/SPSS/ModelerServer/17.0/config
    1. Set the value of start_process_as_login_user to Y.
    2. If the model server is already started, stop and restart the server by running the following commands as the ibmadmin user from /opt/IBM/SPSS/ModelerServer/17.0 
      ./modelersrv.sh stop
./modelersrv.sh start
./modelersrv.sh list
      Note: Ensure that the ASKSPSSEnabled system property is set to true. Also, ensure that the ID and password credentials in the ASKCredentials system property are correct for your solution.