Installing on the server

This chapter provides information about installing DB2 Everyplace on a server. The topics covered are:

Pre-installation tasks

This chapter provides information about the pre-installation steps that you need to perform before installing DB2 Everyplace on a server. The topics covered are:

Adjusting operating system parameters for Linux

In order for DB2 Everyplace to operate with the highest degree of efficiency, system parameters in DB2 Universal Database need to be adjusted. Failure to do so, can result in the inability to create a new connection to the database on Linux. It is recommended that the kernel parameters are adjusted.

Note:
Only 32 bit DB2 Universal Database instances are supported.

Prerequisites

Modify the login profile to include the following:

export DISPLAY=<workstation>:0.0

Where <workstation> is the UNIX workstation where you want to use the Mobile Devices Administration Center.

Procedure

For Linux systems running kernel 2.4 or higher, issue the following commands on the command line as the root user:

To execute the commands automatically, edit the file /etc/rc.d/rc.local, and place the above commands at the end of the file. On every subsequent system boot, the values will be set automatically. Additional setting recommendations can be found in the Linux 7.2 Release Notes for the fix pack you are running.

Related tasks

Adjusting operating system parameters for Solaris

In order for DB2 Everyplace to operate with the highest degree of efficiency, system parameters in DB2 Universal Database need to be adjusted. Failure to do so, can result in unexpected interruptions. It is recommended that the kernel parameters are adjusted.

Note:
Only 32 bit DB2 Universal Database instances are supported.

Prerequisites

Modify the login profile to include the following:

export DISPLAY=<workstation>:0.0

Where <workstation> is the UNIX workstation where you want to use the Mobile Device Administration Center.

Procedure

For Solaris systems, the default system kernel parameters are insufficient to run DB2 Universal Database and DB2 Everyplace. These values can be added or edited in the file, /etc/system.

The format for setting these values is:

set parameter_name = value

The suggested parameters in the DB2 Universal Database should be further adjusted to include the following minimum values:

After modification of any kernel parameters, reboot the system to make the kernel settings effective.

Related tasks

Adjusting operating system parameters for AIX

In order for DB2 Everyplace to operate with the highest degree of efficiency, system parameters in DB2 Universal Database need to be adjusted. Failure to do so, can result in the inability to create a new connection to the database. The extended shared memory segments should be enabled.

Note:
Only 32 bit DB2 Universal Database instances are supported.

Prerequisites

Modify the login profile to include the following:

export DISPLAY=<workstation>:0.0

Where <workstation> is the UNIX workstation where you want to use the Mobile Devices Administration Center.

Procedure

For each DB2 instance running DB2 Everyplace:

  1. Modify the login profile (most likely /home/<username>/.profile), to include the following:
    export EXTSHM=ON
    
  2. Exit the user shell.
  3. Login as the user (to make the changes effective) and open a new shell.
  4. From the shell prompt, execute the following command:
    db2set DB2ENVLIST=EXTSHM 
    
  5. Restart the DB2 Universal Database instance.

Related tasks

Installing on the server

You need to install DB2 Everyplace on a server and on each mobile device or emulator that connects to the server.

Related tasks

Installing on a server for Windows

Complete the following steps to install DB2 Everyplace on a Windows.

Procedure

  1. Run the setup program:

    If you are installing from a CD-ROM:

    If you are installing from the DB2 Everyplace Web site:

    The Welcome panel opens.
  2. Click Next to read the Install Notes. After reading the Install Notes, click Next to view the License Agreement. After accepting the License Agreement, click Next to open the Destination directory panel.
  3. Type the directory where you would like to install DB2 Everyplace or click Browse to select a directory. After selecting the destination directory, click Next. The Select the installation type panel opens.
  4. Select the installation setup type: Click Next.
  5. If you select Typical, the DB2 Everyplace Setup Wizard: Proceed to Step 10.
  6. If you select the Custom installation setup type:
    1. A panel opens where you can select the features that you want to install. Click Next. The Select install actions panel opens.
    2. Select the check box next to the installation action that you want to enable. You can select both options, but you must select at least one. If you do not select an installation action, you will receive an error. Specify whether you would like the Setup Wizard to install DB2 Everyplace on your computer or to generate a response file. A response file is used to record the user responses required during an interactive installation. It can be used for automating installation on other computers. After selecting the appropriate installation actions, click Next. The Select sample actions panel opens.
    3. Select the check box next to the sample action that you want to enable. You can specify whether you would like the Setup Wizard to create the DB2 Everyplace sample databases and Visiting Nurse sample application, or to install a pre-configured windows client for demonstrating synchronization with the DB2 Everyplace Sync Server. Click Next. The Select Service action panel opens.
    4. Select the check box if you want the Setup Wizard to start the Windows Service for DB2 Everyplace Sync Server at the end of the installation. Click Next.
    Proceed to Step 10.
  7. If you select Multiple server:
    1. A panel opens where you can select the features that you want to install. Click Next. The Select Installation actions panel opens.
    2. Select the check box next to the installation action that you want to enable. You can select both options, but you must select at least one. If you do not select an installation action, you will receive an error. Specify whether you would like the Setup Wizard to install DB2 Everyplace on your computer or to generate a response file. A response file is used to record the user responses required during an interactive installation. It can be used for automating installation on other computers. After selecting the appropriate installation actions, click Next. The Select sample actions panel opens.
    3. Select the check box next to the sample action that you want to enable. You can specify whether you would like the Setup Wizard to create the DB2 Everyplace sample databases and Visiting Nurse sample application, or to install a pre-configured windows client for demonstrating synchronization with the DB2 Everyplace Sync Server. Click Next. The Select Control database action panel opens.
    4. A panel opens where you can select whether you would like the Setup Wizard to create control database on this computer. Select the check box next to Create DB2 Everyplace Sync Server control database if you would like this server to have the control database and Click Next. If you choose not to create the control database on this server, Remote Control database information panel opens. If you choose to create the control database on this server, Proceed to Step 10.
    5. Type the hostname of the machine on which the remote control database resides, the connection port for the DB2 instance, the name of the node which will be created in the local node directory to catalog the remote control database, user name and the password to connect to the remote control database. Click Next. Proceed to Step 10.
  8. If you select Control database only:

    Proceed to Step 13.

  9. If you select DB2 Everyplace Sync Server only:
    1. A panel opens where you can select the features that you want to install. Click Next. The Select install actions panel opens.
    2. Select the check box next to the installation action that you want to enable. You can select both options, but you must select at least one. If you do not select an installation action, you will receive an error. Specify whether you would like the Setup Wizard to install DB2 Everyplace on your computer or to generate a response file. A response file is used to record the user responses required during an interactive installation. It can be used for automating installation on other computers. After selecting the appropriate installation actions, click Next. The Select service action panel opens.
    3. Select the check box if you want the Setup Wizard to start the Windows Service for DB2 Everyplace Sync Server at the end of the installation. Click Next. The Remote Control database information panel opens.
    4. Type the hostname of the machine on which the remote control database resides, the connection port for the DB2 instance, the name of the node which will be created in the local node directory to catalog the remote control database, and the user name and password to connect to the remote control database. Click Next. Proceed to 14.
  10. Informational panels open if you do not have DB2 Universal Database installed on your computer. If you have DB2 Universal Database installed on your computer, proceed to Step 11.
    1. You will be required to specify the directory where you would like to install the embedded version of DB2 Universal Database. Type the name of the directory, or click Browse to select the directory name. After specifying the directory, click Next
    2. You will be required to specify the user information for the DB2 UDB Database Administration Server. You can either use an existing Administrative user or specify a new user that will be created on your computer. Select the check box in order to use the same authentication information for the DB2 Everyplace Sync Server. Click Next. If you select the check box, proceed to Step 14.
  11. The JDBC migration panel opens. Select Yes if would you like to migrate the JDBC subscriptions at the end of the DB2 Everyplace installation. The migration process requires that the sources databases used in the JDBC subscriptions be active during the migration process. In addition, you must perform the steps listed Migration considerations for Version 8.1.4. If you select No, you must migrate the JDBC subscriptions before you can start the DB2 Everyplace Sync Server. Click Next. The User reset panel opens.
  12. This panel lists the users with unfinished synchronizations sessions or cancelled synchronizations. When DB2 Everyplace migrates the message store table, the data in this table is deleted. Users with unfinished synchronization sessions will receive an error when they try to synchronize again after DB2 Everyplace is migrated to Version 8.1.4. To avoid receiving this error, the users must be reset. Select Yes if you would like to have the users reset at the end of the installation. Click Next.
  13. The Specify DB2 UDB logon information panel opens. Type the authentication information that DB2 Everyplace Sync Server will use to logon to the DB2 UDB DAS. After specifying the required information, Click Next.
  14. The Pre-Install summary panel opens which lists the features that will be installed on your computer and the configuration information for the DB2 Everyplace Sync Server. It will also list the configuration information for the embedded Application Server. The Server port and the SSL port listed on this panel is used by the clients to synchronize with the DB2 Everyplace Sync Server. After reading the pre-install summary, click Next.
  15. The Installation begins as the progress bar charts the progress of the installation.
    Note:
    The following list applies to the typical installation type only. For other installations types, the installation Setup Wizard performs a subset of these tasks.
    During the installation of the typical installation type, the installation Setup Wizard:
  16. Congratulations! You've successfully installed DB2 Everyplace.

Related tasks

Installing on a server for UNIX

Complete the following steps to install DB2 Everyplace on a UNIX.

Procedure

  1. Run the setup program DB2Everyplace.bin as the root user. The Welcome panel opens.
  2. Click Next to read the Install Notes. After reading the Install Notes, click Next to view the License Agreement. After accepting the License Agreement, click Next to open the Select the installation type.
  3. Select the installation setup type: Click Next.
  4. If you select Typical, the DB2 Everyplace Setup Wizard: Proceed to Step 10.
  5. If you select the Custom installation setup type:
    1. A panel opens where you can select the features that you want to install. Click Next. The Select install actions panel opens.
    2. Select the check box next to the installation action that you want to enable. You can select both options, but you must select at least one. If you do not select an installation action, you will receive an error. Specify whether you would like the Setup Wizard to install DB2 Everyplace on your computer or to generate a response file. A response file is used to record the user responses required during an interactive installation. It can be used for automating installation on other computers. After selecting the appropriate installation actions, click Next. The Select UNIX post install actions panel opens.
    3. Select the check box next to the post install actions that you want to enable. You can specify whether you would like the Setup Wizard to create the DB2 Everyplace Sync Server instance or to create the DB2 Everyplace sample databases and Visiting Nurse server sample application. Click Next.
  6. If you select Multiple server:
    1. A panel opens where you can select the features that you want to install. Click Next. The Select install actions panel opens.
    2. Select the check box next to the installation action that you want to enable. You can select both options, but you must select at least one. If you do not select an installation action, you will receive an error. Specify whether you would like the Setup Wizard to install DB2 Everyplace on your computer or to generate a response file. A response file is used to record the user responses required during an interactive installation. It can be used for automating installation on other computers. After selecting the appropriate installation actions, click Next. The Select UNIX post install actions panel opens.
    3. Select the check box next to the post install actions that you want to enable. You can specify whether you would like the Setup Wizard to create the DB2 Everyplace Sync Server instance. You can also specify whether you would like the Setup Wizard to create the control database for this DB2 Everyplace Sync Server instance. You can also specify whether you would like the Setup Wizard to create the DB2 Everyplace sample databases and Visiting Nurse server sample application for the DB2 Everyplace Sync Server instance being created. After selecting the appropriate Post install actions, Click Next.
    4. If you chose not to create the DB2 Everyplace Sync Server control database for the DB2 Everyplace Sync Server instance, Remote control database information panel opens. Type the hostname of the remote machine which hosts the control database, connection port for the DB2 instance and the name for the local node being created to catalog the remote control database. Click Next to proceed to Step 9.
  7. If you select Control database only:

    Proceed to Step 11.

  8. If you select DB2 Everyplace Sync Server only:
    1. A panel opens where you can select the features that you want to install. Click Next, the Select install actions panel opens.
    2. Select the check box next to the installation action that you want to enable. You can select both options, but you must select at least one. If you do not select an installation action, you will receive an error. Specify whether you would like the Setup Wizard to install DB2 Everyplace on your computer or to generate a response file. A response file is used to record the user responses required during an interactive installation. It can be used for automating installation on other computers. After selecting the appropriate installation actions, click Next. The Select UNIX post install actions panel opens.
    3. Select the check box next to the post install action that you want to enable. You can specify whether you would like the Setup Wizard to create the DB2 Everyplace Sync Server instance. Click Next.
    4. The Specify DB2 Everyplace Sync Server instance information panel opens. Type the user name, password, and the locale for the DB2 Everyplace Sync Server instance. After specifying the required information, click Next. The Remote Control database information panel opens.
    5. Type the hostname of the machine on which the remote control database resides, the connection port for the DB2 instance, the name of the node which will be created in the local node directory to catalog the remote control database, user name and the password to connect to the remote control database. Click Next to proceed to Step 12.
  9. Informational panels open if you do not have DB2 Universal Database installed on your computer. If you have DB2 Universal Database installed on your computer, proceed to Step 6.
    1. You will be required to specify the user information for the DB2 Database Administration Server instance. Type the name of the user, the password, the name of the primary group and the users home directory. Click Next.
    2. You will be required to specify the user information for the DB2 instance owner. Type the name of the user, the password, the name of the primary group and the user's home directory. Click Next.
    3. You will be required to specify the user information for the DB2 fenced user. Type the name of the user, the password, the name of the primary group and the user's home directory. Click Next.
  10. The Sync Server instance migration panel opens. Select Yes if you would like the Setup Wizard to migrate the JDBC subscriptions for the existing DB2 Everyplace Sync Server instances. Select Yes if you would you like the Setup Wizard to reset the users at the end of the installation.

    The reason for these choices:

  11. The Specify DB2 Everyplace Sync Server instance information panel opens. Type the user name, password, and the locale for the DB2 Everyplace Sync Server instance. After specifying the required information, click Next.
  12. The Pre-Install summary panel opens which lists the features that will be installed on your computer and the configuration information for the DB2 Everyplace Sync Server. It will also list the configuration information for the embedded Application Server - Express. The Server port and the SSL port listed on this panel is used by the clients to synchronize with the DB2 Everyplace Sync Server. After reading the pre-install summary, click Next.
  13. The Installation begins as the progress bar charts the progress of the installation. During the installation, the installation Setup Wizard:
  14. Congratulations! You've successfully installed DB2 Everyplace.

Related tasks

Installing DB2 Everyplace Express on a server for Windows

Complete the following steps to install DB2 Everyplace on a Windows.

Procedure

  1. Run the setup program:

    If you are installing from a CD-ROM:

    If you are installing from the DB2 Everyplace Web site:

  2. Click Next to read the Install Notes. After reading the Install Notes, click Next to view the License Agreement. After accepting the License Agreement, click Next to open the Destination directory panel.
  3. Type the directory where you would like to install DB2 Everyplace Express or click Browse to select a directory. After selecting the destination directory, click Next. The Select the installation type window opens.
  4. Select the installation setup type: Click Next.
  5. If you select the Custom installation setup type:
    1. A panel opens where you can select the features that you want to install. Click Next. The Select install actions panel opens.
    2. Select the check box next to the installation action that you want to enable. You can select both options, but you must select at least one. If you do not select an installation action, you will receive an error. Specify whether you would like the Setup Wizard to install DB2 Everyplace Express on your computer or to generate a response file. A response file is used to record the user responses required during an interactive installation. It can be used for automating installation on other computers. After selecting the appropriate installation actions, click Next. The Select sample actions panel opens.
    3. Select the check box next to the sample action that you want to enable. You can specify whether you would like the Setup Wizard to create the DB2 Everyplace sample databases and Visiting Nurse sample application, or to install a pre-configured windows client for demonstrating synchronization with the DB2 Everyplace Sync Server. Click Next. The Select Service action panel opens.
    4. Select the check box if you want the Setup Wizard to start the Windows Service for DB2 Everyplace Sync Server at the end of the installation. Click Next. Proceed to Step 7.
  6. If you select Typical, the DB2 Everyplace Setup Wizard: Proceed to Step 7.
  7. Informational panels open if you do not have DB2 Universal Database installed on your computer. If you have DB2 Universal Database installed on your computer, proceed to Step 8.
    1. You will be required to specify the directory where you would like to install the embedded version of DB2 Universal Database - Express. Type the name of the directory, or click Browse to select the directory name. After specifying the directory, click Next
    2. You will be required to specify the user information for the DB2 UDB Database Administration Server. You can either use an existing Administrative user or specify a new user that will be created on your computer. Select the check box in order to use the same authentication information for the DB2 Everyplace Sync Server. Click Next. If you select the check box, proceed to Step 9.
  8. The Specify DB2 UDB logon information panel opens. Type the authentication information that DB2 Everyplace Sync Server will use to logon to the DB2 UDB DAS. After specifying the required information, Click Next.
  9. The Pre-Install summary panel opens which lists the features that will be installed on your computer and the configuration information for the DB2 Everyplace Sync Server. It will also list the configuration information for the embedded Application Server Express. The Server port and the SSL port listed on this panel is used by the clients to synchronize with the DB2 Everyplace Sync Server. After reading the pre-install summary, click Next.
  10. The Installation begins as the progress bar charts the progress of the installation. During the installation, the installation Setup Wizard:
  11. Congratulations! You've successfully installed DB2 Everyplace Express.

Related tasks

Installing DB2 Everyplace Express on a server for Linux

Complete the following steps to install DB2 Everyplace Express on a Windows.

Procedure

  1. Run the setup program DB2Everyplace.bin as the root user. The Welcome panel opens.
  2. Click Next to read the Install Notes. After reading the Install Notes, click Next to view the License Agreement. After accepting the License Agreement, click Next to open the Select the installation type.
  3. Select the installation setup type: Click Next.
  4. If you select the Custom installation setup type:
    1. A panel opens where you can select the features that you want to install. Click Next. The Select install actions panel opens.
    2. Select the check box next to the installation action that you want to enable. You can select both options, but you must select at least one. If you do not select an installation action, you will receive an error. Specify whether you would like the Setup Wizard to install DB2 Everyplace Express on your computer or to generate a response file. A response file is used to record the user responses required during an interactive installation. It can be used for automating installation on other computers. After selecting the appropriate installation actions, click Next. The Select UNIX post install actions panel opens.
    3. Select the check box next to the post install actions that you want to enable. You can specify whether you would like the Setup Wizard to create the DB2 Everyplace Sync Server instance or to create the DB2 Everyplace sample databases and Visiting Nurse server sample application. Click Next. Proceed to Step 6.
  5. If you select Typical, the DB2 Everyplace Setup Wizard: Proceed to Step 6
  6. Informational panels open if you do not have DB2 Universal Database installed on your computer. If you have DB2 Universal Database installed on your computer, proceed to Step 6.
    1. You will be required to specify the user information for the DB2 Database Administration Server instance. Type the name of the user, the password, the name of the primary group and the user's home directory. Click Next.
    2. You will be required to specify the user information for the DB2 instance owner. Type the name of the user, the password, the name of the primary group and the user's home directory. Click Next.
    3. You will be required to specify the user information for the DB2 fenced user. Type the name of the user, the password, the name of the primary group and the user's home directory. Click Next.
  7. The Specify DB2 Everyplace Sync Server instance information panel opens. Type the user name, password, and the locale for the DB2 Everyplace Sync Server instance. After specifying the required information, .Click Next.
  8. The Pre-Install summary panel opens which lists the features that will be installed on your computer and the configuration information for the DB2 Everyplace Sync Server. It will also list the configuration information for the embedded Application Server Express. The Server port and the SSL port listed on this panel is used by the clients to synchronize with the DB2 Everyplace Sync Server. After reading the pre-install summary, click Next.
  9. The Installation begins as the progress bar charts the progress of the installation. During the installation, the installation Setup Wizard:
  10. Congratulations! You've successfully installed DB2 Everyplace Express.

Related tasks