Advanced Tuning for JD Edwards EnterpriseOne Implementations

Advanced Tuning for JD Edwards EnterpriseOne Implementations

by Michael Jacot, Allen Jacot, Frank Jordan, Gurbinder Bali
Released June 2013
Publisher(s): Oracle Press
ISBN: 9780071798556

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

Best Practices for JD Edwards EnterpriseOne Tuning and Optimization

Achieve peak performance from your ERP platform while minimizing downtime and lowering TCO. Advanced Tuning for JD Edwards EnterpriseOne Implementations shows how to plan and adopt a structured, top-to-bottom maintenance methodology. Uncover and eliminate bottlenecks, maximize efficiency at every component layer, troubleshoot databases and web servers, automate system testing, and handle mobile issues. This Oracle Press guide offers complete coverage of the latest cloud, clustering, load balancing, and virtualization solutions.

  • Understand the components of a structured tuning plan
  • Establish benchmarks and implement key industry practices
  • Perform changes and accurately measure system-wide impact
  • Diagnose and repair HTTP, web application, and Java issues
  • Troubleshoot Oracle Database connections and transactions
  • Streamline Oracle’s JD Edwards EnterpriseOne kernel and JDENeT processes
  • Configure, test, and manage virtual machines and servers
  • Work with Oracle Exadata Database Machine and Oracle Exalogic Elastic Cloud

Table of contents

  1. Cover 
  2. About the Authors
  3. Title Page
  4. Copyright Page
  5. Contents 
  6. Foreword
  7. Acknowledgments
  8. Introduction
  9. Chapter 1: Outline of a Structured Tuning Methodology
    1. Overview
    2. Benchmarks
    3. Merits of Continuous Performance Tuning
    4. Business Drivers
    5. Automated Scripting/Server Manager
    6. Conclusion
  10. Chapter 2: Understanding the Components of Performance Tuning
    1. Creating a Performance Tuning Strategy
    2. System Boundaries
    3. Operating System
      1. OS/400
      2. Linux
      3. Microsoft Windows
      4. AIX
      5. HP-UX
    4. Operating System Levels
    5. Patching the Operating System
    6. Disk Considerations
      1. Disk Speeds
      2. Disk Layout
      3. Storage Area Network (SAN)
    7. Database Components
      1. Types of Databases
      2. Database Layout
    8. General Tuning Levers
      1. System Global Area (SGA)
      2. Program Global Area (PGA)
      3. TEMPDB
    9. Network
      1. Network Cards
      2. Packet Priority
      3. Generate Server Layout
    10. Direct Application Tuning
      1. User Interface
      2. Application Tier
      3. Batch Tier
      4. Interfaces
      5. Common Performance Tools
    11. Summary
  11. Chapter 3: Building Blocks of an EnterpriseOne Implementation
    1. Types of EnterpriseOne Servers
      1. Enterprise (All-in-One)
      2. Application Logic
      3. Batch/Universal Batch Engine
      4. HTML/Java Application Server
      5. Database Server
      6. WebCenter/Portal Server
      7. Business Services/Transaction Server
      8. Deployment Server
    2. Enterprise/Application/Batch Servers
      1. Kernels
      2. Batch Processes
      3. Business Functions
      4. Java
      5. Configuration Settings
    3. HTML/JAS Servers
      1. Application Server–specific Settings
      2. EnterpriseOne Web/JAS Server Configuration Settings
    4. Database Server
      1. Purpose
      2. Configuration Aspects
    5. WebCenter/Portal Server
      1. Portal Configuration Settings
    6. Business Services/Transaction Server
      1. Configuration Settings
    7. Deployment Server
    8. Summary
  12. Chapter 4: Implementing a Performance Tuning Methodology
    1. Performance Tuning Methodology Basics
      1. Parts of the Methodology
      2. Having a Structured Plan
      3. Applying the Methodology with Benchmarks
    2. Conclusion
  13. Chapter 5: Understanding Base EnterpriseOne Technical Architecture
    1. Basic Principles of Performance Tuning
      1. Principle of Gears and Cogs
      2. Principle of Peeling the Onion
    2. Understanding the EnterpriseOne Technical Flexible Architecture
      1. Complexity and Implementation Types
      2. EnterpriseOne Environments
      3. Complexity Categories
    3. EnterpriseOne Technical Components
      1. JAS Server
      2. EnterpriseOne Logic Server
      3. EnterpriseOne Batch Server
      4. Database Server
    4. EnterpriseOne Process Flow
      1. Starting EnterpriseOne Services
      2. EnterpriseOne Requests
      3. EnterpriseOne Call Object Kernel
      4. EnterpriseOne Security Kernel
      5. EnterpriseOne Metadata Kernel
      6. EnterpriseOne Queue and UBE Kernels
    5. Defining the Size of an EnterpriseOne Implementation
      1. Interactive and Batch Processing
      2. EDI Processing
      3. Modules of Integration
      4. Horizontal and Vertical Scaling of the Architecture
    6. Implementation Stages of EnterpriseOne Architecture
      1. Designing the Architecture
      2. Installing the Components
      3. Configuring and Validating the Installation
      4. Customizing the Implementation
      5. Extending Nodes/Resources
      6. Directing Traffic by Implementing Hardware Switches
      7. Setting Up Security
      8. Further Testing and Validation
      9. Training
    7. Bringing It All Together
  14. Chapter 6: Tuning by Tier: The Web Tier
    1. Isolating Performance Issues to a JAS Server
    2. Components of the JAS Architecture
      1. Tuning the J2EE Server
      2. Tuning the HTTP Server
      3. Tuning the JAS Layer
      4. Using Server Manager to Detect Issues in the JAS Server
    3. WebLogic Application Server–specific Tuning
      1. WebLogic Console and JRockit Command-Line Arguments
      2. Memory Considerations
    4. WebSphere Application Server–specific Tuning
      1. WebSphere Class Sharing Option
      2. WebSphere Heap Fragmentation
      3. Tuning WebSphere on System i
      4. Garbage Collection and Its Interpretation
    5. End User Browser Tuning
      1. Internet Explorer
      2. Firefox Browser
    6. Wide Area Network Tuning
      1. Web Timeouts and Their Interrelationships
      2. WebServer Caches
      3. TCP/IP Level Tuning and Its Impact on Web Tier Performance
    7. Conclusion
  15. Chapter 7: Tuning by Tier: The Foundation Tier
    1. EnterpriseOne JDB Infrastructure
      1. EnterpriseOne Database Middleware Features
      2. User Sign-on
      3. Database Connections
      4. SQL DML Statements
      5. Transactions
      6. JDB Connection Pooling
      7. SQL DDL Statements
      8. Auditing
      9. Incoming Database Connections
      10. Excessive Oracle Database Connections
      11. SQL Packages for iSeries DB2 Databases
    2. EnterpriseOne Kernel Infrastructure
      1. Crashed Processes, or Zombie Kernels
      2. Call Object Kernels or Runbatch with High CPU or Deadlocked Processes
      3. Call Object Kernels or Runbatch Crash Due to Out of Memory
    3. Kernel Processes and Common Tuning Recommendations
      1. JDENET Reserved Kernel
      2. UBE Kernel
      3. Replication Kernel
      4. Security Kernel
      5. Lock Manager Kernel
      6. Call Object Kernel
      7. JDBNet Kernel
      8. Package Install Kernel
      9. Management Kernel
      10. Scheduler Kernel
      11. Package Build Kernel
      12. UBE Subsystem Kernel
      13. Workflow Kernel
      14. Queue Kernel
      15. XML Transaction Kernel
      16. Event Notification Kernel
      17. Interoperability Event Observer Kernel
      18. XML Dispatch Kernel
      19. XTS Kernel
      20. XML Service Kernel
      21. Metadata Kernel
      22. XML Publisher / BI Publisher Kernel
    4. Conclusion
  16. Chapter 8: Tuning by Tier: The Database Tier (Oracle)
    1. Database Tuning Overview
      1. Principle 1: The Principle of Best Benefit
      2. Principle 2: Trust, but Verify Tuning Changes
      3. Principle 3: Review Previous Tuning Changes When a New Change Is Introduced
    2. EnterpriseOne Load Profiles
      1. Interactive Users
      2. Batch Processes
    3. Aspects of Database Performance Tuning
      1. Tuning After the Design
      2. Using Metric Statistics
      3. Performance Tuning Diagnostic Checklist
    4. Tuning the Operating System
    5. Tuning the EnterpriseOne Application
      1. Analysis Tools for the EnterpriseOne Application
      2. Tuning the EnterpriseOne Product Life Cycle
      3. EnterpriseOne SQL Statement Tuning
    6. Tuning the Oracle Database Instance
      1. The Oracle Database Time Model
      2. DB Time and DB Processor Time Ratios
      3. Dynamic Performance Views
      4. Oracle WAIT Events
      5. Oracle Alert Log
      6. User Trace Files
      7. Oracle Database Monitoring and Tuning Tools
    7. Oracle Enterprise Manager (OEM)
    8. Tuning Other Oracle Resources
      1. Oracle Full Table Scans and SQL Joins
      2. Oracle Automated Management Configurations
      3. Shared Pool Performance Issues
      4. Oracle Database Buffer Cache Performance Issues
      5. Program Global Area Memory and Temporary Space
      6. Oracle Database Performance and Disk Architecture
      7. Review the Logs
      8. Sufficient Swap Space
      9. Operating System Patches
      10. Interprocess Communication Kernel Memory Settings
      11. Processor, Memory, and Disk Configuration
    9. Conclusion
  17. Chapter 9: Tuning by Tier: The Database Tier (Microsoft SQL Server and IBM System i)
    1. Tuning Microsoft SQL Server
      1. Reviewing the Logs
      2. Operating System/Database Patches
      3. Microsoft SQL Server Service Account Privileges/Permissions
    2. SQL Server CPU, Memory, Network, and Disk Configuration
      1. CPU or Processors
      2. Memory
      3. Disk Subsystem
      4. Network
    3. SQL Server Configuration Ideas
      1. Database Configuration
      2. Production Parameter Settings
      3. Performance Monitoring and Index Review
      4. Dynamic Management View Reports
      5. Database and Backup Compression
      6. Read Committed Snapshot Isolation (RCSI)
    4. Tuning IBM System i Database
      1. Performance Collection
      2. Database Index Configuration
      3. JDE.INI and QAQQINI Settings
      4. Job Prestart Allocations
      5. TCP/IP Buffer Size
      6. Job Class Time Slices
      7. Batch Subsystem Priorities
      8. Memory Pools
  18. Chapter 10: Tuning by Tier: The Interface Tier
    1. Business Services Server
      1. JVM Arguments and BSSV
      2. Clustering
      3. Load Balancing
    2. Transaction Server (Real-Time Events)
      1. Clustering Transaction Server
      2. Web and Transaction Server Technologies
      3. Monitoring Events Using Administrative Tools
    3. Mobility Applications
      1. New Technologies for Mobile
      2. Mobile Architecture
      3. Security Considerations
      4. ADF Tuning Tips
  19. Chapter 11: Virtualization
    1. Benefits of Virtualization
    2. Oracle VM
      1. Oracle VM Tools
      2. Monitoring the Functions of Oracle VM Manager 2.2.0
    3. JD Edwards VM Templates with Oracle VM
      1. Tips for Using Oracle VM Templates
    4. Oracle VM VirtualBox
    5. VMware for Servers and Workstations
      1. VMware Deployment Specifications
      2. VMware Tools with Veeam Reporting
      3. Veeam Reporting
    6. JD Edwards Tuning for Virtualization
      1. BSSV JDBJ.INI
      2. Web Client JDBJ.INI
      3. Enterprise Server JDE.INI
  20. Chapter 12: Oracle Exadata Database Machine and Exalogic Elastic Cloud
    1. JD Edwards EnterpriseOne and the “Exa” Revolution
    2. Fabric–based Technologies
      1. Fabric–based Technologies: Advantages and Disadvantages
      2. Fabric–based Technology for Exadata and Exalogic
    3. Exadata Database Machine
    4. Exalogic Elastic Cloud
      1. Exalogic Elastic Cloud Application Stack
    5. Implementing Exadata and Exalogic for EnterpriseOne
      1. Implementing EnterpriseOne on Exalogic
      2. Implementing EnterpriseOne on an Exadata Database Machine
    6. Exadata and Exalogic Performance Tuning for EnterpriseOne
      1. Interactive User Processing Profile
      2. Batch Processing Profile
    7. Summary
  21. Chapter 13: Load Balancing/Scalability Opportunities for EnterpriseOne
    1. Hardware- vs. Software-based Network Load Balancers
      1. Hardware-based Network Load Balancing
      2. Software-based Network Load Balancers
    2. Software Solutions
      1. Web/HTTP Virtual Server Names
      2. EnterpriseOne Virtual Server Names
      3. EnterpriseOne JDE Kernel Process Load Balancing
    3. Network Load Balancer Solutions
      1. Network Hardware and Software Load Balancer Considerations
    4. Examples of Load Balancing an EnterpriseOne Configuration
      1. HTML/JAS: Presentation Layer
      2. Application Logic
      3. UBE/Batch
      4. UBE Load Balancing
      5. Business Services
    5. Summary
  22. Index

Product information

  • Title: Advanced Tuning for JD Edwards EnterpriseOne Implementations
  • Author(s): Michael Jacot, Allen Jacot, Frank Jordan, Gurbinder Bali
  • Release date: June 2013
  • Publisher(s): Oracle Press
  • ISBN: 9780071798556