ibm management console for ims and db2 z/os - minneapolis rug mar 11 2015

The future runs on System z

© 2013 IBM Corporation

IBM Management Console for IMS and DB2

Demetrios DimatosIMS Explorer for Admin [email protected]

© 2013 IBM Corporation2 IBM Confidential

IBM’s statements regarding its plans, directions, and intent are subject to change or withdrawal without notice at IBM’s sole discretion.

Information regarding potential future products is intended to outline our general product direction and it should not be relied on in making a purchasing decision.

The information mentioned regarding potential future products is not a commitment, promise, or legal obligation to deliver any material, code or functionality. Information about potential future products may not be incorporated into any contract. The development, release, and timing of any future features or functionality described for our products remains at our sole discretion.

Performance is based on measurements and projections using standard IBM benchmarks in a controlled environment. The actual throughput or performance that any user will experience will vary depending upon many factors, including considerations such as the amount of multiprogramming in the user’s job stream, the I/O configuration, the storage configuration, and the workload processed. Therefore, no assurance can be given that an individual user will achieve results similar to those stated here.


Management Console

• Provides a single, holistic easy-to-use web-based interface

• Consolidates information from various tools giving a more complete picture of IMS systems and databases

• Leverages the latest web technologies for a richer user experience

• Access from anywhere via the Internet using standard web browsers, with positioning to extend to mobile

• Integrates a context sensitive help system as a learning aid for new IMS DBAs and System Programmers

• Dramatically changes the appearance and impression of our mainframe tools

• Continue to extend integration to all our Tools…including Vendor Tools and DB2

Database Healthand Autonomics

Graphical Visualizationof data not possible in ISPF

IBM OneUI Theme

Integrated Help

4 © 2013 IBM Corporation4 IBM Confidential

Prerequisites

Software requirements– IBM Management Console for IMS and DB2 for z/OS v 1.1 (5655-TAC)– IMS Version 12 or 13

– IMS Connect– IMS SCI– IMS OM

– Web browser– Firefox ESR 17 and 24

– z/OS (1.11, 1.12, 1.13, 2.1)– IBM Installation Manager for z/OS V01a.06.02 or higher

– included in Tools Base or downloaded as archive– Windows 7 (32-bit) or Windows 7 (64-bit)

– IBM Installation Manager V01a.06.02 or higher– downloadable as a self installable executable


IMS

• Enterprise System View

• IMS Resource and IMSPlex discovery

• Hierarchical representation starting from the SYSPLEX to the IMS Resources

• Enterprise Search

• Search across the entire enterprise on any type of resource

• Visual Status

• Quickly see the status of any IMS Resource with colored status icons

• Hover and click status icons for reason codes and corrective actions

• Filter IMS Resources

• Manage IMS Resources

• Start and stop IMS Resources

• Multi select IMS Resources to manage and update

• Resource Relationships

• View relationships between IMS Resources

• At a glance understand why a transaction is having a problem

• Customize

• Change the column attribute defaults


IMS - Discovery

• Minimal configuration

• Define a Sysplex• Define the discovery endpoint

• IMS Connect connections

• Discovery of IMS Resources:

• IMSPlexes• IMSPlex Members

• IMS Connect Instances

• IMS Instances• Transactions• Databases• Programs• Routing Codes

© 2013 IBM Corporation7

IMS Resource and IMSPlex Discovery

Define Environment

Discovering.... IMS

Configure IMS Connect

Discovered PLEX1 & PLEX2


IMS Resource and IMSPlex Discovery

Discovering.... IMS


Enterprise View

• Hierarchical view of IMS Resources

• Logically grouped and auto discovered

• Quickly navigate from one resource to another

SYSPLEX1 LPAR 1

LPAR 3

IMS 1

ICON

LPAR 2

ICON

IMSPLEX (PLEX1)

IMSPLEX (PLEX2)

OM

OM

SPOC

SCI

ODBM

TRANDBPGM RTC

SYSPLEX2 SYSPLEX3

TRANDBPGM RTCTRANDBPGM RTC

ICON

System Diagram

IMS 2 IMS 3


Search the Enterprise

• Search discovered resources by name

• Transactions, Programs, Routing Codes, Databases

• Context-sensitive search• Search by character

• Visually display resource location

• Sysplex > IMSPlex > IMS

100101


Manage IMS Visually

• View the enterprise hierarchy• Sysplex > IMSPlex > IMSPlex Members

• Start and stop IMS Resources• Transactions, Programs, Routing Codes, Databases

• Multi select resources to command

• At-a-glance view IMS resource status icons• Hover icons for reason codes and corrective actions

• Filter displayed results by attributes, name, status


Manage IMS

Enterpise Search

Customize and Manage Resources

Visual Status

Select Resources

Enterpise View


Manage – Start and Stop Resources


Manage - Statuses

• Hover Help– Helpful to new users

• Hover Status Codes– Quickly understand a status

• Context Sensitive Help– Help specific to statuses

Context Sensitive Help

Hover Status Codes

Hover Help


IMS Resource Relationships

• Resource Relationships• At a glance see how

resources are related

• Relationships between resources in one view

• Quickly diagnose problems between resources

TransDatabase Routing Codes

IMSIMS

IMS

IMSIMS

IMS

Programs


Resource Relationship - Transaction


New Features Coming 4Q 2014


Resource Relationship – IMS Connect

QUERY IMSCON TYPE(IMSPLEX). QUERY IMSCON

TYPE(ODBM)QUERY IMSCON

TYPE(RMTIMSCON)

QUERY IMSCON TYPE(DATASTORE)

Start/Stop Communication

QUERY IMSCON TYPE(PORT)


Resource Relationship – IMS

/RMLIST DBRC ='RECON'

/DIS STRUCTURE

/DIS OTMA

QUERY ODBM TYPE(DATASTORE) NAME(IMS1) SHOW(ALL) /DIS A REG


Messages and Commands Displayed

OM Messages Displayed

Command Displayed


OM Message Details

IMS Command Processed

Return and Reason Code

IMS Information Center Link


IMS Command Console – Text View

History of commands

Toggle result as text or a grid

History of commands


IMS Command Console – Grid View


Update Transaction Attributes

Multi-select Transactions for Update


Update Transaction

Update attributes


View Resources from an IMSPlex

Select Resource Type

Transaction displayed for IMS1 & IMS2


Demonstration of the Management Console


IMS Tools Holistic Views


Management Console Goals

• Provide a single holistic, easy-to-use interfaceto manage IMS systems and databases

• Consolidate information from various tools to paint a more complete picture of IMS systems and databases

• Leverage the latest web technologies for a richer user experience

• Access from anywhere via the Internet using standard web browsers

• Prepare the next generation of IMS DBAs and System Programmers through an integrated, context sensitive help system

• Begin with integration of our Autonomics Solutions• …Extend integration to support all our IMS Tools


Drill down from User Created Groups

Resource status, errors, and recommendations can be aggregated with an ability to drill down


Holistic View of IMS Databases

…from Sensors

…from Auto Discovery

…from Autonomics Director…from Various HP Tools


Integrated Help Throughout

Integrated help educates new and experienced DBAs on database concepts and how to interpret charts


Questions?


Additional Line Item Feedback

Please describe any additional IMS function you would like to see upcoming releases

● Consider the following open requirements:

● View, start and stop dependent regions

● Create and delete IMS resources (pgm,db,tran,rtc)

● Drill down into related resources for IMS and IMS Connect

● View, create, delete IMS descriptor resources (pgm,db,tran,rtc)

● Start and stop IMS Connect

● Edit Proclib configuration members

I would like IMS Explorer for Administration to:

1)

2)

3)

4)

5)


Additional Line Item Feedback

Please describe any additional Usability function you would like to see upcoming releases

● Consider the following open requirements:

● User defined status color for IMS Resources

● Paging when displaying IMS Resources (many rows)

● Log-in dashboard that will display messages and status

● User defined corrective actions

● View the server log

● Dynamically change logging levels

I would like IMS Explorer for Administration to:

1)

2)

3)

4)

5)

ibm management console for ims and db2 z/os - minneapolis rug mar 11 2015

Technology