Showing documents 81 to 100 of 150  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

Enabling Robust Business Analytics with InfoSphere Warehouse Cubing Services
Information Management

Redguide, published 17 Mar 2009

In this IBM® Redguide™ publication, we describe how you can develop an environment that will enable you to perform more detailed analytics on your data and turn it into powerful information and business insight for making better informed decisions. Business decisions have historically been made primarily by analyzing data with techniques that limit you to a two dimensional view of that data. However, decisions are rarely defined or determined by such a narrow perspective. Now you can view and analyze your data from multiple perspectives - or dimensions as they are called in the technical ... [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

DB2 for z/OS: Considerations on Small and Large Packages
Information Management

Redpaper, published 14 Jul 2008

In this IBM® Redpaper, after some introductory background information on packages, we discuss the CPU utilization by packages related to two situations: when a small number of short-running SQL statements out of many SQL statements in a large package are executed and when a set of short-running SQL statements out of many different packages are executed. These two specific situations have become critical in some environments due to the performance difference after migration from DB2® V7 to V8. DB2 V8 has shown an increase in CPU associated with the major changes in functionalities. We show ... [more]


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

DB2 9.5 Features for Oracle to DB2 Conversion
Information Management

Web Doc, published 12 Mar 2008

DB2 9.5 for Linux, UNIX, and Windows provides new features that will make your database and application conversion from Oracle to DB2 even easier. The new features include the support of DECODE, OUTER JOIN, ROWNUM, as well as the new conversion algorithm for ARRAY, BULK COLLEC, and global variables. For the detailed explanation of these new features, refer to the developerWorks article: ... [more]


cover image

News on DB2 Optimization Expert for z/OS V1.2 and DB2 Optimization Service Center Version 1.1
Information Management

Web Doc, published 7 Mar 2008, last updated 10 Mar 2008

On March 4, IBM announced V1.2 of DB2 Optimization Expert for z/OS. In this technote we summarize the main enhancements provided in this release. DB2 for z/OS Version 8 support is also included among these enhancements. For complete details, see: http://www.ibm.com/software/data/db2imstools/db2tools/opti-expert-zos/ and - IBM United States Software Announcement 208-044 March 4, 2008 - IBM DB2 Optimization Expert for z/OS Liicense Information, GC19-1131 - IBM DB2 Optimization Expert for z/OS Program Directory, GI10-8755 - IBM DB2 Optimization Expert for z/OS Getting Started, GC19-1144 We also ... [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]


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.



IBM Redbooks Mobile App
Redbooks mobile app

The newest version of the official IBM Redbooks mobile app provides automated notifications for new and updated Redbooks content that is specifically tailored to your interests.


Follow IBM Redbooks

Follow IBM Redbooks