IBM IMS Solutions for Automating Database Management
IBM IMS Solutions for Automating Database Management

Author: Paolo Bruni

Publisher: IBM Redbooks

Published: 2014-12-09

Total Pages: 200

ISBN-13: 073844023X

DOWNLOAD EBOOK

Over the last few years, IBM® IMSTM and IMS tools have been modernizing the interfaces to IMS and the IMS tools to bring them more in line with the current interface designs. As the mainframe software products are becoming more integrated with the Windows and mobile environments, a common approach to interfaces is becoming more relevant. The traditional 3270 interface with ISPF as the main interface is no longer the only way to do some of these processes. There is also a need to provide more of a common looking interface so the tools do not have a product-specific interface. This allows more cross product integration. Eclipse and web-based interfaces being used in a development environment, tooling using those environments provides productivity improvements in that the interfaces are common and familiar. IMS and IMS tools developers are making use of those environments to provide tooling that will perform some of the standard DBA functions. This book will take some selected processes and show how this new tooling can be used. This will provide some productivity improvements and also provide a more familiar environment for new generations DBAs. Some of the functions normally done by DBA or console operators can now be done in this eclipse-based environment by the application developers. This means that the need to request these services from others can be eliminated. This IBM Redbooks® publication examines specific IMS DBA processes and highlights the new IMS and IMS tools features, which show an alternative way to accomplish those processes. Each chapter highlights a different area of the DBA processes like: PSB creation Starting/stopping a database in an IMS system Recovering a database Cloning a set of databases

Modernize Your IBM DB2 for IBM z/OS Maintenance with Utility Autonomics
Modernize Your IBM DB2 for IBM z/OS Maintenance with Utility Autonomics

Author: Dean Brown

Publisher: IBM Redbooks

Published: 2015-08-20

Total Pages: 152

ISBN-13: 0738440892

DOWNLOAD EBOOK

IBM® DB2® for IBM z/OS® helps lower the cost of managing data by automating administration, increasing storage efficiency, improving performance, and simplifying the deployment of virtual appliances. By automating tasks such as memory allocation, storage management, and business policy maintenance, DB2 is able to perform many management tasks itself, freeing up Database Administrators to focus on new projects. This IBM Redbooks® publication introduces autonomics for DB2 for z/OS. IBM provides several different components that, when combined, can create an autonomic database environment. All these respective components cover certain aspects of autonomics, which can collaborate into one coherent solution. In our evolution of autonomics and the need to move to smarter systems there has been a bigger drive to the concept of "Active" versus "Passive" autonomics. With the inclusion of the IBM Management Console for IMSTM and DB2 for z/OS and the Autonomics Director, it is now easier than ever to make that transition by leveraging the strength of the DB2 Utilities Solution Pack for z/OS all in one standardized and centralized interface. This publication guides you through the business reasons for adopting autonomic solutions, and provides step-by-step guidance to implement these capabilities in your DB2 for z/OS configuration. This publication is of interest primarily to DB2 Database Administrators and DB2 Systems Programmers, and for anyone looking to understand the benefits of DB2 autonomic solutions.

New Approach to Analytics for IBM IMS Data
New Approach to Analytics for IBM IMS Data

Author: Deepak Kohli

Publisher: IBM Redbooks

Published: 2016-04-17

Total Pages: 18

ISBN-13: 0738455229

DOWNLOAD EBOOK

IBM® Information Management System (IMSTM) applications and data are the core of critical online transaction processing (OLTP) workloads for many of the world's major organizations. This operational data, when analyzed properly, forms the basis for making better decisions by organizations running IMS. With IBM DB2® Analytics Accelerator for z/OS®, you can exploit your IBM z SystemsTM platform's IMS data where it originates so that delivering new insights to improve efficiency and drive smart outcomes is possible. Critical business insights that are gained by performing analytics on IMS operational data is a valuable corporate asset and must be delivered efficiently across an organization, with high quality and proper governance, which is possible with this solution. This IBM Redbooks® Solution Guide describes DB2 Analytics Accelerator for z/OS and how it enables you to exploit the IMS data. It explains the business value of the solution, provides an overview and high-level solution architecture and includes usage scenarios.

Publishing IMS and DB2 Data Using WebSphere Information Integrator
Publishing IMS and DB2 Data Using WebSphere Information Integrator

Author: Nagraj Alur

Publisher:

Published: 2005

Total Pages: 312

ISBN-13:

DOWNLOAD EBOOK

This IBM Redbooks publication provides an overview of IBM's event publishing solution delivered via its WebSphere Information Integrator Classic Event Publisher and WebSphere Information Integrator Event Publisher products, and documents the procedure for implementing a replication and event publishing solution using these products. The book is aimed at an audience of IT architects and database administrators (DBA) responsible for leveraging the WebSphere Information Integrator event publishing capabilities in a variety of business solutions involving replication and event alert systems. Using an insurance industry acquisition scenario involving auto insurance and home insurance companies, this book documents a step-by-step approach to implementing an integrating Customer Information Facility (CIF) application, and an Event Alert System application using WebSphere Information Integrator Classic Event Publisher and WebSphere Information Integrator Event Publisher. Please note that the additional material referenced in the text is not available from IBM.

IBM Information Governance Solutions
IBM Information Governance Solutions

Author: Chuck Ballard

Publisher: IBM Redbooks

Published: 2014-04-04

Total Pages: 264

ISBN-13: 0738439517

DOWNLOAD EBOOK

Managing information within the enterprise has always been a vital and important task to support the day-to-day business operations and to enable analysis of that data for decision making to better manage and grow the business for improved profitability. To do all that, clearly the data must be accurate and organized so it is accessible and understandable to all who need it. That task has grown in importance as the volume of enterprise data has been growing significantly (analyst estimates of 40 - 50% growth per year are not uncommon) over the years. However, most of that data has been what we call "structured" data, which is the type that can fit neatly into rows and columns and be more easily analyzed. Now we are in the era of "big data." This significantly increases the volume of data available, but it is in a form called "unstructured" data. That is, data from sources that are not as easily organized, such as data from emails, spreadsheets, sensors, video, audio, and social media sites. There is valuable information in all that data but it calls for new processes to enable it to be analyzed. All this has brought with it a renewed and critical need to manage and organize that data with clarity of meaning, understandability, and interoperability. That is, you must be able to integrate this data when it is from within an enterprise but also importantly when it is from many different external sources. What is described here has been and is being done to varying extents. It is called "information governance." Governing this information however has proven to be challenging. But without governance, much of the data can be less useful and perhaps even used incorrectly, significantly impacting enterprise decision making. So we must also respect the needs for information security, consistency, and validity or else suffer the potential economic and legal consequences. Implementing sound governance practices needs to be an integral part of the information control in our organizations. This IBM® Redbooks® publication focuses on the building blocks of a solid governance program. It examines some familiar governance initiative scenarios, identifying how they underpin key governance initiatives, such as Master Data Management, Quality Management, Security and Privacy, and Information Lifecycle Management. IBM Information Management and Governance solutions provide a comprehensive suite to help organizations better understand and build their governance solutions. The book also identifies new and innovative approaches that are developed by IBM practice leaders that can help as you implement the foundation capabilities in your organizations.

IMS Integration and Connectivity Across the Enterprise
IMS Integration and Connectivity Across the Enterprise

Author: Paolo Bruni

Publisher: IBM Redbooks

Published: 2014-04-08

Total Pages: 506

ISBN-13: 0738439010

DOWNLOAD EBOOK

This IBM® Redbooks® publication gives a broad understanding of IBM IMSTM integration and connectivity solutions to access applications and data stores across your enterprise architecture. As an application developer, architect, systems integrator, or systems programmer, there is important information that is available in this book that pertains to your responsibilities to continue to include the proven performance, data integrity, and workload distribution that is available from IMS in to selected projects that are related to your entire enterprise. This book updates and adds to the information in the following IBM Redbooks publications: IMS e-business Connectors: A Guide to IMS Connectivity, SG24-6514 IMS Connectivity in an On Demand Environment: A Practical Guide to IMS Connectivity, SG24-6794 Powering SOA Solutions with IMS, SG24-7662 IBM IMS Version 12 Technical Overview, SG24-7972 IMS 12: The IMS Catalog, REDP-4812 Rethink Your Mainframe Applications: Reasons and Approaches for Extension, Transformation, and Growth, REDP-4938

IMS 11 Open Database
IMS 11 Open Database

Author: Paolo Bruni

Publisher: IBM Redbooks

Published: 2010-08-12

Total Pages: 296

ISBN-13: 0738434566

DOWNLOAD EBOOK

IMSTM Version 11 continues to provide the leadership in performance, reliability, and security that is expected from the product of choice for critical online operational applications. IMS 11 also offers new functions to help you keep pace with the evolving IT industry. Through the introduction of the new IMS Enterprise Suite application developers with minimal knowledge of IMS Connect can start developing client applications to communicate with IMS. With Open Database, IMS 11 also provides direct SQL access to IMS data from programs that run on any distributed platform, unlocking DL/I data to the world of SQL application programmers. In this IBM® Redbooks® publication, system programmers get the steps for installing the new IMS components, and the application programmer can follow scenarios of how client applications can take advantage of SQL to access IMS data. We describe the installation of prerequisites, such as IMS Connect and the Structured Call Interface component of Common Service Layer address space and document the set up of the three new IMS drivers: - Universal DB resource adapter - Universal JDBC driver - Universal DL/I driver Our scenarios use the JDBC driver for type-4 access from Windows® to a remote DL/I database and DB2® tables and extend it to use IBM Mashup Center to provide an effective Web interface and to integrate with Open Database. Important: IMS Enterprise Suite V2.1 is the last release of the IMS Enterprise Suite that includes the DLIModel utility plug-in. Customers should migrate to using IMS Enterprise Suite V2.2 or later, which includes the IMS Enterprise Suite Explorer for Development. DLIModel utility projects can be imported into new IMS Explorer projects. In this book, any references to generating IMS metadata classes by using the DLIModel utility are comparable to the actions used to generate the classes using the IMS Explorer for Development.

IBM IMS Version 12 Technical Overview
IBM IMS Version 12 Technical Overview

Author: Paolo Bruni

Publisher: IBM Redbooks

Published: 2011-10-25

Total Pages: 510

ISBN-13: 073843616X

DOWNLOAD EBOOK

IBM® Information Management System (IMSTM) provides leadership in performance, reliability, and security to help you implement the most strategic and critical enterprise applications. IMS also keeps pace with the IT industry. IMS, Enterprise Suite 2.1, and IMS Tools continue to evolve to provide value and meet the needs of enterprise customers. With IMS 12, integration and open access improvements provide flexibility and support business growth requirements. Manageability enhancements help optimize system staff productivity by improving ease of use and autonomic computing facilities and by providing increased availability. Scalability improvements have been made to the well-known performance, efficiency, availability, and resilience of IMS by using 64-bit storage. IBM IMS Enterprise Suite for z/OS® V2.1 components enhance the use of IMS applications and data. In this release, components (either orderable or downloaded from the web) deliver innovative new capabilities for your IMS environment. They enhance connectivity, expand application development, extend standards and tools for a service-oriented architecture (SOA), ease installation, and provide simplified interfaces. This IBM Redbooks® publication explores the new features of IMS 12 and Enterprise Suite 2.1 and provides an overview of the IMS tools. In addition, this book highlights the major new functions and facilitates database administrators in their planning for installation and migration.

IBM Open Platform for DBaaS on IBM Power Systems
IBM Open Platform for DBaaS on IBM Power Systems

Author: Dino Quintero

Publisher: IBM Redbooks

Published: 2018-03-26

Total Pages: 234

ISBN-13: 0738442798

DOWNLOAD EBOOK

This IBM Redbooks publication describes how to implement an Open Platform for Database as a Service (DBaaS) on IBM Power Systems environment for Linux, and demonstrate the open source tools, optimization and best practices guidelines for it. Open Platform for DBaaS on Power Systems is an on-demand, secure, and scalable self-service database platform that automates provisioning and administration of databases to support new business applications and information insights. This publication addresses topics to help sellers, architects, brand specialists, distributors, resellers and anyone offering secure and scalable Open Platform for DBaaS on Power Systems solution with APIs that are consistent across heterogeneous open database types. An Open Platform for DBaaS on Power Systems solution has the capability to accelerate business success by providing an infrastructure, and tools leveraging Open Source and OpenStack software engineered to optimize hardware and software between workloads and resources so you have a responsive, and an adaptive environment. Moreover, this publication provides documentation to transfer the how-to-skills for cloud oriented operational management of Open Platform for DBaaS on Power Systems service and underlying infrastructure to the technical teams. Open Platform for DBaaS on Power Systems mission is to provide scalable and reliable cloud database as a service provisioning functionality for both relational and non-relational database engines, and to continue to improve its fully-featured and extensible open source framework. For example, Trove is a database as a service for OpenStack. It is designed to run entirely on OpenStack, with the goal of allowing users to quickly and easily utilize the features of a relational or non-relational database without the burden of handling complex administrative tasks. Cloud users and database administrators can provision and manage multiple database instances as needed. Initially, the service focuses on providing resource isolation at high performance while automating complex administrative tasks including deployment, configuration, patching, backups, restores, and monitoring. In the context of this publication, the monitoring tool implemented is Nagios Core which is an open source monitoring tool. Hence, when you see a reference of Nagios in this book, Nagios Core is the open source monitoring solution implemented. Also note that the implementation of Open Platform for DBaaS on IBM Power Systems is based on open source solutions. This book is targeted toward sellers, architects, brand specialists, distributors, resellers and anyone developing and implementing Open Platform for DBaaS on Power Systems solutions.