The IBM® DB2 QMF® Data Service Studio User's Guide describes how to use Data Service Studio to create and manage data services.
IBM DB2 QMF Data Service provides integration facilities for mainframe data sources and other off-platform data sources. Data Service Studio is an Eclipse-based user interface that communicates with the Data Service server to create virtual source libraries, virtual tables, and virtual views.
The guide covers connecting to the Data Service server, creating server metadata for sources such as Adabas, Db2, CA IDMS, IMS, IBM MQ, sequential, VSAM, zFS, and HFS data, accessing IT Operational Analytics and DB2 unload data, generating and executing SQL queries, Server Trace, and Data Service preferences.
| Supported mainframe data sources | Adabas, Db2 for z/OS, CA IDMS, IMS, IBM MQ, Sequential, VSAM, VSAM CICS, IAM, zFS, HFS |
|---|---|
| Supported off-platform data sources | Oracle, Microsoft SQL Server, Db2 for LUW |
| Studio interface | Eclipse-based user interface |
Data Service Studio is an Eclipse-based user interface that communicates with the Data Service server.
Virtual source libraries, virtual tables, and virtual views can be created on the Data Service server.
Virtual tables are created using the New Virtual Table Wizard.