DB2 Administration Solution Pack for z/OS: Streamlining DB2 for z/OS Database Administration

DB2 Administration Solution Pack for z/OS: Streamlining DB2 for z/OS Database Administration PDF Author: Paolo Bruni
Publisher: IBM Redbooks
ISBN: 0738438669
Category : Computers
Languages : en
Pages : 314

Get Book Here

Book Description
IBM® DB2® tools for z/OS® support and exploit the most current versions of DB2 for z/OS. These tools are integral for the administration of the DB2 for z/OS environment and optimization of data performance. DB2 Administration Solution Pack for z/OS V1.1 (5697-DAM) offers features, functions, and processes that database administrators (DBAs) can use to more effectively and efficiently manage DB2 environments. DB2 Administration Solution Pack for z/OS is composed of the following tools: IBM DB2 Administration Tool for z/OS IBM DB2 Object Comparison Tool for z/OS IBM InfoSphere® OptimTM Configuration Manager for DB2 for z/OS IBM DB2 Table Editor for z/OS This IBM Redbooks® publication shows how the delivered capabilities can help DBAs to more easily complete tasks associated with object management, change management, application management, and configuration management.

Managing DB2 for z/OS Utilities with DB2 Tools Solution Packs

Managing DB2 for z/OS Utilities with DB2 Tools Solution Packs PDF Author: Paolo Bruni
Publisher: IBM Redbooks
ISBN: 0738438472
Category : Computers
Languages : en
Pages : 598

Get Book Here

Book Description
IBM® DB2® Tools for z/OS® support and take advantage of the latest versions of DB2 for z/OS. These tools are integral for the administration of the DB2 for z/OS environment and for optimization of data performance. In addition, the IBM portfolio addresses additional client requirements in the areas of data governance and version upgrade acceleration. Underlying the operation of any database management system are the utilities. With the number of database objects growing exponentially, managing utility jobs, meeting service level agreements (SLAs), and ensuring recoverability can be overwhelming. IBM offers DB2 Tools solution packs that assist in the DB2 utilities management process. Solution packs combine several products into a single consolidated solution providing everything necessary to ensure the execution of a set of database administration functions. The goals are to reduce the operational complexity and reduce cost. The objective of this IBM Redbooks® publication is to document the added value in terms of productivity and performance for database administrators when using the IBM DB2 Utilities Solution Pack and the IBM DB2 Fast Copy Solution Pack. We show the functions of the tools provided by the solution packs as used in real-life scenarios and adopting utilities best practices.

IBM IMS Solutions for Automating Database Management

IBM IMS Solutions for Automating Database Management PDF Author: Paolo Bruni
Publisher: IBM Redbooks
ISBN: 073844023X
Category : Computers
Languages : en
Pages : 200

Get Book Here

Book Description
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

DB2 11 for z/OS Technical Overview

DB2 11 for z/OS Technical Overview PDF Author: Paolo Bruni
Publisher: IBM Redbooks
ISBN: 0738439053
Category : Computers
Languages : en
Pages : 484

Get Book Here

Book Description
IBM® DB2® Version 11.1 for z/OS® (DB2 11 for z/OS or just DB2 11 throughout this book) is the fifteenth release of DB2 for IBM MVSTM. It brings performance and synergy with the IBM System z® hardware and opportunities to drive business value in the following areas. DB2 11 can provide unmatched reliability, availability, and scalability - Improved data sharing performance and efficiency - Less downtime by removing growth limitations - Simplified management, improved autonomics, and reduced planned outages DB2 11 can save money and save time - Aggressive CPU reduction goals - Additional utilities performance and CPU improvements - Save time and resources with new autonomic and application development capabilities DB2 11 provides simpler, faster migration - SQL compatibility, divorce system migration from application migration - Access path stability improvements - Better application performance with SQL and XML enhancements DB2 11 includes enhanced business analytics - Faster, more efficient performance for query workloads - Accelerator enhancements - More efficient inline database scoring enables predictive analytics The DB2 11 environment is available either for new installations of DB2 or for migrations from DB2 10 for z/OS subsystems only. This IBM Redbooks® publication introduces the enhancements made available with DB2 11 for z/OS. The contents help database administrators to understand the new functions and performance enhancements, to plan for ways to use the key new capabilities, and to justify the investment in installing or migrating to DB2 11.

DB2 for z/OS and WebSphere Integration for Enterprise Java Applications

DB2 for z/OS and WebSphere Integration for Enterprise Java Applications PDF Author: Paolo Bruni
Publisher: IBM Redbooks
ISBN: 0738438391
Category : Computers
Languages : en
Pages : 638

Get Book Here

Book Description
IBM DB2® for z/OS® is a high-performance database management system (DBMS) with a strong reputation in traditional high-volume transaction workloads that are based on relational technology. IBM WebSphere® Application Server is web application server software that runs on most platforms with a web server and is used to deploy, integrate, execute, and manage Java Platform, Enterprise Edition applications. In this IBM® Redbooks® publication, we describe the application architecture evolution focusing on the value of having DB2 for z/OS as the data server and IBM z/OS® as the platform for traditional and for modern applications. This book provides background technical information about DB2 and WebSphere features and demonstrates their applicability presenting a scenario about configuring WebSphere Version 8.5 on z/OS and type 2 and type 4 connectivity (including the XA transaction support) for accessing a DB2 for z/OS database server taking into account high-availability requirements. We also provide considerations about developing applications, monitoring performance, and documenting issues. DB2 database administrators, WebSphere specialists, and Java application developers will appreciate the holistic approach of this document.

Extremely pureXML in DB2 10 for z/OS

Extremely pureXML in DB2 10 for z/OS PDF Author: Paolo Bruni
Publisher: IBM Redbooks
ISBN: 0738435147
Category : Computers
Languages : en
Pages : 334

Get Book Here

Book Description
The DB2® pureXML® feature offers sophisticated capabilities to store, process and manage XML data in its native hierarchical format. By integrating XML data intact into a relational database structure, users can take full advantage of DB2's relational data management features. In this IBM® Redbooks® publication, we document the steps for the implementation of a simple but meaningful XML application scenario. We have chosen to provide samples in COBOL and JavaTM language. The purpose is to provide an easy path to follow to integrate the XML data type for the traditional DB2 for z/OS® user. We also add considerations for the data administrator and suggest best practices for ease of use and better performance.

ABCs of z/OS System Programming Volume 8

ABCs of z/OS System Programming Volume 8 PDF Author: Paul Rogers
Publisher: IBM Redbooks
ISBN: 0738436828
Category : Computers
Languages : en
Pages : 396

Get Book Here

Book Description
The ABCs of IBM® z/OS® System Programming is a 13-volume collection that provides an introduction to the z/OS operating system and the hardware architecture. Whether you are a beginner or an experienced system programmer, the ABCs collection provides the information you need to start your research into z/OS and related subjects. If you would like to become more familiar with z/OS in your current environment, or if you are evaluating platforms to consolidate your e-business applications, the ABCs collection serves as a powerful technical tool. . This IBM Redbooks® publication, Volume 8, shows you how to: - Adopt a systematic and thorough approach to dealing with problems and identifying the different types of problems - Determine where to look for diagnostic information and how to obtain it - Interpret and analyze the diagnostic data collected - Escalate problems to the IBM Support Center when necessary - Collect and analyze diagnostic data—a dynamic and complex process - Identify and document problems, collect and analyze pertinent diagnostic data and obtain help as needed, to speed you on your way to problem resolution The content of the volumes is as follows Volume 1: Introduction to z/OS and storage concepts, TSO/E, ISPF, JCL, SDSF, and z/OS delivery and installation Volume 2: z/OS implementation and daily maintenance, defining subsystems, JES2 and JES3, LPA, LNKLST, authorized libraries, SMP/E, Language Environment® Volume 3: Introduction to DFSMS, data set basics storage management hardware and software, catalogs, and DFSMStvs Volume 4: Communication Server, TCP/IP, and VTAM® Volume 5: Base and Parallel Sysplex® , System Logger, Resource Recovery Services (RRS), global resource serialization (GRS), z/OS system operations, automatic restart management (ARM), Geographically Dispersed Parallel SysplexTM (GDPS® ) Volume 6: Introduction to security, RACF, Digital certificates and PKI, Kerberos, cryptography and z990 integrated cryptography, zSeries® firewall technologies, LDAP, and Enterprise identity mapping (EIM) Volume 7: Printing in a z/OS environment, Infoprint® Server and Infoprint Central Volume 8: An introduction to z/OS problem diagnosis Volume 9: z/OS UNIX System Services Volume 10: Introduction to z/ArchitectureTM , zSeries processor design, zSeries connectivity, LPAR concepts, HCD, and HMC Volume 11: Capacity planning, performance management, WLM, RMFTM , and SMF

Hybrid Analytics Solution using IBM DB2 Analytics Accelerator for z/OS V3.1

Hybrid Analytics Solution using IBM DB2 Analytics Accelerator for z/OS V3.1 PDF Author: Paolo Bruni
Publisher: IBM Redbooks
ISBN: 0738438790
Category : Computers
Languages : en
Pages : 382

Get Book Here

Book Description
The IBM® DB2® Analytics Accelerator Version 3.1 for IBM z/OS® (simply called Accelerator in this book) is a union of the IBM System z® quality of service and IBM Netezza® technology to accelerate complex queries in a DB2 for z/OS highly secure and available environment. Superior performance and scalability with rapid appliance deployment provide an ideal solution for complex analysis. In this IBM Redbooks® publication, we provide technical decision-makers with a broad understanding of the benefits of Version 3.1 of the Accelerator's major new functions. We describe their installation and the advantages to existing analytical processes as measured in our test environment. We also describe the IBM zEnterprise® Analytics System 9700, a hybrid System z solution offering that is surrounded by a complete set of optional packs to enable customers to custom tailor the system to their unique needs..

IBM z/OS Mainframe Security and Audit Management Using the IBM Security zSecure Suite

IBM z/OS Mainframe Security and Audit Management Using the IBM Security zSecure Suite PDF Author: Axel Buecker
Publisher: IBM Redbooks
ISBN: 0738435880
Category : Computers
Languages : en
Pages : 494

Get Book Here

Book Description
Every organization has a core set of mission-critical data that must be protected. Security lapses and failures are not simply disruptions—they can be catastrophic events, and the consequences can be felt across the entire organization. As a result, security administrators face serious challenges in protecting the company's sensitive data. IT staff are challenged to provide detailed audit and controls documentation at a time when they are already facing increasing demands on their time, due to events such as mergers, reorganizations, and other changes. Many organizations do not have enough experienced mainframe security administrators to meet these objectives, and expanding employee skillsets with low-level mainframe security technologies can be time-consuming. The IBM® Security zSecure suite consists of multiple components designed to help you administer your mainframe security server, monitor for threats, audit usage and configurations, and enforce policy compliance. Administration, provisioning, and management components can significantly reduce administration, contributing to improved productivity, faster response time, and reduced training time needed for new administrators. This IBM Redbooks® publication is a valuable resource for security officers, administrators, and architects who wish to better understand their mainframe security solutions.

z/OS Version 1 Release 11 Implementation

z/OS Version 1 Release 11 Implementation PDF Author: Paul Rogers
Publisher: IBM Redbooks
ISBN: 073843387X
Category : Computers
Languages : en
Pages : 736

Get Book Here

Book Description
This IBM® Redbooks® publication positions the new z/OS® Version 1 Release 11 for migration by discussing many of the new functions that are available. The goal for the z/OS platform is to eliminate, automate, and simplify tasks without sacrificing z/OS strengths, and to deliver a z/OS management facility that is easy to learn and use. z/OS is a highly secure, scalable, high-performance enterprise operating system on which to build and deploy Internet- and JavaTM-enabled applications, providing a comprehensive and diverse application execution environment. This books describes the following new and changed functions: - IBM z/OS Management Facility - Allocation enhancements in z/OS V1R11 - BCPii function enhancements in z/OS V1R11 - JES2 and JES3 enhancements - zFS file sharing enhancements - Extended access volume enhancements - Choosing whether to run zAAP work on zIIP processors - System REXX enhancements in V1R11 - RRS global panel options - Service aids enhancements in V1R11 - GRS ENQ contention notification enhancements and analysis for GRS latches - Basic HyperSwap® support enhancement - Message Flood Automation enhancements - Program Management new Binder IEWPARMS - Predictive failure analysis (PFA) - SMF enhancements in V1R11 - System Logger enhancements - XCF/XES enhancements in V1R11 - AutoIPL support - Displaying PDSE caching statistics - ISPF enhancements - IBM Health Checker for z/OS enhancements