The Db2 Web Query High-Availability and Disaster Recovery Guide describes the components and best practices for installing Web Query in an iASP-based cluster environment to ensure high-availability or disaster recovery for your business-critical reports and business intelligence (BI) analytics.
This guide explains the components and best practices for installing IBM Db2 Web Query V2.2 in an iASP-based cluster environment to support high-availability or disaster recovery for business-critical reports and BI analytics. It covers switched disk, geographic mirroring, and logical replication environments.
The document describes the Web Query components that must be considered, including the licensed program product, Web Query data and objects, user licenses, and reported-on data. It also provides setup steps for the primary and backup systems, including moving Web Query data onto an iASP, configuring the Administrative Domain, editing job descriptions, and switching from primary to backup.
| Product version | Db2 Web Query V2.2 |
|---|---|
| Licensed program product number | 5733-WQX |
| Product library | QWEBQRY |
| Product directory | /qibm/ProdData/qwebqry |
| Sample data libraries | QWQCENT and QWQRETAL |
| Web Query IFS data directory | /QIBM/UserData/qwebqry |
| Db2 repository library | QWQREPOS |
| Administrative profile | QWQADMIN |
| Administrator group profile | QWQADMGRP |
| Document date | 2/26/2019 |
It explains the components and best practices for installing Web Query in an iASP-based cluster environment to ensure high-availability or disaster recovery for business-critical reports and BI analytics.
The Web Query product 5733-WQX is installed in the system ASP (SYSBASE), because licensed program products cannot be installed into an iASP.
All reports, documents, dashboards, schedules, distribution lists, and runtime environments reside in Db2 in the QWQREPOS library.
Their job descriptions must specify the iASP name as the initial ASP group, using the CHGJOBD command.