GRIDSCALE for IBM DB2
GRIDSCALE for DB2 has been specifically built to integrate with DB2 APIs and interfaces. GRIDSCALE for DB2 has also been tested by IBM at its lab in Markham, Canada for compatibility. Specific features for DB2 include the following:
DB2 CLI Clients
GRIDSCALE for DB2 provides a Call Level Interface (CLI) for DB2. This allows native DB2 applications to connect directly to GRIDSCALE transparently.
SQL Parser for DB2
GRIDSCALE for DB2 is 100% compatible with the SQL dialect used by DB2. This allows existing DB2 applications to use GRIDCALE for DB2 without any code changes.
xdb2
xdb2 is a cluster-friendly equivalent command line processor (CLP) to IBM's DB2 CLP. xdb2 allows customers to issue SQL and DB2 maintenance commands (e.g. load, runstats, etc.) through GRIDSCALE so that the command is applied to all the database servers. This allows the GRIDSCALE cluster to be managed like a single instance of DB2 reducing management costs.
DB2 Data Warehouses
GRIDSCALE for DB2 provides availability for business-critical data warehouses for round-the-clock operation. You can use GRIDSCALE for DB2 to provide disaster protection for warehouses in different geographic data centers.
In addition, GRIDSCALE enables you to perform maintenance on warehouses without outages. For example, if you plan on repartitioning a database across multiple database servers, GRIDSCALE for DB2 allows you to accomplish this without an outage.
Solution Comparison
This table shows how GRIDSCALE compares to other clustering and high availability (HA) solutions:
| Solution | WebSphere Information Integrator (QRep) | HACMP | HADR | GRIDSCALE |
|---|---|---|---|---|
| Hardware Utilization | All Active - Requires manual load balancing | Active-Passive | Active-Passive | All Active |
| Horizontal Scalability | Yes - Requires manual load balancing | No | No | Yes |
| Automatic Failover | No | Yes | No - Requires other cluster solution such as Tivoli Systems Automation | Yes |
| Protection Level | Table | Database | Database | Database |
| Points of Failure | None | None | Disk | None |
| Consistent Data View | No | Yes | Yes | Yes |
| Easy to Use/Maintain | No | No | Yes | Yes |
