Office of the CIO Services Catalog

Last modified on:11.06.10

Database Management Services(DBMS) for the Mainframe

Description

Database Management Services for the Mainframe provides installation and support for DB2 and IMS database structures. The service provides a database ‘engine’ that can be used by all front-end software tools (i.e. Web, TSO, CICS, AS400, Windows) to access the data our customers have entrusted to us for safe and secure keeping. This service safeguards the information from loss, misuse, and corruption by unknown and unauthorized entities.Features include:

  • Both relational (DB2) and hierarchical (IMS) database structures;
  • Database policies and procedures to support DB2 on the mainframe;
  • Built in back out and recovery services;
  • Security and protection of customer data;
  • The use of mainframe front-end attachments (e.g. CICS, TSO) to access DB2 data;
  • Remote customer (e.g. Web, Client/Servers) connections thru the services of “DB2 Connect” to access DB2 data;
  • Mainframe tools for customers to query and manipulate data without the use of a developed application (e.g. QMF, File-Aid for DB2 or IMS);
  • Tools (e.g. Data Propagator) to allow customers to import or export data between IBM database platforms.

Business Value

This service allows customers to focus on their business instead of DBMS architecture.
Benefits for our customers include:

  • Access to mainframe data 24/7;
  • Protection of data from unauthorized parties;
  • Centralized administration for installing and supporting mainframe databases; and
  • The ability to set policies and procedures for the current DBMS technology.

Customer Profile

All mainframe customers are provided this service.

Service Cost

This service is provided by default to customers with applications accessing DB2 or IMS data on the mainframe.

CIO Services Catalog (pdf)

How to Order Service

The Office of the CIO Help Desk may be reached at 1-800-982-2468 or 471-4636 or 471-INFO or by e-mailing GWI.Support@nebraska.gov . 

For those interested in self serve capabilities, an End User Desktop allows customers to submit their own tickets.  The current status of existing tickets can be obtained with a Lotus Notes client at Helpdesk@nebraska.gov from a browser.

Glossary/Expanded Definitions

CICS – Customer Information Control System that provides telecommunication from terminal.

DB2 – Database 2 is relational database environment. DB2 on the mainframe is the preferred database management system due to the ease of use and tools available.

IMS – Information Management System is hierarchical database environment capable of managing complex databases.

Mainframe - A large computer supporting hundreds of customers simultaneously. Currently, the DB2 and IMS servers reside on IBM z-Series computer.

QMF - Query Management Facility provides interactive SQL report generator.

TSO – Time Sharing Option that provides interactive access from terminals.

Windows – Use to refer to Windows PC running on INTEL processor.

Date of Last Revision: March 9, 2006