IBM Db2 Web Query V2.2 High-Availability and Disaster Recovery Guide

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.


IBM Db2 Web Query V2.2 High-Availability and Disaster Recovery Guide - cover page
Brand
IBM
Category
Other software
Document type
Application Note
Language
English
Pages
12
File format
PDF
File size
416 KB
Published
30 November, 2023
Updated
30 November, 2023
MD5 checksum
E71C07CD8C09AD04ADFCF40CCAFF96EA

About this manual

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.

What's inside

  • Preface
  • Background
  • Components of Web Query HA/DR
  • Reporting on Data that Resides in an iASP
  • Moving Web Query Data onto an iASP
  • Setting-up the Primary
  • Setting-up the Backup
  • Switching from Primary to Backup
  • Best Practices
  • References

Specifications

Product versionDb2 Web Query V2.2
Licensed program product number5733-WQX
Product libraryQWEBQRY
Product directory/qibm/ProdData/qwebqry
Sample data librariesQWQCENT and QWQRETAL
Web Query IFS data directory/QIBM/UserData/qwebqry
Db2 repository libraryQWQREPOS
Administrative profileQWQADMIN
Administrator group profileQWQADMGRP
Document date2/26/2019

Frequently asked questions

What is the purpose of this Db2 Web Query guide?

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.

Where is the Web Query licensed program product installed?

The Web Query product 5733-WQX is installed in the system ASP (SYSBASE), because licensed program products cannot be installed into an iASP.

Where are Web Query reports and dashboards stored?

All reports, documents, dashboards, schedules, distribution lists, and runtime environments reside in Db2 in the QWQREPOS library.

What must be done for users accessing data on an iASP?

Their job descriptions must specify the iASP name as the initial ASP group, using the CHGJOBD command.

Download PDF (416 KB)

More IBM Manuals


View all IBM manuals →