Date Posted: October 9, 2008
Update: October 24, 2008 New version adds port number entry on harvesting screen and replaces TRIM() function (DB2 9 only) with its equivalent LTRIM(RTRIM()) (supported on DB2 8 and 9).
Tab navigation
1. Why do you need to connect to a database to harvest queries?
QueryScope does not merely harvest queries. It also collects table and index information from the database; this information shows up as critical visual cues on the diagram. QueryScope looks into SYSIBM tables for this information.
2. Does QueryScope work only on IBM® DB2®?
In order to render queries visually, a necessary step is query statement parsing, which we have tested only on valid DB2 queries. The current parser should be able to recognize standard SQL syntax, which is commonly applied across major database vendors. If you encountere queries that our SQL parser does not handle, please contact us through the feedback forum. In addition, QueryScope accesses the catalog tables for table and index information, which is stored in vendor-defined schema. In the case of IBM DB2, QueryScope harvests the information from SYSIBM tables.
3. Do you plan to release future versions that support other databases?
Please let us know how useful this tool is in your job and what database products you are using. We will take this into consideration when planning our next release.
