Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
DB2
1. |  DB2 UDB's High-Function Business Intelligence in e-business By: Nagraj Alur; Peter Haas; Daniela Momiroska; Paul Read; Nicholas Summers; Virginia Totanes; Calisto Zuzarte Publisher: IBM Redbooks Publication Date: 17-SEP-2002 Insert Date: 19-NOV-2012 Slots: 1.0 | Overview: DB2 UDB's High-Function Business Intelligence in e-business This IBM Redbooks publication deals with exploiting DB2
UDB’s materialized views (also known as ASTs/MQTs),
statistics, analytic, and OLAP functions in e-business applications
to achieve superior performance and scalability. This book is aimed
at a target audience of DB2 UDB application developers, database
administrators (DBAs), and independent software vendors (ISVs).
We provide an overview of DB2 UDB’s materialized views
implementation, as well as guidelines for creating and tuning them
for optimal performance.
We introduce key statistics, analytic, and OLAP functions, and
describe...
|
2. |  DB2 10 for Linux on System z Using z/VM v6.2, Single System Image Clusters and Live Guest Relocation By: Lydia Parziale; Dan Davenport; Eduardo Kienetz; Tito Ogando; Manoj Srinivasan Pattabhiraman; Srivatsan Venkatesan Publisher: IBM Redbooks Publication Date: 03-NOV-2012 Insert Date: 12-NOV-2012 Slots: 1.0 | Overview: DB2 10 for Linux on System z Using z/VM v6.2, Single System Image Clusters and Live Guest Relocation IBM® z/VM® 6.2 introduced significant changes to z/VM
with a multi-system clustering technology that allows up to four
z/VM instances in a single system image (SSI) cluster. This
technology is important because it offers you an attractive
alternative to vertical growth by adding new z/VM systems. In the
past, this capability required duplicate efforts to install,
maintain, and manage each system. With SSI, these duplicate efforts
are reduced or eliminated.
Support for live guest relocation (LGR) allows you to move Linux
virtual servers without disrupting your business or incurring loss
of...
|
3. |  DB2 for z/OS and OS/390 Version 7 Selected Performance Topics By: Paolo Bruni; Florence Dubois; Claudio Nacamatsu Publisher: IBM Redbooks Publication Date: 12-NOV-2002 Insert Date: 12-NOV-2012 Slots: 1.0 | Overview: DB2 for z/OS and OS/390 Version 7 Selected Performance Topics Performance measurements are ongoing during the life of each
release of DB2 for OS/390. DB2 for z/OS and OS/390 Version 7 (DB2
V7 throughout this document) has introduced several enhancements in
the areas of performance and availability, and other enhancements
are currently being added.
Most of these enhancements and the related performance
measurements implemented in the Silicon Valley Laboratory have been
documented in the IBM Redbooks publication DB2 for z/OS and OS/390
Version 7 Performance Topics, SG24-6129.
However, information on new DB2 functions and their synergy with
the...
|
4. |  Domino Web Service Application Development for the IBM eServer iSeries Server By: Yessong Johng; Kim Greene; Clayton McDaniel; Vinit Saraswat; Jing Han Zhao Publisher: IBM Redbooks Publication Date: 21-NOV-2002 Insert Date: 12-NOV-2012 Slots: 1.0 | Overview: Domino Web Service Application Development for the IBM eServer iSeries Server "Contextual collaboration" is a new term whirling in the
industry today. This phenomenal new type of business asset can be
realized by two major mechanisms: the components managing mechanism
and the services delivery mechanism. The component managing
mechanism deals with calendar, workflow, messaging, e-mail, and so
on, while the services delivery mechanism deals with receiving and
responding to a request. In terms of IBM product offerings, we have
Domino for the component managing mechanism and WebSphere for the
services delivery mechanism.
We need standards to connect the applications...
|
5. |  DB2 OLAP Server V8.1: Using Advanced Functions By: Corinne Baragoin; Luciana Dongo Alves; Jakob Burkard; Ulrich Guldborg; Jo Ramos; Paola Rodriguez Publisher: IBM Redbooks Publication Date: 26-NOV-2002 Insert Date: 12-NOV-2012 Slots: 1.0 | Overview: DB2 OLAP Server V8.1: Using Advanced Functions This IBM Redbooks publication explores DB2 OLAP Server V8.1
enhancements and strengths in the areas of scalability,
performance, high concurrency, high availability, and
administration, and explains how to deploy them in a whole
enterprise environment.
We provide administrators and implementers with practical
guidelines based on a case study on the new advanced functions in
DB2 OLAP Server V8.1. We discuss Hybrid Analysis and its ability to
conciliate and integrate data from OLAP cubes and data warehouses,
as well as the ability of OLAP Miner to detect deviations and
discover anomalies and...
|
6. |  Introducing VERITAS Foundation Suite for AIX By: KyeongWon Jeong; Anita Govindjee; Fred Sherman; Jason Littin; Shona Robertson Publisher: IBM Redbooks Publication Date: 04-NOV-2002 Insert Date: 12-NOV-2012 Slots: 1.0 | Overview: Introducing VERITAS Foundation Suite for AIX VERITAS Software products, such as VERITAS Volume Manager (VxVM)
and VERITAS File System (VxFS), are popular on other UNIX
platforms, and VERITAS announced these products for AIX in the
early of May 2002. VERITAS Foundation Suite for AIX includes
VERITAS Volume Manager for AIX and VERITAS File System for AIX.
These products will be useful for people who are familiar with the
same products on other UNIX platforms since VERITAS Foundation
Suite for AIX provides a similar environment for them. That means
they can use their same skills and knowledge in the AIX
environment.
This IBM Redbooks...
|
7. |  DB2 Recovery Expert for Multiplatforms By: Bart Steegmans; Mark Samson; Manish Shah Publisher: IBM Redbooks Publication Date: 02-DEC-2002 Insert Date: 12-NOV-2012 Slots: 1.0 | Overview: DB2 Recovery Expert for Multiplatforms DB2 Recovery Expert is one of the most recent IBM Data
Management Tools for Multiplatforms. It provides an easy-to-use
environment that even less experienced DBAs can successfully use,
to complete highly sophisticated and efficient recovery techniques
in minimal time. Built-in SMART (Self-Managing and Resource Tuning)
features provide intelligent analysis of altered, incorrect or
missing database assets - including tables, indexes, or data - and
automate the process of rebuilding those assets to a correct point
in time, often without taking the database or business operations
offline.
This...
|
8. |  SAP on DB2 Universal Database for OS/390 and z/OS: Multiple Components in One Database (MCOD) By: Mike Ebbers; Florence Dubois; Kellie Bohlsen; Tim Bohlsen; Bernd Kohler; Gert Ruland Publisher: IBM Redbooks Publication Date: 19-FEB-2003 Insert Date: 29-OCT-2012 Slots: 1.0 | Overview: SAP on DB2 Universal Database for OS/390 and z/OS: Multiple Components in One Database (MCOD) The Multiple Components in One Database (MCOD) feature of SAP
enables a reduction in the number of DB2 systems that need to be
installed and maintained. This significantly simplifies overall
database administration and is considered one of the major DB2
competitive advantages.
This IBM Redbooks publication will help systems administrators,
database administrators, managers, and operation staff to plan,
implement, and administer an SAP MCOD landscape with DB2 Universal
Database (UDB) for OS/390 and z/OS as the database management
system.
We describe how to merge existing systems into a single...
|
9. |  Moving Data Across the DB2 Family By: Paolo Bruni; Michael Ho; Marko Milek; Arne Nilsen; Jose Mari Michael Sanchez Publisher: IBM Redbooks Publication Date: 14-FEB-2003 Insert Date: 29-OCT-2012 Slots: 1.0 | Overview: Moving Data Across the DB2 Family Moving data across different databases and even different
platforms has been a common task in IT shops for quite some time.
Applications may have been developed independently and over time,
using packages and different technology; and data might reside on
different platforms exploiting the specific platform strong points.
However, there still is a growing need for applications that need
to access all of this data for overall processing.
While new Web related technologies are emerging with the intent
to provide functions to collect and integrate information across
multiple databases and...
|
10. |  Up and Running with DB2 UDB ESE: Partitioning for Performance in an e-Business Intelligence World By: Corinne Baragoin; Alain Fournil; Andrea Hirata Miqui; George Latimer; Susan Schuster; Calisto Zuzarte Publisher: IBM Redbooks Publication Date: 24-MAR-2003 Insert Date: 22-OCT-2012 Slots: 1.0 | Overview: Up and Running with DB2 UDB ESE: Partitioning for Performance in an e-Business Intelligence World Data warehouses in the 1990s were for the privileged few
business analysts. Business Intelligence is now being democratized
by being shared with the rank and file employee demanding higher
levels of RDBMS scalability and ease of use, being delivered
through Web portals.
To support this emerging e-Business Intelligence world, the
challenges that face the enterprises for their centralized data
warehouse RDBMS technology are scalability, performance,
availability and smart manageability.
This IBM Redbooks publication focuses on the innovative
technical functionalities of DB2 UDB ESE V8.1 and...
|
11. |  Siebel 7 with DB2 for z/OS: Database Implementation and Administration Guide By: Viviane Anavi-Chaput; Steve Baker; Richard Corrihons; Rich Dale; Lou Doran; Debra Scott; Lee Siegmund; Xuan Nhut Tran; Marion Wilmot Publisher: IBM Redbooks Publication Date: 18-MAR-2003 Insert Date: 22-OCT-2012 Slots: 1.0 | Overview: Siebel 7 with DB2 for z/OS: Database Implementation and Administration Guide In this IBM Redbooks publication, we describe the
implementation, customization, and administration of the Siebel 7
database with DB2 UDB for z/OS and OS/390 V7 using AIX V5L or
Win2000 Siebel Servers, and we discuss the following
topics:
Installation tasks for setting up a three-tier configuration,
with the application middle tier residing on AIX/Win2000 and the
database tier residing on z/OS. The DB2 Connect EE V7 setup
required to connect the Siebel application server to the DB2
database on z/OS is also discussed.
Customization of the Siebel schema for a...
|
12. |  Scaling DB2 UDB on Windows Server 2003 By: Whei-Jen Chen; Drew Bradstock; David Ceron; Chris Fierros Publisher: IBM Redbooks Publication Date: 22-AUG-2003 Insert Date: 10-OCT-2012 Slots: 1.0 | Overview: Scaling DB2 UDB on Windows Server 2003 As organizations strive to do more with less, DB2 Universal
Database v8.1 on Windows Server 2003 brings unprecedented
enterprise-class scalability to 32-bit and 64-bit Intel platforms.
Supporting both vertical (scale up) and horizontal (scale out)
scaling, DB2 UDB v8.1 represents over a decade of industry proven
scalability with both non-clustered and clustered database
architectures.
This IBM Redbooks publication is designed as an informative
guide to scaling DB2 UDB V8.1 with Windows Server 2003. It is
intended for database and system administrators who need both an
introduction and...
|
13. |  By: Corinne Baragoin; Geetha Balasubramaniam; Bhuvaneshwari Chandrasekharan; Landon DelSordo; Jan B. Lillelund; Julie Maw; Annie Neroda; Paulo Pereira; Jo A. Ramos Publisher: IBM Redbooks Publication Date: 05-SEP-2003 Insert Date: 01-OCT-2012 Slots: 1.0 | Overview: DB2 Cube Views: A Primer Business Intelligence and OLAP systems are no longer limited to
the privileged few business analysts: they are being democratized
by being shared with the rank and file employee demanding a
Relational Database Management System (RDBMS) that is more
OLAP-aware.
DB2 Cube Views and its cube model provide DB2 the ability to
address multidimensional analysis and become an actor in the OLAP
world.
This IBM Redbooks publication focuses on the innovative
technical functionalities of IBM DB2 Cube Views V8.1 to store
multidimensional metadata in DB2 catalog; to build automatically
model-based...
|
14. |  eClient 101 Customization and Integration By: Wei-Dong Zhu; Mike Grasselt; Alan Mayer; Lijing Zhang Publisher: IBM Redbooks Publication Date: 21-OCT-2003 Insert Date: 01-OCT-2012 Slots: 1.0 | Overview: eClient 101 Customization and Integration This IBM Redbooks publication provides a basic introduction to
IBM DB2 Content Manager Version 8 eClient. By providing helpful,
easy-to-understand sample codes and step-by-step instructions, this
book will help you in your next eClient integration and
customization project.
We provide detailed step-by-step instructions on installing
eClient, installing eClient in a WebSphere Network Deployment
environment, and using eClient.
To prepare for eClient customization and integration, we
introduce J2EE, servlets, and JSPs. We cover the eClient
architecture and inspect a basic eClient control...
|
15. |  Streamline Business with Consolidation and Conversion to DB2 for z/OS By: Paolo Bruni; Marcos Caurim; Elise Gotay; Susan Lawson; Glenn McGeoch; Rebecca Poole Publisher: IBM Redbooks Publication Date: 26-SEP-2012 Insert Date: 01-OCT-2012 Slots: 1.0 | Overview: Streamline Business with Consolidation and Conversion to DB2 for z/OS Time to market, flexibility, and cost reduction are among the
top concerns common to all IT executives. If significant resource
investments are placed in mature systems, IT organizations need to
balance old and new technology. Older technology, such as non-IBM
pre-relational databases, is costly, inflexible, and non-standard.
Users store their information on the mainframe and thus preserve
the skills and qualities of service their business needs. But users
also benefit from standards-based modernization by migrating to
IBM® DB2® for z/OS®. With this migration, users
deliver new application...
|
16. |  Preparing for DB2 Near-Realtime Business Intelligence By: Chuck Ballard; Roopa MS; Olaf Mueller; Zhi Yuan Pan; Andy Perkins; Pagadala J. Suresh Publisher: IBM Redbooks Publication Date: 15-MAR-2004 Insert Date: 10-SEP-2012 Slots: 1.0 | Overview: Preparing for DB2 Near-Realtime Business Intelligence In this IBM Redbooks publication we discuss primary processes
and various alternatives that prepare you in implementing a DB2
near-realtime business intelligence environment. We discuss
architectural alternatives and include overviews of software
products that you can use in an implementation. As a primary focus,
we tested the capabilities for supporting continuous update of a
DB2 data warehouse while running a continuous concurrent query
workload against that data warehouse. We tested several
implementation scenarios and the variables that impact them. The
results of our testing and the...
|
17. |  DB2 UDB V8 and WebSphere V5 Performance Tuning and Operations Guide By: Whei-Jen Chen; Peter Z He; Kang Yong Ying; Andreas Paulsen; Sunminder S Saini Publisher: IBM Redbooks Publication Date: 12-MAR-2004 Insert Date: 10-SEP-2012 Slots: 1.0 | Overview: DB2 UDB V8 and WebSphere V5 Performance Tuning and Operations Guide This IBM Redbooks publication discusses the integrated
environment of DB2 UDB and WebSphere Application Server (WAS),
including design considerations, best practices, operation,
monitoring, and performance tuning.
We provide an overview of the architecture and main components
of both WebSphere Application Server V5.0.2 and DB2 UDB V8. We
introduce their key application and system performance tuning
parameters.
We discuss the general steps to get DB2 UDB V8 and WAS V5
working together. We also discuss the available JDBC drivers
shipped with DB2 UDB V8 and their differences. The steps to...
|
18. |  Delivering Continuity and Extreme Capacity with the IBM DB2 pureScale Feature By: Vlad Barshai; Yvonne Chan; Hua Lu; Satpal Sohal Publisher: IBM Redbooks Publication Date: 07-SEP-2012 Insert Date: 10-SEP-2012 Slots: 1.0 | Overview: Delivering Continuity and Extreme Capacity with the IBM DB2 pureScale Feature The IBM® DB2® pureScale® feature offers
clustering technology that helps deliver high availability and
exceptional scalability transparent to applications. The DB2
pureScale feature helps you to meet your business needs around
availability and scalability, and is also easy to configure and
administer.
This IBM Redbooks® publication addresses the DB2 pureScale
feature that is available in IBM DB2 10.1 for Linux, UNIX, and
Windows operating systems. It can help you build skills and deploy
the DB2 pureScale feature. This book bundles all the information
necessary for a in-depth analysis into...
|
19. |  Unleashing DB2 10 for Linux, UNIX, and Windows By: Danny Arnold; Steve Diniro; Vivian Lee; Stan Musker; Jo-Ann Woods Publisher: IBM Redbooks Publication Date: 31-AUG-2012 Insert Date: 03-SEP-2012 Slots: 1.0 | Overview: Unleashing DB2 10 for Linux, UNIX, and Windows This IBM® Redbooks® publication provides a broad
understanding of the key features in IBM DB2® 10 and how to
use these features to get more value from business applications. It
includes information about the following features:
Time Travel Query, which you use to store and retrieve
time-based data by using capability built into DB2 10, without
needing to build your own solution
Adaptive compression, an enhanced compression technology that
adapts to changing data patterns, yielding extremely high
compression ratios
Multi-temperature storage, which you may use...
|
20. |  DB2 SQL Tuning Tips for z/OS Developers By: Tony Andrews Publisher: IBM Press Publication Date: 15-OCT-2012 Insert Date: 29-AUG-2012 Slots: 1.0 | Overview: DB2 SQL Tuning Tips for z/OS Developers The Definitive Solutions-Oriented Guide to IBM® DB2®
for z/OS®: Now Fully Updated for Both v9 and v10!
The largest database tuning performance gains can often be obtained
from tuning application code, and applications that use SQL to
retrieve data are the best candidates for tuning. This
well-organized, easy-to-understand reference brings together more
than 100 SQL-related skills and techniques that any developer can
use to build and optimize DB2 applications for consistently
superior performance.
DB2 tuning expert Tony Andrews (“Tony the Tuner”) draws
on more than 20 years of...
|
©2013 Safari Books Online