Creating a geodatabase in DB2 on z/OS

Use the sdesetup command to create the geodatabase in the database subsystem. The sdesetup command creates all the ArcSDE geodatabase system tables and stored procedures in the database management system (DBMS).

The sdesetup command must execute successfully to properly create your geodatabase and for ArcSDE to function correctly.

The full usage for the sdesetup command with the install operation on DB2 for z/OS is as follows:

sdesetup -o install -d DB2ZOS [-H <sde_directory>] [-u <DB_Admin_user>]
[-p <DB_Admin_password>] -D <database_subsystem> [-N] [-l <license_file>] [-q]

The options are as follows:

• –d specifies the underlying RDBMS used to store the geodatabase.
• –D specifies the name of the database subsystem in which the ArcSDE geodatabase is to be created.
• –H indicates the location of the SDEHOME directory.
• –l is used to specify the ArcGIS Server Enterprise authorization key or path to and name of the authorization file.
• –N indicates that no verification prompt is given.
• –o indicates the operation to be performed; in this case, the geodatabase will be installed in the database subsystem.
• –p specifies the sde user password.
• –q indicates that all titles and warnings will be suppressed.
• –s specifies the datasource name.
• –u specifies the sde user.

Note:

The sde user must have specific authority to create the geodatabase.

Steps:

1. Open an MS-DOS command window.
2. Change to the bin directory of %SDEHOME%.
3. Type the following command:

   sdesetup -o install -d DB2ZOS -D <database_subsystem> -u sde 
   -p <sde_user_password> -l <license_file>
   

   Tip:

   If you do not have the license file at this time, you can run sdesetup without the -l option to create the ArcSDE geodatabase system tables and files. When you obtain the file, you can run the sdesetup command with the update_key operation.