Commerce application, Application environment | IBM SG24-6320-00

6320ch_application_used.fm

Draft Document for Review July 28, 2004 7:33 pm

4.1 Commerce application

CarrotInk.com is an Internet-based retailer of inkjet printer cartridges and supplies. CarrotInk.com sells after-market and OEM brand printer supplies. The company supplies as many as 400 individual cartridge types, supporting thousands of different printer models. Before migrating to WebSphere Commerce Suite V5.1, the original site contained more than 800 static HTML pages. The pages were managed manually and the need to upgrade to a new system became prevalent.

Carrot Ink needed a solution that would provide easy maintenance of the product catalog and Web site design. Another issue was that customers could not register with the site and store billing and shipping information, therefore no order history was provided to the customer.

The solution was to migrate the existing site to WebSphere Commerce Suite V5.1. The products catalog is now easier to update, the site look and feel is easier to update, and the performance of the site is excellent. Back-end integration has been facilitated, helping Carrot Ink to process and fulfill more orders.

This section gives an overview of the application environment of the commerce application.

4.1.1 Application environment

The application environment has been implemented as two node which consists of an WebSphere Commerce Suite V5.1 application node and a database server node. These servers are mirrored servers running Raid 1. Both of these servers are behind a firewall.

Hardware Configuration

The following is a list with the hardware configuration of the application and database servers:

Microsoft Windows 2000 Server, Service Pack 4

Pentium III, 1266 MHz

2 GB Ram

40 GB Hard Disk

Application Server Tier

The following shows the software and levels installed and configured on the application server tier:

WebSphere Application Server V3.5.6

56Keeping Commerce Applications Updated WebSphere Commerce 5.1 to 5.6 Migration Guide

Image 74

IBM SG24-6320-00 manual Commerce application, Application environment, Hardware Configuration, Application Server Tier

Contents

Keeping Commerce Applications Updated Page International Technical Support Organization First Edition July Contents 6320TOC.fm Part 2. Development environment Part 3. Production environment 6320TOC.fm Part 4. Appendixes Abbreviations and acronyms Index 6320TOC.fm 6320spec.fm Trademarks IBM Preface Team that wrote this redbook 6320pref.fm Become a published author Comments welcome Redbook@us.ibm.com Part 1 Introduction to WebSphere Commerce 6320p01.fm Introduction Part 1, Introduction to WebSphere Commerce OverviewStructure of the book Part 4, Appendixes Part 2, Development environmentPart 3, Production environment Commerce Application used during the migration 6320chintro.fm WebSphere Commerce V5.6 Overview Product overview WebSphere Commerce V5.6 Overview WebSphere Commerce software components WebSphere Application Server Web server WebSphere Application Server Database Server WebSphere Commerce Server WebSphere Commerce Payments Server Enablement softwareWebSphere Commerce enablement software WebSphere enablement software User registration methods WebSphere Commerce Server subsystemsMember subsystem User registration and update methods Member security services 6320chsumofchanges.fm Catalog subsystem Single sign-on Merchandising subsystem Trading subsystemOrder subsystem Marketing subsystem Messaging subsystem Configuration ManagerWebSphere Commerce Tools WebSphere Commerce Accelerator Password Manager Organization Administration ConsoleAdministration Console WebSphere Commerce Business models Direct Sales Consumer direct Demand chain Value ChainB2B direct Hosting Hosting Ex-SitesSupply chain Ex-Site What’s new in WebSphere CommerceWebSphere Commerce Development Environment WebSphere Commerce Payments Configuration ManagerPassword Manager Loader Package Adaptor for CrossWorld Catalog and product management SKU generation Accounts Business Edition Collaboration Access ControlBusiness Models Product Management tooling Campaigns and Promotions Order and inventory Management Analytics Security Caching Dynacache Https//hostname8002/cachemonitor Product Advisor 6320chsumofchanges.fm Migration Strategy and Planning Take advantage of DynaCache Migration Strategy considerationsAdd or replace functionality Optimization Prepare a detailed Plan External product and user managementHow does custom code impact the process? Migration Planning Skill requirements Hardware and software prerequisites Production Environment Software prerequisites Development Environment Hardware prerequisites for development environment Product versions mapping, production environment Product versions mappingMigration approach for development environment Product versions mapping, development environment Migration approaches for runtime environment Switch-Over migration scenario Firewall Co-existence migration scenario In-place migration scenario Approach used for this migration Detailed overview of development migration steps Detailed overview of production environment migration 6320chplanning.fm 6320chplanning.fm 6320chplanning.fm Commerce Application used during the migration Application environment Hardware ConfigurationCommerce application Application Server Tier Database Server Tier Commerce customizationShopping flow Account Creation Billing/Shipping Selection Payment ProcessingOffline Orders InFashion default shopping flow Commands Customized shopping flow 1provides a summary of the custom commands used with Application Catalog Database tables Database 6320chapplicationused.fm Part 2 Development environment 6320p03.fm Installing WebSphere Commerce Development Environment Pre-installation requirements Development environment overview VisualAge for Java V4.0 prerequisites Installing WebSphere Studio Application DeveloperPre-installation steps Installing WebSphere Studio Application Developer Apply fixes to the test environment Prepare for fixpack installation Install WebSphere Application Server V5.0.2 cumulative fix Select Install fixpacks and click Next Click Next Install interim fixes CD-ROM drive\BASE\fixes Installing WebSphere Commerce V5.6 Toolkit Installing WebSphere Commerce V5.6 Toolkit Installation verification Installing DB2 Universal Database Backup development databases Installation requirements Preparing a Windows user for DB2 Select Action New User Installing DB2 Universal Database Output from this command should be as follows 6320chDEVinstallation.fm 6320chDEVinstallation.fm Installing DB2 Universal Database fixpack 6320chDEVinstallation.fm Migrate databases to DB2 Universal Database V8.1 level Configuring the development environment for DB2Our example, we entered the following commands Wctoolkithome\bin Time spent installing and configuring VisualAge for Java Installing VisualAge for JavaInstalling VisualAge for Java \WebSphere\VAJ40 Select Administrator and click OK Configuring VisualAge for JavaInstall features and fixes for VisualAge for Java Install the DeployTool fix Install IBM WebSphere Test Environment fix Click Finish Prepare the VisualAge for Java V4.0 workspace Packages to delete from workspace Import WebSphere Commerce Studio V5.1 repository Select Local repository 6320chDEVinstallation.fm Pre-migration steps Preparation overview To the following directory Instance preparationUpdating the product information file Example 6-1 Example product.xml file Choosing the value for editionname Choosing the value for fixpack Prepare resourcesChoosing the value for mod Merge EJB groups Export code from VisualAge for Java Overview Exporting the Java code Update database configuration values Database preparation DB2 configuration set by the updateDBConfiguration script Our example we called the as follows Order status Change the order status to X CancelledUnsent messages Catalog Product-item relationship MembersMaster catalog Organizational structure Profile types Refer to WebSphere Commerce AdministratorsRole changes Roles that are not included in WebSphere Commerce Dropping foreign key references Add Store Administrator as role for our usersCustom message types Erroneous data in encrypted fields Tables and fields to check for erroneous leading spaces 6320chDEVbeforemigration.fm Migrating the development environment Current development environment Development environment migrated Migrating the development instance Overview Run the Wcim tool as follows Running the toolOur example, we used the following directory Example 7-1 Sample output from the Wcim tool File name of the log will be in the following format Run the migration script as follows Migrating the development databaseMigrating unencrypted data For example, we used We used the following commandMigrating encrypted data Run the script as follows Migrating custom EJBs Summary 119 Export the EJB project from VisualAge for Java Process for converting from EJBs from version 1.0 to Import the EJB projects into VisualAge for Java Regenerate the deployed code for the EJBs Export EJBs as EJB 1.1 JAR files Import the EJBs into WebSphere Studio Application Developer 6320chDEVmigration.fm Post-migration steps Setting up aliases Lightweight test environment Example 8-1 Excerpt from the looseconfig.xmi file Example 8-2 Excerpt from the deployment.xml file Example 8-3 Excerpt from the application.xml file Migrating custom code Command parameter validation User registration Background Logon commandCalculation usage framework Mapping between WebSphere Commerce commands Migration Example 8-4 Sample MyApplyShippingCmd Example 8-5 Sample MyApplyShippingCmdImpl 6320chDEVpostmigration.fm 137 Example 8-6 Registering calculation method WebSphere Commerce V5.6 command interfaces Interface changes Refer to Example 8-5 on page 135 for an sample of this WebSphere Commerce Suite V5.1 interfaces for the commandsApplyOrderAdjustmentsCmd contain the following methods Accessing the order items Accessing OrderItemAccessBean Accessing Item Then this could be migrated into the following line 143 Configuration and code changes for migrated EJBs Access bean string converters 145 Change the access isolation level Example 8-7 Example ibm-ejb-access-bean.xmi file 147 Add the WCSecurity role Ensure that ejbCreate returns primary key object Change the container transaction typeRemove serialVersionUID constants Delete this line and save your source by pressing Ctrl + S Remove java.rmi.RemoteException from remote methods Following method would be added to the home interface Match ejbPostCreate and ejbCreate methodsRemove FinderHelper interface 7 J2EE Connector Architecture Regenerating the deploy code Pricing New task commandsChanged price task commands New data bean methods Package name change Changes to myAccount.jsp Rule server administration commandsJSP and property file changes Our example Example 8-8 The content of the modified myAccount.jsp file Changes to Register.jsp Example 8-9 The content of the modified register.jsp file @ include file=getResource.jsp% Changes to property files Example 8-10 Error texts for file Register.jspExample 8-11 Error texts for file myAccount.jsp 159 6320chDEVpostmigration.fm Part 3 Production environment 6320p02.fm Installing WebSphere Commerce Software Single-node runtime overviewHardware Installation Install WebSphere Commerce IBM Http Server D\WebSphere\HTTPServer Enabling Cache accelerator Configuring IBM Http ServerEnabling for SSL WebSphere Commerce installation logs Verifying the installationVerify installation log files Examine the following log files DB2 Universal Database installation logsWebSphere Application Server installation logs Washome\logs\WASFixPack.log IBM Http Server installation logs Create test instance Create a WebSphere Commerce instance Web server restart prompt for commerce instance creation Create a WebSphere Commerce Payments instance Commerce instance creation confirmation 6320chinstall56.fm Removing test instances Removing WebSphere Commerce instance RmCommerceServer instancename Removing WebSphere Commerce Payments instance Example 9-1 Sample rmPaymentServer.bat script 6320chinstall56.fm Draft Document for Review July 28, 2004 733 pm 6320chbeforemigration.fm Preparation overview 185 Example 10-1 product.xml file content Example 10-2 Our product.xml file Our example the product.xml file looked like thisWebSphere Commerce Suite Choosing the value for fixpack Disable security on WebSphere Application Server 189 Copying the database from Commerce V5.1 to Commerce Restore the configuration values to the original values Migrate the database Updating database configuration values Script is invoked as follows Changes are done by executing the following SQL commands Orders status Example of a master catalog Create catalog description Update keys for catalogUpdate keys for category Create category catalog group Members Update the users profile type Our example this command retrieved 6 records 199 Erroneous data in encrypted fields Migrating WebSphere Commerce components Migrating commerce instance configuration Migration overview Migrating the instance Unpack backupwcim.zip This will generate the following file Enter the previous IBM Http Server home directory Running the above command will produce the following fileFrom the following directory Wc56home\temp Migrating commerce database Enter the new IBM Http Server home directory Migrating the database Script receives the following parameters Mandatory migration script parameters Parameter name Parameter value Our example Example 11-2 a small extract of the migration log file Sample of this error in the log Error SQL0605WError SQL0601N Example 11-3 The content of the modified choosemc.sql file Choosing the master catalog Migrating the encrypted data Merchant key and encrypted data Encrypted data migration script parameters Script must have the following mandatory parametersOptional parameters are Parameter Encrypted data migration script parameters and behavior Migrating Payment Manager Install Fixpack for WebSphere Payment Manager Our example, we used Install WebSphere Commerce Payments remote nodeEnsure that none of these files contain any error messages Next Package and transfer the Wcim tool Backup the WebSphere Payment Manager instance Backup the WebSphere Payment Manager database Backup the payment database Migrate the WebSphere Payment Manager instance Restore WebSphere Payment Manager databaseTransfer assets to WebSphere Commerce Payments node Our example we typed Click on OK Click Apply Click OK on the following confirmation window Restart the Web server Disconnect from the commerce database Migrate the WebSphere Payment Manager databaseDelete the obsolete payment methods Disconnect from the payments database This concludes the payments database migration 6320chpostmigration.fm Post migration steps for IBM Http Server Migrating static contentUpdating configuration Document root is added as described below Example 12-1 WebSphere Commerce section of httpd.conf DeployingDeploying EJBs Configure and export the JAR file Applying the JAR file to the production environment Deploying commands and databeans Export the JAR file To export store assets perform the following steps Deploying store assetsExporting store assets Applying the store assets to the production environment Select Create directory structure for files 6320chpostmigration.fm Part 4 Appendixes 6320p04.fm Appendix A. Managing WebSphere Commerce components Checking instance status Run the following command from the washome\bin directoryWebSphere Commerce instance management Starting the instance WebSphere Commerce Payments instance management Stopping the instance Start the Configuration Manager Follow these steps to start the Configuration Manager Db2start Modifying trace strings for a running server Output should be similar to what is shown in Example A-1Restarting IBM Http Server Example A-1 Restarting the IBM Http Server Our example, we issued the following command Resulting in the following messages Quit Tracing for Lightweight WebSphere Test Environment Tracing with WebSphere Commerce V5.6 Toolkit Tracing for Full WebSphere Test Environment Example A-2 Excerpt from Logging.properties file Create wcspmpassword script Create missing password scriptsCreate wcspassword script 6320ax04.fm Appendix B. Backup WebSphere Commerce Suite Custom directories Default directoriesFile system Database backup Db2 backup database dbname to backupdirectory Appendix C. Migration scripts Migratedb.bat behavior Here is an excerpt of the configuration fileWebSphere Commerce V5.6 migration scripts behavior Example C-1 Excerpt of DataMigrationPlan51.xml file MigrateEncryptedInfo.bat behavior Wcim.bat behavior Tables used by migrateEncryptedInfo script file 6320ax02.fm Custom database migration scripts behavior Sequence diagram of the batch files Database preparation batch script Example C-2 Content of the pre.migration.bat file Example C-3 Content of the pre.migration.sql file Database preparation SQL script Database migration batch script Create NEW Master Catalogue Example C-4 Content of the migration.bat file Database post migration batch script Example C-5 Content of post.migration.sql file Database post migration SQL script Appendix D. Moving from single to multi-node environment Create a Windows user for DB2 Installing and configuring the database nodeSingle-node environment Installing DB2 Moving the database Connecting to the remote databaseBackup the current production database Stop all connections to the database Verify connectivity Create a local alias for the remote database 6320ax01.fm Using the Web material Locating the Web material Copy of the product.xml.51.sample file How to use the Web materialZipped containing the rmPaymentsServer.bat script and a Abbreviations and acronyms 6320abrv.fm Online resources IBM RedbooksOther publications Help from IBM How to get IBM RedbooksIBM Support and downloads IBM Global Services Index EJB Migration scenario in-place 6320IX.fm 6320IX.fm Security Keeping Commerce Applications Updated Keeping Commerce Applications Updated WebSphere Commerce Page Keeping Commerce Applications Updated WebSphere Commerce