About the DB2 User

Before initializing a DB2 database, you need to verify that the database user has been created and that the user has been placed into the correct DB2 group.

The process for verifying these settings varies based on the operating system that is running the database.

Windows DB2

If you are using a Windows-based DB2 database with your SIMULIA Execution Engine, you need to add the database user (seeadmin) to a specific Windows group. These steps are not necessary if you are using an Oracle database.

  1. Create a new Windows user called seeadmin.
  2. Add the user to the local group DB2ADMNS. This step is necessary to allow the user to create and alter the DB2 database.

Note: The remaining procedures in this section assume that you have created a new user called seeadmin. If you create a user with a different name or use an existing user with a different name, be sure to use that user during all of the configuration steps.

For detailed information on the steps necessary to set up a user and set these permissions, see Creating the seeadmin User on Windows.

Linux DB2

If you are using a Linux-based DB2 database with your SIMULIA Execution Engine, the designated user (usually seeadmin) needs to be in the DB2 administration group to be able to create a database. In addition, the home directory of the SIMULIA Execution Engine designated user (seeadmin) needs to be “world writable” at database creation time for one of the DB2 administrative users to write a file. This arrangement is not secure and should be a temporary setting only. For more information, contact your local system administrator.

About DB2 Database Scripts

Several DB2 scripts are included with your SIMULIA Execution Engine installation. These scripts can be used to create your SIMULIA Execution Engine database, create the tables within the database, remove the contents of the database tables, or remove the tables entirely from the database.

Note: On Windows, each of these scripts uses the .bat extension.

The following scripts are included:

initdb
This script creates the SIMULIA Execution Engine database. For more information on the settings within this script, see Updating the Initialization File. For more information on using this script, see Executing the Database Scripts.
createtables
This script creates the SIMULIA Execution Engine tables in an existing database. For more information on using this script, see Executing the Database Scripts.
cleartables
This script cleans the tables of their contents, but it leaves them in place. You must reexecute the publishall command after running this script. All jobs, results, and library content are removed.
droptables
This script removes the SIMULIA Execution Engine tables in an existing database. It should be used when your table structure is modified because of a change in the SIMULIA Execution Engine infrastructure. It will be used rarely, if ever. The createtables script should be run after running this script.