Creating a geodatabase in DB2 on Windows

To create a geodatabase in DB2 on a Windows server, use the Post Installation wizard.

After you install the ArcSDE component, the Post Installation wizard automatically launches. If you have already created your DB2 database, registered it with the Spatial Extender, and created a user on the server named sde, you can proceed with the Post Installation wizard. If you have not, exit the wizard and complete those tasks. You can restart the Post Installation wizard from the Windows Start menu (Start > All Programs > ArcGIS > ArcSDE > ArcSDE for DB2 Post Installation) once you have completed these tasks.

The Post Installation wizard takes you through the following steps:

• Creating the geodatabase system tables and stored procedures in the database
• Authorizing the geodatabase using your ArcGIS Server Enterprise license file
• Creating an ArcSDE service

Note:

You only need to create a service if there are users at your site who will connect to the geodatabase using an ArcSDE service.

If you plan to only use direct connections to the geodatabase, see Setting up a direct connection to DB2 for information about setting up direct connections to the geodatabase from a client machine.

Steps:

1. The first dialog box of the wizard lets you choose whether to perform all the postinstallation tasks or choose only some of the tasks. For most new installations, choose the Complete option and click Next.

   You might choose the Custom option if you do not want to create an ArcSDE service or you only need to update your authorization file in an existing geodatabase.

2. On the ArcSDE configuration files dialog box, specify which configuration files to use to connect to and configure the geodatabase. For most installations, you can choose to Use the default file.
3. Click Next.
4. In the next User information dialog box, connect to the database as the sde user by typing the sde user's password in the SDE user password text box.

   The SDE user name and ArcSDE database name text boxes are populated automatically. If they are not, or if they contain the wrong database name, type the correct information.

5. Click Next.
You should receive a message indicating whether or not the geodatabase was created successfully.
6. Choose whether or not to view the log.
   • If you want to view the creation log, click Yes. You should do this if the geodatabase was not created.
   • If the geodatabase was created without error and you do not want to view the log, click No.

The geodatabase has been created.

Next, you must authorize the geodatabase. See Authorizing ArcSDE geodatabases in DB2 on Windows. If you are creating a service, see Creating and starting an ArcSDE service for geodatabases in DB2 on Windows.