||Oracle Tips by Burleson
Oracle10g Grid Computing
Chapter 3 - High
Performance and Highly Available
UDB EEE Architecture
UDB (EEE) uses the concept of function
shipping. Function shipping helps in the reduction of network
traffic because functions, such as SQL queries, are shipped instead
of data. Function shipping means that relational operators are
executed on the node (or processor) containing the data whenever
possible. So, the operation (or the SQL) is moved to where the data
resides. Function shipping is well suited to the shared nothing
In case of the failure of one node, a
pre-configured node takes over the disk system and makes the data
available through that node. A Cluster script starts DB2 UDB EEE
database partitions on the take-over node. Once this script
completes, all the database partitions in the DB2 UDB EEE database
are available and processing goes on as usual.
As an example, When RS/6000 SP cluster is
implemented with HACMP to support the UDB EEE, nodes are usually
configured in three ways:
Idle Standby - A standby SP node can
be provided which will take over the work of a failed SP node.
The standby SP node has access to all resources required for the
provision of the essential services: disks, networks and so on.
When the failed SP node is fixed and reintegrated into the
cluster, it will reclaim its resources.
Rotating Standby - A standby SP node
is provided to take over the work of a failed SP node, as in the
idle standby scenario. However, when the failed SP node is
reintroduced, it does not reclaim its resources, but becomes the
new standby machine.
Mutual Takeover - There are no
standby SP nodes; all SP nodes are utilized in a normal state.
After an SP node failure, the failed SP nodes resources and
essential services are taken over by one of the surviving SP
nodes in addition to its normal services.
For more information, see the book
Grid and Real Application Clusters 30% off if you
buy it directly from Rampant TechPress .
Written by top Oracle
experts, this RAC book has a complete online code depot with
ready to use RAC scripts.
Oracle Consulting Services
Burleson Oracle Consulting offers Senior Oracle consultants which are available
for all areas of Oracle support. Common Oracle consulting support
activities include short-term Oracle tuning, Oracle database troubleshooting,
Oracle9i and Oracle10g migration,
Oracle9iAS App Server
consulting, Oracle design reviews and
Oracle requirements evaluation support. Oracle support and Oracle consulting
services are priced by the hour, so you only pay for what you need. These
one-time Oracle consulting services commonly include:
Answering questions from your Oracle DBA technical staff
Repairing down production Oracle database systems
One-time Oracle tuning evaluation
Guru support for your Oracle DBA
Installation of Oracle application packages
For more information, please visit