Showing documents 81 to 100 of 135  Previous  Next

Results per page: 5 | 10 | 20


cover image

IBM Data Studio V2.1: Getting Started with Web Services on DB2 for z/OS
Information Management

Redpaper, published 7 Apr 2009

This IBM® Redpaper™ provides a step-by-step introduction on how to get started with Web services using Data Studio V2.1. Our goal is to explain basic concepts and introduce the functions that can help you take your first steps in the Web services arena with DB2® for z/OS®. We start with describing and setting up the basic software components and showing a step-by-step guide to creating your first Web service. We then show how you can test and deploy Web services and let DB2 operate as a Web service requester (consumer) and a Web service server (provider). Last, we introduce the SOAP UDFs ... [more]


cover image

Optimizing Restore and Recovery Solutions with DB2 Recovery Expert for z/OS V2.1
Information Management

Redbooks, published 22 Jun 2008, last updated 20 Feb 2009

IBM DB2 Recovery Expert manages the recovery of DB2 for z/OS V8 and V9 objects in a data sharing and non-data sharing environment. The major focus of IBM DB2 Recovery Expert V2.1 for z/OS (5697-N92) is on DB2 system level backup and restore. The tool provides the ability to create a consistent full system backup with no impact on DB2 availability, comprehensive backup and recovery reporting capabilities, and robust database and storage validity checking to ensure successful creation and usage of database system backups. By integrating with disk storage functions, it supports DB2 subsystem ... [more]


cover image

DB2 9 for z/OS: Deploying SOA Solutions
Information Management

Redbooks, published 14 Jan 2009

Flexibility in business has become of equal in importance with operational efficiency. Service-oriented architecture (SOA) can help businesses respond more quickly and cost-effectively to the changing market conditions by promoting reuse and interconnection of existing IT assets rather than time-consuming and costly reinvention. SOA has been the top fashionable topic in IT for a few years now, which is because there is a consensus of opinions among enterprise architects that SOA is the key to making the IT department a catalyst for growth and innovation. DB2® for z/OS® integrates with Web ... [more]


cover image

InfoSphere Warehouse: Cubing Services and Client Access Interfaces
Information Management

Redbooks, published 12 Dec 2008, last updated 16 Dec 2008

Formerly known as DB2® Warehouse, InfoSphere™ Warehouse enables a unified, powerful data warehousing environment. It provides access to structured and unstructured data, as well as operational and transactional data. In this IBM® Redbooks® publication, we provide a brief overview of InfoSphere Warehouse, but the primary objective is to discuss and describe the capabilities of one particular component of the InfoSphere Warehouse, which is InfoSphere Warehouse Cubing Services. InfoSphere Warehouse Cubing Services is designed to provide a multidimensional view of data stored in relational ... [more]


cover image

DB2 Deployment Guide
Information Management

Redbooks, published 24 Oct 2008

DB2® provides various installation methods as well as features and tools to deploy a large number of clients and servers. Database administrators, application developers, and application architects have a number of available options when deploying DB2 9.5 for Linux® , UNIX® , and Windows® (DB2 for LUW). Focusing on the DB2 V9.5 deployment methodology, this IBM® Redbooks® publication provides general guidance and serves as a reference resource for DB2 based solution deployment. These techniques and considerations are also applicable to other recent versions of DB2 for LUW. Deployment begins ... [more]


cover image

DB2 9 for z/OS: Backup and Recovery I/O Related Performance Considerations
Information Management

Redpaper, published 10 Oct 2008

This IBM® Redpaper provides best practices and I/O-related performance considerations for backup and recovery using DB2® 9 for z/OS®. It describes some guidelines for DB2 for z/OS backup and recovery, then it discusses performance considerations that may be used to predict recovery time, which can be used, in turn, to adjust backup frequencies or methods. This Redpaper has the following sections: “ Planning the backup strategy” on page 2 This section deals with the series of decisions which a backup strategy involves, beginning on the day that disk and tape hardware are purchased. ... [more]


cover image

Deploying a Grid Solution with the IBM InfoSphere Information Server
Analytics

Redbooks, published 24 Sep 2008

The IBM InfoSphere Information Server and the IBM Blade/GRID offering is a revolutionary new software/hardware platform (leveraging Linux on Intel) that helps organizations derive more value from the complex heterogeneous information spread across their systems. It enables organizations to integrate disparate data and deliver trusted information wherever and whenever needed, in line and in context, to specific people, applications, and processes. This IBM Redbooks publication describes a scenario for migrating an existing InfoSphere Information Server parallel framework implementation on a ... [more]


cover image

Enterprise Data Warehousing with DB2 9 for z/OS
Information Management

Redbooks, published 12 Sep 2008

Enterprises look more and more to business intelligence (BI) to gain a competitive edge. Today's BI systems incorporate large data warehouses that are consolidated with near real-time operational data stores (ODS) and continuously updated from multiple sources. An increasing number of users in the enterprise want to access the data warehouse with BI applications with real-time needs. There is a renewed interest in the ability to implement a data warehouse solution on DB2® for z/OS® and System z™. This is due to the inherent characteristics of security, availability, performance, mixed ... [more]


cover image

Database Partitioning, Table Partitioning, and MDC for DB2 9
Information Management

Redbooks, published 23 Aug 2007, last updated 27 Aug 2008

As organizations strive to do more with less, DB2 Enterprise Server Edition V9 for Linux, Unix, and Windows contains innovative features for delivering information on demand and scaling databases to new levels. The table partitioning, newly introduced in DB2 9, and the database partitioning feature provide scalability, performance, and flexibility for data store. The multi-dimension clustering table enables rows with similar values across multiple dimensions to be physically clustered together on disk. This clustering allows for efficient I/O and provides performance gain for typical ... [more]


cover image

IBM z/OS Application Connectivity to DB2 for z/OS and OS/390
Information Management

Web Doc, published 20 Jan 2004, last updated 22 Jul 2008

This Tip describes the no-charge feature that was initially made available for DB2 for z/OS V7after the publication of the related IBM Redbooks publication "DB2 for z/OS and OS/390: Ready for Java."


cover image

Up and Running with DB2 on Linux
Information Management

Redbooks, published 25 Jun 2008

Linux® is one of the fastest growing server operating platforms within the past few years. DB2® has long been known for its technology leadership. This IBM® Redbooks® publication is an informative guide that describes how to effectively integrate DB2 for Linux, UNIX®, and Windows® (LUW) with SUSE and Red Hat Linux operating systems. This book provides both introductory and detailed information about installing, configuring, managing, and monitoring DB2 in a Linux environment. We describe the DB2 product family and features for Linux, and we provide step-by-step instructions for a single as ... [more]


cover image

DB2 Security and Compliance Solutions for Linux, UNIX, and Windows
Information Management

Redbooks, published 31 Mar 2008, last updated 10 Jun 2008

In this IBM Redbooks publication we discuss the existing and new DB2 security features introduced in DB2 9.5 for Linux, UNIX, and Windows. These enriched DB2 security features provide you with the capability to protect your data and comply with regulatory requirements. We describe how you can control data access through DB2 authentication and authorization functions. The role feature provides new options for tighter security, more granularity, and flexibility in administrating data access. Data encryption offers the capability to protect sensitive data in the database, critical database ... [more]


cover image

DB2 Workload Manager for Linux, UNIX, and Windows
Information Management

Redbooks, published 19 May 2008

DB2 Workload Manager (WLM) introduces a significant evolution in the capabilities available to database administrators for controlling and monitoring executing work within DB2. This new WLM technology is directly incorporated into the DB2 engine infrastructure to allow handling higher volumes with minimal overhead. It is also enabled for tighter integration with external workload management products, such as those provided by AIX WLM. This IBM Redbooks publication discusses the features and functions of DB2 Workload Manager for Linux, UNIX, and Windows. It describes DB2 WLM architecture, ... [more]


cover image

Index Compression with DB2 9 for z/OS
Information Management

Redpaper, published 4 Sep 2007, last updated 28 Feb 2008

In data warehouse applications, it is common to have many very large indexes defined on large tables. It is also possible that the index spaces exceed the size of the tables upon which the indexes are based. As one way of helping you to manage the cost of ownership, in DB2 9 for z/OS (New Function Mode) you can choose to compress your indexes and you can define indexes with a page size larger than 4 KB. All references to the DB2 product refer specifically to DB2 9, except where the release level is explicitly mentioned. Compression has been available for table spaces on z/OS since DB2 ... [more]


cover image

IBM DB2 9 for z/OS: New Tools for Query Optimization
Information Management

Redbooks, published 13 Dec 2007

The cost-based optimizer of IBM DB2 for z/OS has continually evolved since its initial inception. Support has included new optimization algorithms, join methods, complex relational data structures, such as star schemas. DB2 for z/OS V8 has provided access path visualization and a Statistics Advisor function through a new Visual Explain. DB2 9 for z/OS starts addressing the challenge of reducing cost of ownership by extending query optimization through expert-based query and workload analysis, server enhancements, and an Index Advisory function. These functions are delivered with two tools: ... [more]


cover image

LOBs with DB2 for z/OS: Stronger and Faster
Information Management

Redbooks, published 29 Nov 2006, last updated 14 Nov 2007

The requirements for a database management system (DBMS) have included support for very large and complex data objects. DB2 UDB for OS/390 Version 6 introduced the support for large objects (LOBs): they can contain text documents, images, or movies, and can be stored directly in the DBMS with sizes up to 2 gigabytes per object and 65,536 TB for a single LOB column in a 4,096 partition table. The introduction of these new data types has implied some changes in the administration processes and programming techniques. The book Large Objects with DB2 for z/OS and OS/390, SG24-6571, introduced ... [more]


cover image

DB2 UDB for z/OS Version 8 Performance Topics
Information Management

Redbooks, published 11 Apr 2005, last updated 1 Oct 2007

IBM DATABASE 2 Universal Database Server for z/OS Version 8 (DB2 V8 throughout this IBM Redbooks publication) is the twelfth and largest release of DB2 for MVS. It brings synergy with the zSeries hardware and exploits the z/OS 64-bit virtual addressing capabilities. DB2 V8 offers data support, application development, and query functionality enhancements for e-business, while building upon the traditional characteristics of availability, exceptional scalability, and performance for the enterprise of choice. Key improvements enhance scalability, application porting, security architecture, and ... [more]


cover image

DB2 9 pureXML Guide
Information Management

Redbooks, published 23 Jan 2007, last updated 16 Aug 2007

IBM DB2 9 for Linux, UNIX, and Windows marks a new stage in the evolution of data servers. IBM has continually led the data management industry with the release of innovative technology. DB2 9 is a new generation data server with revolutionary pureXML technology. This technology in DB2 9 fundamentally transforms the way XML information is managed for maximum return while seamlessly integrating XML with relational data. In this IBM Redbooks publication we discuss the pureXML data store, hybrid database design, and administration. We describe XML schemas, industry standards, and how to manage ... [more]


cover image

Oracle to DB2 Conversion Guide for Linux, UNIX, and Windows
Information Management

Redbooks, published 9 Aug 2007

[NOTE: There is a new conversion guide available for DB2 9.7] - [Oracle to DB2 Conversion Guide: Compatibility Made Easy] which can be found at: http://www.redbooks.ibm.com/abstracts/sg247736.html
IBM DB2 has long been known for its technology leadership. This IBM Redbooks publication, intended for technical staff who are involved in an Oracle to DB2 conversion project, is an informative guide that describes how to migrate the database system from Oracle to DB2 Version 9 on Linux, UNIX, and Microsoft ... [more]


cover image

DB2 for z/OS Administration Tools for Enhanced Change Management
Information Management

Redbooks, published 25 Jun 2007

A database administrator (DBA) has a challenging job trying to maintain databases in today’s nonstop 24x7 environments. This challenge is compounded by the complexity of database structures and the time pressure of trying to be up again as soon as possible without making mistakes. When business expands, several DB2 subsystems have to be maintained, such as multiple development systems, function test, acceptance test, volume test, and production systems. Often changes have to be implemented across multiple DB2 subsystems. The two IBM DB2 for z/OS tools that help database administrators to ... [more]


 Previous  Next

The above is a list of IBM Redbooks and Redpapers on Information Management, showing most recently published first. Most of these publications are available in Adobe PDF format and may be viewed online or downloaded for offline viewing and printing. Read our How to buy page for details on how to order a bound hardcopy.



Follow IBM Redbooks

Follow IBM Redbooks