Executing the Database Scripts

Two database scripts must be executed to initialize your DB2 database and to create the tables needed by the SIMULIA Execution Engine. These scripts are included with your SIMULIA Execution Engine installation.

  1. Verify that you are logged in as the same operating system user that installed the DB2 software.

  2. Open a Command Prompt dialog box (terminal window on Linux).

    Important: If you are running your database on Windows Server 2008 or Windows 7, the database scripts must be run from a Command Prompt dialog box with full administrator privileges. To launch this type of Command Prompt dialog box, locate the cmd.exe file using Windows Explorer (this file is usually located in the C:\Windows\system32 directory), right-click the file, and select Run as Administrator. When prompted, click Continue on the User Account Control dialog box.

  3. Navigate to the following directory: 

    <SEE_install_dir>/<os_dir>/reffiles/SMAFIPserver/db/db2/

    where <os_dir> is one of the following:

    • /win_b64/ for Windows 64-bit
    • /linux_a64/ for Linux 64-bit

  4. Type one of the following commands, based on your operating system:

    • Windows: initdb.bat

    • Linux: ./initdb

    A message appears indicating the database was created.

  5. Verify that no errors occurred during the script execution.

    This script creates a log file (initdb.log) in this same directory, which can be examined for more information.

  6. Type one of the following commands, based on your operating system:

    • Windows: createtables.bat

    • Linux: ./createtables -all

    You are prompted to enter your password.

  7. Type the password of the user specified using the FIP_USER setting as described in Updating the Initialization File, and press ENTER.

    A message appears indicating that the tables were created.

  8. Verify that no error messages appeared when the scripts were executed.

    This script creates a log file (createtables.log) in this same directory, which can be examined for more information.

  9. Navigate to the top level directory of your DB2 installation.

  10. Open the db2cli.opt file in the text editor of your choice.

  11. Add the following lines anywhere within the file:

    [common]

    Patch2=50

  12. Save and close the file.

  13. From a Command Prompt dialog box (terminal window on Linux), navigate to the following directory: 

    <db2_install_directory>/bin/

  14. Stop and start DB2 by typing the following commands one after the other at the command prompt.

    db2stop

    db2start

  15. If your DB2 database is running on a Windows system, reboot the system.

    This step is necessary before proceeding to the next section.