Installing and configuring SPSS

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

About this task

  • For IBM® Intelligent Operations Center V5.2.1, install and unzip the SPSS .ZIP files in the following order:
    • spss_mod_svr_18.2_lx86_ml.bin that contains SPSS Modeler Server 18
    • spss_mod_btch_18.2_Lx86_ml.bin that contains SPSS Modeler Batch 18
    • SDAP_7.1.2_Linux64.bin that contains SPSS Data Access Pack 7.1.2
    For the SPSS installation, complete the following steps. For further information, see the SPSS Modeler 18.0 Documentation.
  • For IBM Intelligent Operations Center V5.2.0, install and unzip the SPSS .ZIP files in the following order:
    • spss_mod_svr_18.2_lx86_ml.bin that contains SPSS Modeler Server 18
    • spss_mod_btch_18.2_Lx86_ml.bin that contains SPSS Modeler Batch 18
    • SDAP_7.1.2_Linux64.bin that contains SPSS Data Access Pack 7.1.2
    For the SPSS installation, complete the following steps. For further information, see the SPSS Modeler 17.0 Documentation.

Procedure

  1. Log on to the server as a root user.
  2. For IBM Intelligent Operations Center V5.2.1, complete the following steps to extract, install, and configure SPSS:
    1. To launch the Modeler Server installation wizard, enter the following commands in a terminal window: 
      cd /installmedia
chmod a+x spss_mod_svr_18.2_lx86_ml.bin
./spss_mod_svr_18.2_lx86_ml.bin
    2. Complete the steps in the Modeler Server installation wizard. Select Production Mode in the Server Mode window, and set the installation directory to the following value: 
      /opt/IBM/SPSS/ModelerServer/18.0
    3. To launch the Modeler Batch installation wizard, enter the following commands in a terminal window: 
      cd /installmedia/
chmod a+x spss_mod_btch_18.2_Lx86_ml.bin
./spss_mod_btch_18.2_Lx86_ml.bin
    4. Complete the steps in the Modeler Batch installation wizard. Set the installation directory to the following value: 
      /opt/IBM/SPSS/ModelerBatch/18.0
    5. To extract and run the Install Data Access Pack, enter the following commands in a terminal window: 
      cd /installmedia
./SDAP_7.1.2_Linux64.bin
    6. Complete the steps in the Install Data Access Pack setup wizard. Set the installation directory to the following value: 
      /opt/IBM/SPSS/DataAccessPack/7.1.2
    7. To create the SPSS ODBC data sources, complete the following steps:
      1. Enter the following commands in a terminal window to run the setodbcpath.sh script:
        cd /opt/IBM/SPSS/DataAccessPack/7.1.2
tar -zxvf SDAP_7.1.2_linux64.tar.gz
chmod a+x setodbcpath.sh
./setodbcpath.sh
      2. Enter the following command to back up the odbc.ini file:
        cd /opt/IBM/SPSS/DataAccessPack/7.1.2
cp odbc.ini odbc.ini.bk
      3. Edit the odbc.ini file. After the text TraceDll=/opt/IBM/SPSS/DataAccessPack/7.1.2/lib/XEtrc27.so, enter the following content: 
        [IOCDB]
 Driver=/opt/IBM/SPSS/DataAccessPack/7.1.2/lib/XEdb227.so
 Description=IBM Corp. 7.1.2 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
        Note: The odbc.ini 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.
      4. In the /opt/IBM/SPSS/ModelerServer/18.0/bin directory, enter the following commands:
        rm -f libspssodbc.so
ln -s libspssodbc_datadirect.so libspssodbc.so
      5. Edit the modelersrv.sh file in the directory /opt/IBM/SPSS/ModelerServer/18.0 to add the following line to the file after the line SCLEMDNAME=modelersrv_18_0: 
        . /opt/IBM/SPSS/DataAccessPack/7.1.2/odbc.sh
      6. Edit the options.cfg in the /opt/IBM/SPSS/ModelerServer/18.0/config directory:
        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 entering the following commands as the ibmadmin user:
          cd /opt/IBM/SPSS/ModelerServer/18.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.
  3. For IBM Intelligent Operations Center V5.2.0, complete the following steps to extract, install, and configure SPSS:
    1. To launch the Modeler Server installation wizard, enter the following commands in a terminal window: 
      cd /installmedia
chmod a+x spss_mod_svr_17.0_lx86_ml.bin
./spss_mod_svr_17.0_lx86_ml.bin
    2. Complete the steps in the Modeler Server installation wizard. Select Production Mode in the Server Mode window, and set the installation directory to the following value: 
      /opt/IBM/SPSS/ModelerServer/17.0
    3. To launch the Modeler Batch installation wizard, enter the following commands in a terminal window: 
      cd /installmedia/
chmod a+x spss_mod_btch_17.0_Lx86_ml.bin
./spss_mod_btch_17.0_Lx86_ml.bin
    4. Complete the steps in the Modeler Batch installation wizard. Set the installation directory to the following value: 
      /opt/IBM/SPSS/ModelerBatch/17.0
    5. To extract and run the Install Data Access Pack, enter the following commands in a terminal window: 
      mkdir -p /opt/IBM/SPSS/DataAccessPack/7.1
unzip /installmedia/SPSS_DATA_ACCESS_PACK_7.1.1_MP_EN.zip -d /opt/IBM/SPSS/DataAccessPack/7.1
chmod a+x /opt/IBM/SPSS/DataAccessPack/7.1/Linux/SDAP_7.1_Linux64.bin
/opt/IBM/SPSS/DataAccessPack/7.1/Linux/SDAP_7.1_Linux64.bin
    6. Complete the steps in the Install Data Access Pack setup wizard. Set the installation directory to the following value: 
      /opt/IBM/SPSS/DataAccessPack/7.1.1
    7. To create the SPSS ODBC data sources, complete the following steps:
      1. Enter the following commands in a terminal window to run the setodbcpath.sh script:
        cd /opt/IBM/SPSS/DataAccessPack/7.1
tar -zxvf SDAP_7.1_linux64.tar.gz
chmod a+x setodbcpath.sh
./setodbcpath.sh
      2. Enter the following command to back up the odbc.ini file:
        cd /opt/IBM/SPSS/DataAccessPack/7.1
cp odbc.ini odbc.ini.bk
      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.2/lib/XEdb227.so
 Description=IBM Corp. 7.1.2 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
        Note: The odbc.ini 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.
      4. 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
      5. Edit the modelersrv.sh file in the directory /opt/IBM/SPSS/ModelerServer/17.0 to add the following line to the file after the line SCLEMDNAME=modelersrv_17_0: 
        . /opt/IBM/SPSS/DataAccessPack/7.1/odbc.sh
      6. Edit the options.cfg in the /opt/IBM/SPSS/ModelerServer/17.0/config directory:
        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 entering the following commands as the ibmadmin user:
          cd /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.