Main
ibm.com/redbooks
Front cover
Geac System21 commerce.connect
Implementation on the IBM
Page
Page
Page
Contents
Page
Page
Page
Notices
IBM Director of Licensing, IBM Corporation, North Castle Drive Ar monk, NY 10504-1785 U.S.A.
Trademarks
Preface
call.connect and vendor.connect applications. These applications extend and enhance the
~
The team that wrote this redbook
Become a published author
Comments welcome
commerce.connect
1.1 call.connect
Geac call.connect
Page
1.2 vendor.connect
Geac vendor.connect
Page
Page
commerce.connect products
2.1 The need for an architecture
2.1.1 Key Enterprise JavaBeans and WebSphere Application Server benefits
2.1.2 The architecture moving forward
2.1.3 The development process
2.1.4 Implementation
2.1.5 The design methodology: Using Unified Modelling Language
Page
2.2 Messaging: Java Message Service and IBM WebSphere MQ
2.2.1 call.connect
Adding a Sales Order Line scenario
14
2.2.2 vendor.connect
Events
Key
Figure 2-4 vendor.connect messaging usage
Key
2.3 Overview of process.connect
System21 Database
2.4 Architectural representation
2.4.1 Architectural goals and constraints
2.4.2 Non-functional architectural considerations
2.4.3 Functional architectural considerations
The deployment influence
2.5 Reusing and extending System21 business logic
2.5.1 Accessing System21 RPG business logic
IBM Toolbox for Java (previously AS/4 00 Toolbox for Java)
Java Native Interface (JNI)
Interface
The choice
call.connect
italics
3.1 Skills and prerequisites for installing, running WebSphere Application Server
3.1.1 Skills
3.1.2 Prerequisites
iSeries hardware requirements
iSeries software requirements
Workstation hardware requirements
Workstation software requirements
3.1.3 System21 authorization code for Order Management (OM)
3.2 Standard installation procedures
Checklist of the basic steps
Geac call.connect Installation Guide
3.2.1 Installing Order Management and call.connect
System21 base
System21 Order Management (OM)
Geac System21 Installation and Setup Guide
Java components and configuration files
3.2.2 WebSphere installation and configuration
Starting the administration server
Importing the configuration file
Starting the application
3.2.3 Journaling
Journaling the files without an ASP
Journaling the files with an ASP
Journaling a single file
Journaling multiple files within a library
3.2.4 Stored procedures and SQL
Page
Other SQL
3.2.5 Java Message Service
Setting up MQSeries
Creating a queue manager
Creating a queue
Granting authority
Page
Additional files needed
Creating the JNDI/MQ objects
Standard properties
Additional WebSphere configuration
Testing the messaging
3.2.6 User profiles
Job description
Creating iSeries user profiles
Setting up call.connect users in the XML user directory
Setting up System21 user profiles
Administration Functions Active Enterprise Framework
Setting up an operator
System21 Setup for call.connect
3.2.7 System21 data set up
.
Basic System21 Setup for call.connect
3.2.8 Java Web Start
Ensuring that the HTTP administrative server is ready
Configuring the HTTP Server on the iSeries
Needjava
Page
Configuring an HTTP Server for iSeries (original)
Creating a configuration
Page
Page
Creating an instance
Page
Page
Page
Page
Configuring CallConnect.jnlp
Configuring JWS.bat
3.2.9 Backup
Geac System21 Installation Guide.
3.3 call.connect housekeeping
3.3.1 Daily backups
3.3.2 Stopping WebSphere
3.3.3 Starting call.connect
Starting WebSphere (default instance)
3.4 Troubleshooting
3.4.1 WebSphere node name
3.4.2 Errors on starting the client
3.4.3 Errors when running the client
3.4.4 Cached data and .bl and .cd files
3.4.5 Log files and debugging
Setting up logging on the client
igned on user
Java Web Start
signed on user>\
3.5 Manual configuration
3.5.1 Non-standard Order Management and call.connect installation
System21 and Order Management
Geac System21 Setup and Installation Guide.
Java components and configuration files
3.5.2 WebSphere manual configuration
Starting QEJBSBS on the iSeries
Starting the WebSphere console on a PC
Creating JDBC drivers
Creating DataSources
Setting the node parameters
Creating the application server
Creating an EJB container
Creating enterprise beans
3.5.3 Manual client installation
Ejb_default.cfg
Log.cfg
callConnect.bat
Running the manually configured client
3.6 Alternative configurations
3.6.1 Setting up a test instance of WebSphere
3.6.2 Setting up an iSeries server for a test system
System21 data
Journaling
Job description
Test user
3.6.3 Server configuration
The GL company you want to use
Password for this user
The test user defined previously
The company you want to use
3.6.4 WebSphere administration
Starting the administration server
Importing the configuration file
Starting application server
3.6.5 Manual client installation
Ejb_default.cfg
Log.cfg
callConnect.bat
Running the manually configured client
Testing Java Web Start
HTTP Server for iSeries (powered by Apa che)
Page
Configuring CallConnect.jnlp
Configuring JWS.bat
signed on user>.
Changing to another instance
Page
Page
vendor.connect
italics
@ctive Modeler, and secure.connect. vendor.connect users may install these applications,
4.1 Preparing for the installation
4.1.1 Skills required
4.2 Installing vendor.connect
Basic steps checklist
vendor.connect components
4.2.1 System21 base
4.2.2 Java components and configuration files
Geac System21 Installation and Setup Guide
4.2.3 Restoring libraries
4.2.4 Installing and configuring WebSphere
Creating a new instance
Starting the administration se rver
Starting the instance
Importing the configuration file
Page
Starting the application
4.2.5 IBM HTTP Server for iSeries
Ensuring that the HTTP Server is ready
Configuring the HTTP Server on the iSeries
Needjava
Configuring IBM HTTP Server for iSeries (original)
Creating a configuration
Page
CNDW wait
Setting up on the iSeries
Journaling
Page
Page
User profiles
System21 data setup
Database triggers
4.2.6 MQSeries
Creating a queue manager
4.2.7 Work Management Trigger Handler for the iSeries
4.2.8 Active Architecture framework
Publisher
Verifying whether folders have write authority
Checking the properties file
Updating the events rules
Controller
4.2.9 JConnects server
ConnectorManager.xml
AIF .ini files
4.2.10 Setting up new vendor.connect user IDs and supplier IDs
SecurityManager.xml
XML security
Using LDAP
Configuring the LDAP server
Page
Using IBM SecureWay
do not set this to None.
Page
Page
Page
Creating the vcadmin user in IBM SecureWay
Creating the authorization rule
Page
4.2.11 Database synchronization from System21 to the vendor.connect database
Page
4.2.12 Testing the vendor.connect Web site
4.2.13 Backing up the configuration components
4.3 Changing the iSeries on which the application is running
4.4 Housekeeping
4.4.1 Daily
4.4.2 Stopping
4.4.3 Starting
Starting WebSphere (default instance)
Starting WebSphere (other instances)
Starting the trigger handler and AIF controller
4.4.4 Restoring the vendor.connect IFS objects
Page
5.1 Hardware
Processing Workload
5.2 Operating System/400 (OS/400)
5.2.1 SQL server job configuration
Page
Page
Page
5.2.2 Toolbox JDBC driver
Page
5.2.3 Subsystems and memory pools
Page
Page
Page
Page
Page
5.2.4 Automatic performance adjustment
5.2.5 Manual performance adjustment
5.3 Stateless and stateful connections, datasources, connection pools, etc.
5.3.1 Stateful connections
5.3.2 Stateless connections
5.3.3 Total connections and SQL server jobs
5.4 Performance topics for Java virtual machine (JVM) settings
5.4.1 Initial Java heap size
5.4.2 Maximum Java heap size
5.4.3 Verbose garbage collection
5.4.4 Static compilation
Page
Page
Page
Enterprise bean settings
Performance requirements
Constrained performance
Application settings
Transaction time out
Transaction inactivity time out
Ping interval and timeout
Datasource settings
Connection time out
Idle time out
Orphan time out
Page
Page
6.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
Page
6.1.3 Editing an iSeries stream file using a PC editor
6.1.4 Stream files and CCSID
ebcdic-file-name
ascii-file-name
6.1.5 The cd command
6.1.6 Managing stream files with the OS/400 WRKLNK command
6.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 Qshell
Page
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 command
6.2.4 Qshell scripts
Page
6.3 Checking the QEJBSBS subsystem
6.3.1 Instance monitor jobs
6.3.2 Instance administration jobs
Page
6.3.3 Specifying ports
6.3.4 Application server jobs
6.4 WebSphere versions on the iSeries, your console system, and clients
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 iSeries
6.5.2 Checking the iSeries name as required by WebSphere
6.5.3 Checking the iSeries database name
Related publications
IBM Redbooks
Other resources
Referenced Web sites
How to get IBM Redbooks
Page
Index
Symbols
Numerics
A
B
D
E
F
G
H
L
M
N
O
P
R
S
T
U
V
W
X
Page
Page
Page
Page
INTERNATIONAL TECHNICAL SUPPORT ORGANIZATION
Geac System21 commerce.connect
Back cover
Implementation on the IBM iSeries Server