For IBM i OS operating system

Configuring the development environment to use DB2 for IBM i

The initial installation of WebSphere Commerce Developer provides WebSphere Commerce Developer with the Apache Derby database. You can reconfigure your environment to use DB2 for IBM i.

Before you begin

Reconfigure the development environment to use DB2 for IBM i if one or more of the following statements applies to your environment:
  • You are running your development database on an IBM i machine.
  • You are developing enterprise beans that require you to write database-specific SQL.
  • You are making significant changes to the database schema

Ensure that you have completed the following tasks:

  1. Install Rational Application Developer with the WebSphere Application Server test environment.
  2. Install the latest fixes for Rational Application Developer
  3. Install WebSphere Commerce Developer and set up a test environment.
  4. Back up your existing Apache Derby development database.

Procedure

  1. Ensure that the System i user profile uses the local settings for a language as listed in the following table.
    Local settings for System i user profiles
    Language CCSID LangID CountryID
    English 37 ENU US
    French 297 FRA FR
    German 273 DEU DE
    Italian 280 ITA IT
    Spanish 284 ESP ES
    Brazilian Portuguese 37 PTB BR
    Japanese 5035 JPN JP
    Korean 933 KOR KR
    Traditional Chinese 937 CHT TW
    Simplified Chinese 935 CHS CN
    Romanian 870 ROM RO
    Russia 1025 RUS RU
    Polish 870 PLK PL
    Note: Using local settings for a language in your System i user profile other than the languages that are defined in this table are not tested.
  2. Stop the Rational Application Developer server. If you forget to shut down Rational Application Developer, the server configuration might be deleted. Refresh the Servers project to restore the server configuration.
  3. Back up your Apache Derby development database.
  4. Start a Windows command prompt session.
  5. Change directories to the WCDE_installdir/bin directory.
  6. Depending on your needs, perform one of the following commands.
    OptionDescription
    You are configuring the development environment to use DB2 for IBM i for the first time and were previously using a different WebSphere Commerce Version 7.0 development database. 
    setdbtype iseries dbName dbHost dbUserID dbUserPassword createdb
    where the command parameters are defined as follows:
    dbName
    The name of the database that is registered as *LOCAL in the relational database directory on the IBM i system.
    dbHost
    The fully qualified name of the IBM i machine that is hosting the database.
    dbUserID
    The user profile on the IBM i machine that can access the database.
    dbUserPassword
    The password for the user profile on the IBM i machine that can access the database.
    This command creates and populates the DB2 for IBM i development database and switches the development database to this newly created database.
    You previously used either a Apache Derby or DB2 Database in the development environment and are switching to an existing DB2 Database for IBM i. 
    setdbtype iseries dbName dbHost dbUserID dbUserPassword
    where the command parameters are defined as follows:
    dbName
    The name of the database that is registered as *LOCAL in the relational database directory on the IBM i system.
    dbHost
    The fully qualified name of the IBM i machine that is hosting the database.
    dbUserID
    The user profile on the IBM i machine that can access the database.
    dbUserPassword
    The password for the user profile on the IBM i machine that can access the database.
    This command switches the current development database to the existing development database that is specified in the command.
  7. Update the database settings in the WebSphere Commerce configuration file.
    1. Go to the workspace_dir\WC\xml\config directory and open the wc-server.xml file for editing.
    2. Locate the <WebSphere> element within the <InstanceProperties> element.
      Change the value for the JDBCDriverTypeattribute to be "TOOLBOX".
    3. Save and close the file.
    For more information about updating this file, see Updating the WebSphere Commerce configuration file.
  8. Optional: Depending on the utilities that you need to use, you might need to configure the databases settings for the utilities to use your DB2 for IBM i database.

    For example, to configure the Data Load utility to load data into this database, update the environment configuration file that you use with the utility to use the appropriate settings. For more information, see Configuring the data load environment settings.

  9. To reset the Stores project or before you publish a new starter store, run the command:
    Note: If you run this command, you cannot use existing stores if you switch back to the Apache Derby database later.
    WCDE_installdir/bin/resetstores.bat
  10. Restart the WebSphere Commerce server.