IBM DB2 QMF Data Service Studio User's Guide

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 Studio User's Guide - cover page
Brand
IBM
Category
Other software
Document type
User Manual
Language
English
Pages
69
File format
PDF
File size
575 KB
Published
30 November, 2023
Updated
30 November, 2023
MD5 checksum
0F080B587A8BB2955EF65E4606B566E8

About this manual

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.

What's inside

  • Data Service Studio overview
  • Data Service perspective
  • Connecting to the Data Service server
  • Creating server metadata
  • Accessing IT Operational Analytics data
  • Accessing DB2 unload data
  • Generating and executing SQL queries
  • Server Trace
  • Data Service preferences

Specifications

Supported mainframe data sourcesAdabas, Db2 for z/OS, CA IDMS, IMS, IBM MQ, Sequential, VSAM, VSAM CICS, IAM, zFS, HFS
Supported off-platform data sourcesOracle, Microsoft SQL Server, Db2 for LUW
Studio interfaceEclipse-based user interface

Frequently asked questions

What is Data Service Studio?

Data Service Studio is an Eclipse-based user interface that communicates with the Data Service server.

What components can be created with Data Service Studio?

Virtual source libraries, virtual tables, and virtual views can be created on the Data Service server.

How are virtual tables created?

Virtual tables are created using the New Virtual Table Wizard.

Download PDF (575 KB)

More IBM Manuals


View all IBM manuals →