Performance tuning, 107 | IBM SG24-6526-00 guide

5

Chapter 5. Performance tuning

This chapter covers performance tuning of Geac System21 products.

© Copyright IBM Corp. 2002. All rights reserved.

107

Image 119

IBM SG24-6526-00 manual Performance tuning, 107

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 Implementation Design methodology Using Unified Modelling LanguageDevelopment process 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 Non-functional architectural considerations Architectural representationArchitectural goals and constraints Functional architectural considerations Reusing and extending System21 business logicAccessing System21 RPG business logic Choice Stored proceduresJava Native Interface JNI Installing and setting up call.connect ISeries hardware requirements SkillsPrerequisites ISeries software requirements Installation option During installation After installation Workstation software requirements Standard installation proceduresSystem21 authorization code for Order Management OM Workstation hardware requirements System21 Order Management OM Installing Order Management and call.connectChecklist of the basic steps System21 base Starting the administration server WebSphere installation and configurationJava components and configuration files Importing the configuration file Starting the application Journaling the files without an ASP Journaling Journaling multiple files within a library Journaling the files with an ASPJournaling a single file Creating a user-defined option Stored procedures and SQL Client Access setup for the naming convention Other SQL Java Message ServiceOpen the /OrderManagement/Stored Procedures folder Creating a queue manager Setting up MQSeries Granting authority Creating a queue Object Name SALESORDER.QUEUE Standard properties Additional files neededCreating the JNDI/MQ objects Job description Testing the messagingAdditional WebSphere configuration User profiles Setting up System21 user profiles Setting up call.connect users in the XML user directory 10 Operator setup display Setting up an operator Java Web Start System21 data set upEnsuring that the Http administrative server is ready 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 Stopping WebSphere BackupDaily backups Call.connect housekeeping Restoring IFS objects TroubleshootingStarting WebSphere default instance Starting call.connect Cached data and .bl and .cd files Errors on starting the clientErrors when running the client WebSphere node name Server Setting up logging on the clientManually configured client Log files and debugging System21 and Order Management Manual configurationNon-standard Order Management and call.connect installation PreGenerate Buying Lists Starting the WebSphere console on a PC WebSphere manual configurationStarting Qejbsbs on the iSeries 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 Log.cfg Alternative configurationsSetting up a test instance of WebSphere Running the manually configured client Journaling Setting up an iSeries server for a test systemSystem21 data 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 Skills required Preparing for the installationInstalling vendor.connect Basic steps checklist Vendor.connect components Java components and configuration filesSystem21 base Restoring libraries Installing and configuring WebSphere Starting the instance Starting the administration serverImporting the configuration file Creating a new instance 2shows an example of an imported configuration Starting the application IBM Http Server for iSeriesEnsuring that the Http Server is ready 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 Database triggers System21 data setupUser profiles Creating a queue manager MQSeries Publisher Work Management Trigger Handler for the iSeriesActive Architecture framework Tests Updating the events rules Test Controller AIF .ini files Setting up new vendor.connect user IDs and supplier IDsConnectorManager.xml JConnects server 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 Starting the trigger handler and AIF controller StartingRestoring the vendor.connect IFS objects 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 Transaction time out Application settingsPerformance requirements Constrained performance Transaction inactivity time out Ping interval and timeout 26shows the Advanced page of the DataSource panel Datasource settings Orphan time out Connection time outIdle 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 Other resources How to get IBM RedbooksIBM Redbooks Referenced Web sitesPage 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