You need to install the DB2 database management system (DBMS) and configure a database (on Linux, UNIX, or Windows) or subsystem (z/OS) and spatially enable it before you can install the ArcSDE component.

DB2 for Linux, UNIX, and Windows

1. Install DB2.
2. Make sure the TEMP environment variable is set to a writable folder.
3. Create an SDE Windows system administrator account with database administrator privileges.
4. Create a database. Be sure to explicitly specify the code page UTF-8 in the CREATE DATABASE statement if you want to use Unicode with ArcSDE 9.2 or later geodatabases.
5. Configure the database and the DB2 instance.
The topics DB2 initialization parameters, Minimize disk I/O contention in DB2, and Tuning memory in DB2 can help you with this. Also consult your DB2 documentation.
6. Spatially enable the database using Spatial Extender.

DB2 for z/OS

When you use a DB2 for z/OS database, you must set up a client Windows machine to work with the database subsystem on the mainframe.

On the z/OS machine

1. Install and create your DB2 for z/OS subsystem.
2. Enable the subsystem for spatial support.
3. Install any authorized program analysis report (APAR) fixes needed for spatial support.

On the Windows client machine

1. Install the DB2 Connect client.
2. Create an SDE operating system (OS) user on the client machine.

NOTE: For Windows installations, you must be a Windows administrator to install any software on the machine.

The installation files for the ArcSDE component are on a separate DVD in the ArcGIS Server media kit.

On Windows systems

1. Insert the installation DVD into the drive.
2. Launch the installation wizard.
3. Follow the instructions in the wizard to install the ArcSDE component of ArcGIS Server.

If you are using a DB2 for z/OS database, install the ArcSDE component on the client machine, following these same steps. However, be sure you use the ArcSDE for DB2 z/OS installation wizard.

On UNIX or Linux systems

1. Place the ArcSDE component media into the appropriate drive and mount the drive.
2. Change directories to the appropriate drive.
3. Run the installation command appropriate to the shell you are using to open the command-driven dialog box for the ArcSDE component installation procedure.
4. Follow the instructions in the installation procedure.

The postinstallation tasks

• Create the ArcSDE geodatabase system tables.
• Authorize the ArcSDE component in the database.
• Set up and start an ArcSDE service (DB2 on Linux, UNIX, and Windows only).

In preparing to create the ArcSDE geodatabase system tables, you need to specify storage settings for some of these system tables and their indexes. These settings are grouped under the DATA_DICTIONARY configuration keyword in the dbtune.sde file. You need to alter the configuration parameter values prior to creating the geodatabase, then specify the altered dbtune.sde file when the geodatabase is created.

You should alter the settings to specify the table space in which to create the tables if you are using a DB2 database on Linux, UNIX, or Windows. Otherwise, the database default table space, which is usually quite small, will be used.

If you are using a DB2 z/OS database, you must alter these settings to specify in which database in the subsystem the system tables will be created.

For details, see The DATA_DICTIONARY keyword and its related topics The dbtune file and the DBTUNE table, DBTUNE configuration keywords, and DBTUNE configuration parameter name-configuration string pairs.

ArcSDE for DB2 on Windows

1. If you plan to use table spaces other than the default table space for some of the ArcSDE geodatabase system tables, alter the dbtune.sde file found in SDEHOME\etc.
That means when the ArcSDE component installation wizard completes, cancel out of the Post Installation wizard, navigate to SDEHOME\etc, and open the dbtune.sde file. You need to uncomment the lines with table space definitions and supply a table space name. Be sure to save your changes.
2. Use the Post Installation wizard to complete postinstallation setup.
If you decide not to alter the DATA_DICTIONARY settings in the dbtune.sde file, you can continue with the Post Installation wizard as soon as the installation wizard completes.
If you cancelled out of the Post Installation wizard to change the dbtune.sde file, you can open the Post Installation wizard from the Start menu (Start > All Programs > ArcGIS > ArcSDE).
The Post Installation wizard lets you select configuration files, creates the geodatabase schema, authorizes the software in the geodatabase, and creates and starts an ArcSDE service.

ArcSDE for DB2 on Linux or UNIX

1. Modify the files in SDEHOME/etc and /etc/services directories.
2. Run the sdesetup command to create the geodatabase schema.
3. Authorize the software in the geodatabase using sdesetup.
4. Start an ArcSDE service (if you plan to use one).

ArcSDE for DB2 z/OS

As mentioned previously in this topic, the ArcSDE for DB2 z/OS component is only supported on Windows machines. Although many of the following postinstallation steps are performed against the DB2 for z/OS subsystem, you will likely be running them from the Windows computer on which the ArcSDE component is installed.

Also note that only direct connections to the DB2 z/OS subsystem are supported, so you will not create an ArcSDE service.

1. Configure the ZPARMs on DB2 and refresh DB2 with the setting.
2. Use the Resource Access Control Facility (RACF) to create a user, SDE, for ArcSDE administration.
3. Transfer z/OS specific files to the target multiple virtual storage (MVS) system.
4. Submit the JCL script, ESRIUDFI, to create the storage groups, databases, and user-defined functions (UDFs) for ArcSDE.
5. Grant privileges to the SDE user and ArcSDE user group on DB2.
6. From the ArcSDE client machine, alter the configuration files, run the sdesetup.exe, and authorize the ArcSDE component in the repository database.
7. Submit the JCL script, ESRIUDFB, that binds the DBRMs required to run the ESRI UDFs.
8. Verify the installation.
9. Create ArcSDE users for ArcSDE and ArcGIS applications.