Manuals / IBM / Computer Equipment / Laptop

IBM SG24-6526-00 manual Performance topics for Java virtual machine JVM settings

Models: SG24-6526-00

1 184

Download 184 pages 3.35 Kb

Page 136

5.3.3 Total connections and SQL server jobs

Figure 5-17 The DataSource panel Advanced page of the WebSphere console

5.3.3 Total connections and SQL server jobs

If you estimated the number of stateful and stateless connections required by your applications, then you can easily estimate the total number of connections. You should add these two and the five connections used by the WebSphere administration server job QEJBADMIN. If you are using multiple applications (for example, call.connect and vendor.connect in different pools), then you should also add them. If you are running multiple instances, then count each separately and then add them together. Each instance has its own administration server job and, therefore, five connections.

It is important that sufficient SQL server jobs are available for these connections. See 5.2.1, “SQL server job configuration” on page 109. If WebSphere attempts to use more connections than the number of prestarted SQL server jobs, then performance may be poor.

Any time you adjust the size of your WebSphere connection pools, review the configuration of your SQL server jobs. Remember that if you have other applications that use these server jobs, then you should include them in the calculation of the number of server jobs required. The normal server QSQSRVR jobs are only used by JDBC connections using the native JDBC driver. Therefore, if do not have any other Java applications on your iSeries, then no other applications are using these jobs. If you are using the Toolbox driver QZDASOINIT, remember that Java applications running elsewhere and ODBC clients may use it.

5.4 Performance topics for Java virtual machine (JVM) settings

This section discusses performance-related topics regarding to JVM settings. You can specify command line parameters for the application’s JVM using the WebSphere console. Simply select the application and then select the General tab.

124Geac System21 commerce.connect: Implementation on the iSeries Server

Image 136

IBM SG24-6526-00 manual Performance topics for Java virtual machine JVM settings, Total connections and SQL server jobs

Contents

Front cover Yessong Johng Colin Brown Jim Hirsch John LawlerFollow the step-by-step guide to install commerce.connect Geac System21 commerce.connectPage December International Technical Support OrganizationSG24-6526-00 First Edition December Contents Copyright IBM Corp. 2002. All rights reserved3.3.4 Restoring IFS objects . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 53 3.4 Troubleshooting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 53 3.4.1 WebSphere node name . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 54 3.4.2 Errors on starting the client . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 54 3.4.3 Errors when running the client . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 54 3.4.4 Cached data and .bl and .cd files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 54 3.4.5 Log files and debugging . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 55 3.5 Manual configuration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 56 3.5.1 Non-standard Order Management and call.connect installation . . . . . . . . . . . . . . 56 3.5.2 WebSphere manual configuration. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 57 3.5.3 Manual client installation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 61 3.6 Alternative configurations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 62 3.6.1 Setting up a test instance of WebSphere . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 62 3.6.2 Setting up an iSeries server for a test system. . . . . . . . . . . . . . . . . . . . . . . . . . . . 63 3.6.3 Server configuration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 64 3.6.4 WebSphere administration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 65 3.6.5 Manual client installation Contents IndexPage Notices Trademarks The team that wrote this redbook PrefaceBecome a published author Comments welcome Chapter 1. The .connect applications 1.1 call.connect 2 Geac System21 commerce.connect Implementation on the iSeries ServerStock allocation Rule-based stock allocation and sourcing engine 1.2 vendor.connect Web-based interfaces to System21 to supportPage 6 Geac System21 commerce.connect Implementation on the iSeries Server Chapter 2. Architecture of the commerce.connect products 2.1 The need for an architecture 8 Geac System21 commerce.connect Implementation on the iSeries Server2.1.2 The architecture moving forward Chapter 2. Architecture of the commerce.connect products2.1.3 The development process 2.1.5 The design methodology Using Unified Modelling Language2.1.4 Implementation SalesOrder PricingSupply Delivery2.2 Messaging Java Message Service and IBM WebSphere MQ 2.2.1 call.connectcontract shipmentAdding a Sales Order Line scenario 2.2.2 vendor.connect EventsSystem21 2.3 Overview of process.connectDatabase 2.4.1 Architectural goals and constraints 2.4 Architectural representation2.4.2 Non-functional architectural considerations 2.5 Reusing and extending System21 business logic 2.5.1 Accessing System21 RPG business logic2.4.3 Functional architectural considerations The deployment influenceJava Native Interface JNI Stored proceduresThe choice Chapter 3. Installing and setting up call.connect Copyright IBM Corp. 2002. All rights reserved3.1.2 Prerequisites 3.1.1 SkillsiSeries hardware requirements iSeries software requirements iSeries Developer Kit for Java 5769-JV1, Version 1.2 option3.2 Standard installation procedures 3.1.3 System21 authorization code for Order Management OMWorkstation hardware requirements Workstation software requirements3.2.1 Installing Order Management and call.connect Checklist of the basic stepsSystem21 base System21 Order Management OMJava components and configuration files 3.2.2 WebSphere installation and configurationStarting the administration server Importing the configuration file Starting the application 3.2.3 Journaling Journaling the files without an ASPJournaling a single file Journaling the files with an ASPJournaling multiple files within a library Command = STRJRNPF FILE&L/&N JRNOSLF3/OSL OMTJRNE*OPNCLO 3.2.4 Stored procedures and SQLStored procedures To run SQL scripts, follow these steps 5. Open the /OrderManagement/Stored Procedures folder 3.2.5 Java Message ServiceOther SQL Setting up MQSeries Creating a queue managerGranting authority Creating a queueQueue Name SALESORDER.QUEUE Object Type *Q User Names *PUBLIC see the following note Creating the JNDI/MQ objects Additional files neededStandard properties Testing the messaging Additional WebSphere configuration3.2.6 User profiles Job descriptionSetting up call.connect users in the XML user directory Setting up System21 user profilesuserpassword Password for call.connectSetting up an operator Ensuring that the HTTP administrative server is ready 3.2.7 System21 data set up3.2.8 Java Web Start Configuring the HTTP Server on the iSeries Figure 3-12 HTTP Server configuration Configuring an HTTP Server for iSeries original Figure 3-13 IBM HTTP Server Configuration and Administration pageCreating a configuration Figure 3-15 Request routing page jnlp extension htm extensionCreating an instance Configuring an HTTP Server for iSeries powered by Apache Figure 3-18 Manage HTTP Servers pageType of server HTTP Server powered by Apache - recommended a. Select Static Web Pages and Files a. Click Add b. Enter the following information File Extension .jnlp Configuring CallConnect.jnlp Configuring JWS.bat3.2.9 Backup 3.3.1 Daily backups3. Click Install Java Web Start 3.3 call.connect housekeeping3.4 Troubleshooting Starting WebSphere default instance3.3.3 Starting call.connect 3.3.4 Restoring IFS objects3.4.2 Errors on starting the client 3.4.3 Errors when running the client3.4.1 WebSphere node name 3.4.4 Cached data and .bl and .cd filesSetting up logging on the client Manually configured client3.4.5 Log files and debugging Server3.5 Manual configuration 3.5.1 Non-standard Order Management and call.connect installationOrderManagement/test/cfg/ejbdefault PreGenerate Buying Lists3.5.2 WebSphere manual configuration Starting QEJBSBS on the iSeriesStarting the WebSphere console on a PC OrderManagement/test/cfg/log.cfgCreating DataSources Creating JDBC drivers3. Wait for the message, “Create completed successfully” Setting the node parameters Creating the application serverCreating enterprise beans Creating an EJB container1. Right-click the container and select Create- Enterprise Bean 3.5.3 Manual client installation Ejbdefault.cfg3.6 Alternative configurations 3.6.1 Setting up a test instance of WebSphereRunning the manually configured client Log.cfg3.6.2 Setting up an iSeries server for a test system System21 dataJournaling Table 3-4 Steps required to configure a WebSphere instance3.6.3 Server configuration Server ejbdefault.cfgsystem21.password Password for this user Test user3.6.4 WebSphere administration adminNodeName , -import , and -substituteStarting the administration server Importing the configuration file3.6.5 Manual client installation Starting application serverTesting Java Web Start HTTP Server for iSeries originalEjbdefault.cfg Running the manually configured clientHTTP Server for iSeries powered by Apache URL Template Replacement File PathIndex Actiona. Select Static Web Pages and Files Changing to another instance Configuring CallConnect.jnlpConfiguring JWS.bat Figure 3-25 Manage HTTP Servers page Stopping the serverSee 3.6.5, “Manual client installation” on page The files to modify are ejbdefault.cfg log.cfg standard.propertiesChapter 3. Installing and setting up call.connect Page Chapter 4. Installing and setting up vendor.connect Copyright IBM Corp. 2002. All rights reserved4.1 Preparing for the installation 4.2 Installing vendor.connectBasic steps checklist 4.1.1 Skills required4.2.1 System21 base 4.2.2 Java components and configuration filesvendor.connect components 4.2.4 Installing and configuring WebSphere 4.2.3 Restoring librariesStarting the administration server Importing the configuration fileCreating a new instance Starting the instancePage Ensuring that the HTTP Server is ready 4.2.5 IBM HTTP Server for iSeriesStarting the application Configuring the HTTP Server on the iSeries Figure 4-3 AS/400 Tasks pageConfiguring IBM HTTP Server for iSeries original Figure 4-4 IBM HTTP Server for AS/400 pageCreating a configuration Figure 4-5 IBM HTTP Server Configuration and Administration pageChapter 4. Installing and setting up vendor.connect Figure 4-6 Create configuration pageCreating an instance Setting up on the iSeries JournalingYou must journal the following files at a minimum Figure 4-8 Working with the user-defined options Command STRJRNPF FILE&L/&N JRNOSLF3/OSL OMTJRNE*OPNCLOFigure 4-9 Create User-Defined Option display User profiles System21 data setupDatabase triggers 4.2.6 MQSeries Creating a queue manager4.2.7 Work Management Trigger Handler for the iSeries 4.2.8 Active Architecture frameworkPublisher Verifying whether folders have write authorityUpdating the events rules Controller 4.2.10 Setting up new vendor.connect user IDs and supplier IDs ConnectorManager.xml4.2.9 JConnects server AIF .ini filesXML security Using LDAP Configuring the LDAP servera. Select the Start server when TCP is started box b. Set Administrator name as CN=rootc. Click the Password button. Enter and confirm your password Chapter 4. Installing and setting up vendor.connectUsing IBM SecureWay Figure 4-13 Directory Properties Database/Suffixes pagea. Enter the server name needjava in this example a. Select the Authenticated option b. Enter CN=root for User DN c. Enter the password you entered on the Add directory server displayOn the Rebind to server panel these tasks d. Click OKc. Select the Organizational unit option Creating the vcadmin user in IBM SecureWay Creating the authorization rule Figure 4-19 Logging on as vcadmin Figure 4-20 Setting up a new user1. Set the library list by connecting to the iSeries 4. Run the set of SQL commands that are detailed in the following SQL example. They cause triggers to be fired so that the System21 data will be synchronized into the VendorConnect database. You can find the SQL in the SQL to sync dbs on initial load.txt file in the SQL folder 4.2.12 Testing the vendor.connect Web site 4.2.13 Backing up the configuration components4.3 Changing the iSeries on which the application is running 4.4 Housekeeping4.4.3 Starting 4.4.4 Restoring the vendor.connect IFS objectsStarting the trigger handler and AIF controller Starting WebSphere default instanceThis chapter covers performance tuning of Geac System21 products Chapter 5. Performance tuningCopyright IBM Corp. 2002. All rights reserved 5.1 Hardware 5.2.1 SQL server job configuration 5.2 Operating System/400 OS/4001. Sign on as QSECOFR 2. Enter the following command Figure 5-3 Display Prestart Job Entries list Figure 5-4 Display Prestart Job Entry Detail for QSQSRVROnly one instance of WebSphere is running 5.2.2 Toolbox JDBC driver Note The commands are the same, but the parameters may be different 5.2.3 Subsystems and memory pools Figure 5-7 WRKSYSSTS command showing the memory pool names2. End the QEJBSBS subsystem by using the following command For a more simplified method, you can enter 12.End the SQL server prestart jobs by entering the following command 17.Change the SQL server prestart job to use the new pool 22.Check the QSQSRVR jobs by using the following command 5.2.4 Automatic performance adjustment 5.2.5 Manual performance adjustment 5.3.1 Stateful connections5.3.2 Stateless connections 5.4 Performance topics for Java virtual machine JVM settings 5.3.3 Total connections and SQL server jobs5.4.1 Initial Java heap size 5.4.2 Maximum Java heap size5.4.3 Verbose garbage collection 5.4.4 Static compilation DSPJVAPGM CLSF/OrderManagement/Deployed/roseaodeployed.jar Figure 5-20 The DSPJVAPGM command used with a compiled JAR fileCRTJVAPGM CLSF/OrderManagement/Deployed/roseaodeployed.jar OPTIMIZE40 place of the OS/400 system class loader. This custom class loader does not detect the static programs 2. Add a colon to the end of each line, except the last Enterprise bean settings Application settings Performance requirementsConstrained performance Transaction time outTransaction inactivity time out Ping interval and timeoutFigure 5-24 Advanced page of the Application Server panel Datasource settings Connection time out Idle time outOrphan time out Figure 5-26 The Advanced page of the DataSource panelPage Chapter 6. Tips and techniques Copyright IBM Corp. 2002. All rights reserved6.1 The iSeries integrated file system 6.1.1 Using File Transfer Protocol FTP with the iSeries IFS 6.1.2 Mapping a PC drive to the iSeries IFS 3. Expand File Systems, and select File SharesFigure 6-1 Creating a file share 6.1.3 Editing an iSeries stream file using a PC editor 6.1.4 Stream files and CCSID6.1.5 The cd command 6.1.6 Managing stream files with the OS/400 WRKLNK commandTOCCSID819 DTAFMT*TXT cd /OrderManagement/log6.1.7 Other stream file commands 6.1.8 Stream file authority 6.1.9 Editing an iSeries stream file using the OS/400 EDTF command 6.2 The QshellFigure 6-4 The QSH Command Entry display 6.2.1 Managing stream files with Qshell commands 6.2.2 The touch and setccsid commands 6.2.3 Viewing an iSeries stream file using the Qshell tail commandtail -f /OrderManagement/log.stdout.txt 6.2.4 Qshell scriptsDIRECTORY=/OrderManagement export DIRECTORY=/OrderManagement cd $DIRECTORY/logmyscript.sh redirect.out 6.3 Checking the QEJBSBS subsystem 6.3.2 Instance administration jobs 6.3.1 Instance monitor jobsMessage . . . . WebSphere administration server QEJBADMIN ready Figure 6-6 Job log of the QEJBADMIN jobnetstat *cnn 6.3.4 Application server jobs 6.3.3 Specifying portsFigure 6-7 The NETSTAT command showing ports 900 and 6.4.1 Checking the WebSphere PTF level on the iSeries 6.4.2 Checking the WebSphere PTF level on a PC 6.5 Common problems with commerce.connect on iSeries 6.5.1 Problems connecting the console to WebSphere on the iSeries6.5.2 Checking the iSeries name as required by WebSphere 6.5.3 Checking the iSeries database name How to get IBM Redbooks OS/400 Work Management, SC41-5306 Backup and Recovery, SC41-5304Geac call.connect Installation Guide Geac System21 Installation and Setup GuidePage Index SymbolsNumerics Page Page stateless connection Windows Explorer Page 0.2”spine 0.17”-0.473” 90-249 pages Page Page Back cover Learn helpful usage and performance tips and techniquesFollow the step-by-step guide to install commerce.connect Geac System21 commerce.connect