You can run a Compare session between similar Web Query objects such as tables, queries, views, and results. You can include sections in your Compare report on Permissions, Structure, Data, and Index. You can view the generated Compare report in either text or html format.
To run a Compare report:
1. In the DB2 Web Query navigation tree, click on one of the objects you wish to compare.
The associated drop-down menu appears.
2. Click Compare.
The Compare Session page appears. The object you selected appears in the Sources list.
3. In the DB2 Web Query navigation tree, click on the object you wish to compare the first one to, and select Compare from the drop-down menu.
The second object appears in the Sources list.
4. Select the object pair you wish to compare by holding down the Control key and clicking on the desired objects in the Sources list. Then click the right arrow between the Sources and Sessions lists.
The object pair appears in the Session list as a new Compare session.
Tip: If the Remove Paired box is checked, object that you have paired to create a session are removed from the Sources list. If you uncheck the Remove Paired box, objects that you have paired to create a session are left in the Sources list.
5. In the Session list, select the desired session and click Properties.
The Compare Session Properties page appears.
6. Specify the session properties and click Save.
DB2 Web Query saves the session properties.
Tip: To remember these properties as the default for all other sessions, click Save as Default.
7. Click Options.
The Compare Session Options page appears.
8. Specify the session options and click Save.
DB2 Web Query saves the session options.
Tip: To remember these options as the default for all other sessions, click Save as Default.
9. Click Report.
DB2 Web Query runs the Compare report. The Comparison Report page appears.
10. Select the session you wish to view. Select an Output Format and choose which sections to include in the report. If desired, enter an email address to forward the report to. Then click Next.
DB2 Web Query displays the Compare report in your browser.