Initial Setup Time and Ongoing Administration
NGS-IQ works directly with your Db2 database. It offers a meta data alias feature for those who want to simplify end user understanding and navigation of their database, but aliases are not required. Db2 Web Query requires you to set up and maintain a meta data repository of your Db2 files. Some meta data functions require the separately priced Developer Workbench. All of the optional meta data alias features of NGS-IQ are included in the IQ Server module licensed to all customers.
Db2 files added to Db2 Web Query’s meta data repository aren’t organized by library which can make finding them difficult. You cannot query files stored in your QTEMP library because Db2 Web Query doesn’t allow these files to be defined in its meta data repository. This restriction effectively eliminates the convenience of using QTEMP to store query output that is needed to process a second query.
Db2 Web Query’s meta data repository can be used to identify any Query/400 objects that you wish to run from within Db2 Web Query, but Db2 Web Query requires you to re-enter these query objects in the meta data repository if they have been changed since the last time they were run from Db2 Web Query. This can be frustrating in an environment where Db2 Web Query is being used by some people while others continue using Query/400 to maintain queries.
Legal Notice: NGS believes all of the above information is accurate at the time of publication. However, IBM software products and marketing policies are subject to change at any time, without notice. Speak to your IBM or IBM Business Partner representative for current product, pricing, and support information. We welcome your comments.