Geac System21 commerce.connect | IBM SG24-6526-00 instruction

Front cover

Geac System21 commerce.connect

Implementation on the IBM iSeries Server

Gain useful insights through the product overview

Follow the step-by-step guide to install commerce.connect

Learn helpful usage and performance tips and techniques

Yessong Johng

Colin Brown

Jim Hirsch

John Lawler

ibm.com/redbooks

Image 1

IBM SG24-6526-00 manual Geac System21 commerce.connect

Contents

Geac System21 commerce.connect Page International Technical Support Organization First Edition December Contents Page Index Page Copyright License Trademarks Become a published author Team that wrote this redbook Comments welcome .connect applications Call.connect Call.connect buying list Web-based interfaces to System21 to support Vendor.connect .connect applications Page Architecture of the commerce.connect products Need for an architecture Architecture moving forward Development process Design methodology Using Unified Modelling LanguageImplementation SalesOrder Pricing Call.connect Messaging Java Message Service and IBM WebSphere MQ 3shows how call.connect uses messaging Adding a Sales Order Line scenario Vendor.connect Flow of Information to vendor.connect after System21 Update Relationship between the .connect applications Overview of process.connect Architectural goals and constraints Architectural representationNon-functional architectural considerations Accessing System21 RPG business logic Reusing and extending System21 business logicFunctional architectural considerations Java Native Interface JNI Stored proceduresChoice Installing and setting up call.connect Prerequisites SkillsISeries hardware requirements ISeries software requirements Installation option During installation After installation System21 authorization code for Order Management OM Standard installation proceduresWorkstation hardware requirements Workstation software requirements Checklist of the basic steps Installing Order Management and call.connectSystem21 base System21 Order Management OM Java components and configuration files WebSphere installation and configurationStarting the administration server Importing the configuration file Starting the application Journaling the files without an ASP Journaling Journaling a single file Journaling the files with an ASPJournaling multiple files within a library Creating a user-defined option Stored procedures and SQL Client Access setup for the naming convention Open the /OrderManagement/Stored Procedures folder Java Message ServiceOther SQL Creating a queue manager Setting up MQSeries Granting authority Creating a queue Object Name SALESORDER.QUEUE Creating the JNDI/MQ objects Additional files neededStandard properties Additional WebSphere configuration Testing the messagingUser profiles Job description Setting up System21 user profiles Setting up call.connect users in the XML user directory 10 Operator setup display Setting up an operator Ensuring that the Http administrative server is ready System21 data set upJava Web Start 11 Http Server configuration Configuring the Http Server on the iSeries 12 Http Server configuration 13 IBM Http Server Configuration and Administration Configuring an Http Server for iSeries original 14 Create configuration Creating a configuration 15 Request routing Htm extension Jnlp extension 17 Create server instance Creating an instance 18 Manage Http Servers Configuring an Http Server for iSeries powered by Apache 19 Http Server configuration 2 Apache Type of server Http Server powered by Apache recommended Select Static Web Pages and Files 20 Http Server name Homera global settings Click Add Click Apply Configuring JWS.bat Configuring CallConnect.jnlp Daily backups BackupCall.connect housekeeping Stopping WebSphere Starting WebSphere default instance TroubleshootingStarting call.connect Restoring IFS objects Errors when running the client Errors on starting the clientWebSphere node name Cached data and .bl and .cd files Manually configured client Setting up logging on the clientLog files and debugging Server Non-standard Order Management and call.connect installation Manual configurationPreGenerate Buying Lists System21 and Order Management Starting Qejbsbs on the iSeries WebSphere manual configurationStarting the WebSphere console on a PC Creating DataSources Creating Jdbc drivers Creating the application server Setting the node parameters Creating enterprise beans Creating an EJB container Ejbdefault.cfg Manual client installation Setting up a test instance of WebSphere Alternative configurationsRunning the manually configured client Log.cfg System21 data Setting up an iSeries server for a test systemJournaling Server configuration WebSphere administration Starting application server Http Server for iSeries original Testing Java Web Start Index Action URL Template Replacement File Path Http Server for iSeries powered by Apache Select Static Web Pages and Files 25 Manage Http Servers page Stopping the server Changing to another instance Installing and setting up call.connect Page Installing and setting up vendor.connect Installing vendor.connect Preparing for the installationBasic steps checklist Skills required System21 base Java components and configuration filesVendor.connect components Restoring libraries Installing and configuring WebSphere Importing the configuration file Starting the administration serverCreating a new instance Starting the instance 2shows an example of an imported configuration Ensuring that the Http Server is ready IBM Http Server for iSeriesStarting the application AS/400 Tasks IBM Http Server for AS/400 Configuring IBM Http Server for iSeries original IBM Http Server Configuration and Administration Create configuration Journaling Setting up on the iSeries Select option 9 Work with user-defined options Command Strjrnpf FILE&L/&N JRNOSLF3/OSL OMTJRNE*OPNCLO User profiles System21 data setupDatabase triggers Creating a queue manager MQSeries Active Architecture framework Work Management Trigger Handler for the iSeriesPublisher Tests Updating the events rules Test Controller ConnectorManager.xml Setting up new vendor.connect user IDs and supplier IDsJConnects server AIF .ini files XML security Entry dn=cn=vcadmin, ou=cad, ou=ges,o=geac,c=uk objectclass Configuring the Ldap server Using Ldap 12 Directory Properties General Select the Start server when TCP is started box 13 Directory Properties Database/Suffixes Using IBM SecureWay 14 Add directory server panel 15 Rebind to server panel 16 Adding an entry Select the Organizational unit option 17 Creating the vcadmin user Creating the vcadmin user in IBM SecureWay 101 Creating the authorization rule 19 Logging on as vcadmin 103 21 Selecting Jdbc Setup in Client AccessPage Housekeeping Changing the iSeries on which the application is running Restoring the vendor.connect IFS objects StartingStarting the trigger handler and AIF controller 107 Performance tuning Work with Processor Resources display Hardware Operating System/400 OS/400 SQL server job configuration 2shows the Display Subsystem Description menu. Select option Display Prestart Job Entries list Change the server settings with this command Toolbox Jdbc driver Wrkactjob command showing the Qsqsrvr jobs V4R5 uses slightly different commands as listed here Subsystems and memory pools Wrksyssts command showing the memory pool names End the Qejbsbs subsystem by using the following command For a more simplified method, you can enter Wrksyssts You may want to verify this step Use the following command Start the WebSphere subsystem 16shows the Display System Value display for Qpfradj Automatic performance adjustment Stateful connections Manual performance adjustment Stateless connections Total connections and SQL server jobs Performance topics for Java virtual machine JVM settings Maximum Java heap size Initial Java heap size Verbose garbage collection Static compilation 20 The Dspjvapgm command used with a compiled JAR file Performance tuning 22shows a command prompt and two Notepad sessions Enterprise bean settings Performance requirements Application settingsConstrained performance Transaction time out Transaction inactivity time out Ping interval and timeout 26shows the Advanced page of the DataSource panel Datasource settings Idle time out Connection time outOrphan time out Page 137 Tips and techniques ISeries integrated file system Using File Transfer Protocol FTP with the iSeries IFS Expand File Systems, and select File Shares Mapping a PC drive to the iSeries IFS Creating a file share Stream files and Ccsid Editing an iSeries stream file using a PC editor Managing stream files with the OS/400 Wrklnk command Cd command Wrklnk command showing the root directory Other stream file commands 3shows the Save Object display Stream file authority Qshell Editing an iSeries stream file using the OS/400 Edtf command QSH Command Entry display Managing stream files with Qshell commands Viewing an iSeries stream file using the Qshell tail command Touch and setccsid commands Qshell scripts Cd $DIRECTORY/log Checking the Qejbsbs subsystem Instance monitor jobs Instance administration jobs Job log of the Qejbadmin job Application server jobs Specifying ports Checking the WebSphere PTF level on the iSeries Checking the WebSphere PTF level on a PC Wrkdtaara command showing the SF99147 data area Problems connecting the console to WebSphere on the iSeries Common problems with commerce.connect on iSeries Checking the iSeries name as required by WebSphere Checking the iSeries database name 11 The Wrkrdbdire command file IBM Redbooks How to get IBM RedbooksReferenced Web sites Other resourcesPage 163 Index 111 Java Web Start in test JConnects server 123 140 Word processors Page 2spine 17-0.473 90-249 pages Page Page Geac System21 commerce.connect