In order to save queries and results, you must first create the Web Query Catalog Objects. The Web Query Catalog Objects consist of three tables: WQ.INDEX_TABLE, WQ.STORE_TABLE, and WQ.SMTP.
To create the Web Query Catalog Objects:
1. In the DB2 Web Query navigation tree, click on any connection.
The Connections dropdown menu appears.
2. Click Setup.
The Setup Authenticate page appears.
3. Enter the Web Query user ID and password you want to use to access the Setup Utility. Click Next.
The DB2 Web Query Setup page appears.
4. Click Catalog Objects.
The Catalog Object SQL window appears, with the necessary DDL (data definition language) to create the tables listed.
5. If desired, modify the SQL to change where or how the Web Query Catalog Objects are stored.
Note: Do not change the structure or names of the Web Query Catalog Objects.
6. Click Create.
DB2 Web Query creates the Web Query Catalog Objects.
Tip: You can also issue the DDL to create the Web Query Catalog Objects from another tool, such as SPUFI, by copying and pasting the SQL that appears in the setup window.