ims explorer deep dive - ims ug july 2012 san ramon

IBM Software Group | IMS

IMS Enterprise Suite ExplorerIMS Enterprise Suite Explorer

Kevin A Washington JrNathan Church

© 2011 IBM Corporation


IMS Application Development (AD) ChallengesIMS Application Development (AD) Challenges

Shrinking knowledge base around IMS &

hierarchical data base model

Difficult to find DLI programmersp g

Fewer experienced COBOL and PL/I programmers

Lack of integrated development solutions and tools

Fewer experienced COBOL and PL/I programmers

Lack of integrated development solutions and tools

IBM Confidential © 2011 IBM Corporation2

Difficult to test and deploy applications


IMS Simplification StrategyIMS interfaces

IMSNEW IMS interfaces

IMS Simplification Strategy

JCLSDSFJESISPF

IMS TM/DB

JDBC

SQL

Installation and

Operations

ISPF User ExitsDBDGENPSBGENACBGEN

Web Services

Java EEApplication Developmen

t

OLCDRDDLI

DatabaseC/C++

.NET

GUIReporting

and AnalysisGUI


Reduce the need for special, in-depth IMS skills


IMS Simplification Strategy

IMS Explorer for Administration(Web Browser)

IMS Explorer(Eclipse)

p gyRequirement:

( )

Developer Administrator

ISPF



Eclipse Integrated Development EnvironmentEclipse Integrated Development Environment

–Is a fully Integrated Development Environment supporting– Java, C/C++/C#, PERL, PHP, HTML, JSP™, EJB™ …

–Integration platform for tools and open platform for application development toolspp p

–Easily add new tools to existing installed products – Common shell sharing

®–All IBM Rational® products are Eclipse based

PluginA

Plugin B

Plugin C PluginA B C Plugin

D



Introduction the IMS Enterprise Suite Explorer

Easier visualization and editing of IMS Databases and Program Definitions

P id hi l dit t– Provide graphical editors to: – Display IMS database hierarchical structures– Display/Create/Edit PSBs

Add/Edit fields in DBDs– Add/Edit fields in DBDs – Import COBOL Copybooks and PL/I Structures into database segments– Generates DBD and PSB source

Ability to easily access IMS data using SQL statements– Leveraging IMS v11 Universal JDBC driver

Connectivity to the z/OS system– Browse a dataset and submit JCL – Import DBD and PSB source files from a dataset to IMS Explorer and


– Import DBD and PSB source files from a dataset to IMS Explorer and export generated source back to the host.


Displaying an IMS Database Structure via Green ScreenDisplaying an IMS Database Structure via Green Screen

Logical Relationship in a DBD Source



Displaying a physical IMS Database Structure with IMS Explorer



Displaying a logical IMS Database Structure with IMS Explorer

A concatenated segment andsegment and its underlying

source segments



PSB and PCB Definitions via Green Screen



Building a PCB definition with IMS Explorer

AutomaticAutomaticGeneration

Point and click to select

Sensegs



Querying an IMS Database with DFSDDLT0Querying an IMS Database with DFSDDLT0



Querying an IMS Database with IMS Explorer with Universal JDBC driver

1 – Start by establishing a connection to an IMS system ….

Create a

IP and Port f IMS

new connection…

for IMS Connect

Point to an IMS Explorer project with the PSB that


project with the PSB that will be used to connect

to an IMS database


Querying an IMS Database with IMS Explorer with Universal JDBC driver

2 – Connect … and start querying, updating, deleting IMS data

Here you can create SQL scripts with

S l t SQL Builder with content assistance to build a SQL statement

Select, Update,

Delete, Insert statements

View w/

statement

Connection

PSB = SchemaDB PCB = Database View w/

the SQL results

DB PCB = Database

Database Segments



Browsing Data Sets and Submitting JCL’s



Browsing Data Sets and Submitting JCL’s with the IMS Explorer

Edit a data a

Browse data sets

Edit a data a set member

JES output is displayed

here



IMS E lIMS ExplorerIntegration Strategy

Out of the box shell-sharing with:•Rational Development for Systems z Integration Road Map:Rational Development for Systems z

•Problem Determination Tools• Debug Tool, File Manager, etc.

D t St di

Next Steps: Deeper integration (RDz, IMS Tools, Debug Tools, CICS Explorer..)

• Data Studio



Overview of IMS CataloggThe IMS catalog will contain information about IMS program resources, database resources, and relevant application metadata that IMS controls:

– All program- and database-related information defined to the IMS database systemAll program and database related information defined to the IMS database system including databases, fields, segments, data types, and more

– Changes made to any of these resources when you create, alter, or delete any IMS resource information will be reflected in the catalog

Currently, the only way to update the IMS catalog is through integrated IMS processes:

– PSBGEN

– DBDGEN

– ACBGENThe IMS catalog is a key component of the IMS growth strategy:

– Simplification

– Integration

– Dynamic database


– Versioning


Metadata principlesMetadata principlesSimply defined, metadata is data about data.

– IMS example: metadata about an IMS database segment might include information b t d t t li ti d fi d fi ld d fi d tabout data types, application-defined fields, user-defined types

Metadata is not a means to an end– Users use tools; tools manage and interact with metadata

Metadata shouldMetadata should– Enhance understanding

– Improve consistency

– Improve impact analysis

– Improve productivity

– Improve governanceMetadata needs to be linked

– For impact analysis

– For understanding data lineage


Metadata needs to include physical implementation, logical design intent and business semantics


IMS Explorer enhancements to support CatalogIMS Explorer enhancements to support Catalog

Complex field metadata authoringComplex field metadata authoringField mappingExtended DBDGEN source syntax supportExtended DBDGEN source syntax supportImport IMS resources from catalogData Source Explorer JDBC connection exploiting metadata gfrom the Catalog



MapspMapping support

– A Map is metadata that describes how a field (or set of fields) are mapped for a particular segment instance

– Metadata captures the various cases and for each case defines the set of fields to be used for that case

– Maps can be defined to the catalogMaps are intended to be interpreted at runtime by the Universal drivers and the proper– Maps are intended to be interpreted at runtime by the Universal drivers and the proper data elements are returned based on the runtime case of the segment instance

– Example: Insurance segment mapped multiple ways depending on value of Policy Type control field

Policy Type

Property Type

Rooms Value Address Make Model Year Value Color

M - - - - Ford Escort 1989 2K RedM Ford Escort 1989 2K Red

H Single Family 5 500K

555 Disk Drive Way,

95141- - - - -



Want to Learn More About IMS Explorer?p

Sign up for the IMS Explorer Technical Preview

www ibm com/imswww.ibm.com/imsClick on IMS Enterprise Suite



IMS Explorer for Development Future Enhancements forIMS Explorer for Development – Future Enhancements for Application Development.

IMS Catalog na igationIMS Catalog navigation– Extensions to the Data Source Explorer to navigate PSBs and DBDs.

Unit test support for IMS dependent region applicationspp p g pp– GUI based creation and management of transaction input message

payload.

GUI based input message editing and transaction invocation which– GUI based input message editing and transaction invocation, which triggers GUI based remote debugging.

IMS application callout support– GUI based management of external web service metadata.

– IMS application code generation for performing callout to these web services.



IMS F t i t ti ith D t St diIMS Future integration with Data Studio

Prevent SQL Builder/SQL Editor from generating SQL that IMS does not support.Provide pureQuery compile time support for IMSProvide pureQuery compile time support for IMS.Decorate the Data Source Explorer view with hierarchical information about IMS database segmentshierarchical information about IMS database segments.Provide launch points from Data Studio views to various IMS Explorer views and editors.p


ims explorer deep dive - ims ug july 2012 san ramon

Technology

ibm corporation

ibm software group ims

ims explorer ims explorer

ims databases

ims system

ims controls

ims datahere

here16 ibm confidential