Develop > WebSphere Commerce development environment > WebSphere Commerce development database > Overview: Changing the development database


Configure 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 re-configure the environment to use DB2 for IBM i.


Before you begin

You should re-configure the development environment to use DB2 for IBM i if one or more of the following statements applies to the environment:

Ensure you have the following tasks completed:

  1. Install Rational Application Developer with the WebSphere Application Server test environment.

  2. Install the latest fixes for Rational Application Developer

  3. Install the WebSphere Commerce toolkit including a test environment.

  4. Install DB2 for IBM i on a remote machine.

  5. Backup the existing Apache Derby development database.


Procedure

  1. Verify the System i user profile uses the localized settings for the desired language as listed in the table below.

    Localized 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

    Using localized settings for a language in the System i user profile other than those defined above have not been 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. Backup the Apache Derby development database.

  4. Start a Windows command prompt session.

  5. Change directories to the WCDE_INSTALL/bin directory.

  6. Depending on the needs, perform one of the following commands.

    Option Description
    You are configuring the development environment to use DB2 for IBM i for the first time and were previously using a different WebSphere Commerce v7.0 development database. 

    setdbtype iseries dbName dbHost dbUserID dbUserPassword createdb

    where the command parameters are defined...

    dbName

    The name of the database registered as *LOCAL in the relational database directory on the IBM i system.

    dbHost

    The fully qualified name of the IBM i machine 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 had 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...

    dbName

    The name of the database registered as *LOCAL in the relational database directory on the IBM i system.

    dbHost

    The fully qualified name of the IBM i machine 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. To reset the Stores project or before publishing a new starter store, run the command 

    


     If you run this command we will
not be able to use the existing stores if you decide to switch back
to the Apache Derby database at a later time.




     
  8. Restart the WebSphere Commerce server.


+

Search Tips   |   Advanced Search