1 / 23

Introduction

Introduction. Journal Analysis and Optimization. Journaling Uses and Benefits Understanding Costs and Implications Ongoing Management and Administration. Journaling Uses and Benefits. High Availability Data Warehousing Commitment Control Security and Data Auditing

sissy
Download Presentation

Introduction

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Introduction Journal Analysis and Optimization • Journaling Uses and Benefits • Understanding Costs and Implications • Ongoing Management and Administration

  2. Journaling Uses and Benefits • High Availability • Data Warehousing • Commitment Control • Security and Data Auditing • Application Debugging • Troubleshooting

  3. High Availability • Data Replication Requirements • Additional System(s) Impact • “Real-Time” Replication • Remote Journaling • Increased Network Traffic • Quality Assurance & Testing

  4. Data Warehousing • “Offloading” Workload • Data Transformation • Moving versus Solving Issues • End-User Queries • SQL Performance Analysis • Duplicate Data – Integrity!

  5. Commitment Control • Appropriate Journaling Needs • COMMIT and ROLLBACK • Performance Implications • Added Controls & Integrity • Costs versus Benefits • Impact on Data Replication

  6. Security and Data Auditing • Native File System • Integrated File System • Impact of Temporary Objects • Application - Opens/Closes • Security Audit Journal (QAUDJRN) • Impact on Object Replication

  7. Application Debugging • Data Integrity Issues • Application Performance • Adds, Updates, Deletes • Opens, Closes • Temporary Objects • “Real-Time” Information

  8. Troubleshooting • Application Issues • Systems Management • Performance Analysis • Security Concerns • Disaster Recovery • System Availability Issues

  9. Understanding Costs and Implications • Performance Implications • Hardware Upgrade Costs • Data Integrity • System Availability • Security Risks • Real-Time Visibility

  10. Performance Implications • Nightly Processing Window • Month-End Closing Cycle • Interactive Response Time • End-User Query Needs • “Real-Time” Data Replication • DASD, CPU, I/O, Memory…

  11. Hardware Upgrade Costs • Appropriate Upgrades • Optimization Costs/Benefits • Hardware Costs/Benefits • I/O Bound Systems • Better Systems Management • Simple Application Changes

  12. Data Integrity • Business Impact Analysis • Difficult to Identify/Solve • End-User Confidence • Performance Implications • End-User Queries • Analysts Time and Effort

  13. System Availability • Day-to-Day System Uptime • Recovery Time After Failure • Weekly Processing Window • Month-End Downtime • 24x7 System Availability • Proven, True, Hot Backup!

  14. Security Risks • Basic System Auditing • Data Access and Auditing • Public versus Private Network • Reasonable Security Levels • Proactive versus Reactive • Auditing – Part of Solution

  15. Real-Time Visibility • A “Real-Time” World • Competitive Advantage • Data Synchronization Wows • Responsive to Customers • Functionality and Accuracy • Truly Integrated Systems

  16. Ongoing Management and Administration • DASD Requirements • System Backups & Recovery • Appropriate Journaling • Journal Receiver Retention • Error Detection & Recovery • Performance Analysis

  17. DASD Requirements • Disk Storage Impact • Disk Arm Activity • I/O Bound Systems • Multiple ASPs • Memory Utilization/Faulting • CPU Under-Utilized

  18. System Backups & Recovery • Resulting Downtime • Reasonable Protections • Performance Analyze Backups • Backup to Disk, Disk to Tape • Multi-threaded Backups • Proven Recovery Procedures

  19. Appropriate Journaling • 50 to 80 Percent Waste! • Temporary Objects (Native/IFS) • Application Changes • Whole System versus Selective • Entire Data Libraries • Work Files and User Spaces

  20. Journal Receiver Retention • Reasonable Choices • Analyze Before Deleting • Prevent Transactions • Simple Application Changes • Systems Management Options • Learn from History!

  21. Error Detection & Recovery • Journaling Omissions • Tested Backup/Recovery • Application/Data Integrity • Security Breaches • System Failures • Proven Recovery Process

  22. Performance Analysis • Journal Transaction Analysis • Application Optimization • Query & SQL Tuning • Disk Space Management • Disk Activity Monitoring • Performance Improvement!

  23. Questions & Answers Journal Analysis and Optimization • To receive FREE performance evaluation: • Register at http://www.mb-software.com • Download and install software on AS/400 or iSeries • Call (800) 713-5034 to schedule your free performance review session What To Expect: After performance data is gathered for two business days, you will log into a secure area of MB Software’s web site. We will then have a conference call to discuss our findings and how you can gain performance improvements with your existing applications. It’s that easy!

More Related