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 HA
System i
SMB DR +
CDP
System i
Database
archiving
System i
Optimization
System i, ORACLE,
DB2, SQL Server,
Sybase, Teradata
CDC
MS Windows
Availability, Backup,
Flex, Move & Cloud
System p AIX
SMB DR +CDP
Why Archive?
Business Benefits
Disk Utilization
100%
● Reduce disk storage utilization
90%
Critical threshold
● Improve ERP application performance
75%
Start planning
for disk upgrade
● Defer disk/hardware upgrade
50%
● Accelerate nightly backups
● Optimize environment for HA
Increasing risks and
Increasing monitoring costs
● Meet Legal Requirements
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
On-Line
Production database and now resides on a different
Place on disk. It is accessible to users (typically on
a read-only basis)
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
Planning
Exercise
• Determine Retention Policies
• Perform Database Analysis
• Engage Business Users/Data Owners
• Develop Test Plans
• Metrics
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
v7.2
Advanced database archiving
without downtime
without programming
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
*(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
● Purchase Orders
● CINACC
● Deliveries
● Manufacturing Orders
● OSASTD
● Service Orders
● Works Orders
● OSBSTD
● Many more
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
06/11/10
% CPU used . . .
% DB capability
Elapsed time . .
Jobs in system .
% perm addresses
% temp addresses
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
:
:
:
:
:
:
27.7
18.8
00:00:01
3061
.071
2.279
Auxiliary storage:
System ASP . . . . . .
% system ASP used . .
Total . . . . . . . .
Current unprotect used
Maximum unprotect . .
Type changes (if allowed), press Enter.
System
Pool
1
2
3
4
5
Pool
Size (M)
2818.68
6736.39
1966.71
6.34
51355.92
Reserved
Size (M)
1113.10
1.35
.00
.00
9.17
Max
Active
+++++
2117
212
5
1905
-----DB----Fault Pages
.0
.0
33.0
5567
.0
.0
.0
.0
11.6 512.5
---Non-DB--Fault Pages
.0
.0
.0
4.4
7.1
9.8
.0
.0
24.1
42.9
More...
Command
===>
F3=Exit
F4=Prompt
F5=Refresh
F19=Extended system status
F9=Retrieve
F10=Restart
F24=More keys
F12=Cancel
:
:
:
:
:
VSI72
18:55:37
1371 G
85.2968
1371 G
48120 M
78546 M
Vision Director V8.0
Proactively, Monitor, Manage & Optimize Your IBM i
Analyze
Information
Report &
Recommend
Take
Action
Gather
Information
Stay
in Control!
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
Vision Solutions and Lawson Customers
Thank You!