Transcript Slide 1
Archiving and System Optimization
Michelle Ayers
Advisory Solution Consultant [email protected]
June 2010
Vision Solutions Product Portfolio
System i
Enterprise HA & multi-node clustering
System
i SMB DR + CDP
System i
Optimization
System i, ORACLE, DB2, SQL Server, Sybase, Teradata
CDC
System p AIX
SMB DR +CDP
System i
SMB HA
System i
Database archiving
MS Windows
Availability, Backup, Flex, Move & Cloud
Why Archive?
Business Benefits
● Reduce disk storage utilization ● Improve ERP application performance ● Defer disk/hardware upgrade ● Accelerate nightly backups ● Optimize environment for HA ● Meet Legal Requirements Disk Utilization 100% 90% 75% Critical threshold Start planning for disk upgrade 50% Increasing risks and Increasing monitoring costs Risks & Costs
What to do with Archived Data?
Near-Line and Off-Line Strategies
On-Line – Data that is stored in the production database and is used for on-line transaction processing Off-Line – Data that has been archived to tape and Is not available to users unless it is restored Near-Line – Data that has been archived from the Production database and now resides on a different Place on disk. It is accessible to users (typically on a read-only basis) On-Line Near-Line Off-Line
Choosing Archiving Solution
Considerations
While Active – 24 x 7 users availability and minimize disruption to housekeeping tasks Preserve Database Integrity – avoid creating orphaned data such as Detail Lines without a Header Skills Required – DBA/Business Analyst and/or Programming Reorganizing Physical Files – recover deleted record space Auditing – who ran which task when over which data and when Recovery – if we accidentally archive too much data how do we put it back?
Planning an Archiving Project
Required Steps
• Identify Business Areas • Determine Retention Policies • Perform Database Analysis • Engage Business Users/Data Owners • Develop Test Plans • Metrics Planning Exercise Project Plan
v7.2
Advanced Database Archiving Framework
Business Benefits Technical Benefits
● Reduce disk storage utilization ● Improve ERP application performance ● ● ● ● ● ● ● ● ● ● Accelerate nightly backups Optimize environment for HA Archive without downtime Archive without programming Accelerate archiving projects Reduce costs of archiving projects Suitable for all ERPs *(1) on System i Maintain security Maintain Auditability Near-line and Off-line strategies ● ● ● ● ● ● ● ● ● ● ● DBA defined archiving models (schemas) User exit points for user defined logic Variables & Parameters Compiled archiving requests for improve performance Change management capabilities Business transaction level integrity preserved While-active archive & restore requests Start & stop archive processing to avoid peak times Import & export archiving models *(2) Add
DIRECTOR
*(3) to help analyze and optimize database Add
REPLICATE 1
*(4) to replicate data to other platforms
v7.2
Advanced database archiving without downtime without programming
*(1) Suitable for ERPs running DB2/400 *(2) Vision have pre-defined archiving models for Lawson MOVEX ERP *(3) DIRECTOR is a separate Vision product *(4) REPLICATE 1 is a separate Vision product
Database Archiving Has Never Been so Easy, Affordable or Flexible
Data Manager Pre-Built Models for M3 Pre-built Archive Models – Data manager Projects which utilize pre-built archive models take significantly less time because many of the business rules are already in the model and only customization and testing is required
Standard Models
● Customer Orders and Invoices ● Deliveries ● Service Orders ● Many more ● ● ● Purchase Orders Manufacturing Orders Works Orders ● ● ● CINACC OSASTD OSBSTD
Special Functions
● FAM – Financial Ledgers ● MITTRA – Stock Transactions
Company Copy with Data Manager
Test Database – as a consequence of archiving logic, make copy of data AFTER cut-off date to create a subset test database, plus Change Company Number functionality.
Advantages:
● Save disk space ● Exclude/include specific Divisions Archiving should be a normal business process, not a feared project
Optimisation
Work with System Status WRKSYSTS – System i command, can be run from green-on-black command line (Intermediate Assistance Level) (See also DSPSYSSTS) Work with System Status VSI72 06/11/10 18:55:37 % CPU used . . . . . . . : 27.7 Auxiliary storage: % DB capability . . . . : 18.8
System ASP . . . . . . : 1371 G
Elapsed time . . . . . . : 00:00:01
% system ASP used . . : 85.2968
Jobs in system . . . . . : 3061
Total . . . . . . . . : 1371 G % perm addresses . . . . : .071 Current unprotect used : 48120 M % temp addresses . . . . : 2.279 Maximum unprotect . . : 78546 M Type changes (if allowed), press Enter. System Pool Reserved Max -----DB---- ---Non-DB-- Pool Size (M) Size (M) Active Fault Pages Fault Pages 1 2818.68 1113.10 +++++ .0 .0 .0 .0 2 6736.39 1.35 2117 33.0 5567 .0 4.4 3 1966.71 .00 212 .0 .0 7.1 9.8 4 6.34 .00 5 .0 .0 .0 .0 5 51355.92 9.17 1905 11.6 512.5 24.1 42.9 More... Command ===> F3=Exit F4=Prompt F5=Refresh F9=Retrieve F10=Restart F12=Cancel F19=Extended system status F24=More keys
Vision Director V8.0
Proactively, Monitor, Manage & Optimize Your IBM i
Analyze Information Report & Recommend Gather Information Stay in Control!
Take Action
Save Operator and Management Time
• • • • • • • • • •
Data collection and object monitoring are fully automatic Managers save time on scheduling and corrective action Factory defaults based on years of experience Runs in the background 24x7x365 Built-in exception rules Executes tasks that many operators don’t have access to Executes tasks that many operators don’t have time for Does not lock objects Consume very limited resources Easily tuned parameters provide flexibility
“Director contains every task a systems manager is required to execute or comment on”
News/400
Why Vision Director?
Advanced Systems Management for System i
Benefits Features
• Automated, Proactive Systems Management • Reclaim and Proactively Manage DASD • Improve Application & System Performance • Reduce Planned Downtime • Improve Hardware and Application Upgrades • Improve HA and DR • Helps Meet SLA’s • • • • • • • • • Event Driven File and Object Optimization Access Path & Program Optimization Dynamic Object Cross-Referencing Pre-Built System Health Report Multi-dimensional domain analysis Change Analysis Job Tracking Object & Spool Archiving