IBM Open Data Analytics for z/OS Version 1 Release 1 User's Guide

IBM Open Data Analytics for z/OS is a data service tool that helps users access and analyze data on z/OS.


IBM Open Data Analytics for z/OS Version 1 Release 1 User's Guide - cover page
Brand
IBM
Category
Other software
Document type
User Manual
Language
English
Pages
77
File format
PDF
File size
596 KB
Published
30 November, 2023
Updated
30 November, 2023
MD5 checksum
A59FC7B39F00FA164327E0BE98509A54

About this manual

This IBM Open Data Analytics for z/OS Version 1 Release 1 User's Guide (SC27-9034-00) presents the information needed to get SQL access to mainframe data using the Data Service Studio, an Eclipse-based user interface that communicates with the Data Service server. It is intended for system and database administrators. The guide explains how to open the Data Service perspective, connect to the Data Service server, and create server metadata such as virtual source libraries, virtual tables and virtual views.

The chapters cover virtual tables for Adabas, Db2 for z/OS, CA IDMS, IMS, IBM MQ, sequential, VSAM/VSAM CICS/IAM, and zFS/HFS data, plus Db2 user-defined table functions, generating and executing SQL queries, generating code from SQL, accessing IT Operational Analytics and DB2 unload data, Server Trace, and the Data Service preferences pages.

What's inside

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

Specifications

Program number5655-OD1
VersionVersion 1 Release 1
Document numberSC27-9034-00
Supported mainframe data sourcesAdabas, Db2 for z/OS, CA IDMS, IMS, IBM MQ, Sequential, VSAM/VSAM CICS/IAM, zFS and HFS
Supported off-host data sourcesOracle, Microsoft SQL Server, and Db2 for LUW
User interfaceEclipse-based
Intended readersSystem and database administrators

Frequently asked questions

Who should read this guide?

It is intended for system and database administrators.

What is the Data Service Studio used for?

It is used to create metadata objects on the host Data Service server, such as virtual source libraries, virtual tables and virtual views.

What does Db2 Direct do?

It is a Data Service server access method that accesses Db2 data by reading the data in the underlying Db2 VSAM linear data sets directly.

What is the order number of this publication?

The document number is SC27-9034-00.

Download PDF (596 KB)

More IBM Manuals


View all IBM manuals →