#JDEINFOCUS

Wednesday August 22, 2018

EnterpriseOne on the IBM i (AS400)

DIRECTION, RELEVANCE AND OPTIMIZATION

Prepared by:

Name: Colin Dawes

Title: Chief Solution Architect

Company: Syntax

Email: cdawes@syntax.com

Session ID#: 101620

#JDEINFOCUS

Colin Dawes

• Strategic and innovative technology leader20+ year of IT experience encompassing ERP, Cloud, Mobility, Enterprise Architecture

• Expert on all supported EnterpriseOne databases and platforms

• Performed over 60+ EnterpriseOne installs, upgrades and migrations

• Consulting engagements with over 200 EnterpriseOne customers

#JDEINFOCUS

Syntax at a Glance

A pioneer Oracle

ERP hosting and

disaster recovery

provider.

Focus on building

long-term

relationships.

Delivering

best-of-breed

Cloud, Disaster

Recovery and

Managed Services

for over 25 years.

Oracle expertise

tailored to your

needs and delivered

via our Consulting

Solutions.

#JDEINFOCUS

Syntax Footprint - Local Presence, Global Support

Phoenix, AZHouston, TX

Somerset, NJNew York, NY

Buenos Aires, Argentina

Gurgaon, India

Hyderabad, IndiaMumbai, India

Montreal & Toronto

Los Angeles, CA

Irvine, CA

Denver, CO

Atlanta, GA

Chicago, IL

Data Center & Application Support Center

Application Support Center

Account Management & Sales Support

NO

N O

RA

CL

E A

PP

LIC

AT

ION

S• Remote Managed Services

• JD Edwards: EnterpriseOne, World

• EBS, PSFT, Hyperion, OBIEE

• Other Oracle and 3rd-Party Apps

• Functional Application Managed Services

• Application Development & Extension

• SOA and Middleware Development

• Business Intelligence

• MS SQL Server

• Windows Servers

• Solaris, Linux, Windows, AIX

• Integrations

• DBaaS

• PaaS

• DRaaS

• BaaS

• IaaS

• Implementations & Upgrades

• Project Management

• Functional Support

TraditionalCloud

Solutions

Application Managed Services

Oracle ERP Cloud

Solutions

Associated Technologies

Consulting SolutionsO

RA

CL

E A

PP

LIC

AT

ION

S

#JDEINFOCUS

O/S Installation / Configuration /

Upgrades / Patching

Syntax - IBM i Technical Services

Server Consolidation & Virtualization

High Availability & Disaster Recovery

Backup & Recovery Installation /

Configuration

Infrastructure Installation /

Configuration / Upgrade / Patching

Storage & VIOS Installation /

Configuration

Assessment Services

Troubleshooting and Issue

Resolution

Security & VulnerabilityAlerts Monitoring and Reporting

#JDEINFOCUS

O/S Startup Automation

Syntax - IBM i Development Services

Command Line (CL) Scripting

IBM WebSphere Application Server

Java Programming

RPG / RPGLE, COBOL

Programming

Query/400 Creation

Development Assessment

Services

DB2 for i Performance Tuning

and Optimization

DB2 for i Programming / Stored

Procedures

IBM Host Access Transformation

Services (HATS)

#JDEINFOCUS

IBM Power 7 & 8 – V6R1, V7R1,

V7R2, V7R3 (Power 9 – Q2 2018)

Syntax - IBM i Hosting & Managed Services

Live Partition Mobility (LPM) and

Simplified Remote Restart (SRR) =

Partition Mobility and Recovery

Upgrade to the latest Power System

at no infrastructure additional cost

Dedicated CPW, RAM, Storage per

LPAR

Pool and share resources between

contracted LPAR’s to optimize utilization

Virtual Tape Library on EMC Data Domain

replicated to secondary EMC Data Domain

then duplicated to tape

Maximum Performance Architecture

CPW:RAM ratio of 1000 CPW:8 GB RAM

All Flash Storage on 32 GB Fibre

Channel

Superior Disaster Recovery RPO and RTO

near 0 and available High Availability

Syntax Enterprise Care Alerting,

Monitoring and Reporting Platform

IBM I DIRECTION

#JDEINFOCUS

Is the AS/400 dead?

• Introduced in 1988 as an integrated system

• Now called an IBM Power Systems running IBM i

• Unsung hero for 100,000+ manufacturers, distributors, banks, hospitals, retailers and government

CONTROVERSY

• Perceived as outdated

• Talent is retiring

REALITY

• Scalable

• Secure

• Reliable

• Modern

• Compatible

#JDEINFOCUS

IBM and JD Edwards

• JD Edwards is committed to ongoing support• IBM POWER – IBM i (AS400) and AIX

• IBM DB2 Database

• IBM WebSphere Application Server (WAS)

• IBM is JD Edwards’ longest-standing technology partner

2012:

JDE World

A9.3

2012:

JDE E1

9.1

1979:

Elegant

Software

launched

1982:

World

launched

1996:

OneWorld

launched

2003:

PeopleSoft

acquires

JD Edwards

2005:

Oracle

acquires

PeopleSoft

1977:

JD Edwards

founded

2015:

JDE E1

9.2

JDE World

A9.4

JDE Sol

Edition

POWER7

2010

JDE Sol

Edition

POWER8

2014

S/36

1983AS/400

1988

64-Bit

1995POWER5

2004POWER6

2007

S/38

1978

JDE Sol

Edition

POWER9

2018

#JDEINFOCUS

IBM i Roadmap

• IBM continues to invest in the IBM i through major releases

• Technology Refreshes (TR) provided for additional non-disruptive new functionality

#JDEINFOCUS

IBM i Support Roadmap

• http://www-01.ibm.com/support/docview.wss?uid=nas8N1022027

• http://www-01.ibm.com/support/docview.wss?uid=nas8N1022035

• bit.ly/IBMiRoadmap2016

V7R1 is off

mainstream support

and is no longer

certified on new E1

Tools Releases

#JDEINFOCUS

EnterpriseOne Overview

• EnterpriseOne is a complete suite of modular, pre-integrated, industry-specific business applications

• EnterpriseOne Tools is the runtime architecture and integrated development environment

#JDEINFOCUS

Delivered Planned ►

20242015 2018

EnterpriseOne Tools Support for IBM i

Calendar

Year 2012 2021

Apps 9.1

Tools 9.1 Tools A

Apps A

Tools C

Apps BTools 9.1.3

Tools 9.1.2

Apps 9.1.2 Apps 9.2

Tools 9.2

Tools 9.1.4

Tools 9.1.5

Tools B

Apps CTools 9.2.1

Tools 9.2.2

Apps 9.2.2

O/S400 V6R1

O/S400 V7R1

O/S400 V7R2

O/S400 V7R3

#JDEINFOCUS

Delivered Planned ►

20242015 2018

EnterpriseOne Tools Support for WAS

Calendar

Year 2012 2021

Apps 9.1

Tools 9.1 Tools A

Apps A

Tools C

Apps BTools 9.1.3

Tools 9.1.2

Apps 9.1.2 Apps 9.2

Tools 9.2

Tools 9.1.4

Tools 9.1.5

Tools B

Apps CTools 9.2.1

Tools 9.2.2

Apps 9.2.2

WAS 7.0.0.29

WAS 8.5

WAS 8.5.5.X

WAS 9.0.X

WAS 7.0.0.19V7R1 / V7R2 V7R2 / V7R3

CONSIDERATIONSEnterpriseOne on the IBM i

#JDEINFOCUS

IBM i in the EnterpriseOne Logical Server Architecture

DatabaseServer(s)

HTML (J2EE) Application Server(s)

DeploymentServer

EnterpriseServer(s)

PortalServer(s)

BIP / OVRServer(s)

ADF (J2EE)Application

Server(s)

AIS (J2EE)Application

Server(s)

BSSV(J2EE) Application

Server(s)

AIS(J2EE) Application

Server(s)

RTE / Transaction(J2EE) Application

Server(s)

Development ClientAdmin Client

End User Clients

Identity Management

Server(s)

Required Core Servers / Components UI / Reporting ComponentsIntegration

ComponentsAuthentication

Components

#JDEINFOCUS

J2EE Application Server – “All – On – i”

• The IBM i accommodates multiple workloads• Consolidated “All - On - i” footprint (Web, Enterprise, Database)

• Simplified administration, disaster recovery, backup, etc.

• WAS licensing is less expensive on the IBM i• Compared to WebLogic or WAS on another platform (<200 users)

• Consider running:• WAS Express and “All - On - i” for < 50 concurrent users (FREE)

• WAS ND and “All - On - i” for < 200 concurrent users

• IBM WAS for Developers is free (requires tools 9.2)

• IBM embraces sub-capacity (virtualization) licensing

#JDEINFOCUS

IBM WebSphere Application Server Editions

Only supported

for Developer

Workstations

beginning with

Tools 9.2

•Originally

included in the

IBM Technology

Foundation

•Includes

Clustering

Does not

includes

Clustering (can

use a load

balancer)

•Included with

the IBM iOS

•Limited

scalability (best

used with <50

concurrent

users)

#JDEINFOCUS

J2EE Application Server - Considerations

• Customers who already own the Oracle Technology Foundation should strongly consider deploying WebLogic since it is already ‘paid for’

• Environments with over 200 concurrent users may want to consider deploying the Web Tier on a separate LPAR or on a separate platform

• The EnterpriseOne Orchestrator requires WebLogic

#JDEINFOCUS

Deployment Model

• Consider all flash storage • IBM V7000F or V9000

• Choose Virtual Tape Library backup options

• Infrastructure High Availability is an expensive option for a single customer

IBM i in the Virtual Private Cloud

IBM i On Premise

• Consider all flash storage (IBM V7000F or V9000)

• True IBM i Cloud Solutions provide High Availability

• Backup solutions are typically VTL

#JDEINFOCUS

IBM i Infrastructure Resiliency

Network Servers Virtualization

•Redundancy (n +2)

•No single points of failure

•Flexible & Agile

•Layered & Modular

•Redundancy (n +2)

•Automation for Fail Over

•Secure & Isolated

•Live migrations for PowerVM

•Highly Available Clusters

Private Link

Internet

MPLS

Load Balancer(s) Load Balancer(s)

Production Site Recovery Site

Virtualisation Layer Virtualisation Layer Virtualisation Layer

Failed Server Operating ServerOperating Server

No RebootSeamless Cutover

IBM i LPAR Mobility and Resiliency

Live Partition Mobility (LTM)

PowerVM enables the movement of LPAR’s from one system to another with no loss of service

Enable planned maintenance and easy migrations for workload balancing

Preserves LPAR resource configuration but not the active running state

During “unplanned outages” partitions cannot start on another server

Remote Restart (RR)

Restart on a server within the current data center (cold restart)Restart on a server in another data center using cross-site LTM (cold restart)

In the event of an error that causes a server outage, enables an LPAR configured for RR to be restarted on a different physical server

#JDEINFOCUS

Disaster Recovery MetricsRecovery Point

Objective (RPO)

•“Acceptable loss" in a disaster situation

•RPO governed by administrative practices

Recovery Time

Objective (RTO)

•“Down time” or the duration of time within which a business process must be restored after a disaster (or disruption)

•RTO governed by disaster recovery configuration

Cold Site Warm Recovery Rapid DR

High RTO Low RTO

#JDEINFOCUS

Business Continuity – Data Resiliency

Type Description Pro’s Con’s

Logical replication • HA product supplied by an ISV

(Mimix, iCluster, Maxavva, etc.)

• Near real-time

• Role swap possible

• Inexpensive

• Individual server or LUN setup

and maintenance

Hardware

replication

• Storage level replication • Easy O/S upgrades and

maintenance

• Additional bandwidth

Geographic

Mirroring

• Function of the O/S where data

is mirrored

• Fast and efficient switching

• Single copy of data is simple

• O/S implementation limits

performance

Storage Replication

(Metro Mirror)

• Synchronous and implemented

in storage server

• Possible for both HA and DR • Distance limitation

• High bandwidth

Storage Replication

(Global Mirror)

• Asynchronous and

implemented in storage server

(V7000, V9000)

• Possible for both HA and DR

• No geographic limit

• Additional options required for

consistency

#JDEINFOCUS

Disaster Recovery – Licensing ImpactYou cannot run active workloads against the DR machines without a license.

Backup Category Software Status Oracle Microsoft IBM

Cold Not Started No Additional

Licencing

No Additional

Licencing

No Additional

Licencing

Storage Replication Not Started but rapid

availability

No Additional

Licencing

No Additional

Licencing

No Additional

Licencing

Warm (Idle Standby) Started but Idle Partial License No Additional

Licencing

No Additional

Licencing

High Availability Started and available for

work

Full License Full License Partial to Full

License (CBU)

Hot Started and doing work Full License Full License Full License

OPTIMIZATIONEnterpriseOne on the IBM i

#JDEINFOCUS

IBM i - Network• 1 Gbps bandwidth with low latency

• Ensure EnterpriseOne Servers are on the same VLAN

• Order of host table entries is important• FQDN name must go before HOST NAME.

• All E1 servers should be entered in the HOST table

• Set larger send/receive buffers (default is 8192 bytes)

Bytes Ethernet Line Speed

8192 10 MBs

65536 100 MBs

1048576 1 GBs

• CHGTCPA TCPRCVBUF(1048576) TCPSNDBUF(1048576)

#JDEINFOCUS

IBM i - Memory Management

• Divide workload into separate shared memory pools

• MACHINE

• BASE

• INTERACT

• SPOOL

• SHRPOOL1• SBSD QUSRWRK (QZDASOINIT - JDBC/ODBC)

• SBSD QSYSWRK (QSQSRVR - JDBC/Database)

• SBSD JDEE920 (JD Edwards EnterpriseOne)

• SHRPOOL2• SBSD JDEBATCH (UBE’s)

• SHRPOOL3• SBSD QWAS9 (Websphere)

• SBSD QHTTPSVR (HTTP Server)

#JDEINFOCUS

IBM i - Memory Management

• The QPFRADJ system value allows the system to dynamically move memory between pools

• Can still move storage manually if automatic adjustment is too slow

#JDEINFOCUS

IBM i – Options and Updates

• Update the OS/400 Program Temporary Fixes (PTF) • Emphasis on the CUME, Group Hiper, DB2 for IBM i and Java

(WRKPTFGRP)• http://www-912.ibm.com/s_dir/sline003.NSF/GroupPTFs?OpenView&Start=1&Count=30&Expand=2#2

• Slow processing and long UBE job run times?• Implement HA Journals (Option 42)

• Align the various names (case sensitive)

Network Attribute Relational

Database Name

Host Name Domain Name

Network Attribute Relational

Database Name

Host Name Domain Name

DSPNETA WRKRDBDIRE CFGTCP Option 10 CFGTCP Option 12

#JDEINFOCUS

IBM i - Prestart Jobs

• Job initiation is performance in advance rather than on

demand

• User can see a significant reduction in response time

• Additional jobs are started automatically as needed.

• Every 5 minutes the operating system will check to see if

there are an excess of prestart jobs that are not being

used

• Gradually start ending the extra jobs up to the point where the

number of jobs is at the initial start setting

#JDEINFOCUS

IBM i - Prestart Jobs

• Configuring the number of prestart jobs is an iterative process

• Configure the QSQSRVR jobs to start when the subsystem is started:

• Use DSPACTPJ and CHGPJE to monitor and manage their numbers

Connection Type Jobs Subsystem

ODBC QZDASOINIT (pre-started) QUSRWRK

Toolbox JDBC QZDASOINIT (pre-started) QUSRWRK

Native JDBC QSQSRVR (pre-started) QSYSWRK

#JDEINFOCUS

EnterpriseOne - JDE.INI Tuning

• Input a valid mail server name in the jde.ini

• Reuse SQL Packages

• Use a default queue other than QBATCH

• Package Builds – select appropriate simultaneous builds (~ 1 per 1000 CPW)

• Select a job queue to use for BSFN compiles

#JDEINFOCUS

EnterpriseOne - JDE.INI Tuning

• [JDEMAIL]

• Rule1=90|OPT|MAILSERVER=mail.syntax.com

• mailServer=mail.syntax.com

• [DB SYSTEM SETTINGS]

• SQL Package Library=0 (After Data Conversion)

• [NETWORK QUEUE SETTINGS]

• UBEQueue=JDEBATCH # something other than QBATCH

• [BSFN BUILD]

• SimultaneousBuilds=0 # set at JOBQ level

• QNAME=JDEBUILD # set JOBQ for BSFN’s Compile

#JDEINFOCUS

Batch Performance

JDEBATCH (1) JDEBATCH (1)

GLBATCH (1/3)

DISBATCH (1)

APBATCH (1/3)

DEFAULT

MULTI-

CONCURRENT

MANDATORY

SINGLE-

CONCURRENT

TBATCH (0)

ARBATCH (1/3)

MFGBATCH (1)

NO ACTIVE

SUBSYSTEMS

MFGACBATCH (1/3)

PKGBATCH (1)

PACKAGE BUILD AND DEPLOYMENT

PRODUCTION SIZED FOR A MAXIMUM OF 10 CONCURRENT JOBS

{{

CO

UN

T A

S 4

CO

NC

UR

RE

NT

BA

TC

H J

OB

S

CO

UN

T A

S 4

CO

NC

UR

RE

NT

BA

TC

H J

OB

S

CO

UN

T A

S 0

CO

NC

UR

RE

NT

BA

TC

H J

OB

S

NOTE: As more long running jobs in JDEBATCH are identified, these jobs should be

moved to a separate job queue for processing and JDEBATCH should be throttled down

to 4 concurrent jobs

JD Edwards EnterpriseOne Batch Processing

Job Queue Configuration

{LONGBATCH (1) LONGBATCH (1)

HRBATCH (0)

PAYBATCH (0)

JDEBATCH (1)

RBATCH (0)

DISACBATCH (1/3)

JDEBATCH (1)

CO

UN

T A

S 2

CO

NC

UR

RE

NT

BA

TC

H J

OB

S

FILLBATCH (1/3)

PACKBATCH (0/3)

PICKBATCH (0/3)

INVOICEBATCH (0/3)

TRNSBATCH (1/3)

• Use concurrent batch queues• Move mandatory jobs to single

concurrent queue• Modify default queue to support

concurrent jobs• Move long running jobs to a

dedicated queue• E1 Subsystem jobs require their own

queue

• Start with all Job Queues under a single AS400 Subsystem• Create additional subsystem for

mission critical processes

• Set *MAXACT set at the subsystem level

#JDEINFOCUS

Batch Performance

• IBM i job queue can be inherited per user from a *JOBD • Simply leave the Job Queue undefined in E1

• Manually assign EnterpriseOne bBatch Jobs to Job Queues• UDC 98/JQ• Job Queues: P986130

• Queues can still be created in the jde.ini (required for subsystems)

• GO JDEOW/A98OWMNU

• Check out versions, update job queue, check in and promote

• Automate the assignment of Batch Jobs to Job Queues• 3rd party solutions available

• Create a custom daemon to move jobs after submission

• Convert frequently run jobs to subsystem jobs

#JDEINFOCUS

DB2 for i - Symmetric Multiprocessing

• DB2 Symmetric Multiprocessing (SMP) is an optionally priced feature of IBM i (option 26)• Parallelism is included all through IBM i but SMP enables it

• Improves performance of long running UBE’s

• It is a tradeoff – spend more resource for improved query run times

• Parallelism can be configured using by using:• The system value QQRYDEGREE

• The QAQQINI file (*NONE, *IO, *OPTIMIZE, *MAX)

• The Change Query Attributes (CHGQRYA) command

#JDEINFOCUS

DB2 for i - Optimization Goal

• Optimization Goal• *ALLIO optimized for UBE’s

• *FIRSTIO for web client workloads

• Tells the optimizer how many rows you expect to fetch per transaction

• Optimizer builds a plan that is optimal for the number of rows

• Affects the query "start up" time and overall run time

First n rows

Next n rows

All rows

Time

First I/O All I/O

Read by key

via an index

Build and use

a hash table

#JDEINFOCUS

DB2 for i - QAQQINI Query Options File

• Central point of control for many options for query optimization and execution

• Implemented as a database file with one row per attribute

QQPARM QQVAL QQTEXT

OPTIMIZATION_GOAL *ALLIO Used for all UBE’s

IGNORE_DERIVED_INDEX *YES Advised by IBM 4/14/2011

PARALLEL_DEGREE *OPTIMIZE Improve UBE’s

LOB_LOCATOR_THRESHOLD 10000 E1 installation

#JDEINFOCUS

DB2 for i - SQL Packages

• Store statement and access plan information for any Extended Dynamic SQL interface

• Deletion of SQL package is still recommended whenever there is a significant database change• They will be recreated automatically as needed

• EnterpriseOne services must be down

• Delete QZDAPKG in QGPL after an OS upgrade(QZDAPKG not present with V7R2+)

• In a multi-LPAR EnterpriseOne System DRDA package should be manually created between LPAR’s

#JDEINFOCUS

Index Creation• The Index advisor will recommend an index for

‘everything’• Start with the application first before adding indices to the

database

Database Level• E1 has no knowledge that the

index exists. Query optimizer will determine when and how to use the index.

• Not preserved during an upgrade

• Quicker and easier to add and maintain

• E1 Developers can not directly leverage the index.

Application Level

• E1 knows about the index

• Preserved during an upgrade

• Much more time to add and maintain

• E1 Developers can leverage the index.

• Multiple methods to add• Object Management Workbench (OMW) • Batch Application - R9698713

THANK YOU

Please complete a session evaluation

Session ID: 101620

Contact Info:

cdawes@syntax.com

Tel: 416-875-0800

#JDEINFOCUS

A 55,000+ member user community for Oracle Cloud, JD Edwards and PeopleSoft customers.

What the Quest JD Edwards Community offers:

Customized digital content

Official JD Edwards newsletter

Customer success stories

Virtual and face-to-face events

JD Edwards networking groups

Visit www.QuestDirect.org for more information!

Who is the Quest Community?