Availability Guide for Application Design

Data Protection and Recovery
Availability Guide for Application Design—525637-004
4-25
Solution Using NonStop Operating System in
Support of NetBatch-Plus Software
•
Information cataloging
•
Decision support queries against production data
Read/write tasks include:
•
Inserting a large number of new rows into the database; for example, when loading
or merging data
•
Updating a large number of existing rows in the database
•
Populating new columns in the database
•
Computing derived data; for example, in support of decision support or summary
reporting
•
Deleting rows from the database; for example, when archiving historical data
The NetBatch-Plus product can handle concurrent online access and batch access for
read-only tasks and for read/write tasks. Low-priority transaction processing is most
useful for tasks that require read/write access. Database snapshots work best with
read-only tasks.
The remainder of this subsection describes each of these approaches in terms of when
you would use it, how it works, and what the design considerations are.
Solution Using NonStop Operating System in Support of
NetBatch-Plus Software
The NetBatch-Plus product is an HP software product that automates job scheduling,
startup, and management on HP NonStop systems through a screen-driven interface.
When to Use This Approach
You can perform online operations concurrent with read-only or read/write batch jobs
using the NetBatch-Plus product to manage the batch processing part.
How Does It Work?
The HP NonStop operating system makes it possible to mix transaction processing
with batch processing by providing prioritized input/output operations, automatic load
balancing, true parallel query, and an advanced file-locking and record-locking facility.
As shown in Figure 4-8 on page 4-26, you can run batch applications at a lower priority
than transaction-processing applications to enable batch and decision support to
continue without affecting the performance of online operations. It does not matter that
batch operations are slowed down; online operations are where the performance is
important.
Several vendors offer the ability to control the priority of batch operations with respect
to online operations. However, only HP systems allow you to control the priority in the
I/O subsystem in addition to the priority in the processor.