Related links:
Title
|
Date
|
|---|---|
| Online DB2 for z/OS migration
Increasingly, customers must keep their applications online and available
all hours of every day, 24X7. Fortunately, the DB2 migration process has been designed
specifically to allow the business application set to continue to run while
you migrate. This article provides hints and tips to make your online migration
successful.
|
16 May 2013 |
| DB2 10: Run Oracle applications on DB2 10 for Linux, UNIX, and Windows
IBM DB2 10 for Linux, UNIX, and Windows has out-of-the-box support for
Oracle's SQL and PL/SQL dialects. This allows many applications written
against Oracle to execute against DB2 virtually unchanged. In this article,
get a high-level overview of what Oracle compatibility means in DB2. Whether
you want to switch your custom application to DB2 or extend your DBMS vendor
support to DB2, now is your time.
|
08 May 2013 |
| Restricting database connections using the CONNECT_PROC database configuration parameter in DB2 for Linux, Unix, and Windows
System administrators are responsible for, among other things, protecting a database against unauthorized access
or misuse by authorized database users (for example, inappropriate access to sensitive information within a database).
A common requirement to mitigate such risks is ensuring that users are allowed to connect to the database only from
a list of trusted hosts or IP addresses that are known to be secure. This article gives a practical example of how
such a requirement can be put in practice by making use of the CONNECT_PROC database configuration parameter of
IBM DB2 for Linux, UNIX, and Windows.
|
02 May 2013 |
| Get the most out of DB2 optimizer: Leveraging statistical views to improve query execution performance
Statistical views provide the necessary sophisticated statistics to the optimizer
to more accurately model complex relationships. In this article, you learn
through examples how to identify these complex relationships and create
statistical views to allow the optimizer to compute more accurate cardinality
estimates.
|
02 May 2013 |
| Verify DB2 Net Search Extender indexes using the NSE Index Verification tool
DB2 Net Search Extender, here after called NSE, is an IBM DB2 extender providing
full text search support in DB2. NSE searches documents stored in columns of database
tables by maintaining its internal text indexes. Rather than searching sequentially
through text documents stored in database columns at query time, NSE uses its text
indexes to search in an efficient manner. Verification of NSE indexes are
vital because the errors reported by the top layer applications on full text index can be
misleading. This unnecessarily delays the problem resolution at the production system. To
prevent such a situation, the NSE Index Verification tool was developed to verify the NSE index
validity and consistency, and to check whether or not indexes are valid.
Also available in:
Chinese
|
25 Apr 2013 |
| DB2 pureScale Feature
The DB2 pureScale Feature keeps your distributed database system available 24x7.
WLB, ACR, and client affinities provide uninterrupted service during both planned and
unplanned outages. If a member fails, applications are automatically rerouted to
other DB2 members. When the failed member comes back online, applications are
transparently routed to the restarted member. With the DB2 pureScale Feature,
scaling your database solution to meet the most demanding business needs is easy.
|
25 Apr 2013 |
| What's new in DB2 10.5 for Linux, UNIX, and Windows
This article outlines the key features and enhancements in IBM
DB2 10.5 for Linux, UNIX, and Windows. To be released in June, this latest
version delivers a wide range of new function that directly addresses your
business needs in the areas of cost reduction, application performance,
productivity, and reliability.
|
23 Apr 2013 |
| Introduction to the DB2 Continuous Data Ingest feature
IBM DB2 10.1 for Linux, Unix and Windows has introduced the Continuous Data Ingest
feature. The INGEST command provides an alternative to the known methods of previous DB2
versions: IMPORT and LOAD. In this article you will understand the main Ingest
concepts and find examples and situations where this tool will help you to populate your
databases.
|
18 Apr 2013 |
| Accelerating batch processing with IBM DB2 Analytics Accelerator
This article provides an overview of the benefits that a company can achieve by introducing IBM DB2 Analytics Accelerator in their batch processing systems.
The example given is
based on real implementations done at Swiss Re, a major re-insurance company based in Zurich, Switzerland.
|
16 Apr 2013 |
| Selected common SQL features for developers of portable DB2 applications
This summary of the common SQL application features is a quick reference for application developers who need to understand the
frequently used features and functions across platforms.
|
28 Mar 2013 |
| Simplify backup and recovery with IBM DB2 Merge Backup
for Linux, UNIX, and Windows
It is important to have an up-to-date and consistent backup available so that you can speed database recovery times.
IBM DB2 Merge Backup for Linux, UNIX and Windows gives you alternative strategies to eliminate the need to take regular DB2 full
backups and instead use multiple delta and incremental backups to build a new full
backup copy that is fully recognized by DB2. This step-by-step article introduces you
to IBM DB2 Merge Backup and teaches you how to create merge backups using the control file structure in IBM DB2 Merge Backup.
|
28 Mar 2013 |
| Zigzag join enablement for DB2 star schema queries
IBM DB2 10.1 Linux, UNIX, and Windows introduces a new join method called zigzag join. Zigzag join
improves consistency in performance as well as reduces the execution time of
queries in data warehouse or data mart environments with large volumes of
potentially partitioned data, complex ad hoc queries, and where database
design uses a star schema. This article provides insight into the eligibility
criteria of selecting the zigzag plan, how the zigzag join method works, using
a zigzag join with a gap in the fact table multi-column index, using the
ZZJOIN operator, and using the index advisor for zigzag join.
|
21 Mar 2013 |
| DB2 Tools corner: Using IBM Tools Customizer for z/OS in a multiple-LPAR environment
Although Tools Customizer currently supports only the local LPAR, you can use several methods to customize products on multiple LPARs where Tools Customizer
is not installed.
Also available in:
Russian
|
14 Mar 2013 |
| Capture and store DB2 performance data in an easy way
Did you ever wonder how you can collect performance data about your DB2
system in a simple way without using extra tools? In this article, learn
how to leverage the new DB2 for Linux, UNIX, and Windows monitoring framework available
in V10.1 (initially introduced in version 9.7). The article also explains how to combine DB2
utilities to select, capture, and store data that you can use for analysis with plain SQL
or using BI tools.
Also available in:
Russian
|
14 Mar 2013 |
| A guided tour to IBM Database Patterns, Part 4: Provision and manage your database using the REST API and command-line
interface
IBM Database Patterns provides solutions to easily provision and manage databases
on IBM Workload Deployer (IWD) in a private cloud. IWD is a cloud management appliance
that delivers a patterns-based approach to deploy and manage application
environments in the cloud. The REST API and command-line interface enables you to use IBM
Database Pattern in batch processing with no GUI, thereby allowing it to be mashed up
into existing applications and user interfaces.
|
07 Mar 2013 |
| Choice of SUPERASYNC mode for disaster recovery using DB2 HADR
DB2 High Availability Disaster Recovery (HADR) is an easy-to-use data replication
feature of IBM DB2 for Linux, UNIX, and Windows that provides a high availability (HA)
solution for both partial and complete site failures. Beginning with DB2 V9.5 Fix Pack 8
and DB2 V9.7 Fix Pack 5, a new HADR sync mode called SUPERASYNC has been introduced.
This article explains the purpose of SUPERASYNC mode, the deployment of a HADR pair using this
mode, as well as standby state transition in this mode. In addition, it includes use case
scenarios that explain the implementation of SUPERASYNC mode for disaster recovery.
It will also look at how Primary will overcome the back pressure and
perform better in case of single or multiple standby, and what the benefits
and drawbacks are from using this mode.
|
14 Feb 2013 |
| What's new in RDF application development in DB2 10.1 Fix Pack 2
Beginning with DB2
10.1 for Linux, UNIX, and Windows, DB2 has supported RDF data and SPARQL
application development. In this article, learn about important enhancements for RDF
application development that were added in DB2 10.1 Fix Pack 2.
|
07 Feb 2013 |
| Configure Data Facility Storage Management Subsystem for DB2 10 for z/OS
installation
Installation of DB2 10 requires configuring z/OS Storage Management Subsystem
(SMS) for DB2 system objects, and migrating the system data sets to SMS to exploit its
benefits. Since the migration to DB2 10 is possible from DB2 8, some customers, upon
reaching DB2 10 new-function mode (NFM), can benefit from many features related to
z/OS SMS, including those introduced in DB2 9. This article will help you in
reorganizing DB2 catalog and directory objects.
|
07 Feb 2013 |
| Road map to real-time monitoring in DB2 for Linux, UNIX, and Windows
Are you wondering where to find the information you need to learn about and start using the
real-time monitoring information available in the DB2 for Linux, UNIX, and Windows product?
This article sets out a path through the documentation that will help you deal with this question
by providing direct links to the appropriate topics in the Information Center.
|
07 Feb 2013 |
| Save energy with the DB2 10.1 for Linux, UNIX, and Windows data compression feature
The DB2 for Linux, UNIX, and Windows data compression feature allows you to store your data in a compact form.
There are two known benefits of this approach: first, reduction of storage space, and second, improvement of performance.
In this article we describe a case study showing the third benefit: reduction of electricity consumption per unit of work.
As a result, data compression reduces the cost of database maintenance and
makes your database greener.
Also available in:
Spanish
|
07 Feb 2013 |
| Choosing partitioning keys in DB2 Database Partitioning Feature
environments
Choosing proper partitioning keys is important for optimal query
performance in IBM DB2 Enterprise Server Edition for Linux, UNIX, and Windows
environments with the Database Partitioning Feature (DPF). To help with this
task, this article provides new routines to estimate data skews for existing
and new partitioning keys. The article also details best practices and shows
how to change a partitioning key while keeping the table
accessible.
|
04 Feb 2013 |
| Using DB2 for z/OS pureXML to process SEPA transactions
Single Euro Payments Area (SEPA) is a payment integration mechanism widely used in Europe to handle standard payment messages. Each SEPA document
can contain up to 100,000 credit transfer transactions and must be processed
accurately in a short period of time. This article outlines the author's experience in
performing a benchmark for a large European corporate and investment bank using DB2 for z/OS
pureXML for SEPA (ISO 20022). Learn how the team resolves obstacles and
eventually achieves their performance goal.
|
31 Jan 2013 |
| DB2 pureScale disaster recovery using Storwize V7000 Metro Mirror
The DB2 pureScale feature leverages the IBM Storwize V7000 storage system
synchronous remote copy function like Metro Mirror to maintain an identical copy on both
the primary and secondary volumes for the disaster recovery purposes. The Metro Mirror
features enable you to set up a relationship between two volumes, so that updates that
are made by an application to one volume are mirrored on the other volume. The volumes
can be in the same system or on two different systems. Read on to learn the steps
required to deploy a Metro Mirror solution with the Storwize V7000 storage
subsystem.
|
31 Jan 2013 |
| Using section explain in InfoSphere Optim Query Workload Tuner for DB2 for
Linux, UNIX, and Windows 3.2
Take advantage of the section explain feature in DB2 for Linux, UNIX,
and Windows 9.7.1 and later when you tune SQL with InfoSphere Optim Query Workload
Tuner 3.2.
|
24 Jan 2013 |
| Utilizing the DB2 HADR reads on standby feature in a business intelligence
environment
The DB2 High Availability and Disaster Recovery (HADR) feature is a
database replication method that provides a high availability solution for both partial
and complete site failures. HADR protects against data loss by replicating data changes
from a source database, called the Primary, to a target database, called the Standby.
The HADR reads on standby (HADR ROS) feature, allows read only applications to access
either the HADR Primary or the HADR Standby database. This enables an organization to
offload some of the read-only workloads running on the Primary to the Standby database.
This paper shows a practical application of this HADR ROS feature in conjunction with
Virtual IP addresses to ensure continued, automatic connectivity in an Business
Intelligence Environment.
|
24 Jan 2013 |
| Deploying DB2 pureScale with IBM Storwize V7000 6.4.0.1
A key aspect to the DB2 pureScale solution lies around the capabilities
of the underlying storage. In addition to that, DB2 pureScale takes advantage of
specific storage capabilities to enhance the solution. This paper will take you through
the value proposition of DB2 pureScale on IBM Storwize V7000 storage demonstrating a
solution that meets the needs of even the most demanding businesses.
|
10 Jan 2013 |
| Tips for using SQL to query foreign key relationships
This article discusses how to write SQL queries to find foreign key
relationships in IBM DB2 for Linux, UNIX, and Windows database. Given a
table with a primary key, you will learn how to return the children and
descendant tables, as well as the referential integrity (RI) relationship
paths from the parent table to these children and descendants. Also, you
will see how the query can be modified to return the results for all tables
in the database.
|
10 Jan 2013 |
| Configuring DB2 pureScale for backup and restore using Storwize V7000 V6.4.0.1
FlashCopy
The DB2 pureScale feature leverages the IBM Storwize V7000 storage system
FlashCopy services to mitigate critical requirements from the customer in an extremely
efficient manner. The FlashCopy function enables you to make point-in-time, full volume
copies of data, with the copies immediately available for read or write access. This
article describes the steps required to deploy a FlashCopy solution with the Storwize
V7000 storage subsystem.
|
03 Jan 2013 |
| Sybase to DB2 migration, Part 4: Issues and resolutions
Information assets are key to day-to-day business. They are also a huge
source of institutional value and intellectual property that must be preserved,
extended, and repurposed as the systems underpinning them change. Given the current
business environment, migration has taken on strategic importance for a number of
reasons. This article helps you to understand and map various features and data types of
Sybase and DB2.
|
20 Dec 2012 |
| Sybase to DB2 migration, Part 3: Test strategy
Information assets are key to day-to-day business. They are also a huge
source of institutional value and intellectual property that must be preserved,
extended, and repurposed as the systems underpinning them change. Given the current
business environment, migration has taken on strategic importance for a number of
reasons. This article helps you to understand various processes, verifications, and
validations of post database migration.
Also available in:
Chinese
|
13 Dec 2012 |
| Data mining techniques
Examine different data mining and analytics
techniques and solutions. Learn how to build them using existing software
and installations.
Also available in:
Russian
Vietnamese
|
11 Dec 2012 |
| Configure FIPS mode for DB2 and WebSphere
Learn the necessary steps to configure an application
to be compliant with the US Federal Information Processing Standard (FIPS). The
application in this article uses DB2 and WebSphere in a Windows system.
|
11 Dec 2012 |
| Sybase to DB2 migration, Part 2: Integrity check guidelines
Information assets are key to day-to-day business. They are also a huge source of
institutional value and intellectual property that must be preserved, extended, and
re-purposed as the systems underpinning them change. Given the current business
environment, migration has taken on strategic importance for a number of reasons. This
article helps you to understand the integrity check process for various database objects
while migrating the databases to DB2.
Also available in:
Chinese
|
06 Dec 2012 |
| Set up DB2 for Linux, UNIX, and Windows for high availability using
Microsoft Cluster Server
IBM DB2 for Linux, UNIX, and Windows has a number of options to
provide high availability for production systems such as high availability
and disaster recovery (HADR), DB2 pureScale, and DB2 MSCS. This article shows you how to set up a
DB2 cluster in a virtual Microsoft Windows environment, including how to quickly set up a
training and testing system in a virtual environment such as the cloud.
This article will also help you to learn and practice db2MSCS without special hardware.
Finally, simple troubleshooting methods are introduced to help you with
common issues. This article is an update of a previously published white paper on ibm.com.
|
06 Dec 2012 |
| Getting Started With Fit for Purpose Architectures
We are going to revisit Fit for Purpose architectures today. It has been encouraging to see how quickly customers have picked up the Fit for Purpose concept and how many are now thinking in terms of matching the compute problem to the best underlying compute paradigm.
|
04 Dec 2012 |
| Migrating Data from a Mainframe to a Distributed Environment
The Data Movement Tool is easy to install and flexible to operate. It can be run from the command line or a GUI. Importantly, the Data Movement Tool allows the selection of objects that you want to copy. You can copy individual objects, entire database, objects by authID, or schema.
|
04 Dec 2012 |
| Sybase to DB2 migration, Part 1: Process and methodology
Information assets are key to day-to-day business. They are also a huge
source of institutional value and intellectual property that must be preserved,
extended, and re-purposed as the systems underpinning them change. Given the current
business environment, migration has taken on strategic importance for a number of
reasons. The benefits of rationalizing processes and systems hinges on outcomes where
services and functionality are as good or better than before, while free of costly
redundancies or unnecessarily diverse technologies. Poorly executed migrations diminish
these returns and fail to meet the "as good as or better than before" criteria.
Also available in:
Chinese
|
29 Nov 2012 |
| Maintaining DB2 Analytics Accelerator in a DB2 for z/OS data
sharing environment
The IBM DB2 Analytics Accelerator (IDAA) is a workload optimized appliance
that uses both System z and Netezza technologies. In this article, learn
how to maintain IDAA in configurations other than the standard
configuration of connecting a single IDAA to a single DB2 subsystem or to a
single member of a DB2 data sharing group.
|
29 Nov 2012 |
| Mining your package cache for problem SQL in DB2 for Linux, UNIX, and
Windows
In both OLTP and DSS database environments, DBAs can use information stored in the package cache to find problematic SQL statements either before or after they
begin to negatively impact performance. While there are many third party tools available that can be used to identify and analyze problematic SQL, by executing a few
simple queries, DBAs can locate such SQL without having to use one of these tools. This article shows you how to mine package cache data using some of those queries.
Also available in:
Russian
Portuguese
|
21 Nov 2012 |
| Shredding XML in DB2 with pureXML and XMLTable
DB2's XML processing capability makes it simpler to turn XML data into relational data.
The built-in XMLTABLE function provides an easy-to-use and powerful mechanism to turn hierarchical XML data into parent-child relational data.
Whether your tools do not support XML, or relational processing is required, XMLTABLE provides a means to bridge the gap.
|
15 Nov 2012 |
| IBM federated database technology
In a large modern enterprise, information is almost inevitably distributed among several database management systems. Despite considerable attention from the
research community, relatively few commercial systems have attempted to address this issue. This article describes the technology that enables clients of IBM's
federated database engine to access and integrate the data and specialized computational capabilities of a wide range of relational and nonrelational data sources.
Also available in:
Japanese
|
13 Nov 2012 |
| Enable DB2 in OpenStack
OpenStack is a cloud operating system that controls large pools of compute,
storage, and networking resources throughout a data center. All resources are managed
through a dashboard that gives administrators control while empowering users to
provision resources through a web interface. OpenStack supports MySQL, SQLite and
PostgreSQL as its default databases. In this article, the author shows you how to
quickly enable OpenStack to support DB2.
|
05 Nov 2012 |
| Improve index analysis with DB2 10.1
One of the most challenging parts of index design is verifying that IBM DB2
is using a particular index in a way that was intended. Explain output for an SQL
operation can show whether an index is being utilized, but it can be extremely difficult
and time consuming to generate Explain data for every SQL statement found in an
application. Not to mention the fact that looking for index usage in the volumes of
Explain data that such an endeavor might produce would be extremely tedious.
Furthermore, many applications use dynamic SQL that is generated on-the-fly, which means
that one or more SQL statements coded in an application can have hundreds or even
thousands of variations. And each variation can result in a different data access path,
with some utilizing available indexes and others relying solely on table scans. This
article is designed to introduce you to an object and a set of new table functions that
can be used to analyze index usage in DB2 10.1 for Linux, UNIX, and Windows
databases.
|
01 Nov 2012 |
| Boost JDBC application performance using the IBM Data Server Driver for JDBC and
SQLJ
Developing high performing JDBC applications is not an easy task. This article
helps you gain a better understanding of the factors that contribute to your JDBC
application performance using the IBM Data Server Driver for JDBC and SQLJ to
access DB2 and Informix. Learn to
identify these issues and to find and alleviate client-side bottlenecks.
|
01 Nov 2012 |
| Adopting temporal tables in DB2, Part 2: Advanced migration scenarios for system-period temporal tables
The temporal capabilities in IBM DB2 Version 10 provide powerful tools
for time-based data management. At the core of the temporal features in DB2 are three
types of temporal table: system-period temporal tables, application-period temporal
tables, and bitemporal tables. This articles series explains how to migrate existing
tables and temporal solutions to temporal tables in DB2. Part 1 of the series has
described basic scenarios for adopting system-period temporal tables in DB2. In this
second part we discuss three additional and slightly more advanced scenarios for
migrating to system-period temporal tables.
Also available in:
Chinese
|
25 Oct 2012 |
| Virtualize the IBM DB2 pureScale Feature on Linux using Kernel-based Virtual Machine
Learn how you can improve your return on investment when
you deploy the IBM DB2 pureScale Feature with Linux on IBM System x servers. Modern System x servers
have an ample number of cores and amount of memory and I/O capability. By using virtualization
technology, you can deploy multiple DB2 pureScale instances on a common
infrastructure and achieve greater efficiency.
Also available in:
Portuguese
|
25 Oct 2012 |
| Adopting temporal tables in DB2, Part 1: Basic migration scenarios for system-period tables
The temporal features in IBM DB2 Version 10 provide rich functionality for
time-based data management. Temporal tables in DB2 can record the complete history of
their data changes so that you can "go back in time" and query any past state of your
data. Temporal tables also enable you to track and manage the business validity of your
data, indicating when the information is valid in the real world. This articles
series explains how to migrate existing tables and temporal solutions to temporal tables
in DB2. Part 1 of the series describes basic scenarios for adopting system-period
temporal tables in DB2.
Also available in:
Chinese
|
18 Oct 2012 |
| Use Tivoli Storage Manager to back up and recover a DB2
database
This article describes the basics of IBM Tivoli Storage Manager and IBM DB2
architecture, and shows you how to use the Tivoli Storage Manager backup and restore features.
This article also provides step-by-step instructions that show you how to back up and restore
data on a Tivoli Storage Manager server for the DB2 database.
This document can be used as a guide for DB2 database administrators and Tivoli Storage Manager administrators.
|
17 Oct 2012 |
| Automated DB2 10 for Linux, UNIX, and Windows failover solution using
shared disk storage
This paper describes a distinct configuration of an automated IBM DB2
for Linux, UNIX, and Windows software failover solution that uses shared disk storage.
|
04 Oct 2012 |
| Open Source Big Data for the Impatient, Part 1: Hadoop tutorial: Hello World with Java, Pig, Hive, Flume, Fuse, Oozie, and
Sqoop with Informix, DB2, and MySQL
This article is focused on explaining Big Data and then providing simple worked
examples in Hadoop, the major open-source player in the Big Data space. You'll be happy
to hear that Hadoop is NOT a replacement for Informix or DB2, but in fact plays nicely with
the existing infrastructure. There are multiple components in the Hadoop
family and this article will drill down to specific code samples that show the capabilities.
No Elephants will stampede if you try these examples on your own PC.
|
27 Sep 2012 |
| DB2 Text Search, Part 5: Scheduling updates for DB2 Text Search indices
IBM DB2 Text Search enables users to create full-text
indices in a DB2 for Linux, UNIX, and Windows database. Full-text
indices are updated asynchronously, and it is necessary to explicitly and regularly start
text index updates to ensure that an index properly reflects the content of the base
table. A convenient mechanism to automate this is to use a scheduler to start regular
updates in the required frequency. This article provides information about scheduling
options and discusses troubleshooting the default scheduling mechanism.
Also available in:
Chinese
|
27 Sep 2012 |
| DB2 UDB security, Part 4: Understand how authorities and privileges are implemented in DB2 UDB
A series of articles about IBM DB2 Universal Database for Linux, UNIX, and Windows (DB2 UDB) V8.2 security features would not be complete without a discussion of the different administrative authority levels and privileges. This article is the fourth part of a series that examines the security features available in DB2 UDB V8.2. It reviews the different administrative authority levels and privileges available in DB2 UDB and how they can be granted to and revoked from user and group accounts.
Also available in:
Chinese
|
20 Sep 2012 |
| Accelerating migration from Oracle database-based Pro*C applications to DB2
embedded SQL C
As part of the continuous enhancements happening with respect to Oracle
compatibility in DB2, number of Oracle Pro*C features supported in DB2 has been on the
rise ever since it began with DB2 LUW 9.7 fix pack 5. With the list of features growing
in DB2 V 10.1,migrating an existing pro*c applications would is no more a big
challenge. The tips and techniques as mentioned in this article would help really speed
up the Pro*c migration. All of these are based on real-time migration projects. This would
be really helpful for anyone planning to migrate their Pro*C based applications to DB2
LUW 10.1.
Also available in:
Chinese
|
13 Sep 2012 |
| Tune DB2 database on Windows in eight simple steps
Performance issues can be difficult to diagnose and fix. Often
issues crop up when least expected. Usually, they gradually
develop and sometimes can cause outage of the application using the database. It is
important from the DBA's point of view to be aware of a proactive approach to addressing
performance even before it starts hurting the business. This article discusses an
analytical process that will help DBAs to get to the root of the issue in a few simple
steps.
Also available in:
Chinese
|
13 Sep 2012 |
| Deploying the DB2 pureScale Feature with EMC Symmetrix VMAX
In today's highly competitive marketplace, it is important to deploy a data processing
architecture that not only meets your immediate tactical needs but also can grow and change
to adapt to your future strategic requirements. In December 2009, IBM introduced the DB2
pureScale Feature for Enterprise Server Edition software (DB2 pureScale Feature).
The DB2 pureScale Feature builds on familiar and proven design features from the IBM DB2 for
z/OS database software (DB2 for z/OS), bringing the industry-leading technology and
reliability of DB2 for z/OS to the open systems platform.
|
06 Sep 2012 |
| Diagnosing corruption when using IBM DB2
Learn how to identify and categorize the most common corruption
issues while using IBM DB2. In this article, learn corrective and preventive techniques
that you can implement to combat unpleasant corruption issues.
Also available in:
Chinese
Portuguese
|
16 Aug 2012 |
| Handling access-plan changes using InfoSphere Optim Query Workload Tuner on DB2 for z/OS
Access-plan changes can happen at any point during the
database-application or data-server maintenance lifecycle. It is important for DBAs to
handle these changes quickly and effectively. However, most DBAs lack tools to deal with
access-plan changes in large numbers of packages in enterprise-scale applications.
In this article, we describe methods of managing query access plans in such situations.
We also introduce a tool provided in IBM InfoSphere Optim Query Workload Tuner
3.1 to implement these methods.
Also available in:
Russian
|
19 Jul 2012 |
| Enable RDMA capabilities for DB2 with Socket Direct Protocol
LAN networking devices, like host adapters and Ethernet switches,
have evolved over the last few years, making it possible to achieve throughput
as high as 40Gbps, as well as network latency below one microsecond. Computing power
and LAN devices are no longer a bottleneck. Instead, protocols like TCP have
become the real bottleneck in this new world of high-performance hardware.
To overcome the limitations of TCP, new protocols like Remote Direct Memory Access (RDMA)
have been developed. This article will explain a cost-effective method for enabling RDMA
capabilities in DB2 client server environments without requiring recoding and recompiling
the existing applications.
|
19 Jul 2012 |
| Managing time in DB2 with temporal consistency
The new temporal features in DB2 10 provide rich capabilities for time-based data
management. For example, a date range can be assigned to each row of data to indicate
when a row is deemed valid by your applications or business. Tables enabled to track
such business validity are called application-period temporal tables and their business
time periods can be in the past, present, or future. For a parent table and a child
table that have a foreign key relationship, the notion of referential integrity can be
extended to consider not only the traditional key value, but also the business time
period of any given row. This article explains such temporal referential integrity and
how time-based consistency can be enforced in DB2. The content of this article is applicable to DB2 for z/OS and DB2 for Linux, UNIX, and Windows. All SQL samples in this article have been tested in DB2 10.1 for Linux, UNIX, and Windows.
|
12 Jul 2012 |
| Develop patterns for IBM PureApplication System
During the process of implementing and validating real ISV business applications on the IBM PureApplication System, the authors gathered some best practices, tips, and how-tos for developing both virtual application patterns (VAPs) and virtual system patterns (VSPs). In this article, the authors share some of those secrets with virtual pattern developers to guide them through their pattern development process.
|
09 Jul 2012 |
| A guided tour of IBM Database Patterns, Part 2: Database image management
IBM Database Patterns provides solutions to easily provision and manage
databases on IBM Workload Deployer (IWD) in a private cloud. In this article, learn how to create database images and new
databases using database images in IBM Database Patterns 1.1.0.1.
|
28 Jun 2012 |
| A guided tour of IBM Database Patterns, Part 3: Database workload standards
IBM Database Patterns provides solutions to easily provision and
manage databases on IBM Workload Deployer (IWD) in a private cloud. A database workload standard in IBM Database
Patterns is a set of configuration settings used to create database patterns or
databases directly. Learn the concepts of database workload standards and related
details, including how to create database workload standards, how to manage their
life cycles, and how to deploy databases with them.
|
28 Jun 2012 |
| DB2 pureScale enablement
This paper describes the concept of DB2 workload balancing (WLB) and client
affinities. This paper provides detailed examples to illustrate how to enable and
use these features to access DB2 pureScale cluster from WebSphere Application
Server and various stand-alone DB2 clients. This paper also demonstrates how
automatic client reroute (ACR) routes application requests among pureScale members
when an outage occurs. In addition, this paper provides tips on how to recover from
a non-responsive TCP/IP layer along with how to provide alternate servers for the
first connection to ensure successful access to the DB2 pureScale database.
Also available in:
Chinese
|
28 Jun 2012 |
| DB2 10.1 HADR Multiple Standbys
Beginning in DB2 LUW version 10.1, the high availability disaster
recovery (HADR) feature supports up to three standby databases, allowing you
to provide both high availability (HA) and disaster recovery (DR) protection
to a database with a single technology. This paper shows how HADR multiple standbys can be
set up, configured, and monitored. Through various examples, you will also
learn how HADR multiple standby behaves in different failure scenarios, and
how you can utilize multiple standbys with other HADR features.
Also available in:
Chinese
|
21 Jun 2012 |
| DB2 10 for z/OS: A compelling case for upgrading
Learn how DB2 for z/OS V10 compares with its predecessors and
get an introduction to some of the salient features of DB2 10 for Z/OS.
Also available in:
Russian
|
14 Jun 2012 |
| An inside look at DB2 Advanced Enterprise Server Edition, Part
1: Performance management and storage optimization
IBM DB2 Advanced Enterprise Server Edition (AESE) is a bundle of
software that packages IBM DB2 Enterprise Server Edition V10 with optimization, development,
and management tools for a single prize. A comprehensive solution for managing critical aspect of DB2 environments, it simplifies the acquisition and use of core database features and complimentary tools for development and deployment, administration,
storage optimization, and performance optimization. With the inclusion of these
capabilities in one package, you can reduce costs and improve your ability to manage the DB2 environment. This article focuses on performance management and storage optimization.
Also available in:
Chinese
Vietnamese
|
14 Jun 2012 |
| The SQL Reference for
Cross-Platform Development
Great news for people who want to write portable applications!
This reference makes it easy for you to develop
applications using SQL that is portable across the DB2 database family, including DB2
for z/OS Version 10, DB2 for i Version 7.1, and DB2 for Linux, UNIX, and Windows
Version 9.7.
Also available in:
Russian
|
13 Jun 2012 |
| A guided tour of IBM Database Patterns, Part 1: Introducing IBM Database Patterns
IBM Database Patterns provide solutions to easily provision and manage
databases on IBM Workload Deployer (IWD) in a private cloud. IWD is a cloud management appliance that delivers a patterns-based
approach to deploying and managing application environments in the cloud. This
article introduces IBM Database Patterns 1.1.0.1,
and explains how it works in IWD.
|
07 Jun 2012 |
| Use OData with IBM DB2 and Informix
This article provides a brief introduction to OData, a Web API for data access.
It then goes on to describe how OData can be used with IBM DB2, for Linux, UNIX, and Windows,
for z/OS, and for Informix. Finally, it provides step-by-step instructions for exposing
OData from DB2 in conjunction with Microsoft Visual Studio.
|
31 May 2012 |
| Starting your education in big data
Learn about current free, online courses that are available at
BigDataUniversity.com. Follow the suggested path to get started and grow your
knowledge on big data, and get ready to implement it to meet your own business needs.
|
24 May 2012 |
| Which distributed edition of DB2 10.1 is right for you?
Learn the details of what makes each edition of DB2 10.1 for Linux, UNIX,
and Windows unique. The authors lay out the specifications for each edition,
licensing considerations, historical changes throughout the DB2 release
cycle, and references to some interesting things customers are doing with DB2.
This popular article will be updated during the release for any intra-version
licensing changes announced in future Fix Packs.
|
24 May 2012 |
| Compare the distributed DB2 10.1 database servers
In a side-by-side comparison table, the authors make it
easy to understand the basic licensing rules, functions, and feature
differences between the members of the distributed DB2 10.1 for Linux, UNIX,
and Windows server family as of April 30, 2012.
|
24 May 2012 |
| Licensing distributed DB2 10.1 servers in a high availability (HA)
environment
Are you trying to license your IBM
DB2 Version 10.1 for Linux, UNIX, and Windows servers correctly in a high availability environment?
Do you need help interpreting the announcement letters and licenses?
This article explains it all in plain
English for the DB2 10.1 release that became
generally available on April 30, 2012.
|
24 May 2012 |
| Get the most from the DB2 HADR standby database
DB2 High Availability Disaster Recovery (HADR) is an easy-to-use
data replication feature that provides a high availability (HA)
solution for both partial and complete site failures. Beginning with DB2 V9.7
Fix Pack 1, the standby database permits read access from user applications.
This article explains how this capability can be used for read applications,
and what the current limitations are. In addition, it includes suggestions
for how you can utilize the potential of the standby database.
|
17 May 2012 |
| Optimize storage with deep compression in DB2 10
Organizations are generating more data now than at any other time in history. And the need to comply with legal and governmental
regulations means that they're keeping that data around for longer periods of time. As a result, databases are growing at an astonishing
rate. In fact, according to industry analysts, enterprise databases are growing at the rate of 125 percent annually. This explosion in
data volume places tremendous pressure on enterprises to store, protect, distribute, and derive value from all the data being generated.
In 2007, IBM responded to this pressure by introducing new compression technology, known as Deep Compression, in DB2 Version 9. Since then,
IBM has improved this technology in subsequent releases of DB2. This article describes the various compression methods that are available
in DB2 Version 10.1, as well as provides recommended "best practices" that will help you achieve maximum storage space savings when you
adopt any of the compression techniques available.
|
17 May 2012 |
| DB2 Tools corner: Introducing the IBM-supported batch interface for change management in DB2 Administration Tool for z/OS V10.1 and DB2 Object Comparison Tool for z/OS V10.1
Now you can use the new batch interface enhancement for managing changes to DB2 for z/OS objects
and authorizations with DB2 Administration Tool for z/OS and DB2 Object Comparison Tool for z/OS.
This enhancement lets you create, customize, and reuse batch jobs to match how you manage changes to DB2 for z/OS.
|
10 May 2012 |
| Test drive DB2 10.1 using a virtual appliance
IBM virtual appliances allow you to easily experience
the power of IBM software, such as
DB2 for Linux, UNIX, and Windows, without having to go through the
setup process for either the operating system or IBM software. The virtual
appliances are provided with pre-installed operating systems, and
additionally, they deeply integrate IBM software in VMware virtual machines.
|
03 May 2012 |
| DB2 Express-C 10: Even more value
In our industry, six years is forever. By this measure DB2 Express-C has
been around for an eternity.
Introduced in 2008 as a free version of the IBM's DB2 DBMS, DB2 Express-C quickly became very popular
with DBAs, application developers, students and ISVs. On April 30, 2012 after
6 years in the market with numerous updates, DB2 Express-C 10 was released for anyone to download
or to use on the cloud free of charge. We would not have it any other way.
|
30 Apr 2012 |
| DB2 V10.1 Query performance enhancements
A number of performance improvements have been included in DB2 Version 10.1
to improve the speed of many queries. These improvements are automatic; there are
no configuration settings or changes to the SQL statements required.
Also available in:
Chinese
|
30 Apr 2012 |
| DB2 V10.1 Multi-temperature data management
recommendations
Data in a data warehouse can be classified according to its temperature.
The temperature of data is based on how old it is, how often it is accessed,
how volatile it is, and how important the performance of the queries that access
the data is. Hot data is frequently accessed and updated, and users expect optimal
performance when they access this data. Cold data is rarely accessed and updated,
and the performance of the queries that access this data is not essential.
Also available in:
Chinese
|
30 Apr 2012 |
| Implementing IBM DB2 9.7 Enterprise Server edition with Microsoft Failover
Clustering
Configuring a high availability solution with DB2 and Microsoft Failover
Clustering is much easier with the sample configurations provided in this detailed paper.
|
24 Apr 2012 |
| Use SQL-like languages for the MapReduce framework
Select the most suitable MapReduce implementation for large scale data analysis jobs based on your skills, preferences, and requirements. MapReduce is a simple and powerful programming model that enables the easy development of scalable parallel applications to process vast amounts of data on large clusters of commodity machines. It isolates the application from the details of running a distributed program. But many programmers are unfamiliar with the MapReduce programming style and prefer to use a SQL-like language to perform their tasks. In this article, read an overview of high-level languages and systems designed to tackle these problems and add declarative interfaces on top of the MapReduce framework.
|
17 Apr 2012 |
| Use concurrent I/O to improve DB2 database performance
Concurrent I/O is a feature that was introduced in UNIX/Linux platforms mainly for the
benefit of relational database systems. This article explains the difference between the I/O
mechanisms available with UNIX/Linux file systems, and shows how concurrent I/O technology
can be leveraged in a DB2 environment to improve database performance.
Also available in:
Chinese
|
12 Apr 2012 |
| Preparing for IBM
PureApplication System, Part 3: Choosing a database option
Part 3 of the article series
introduces the integrated DB2 database formats that are found in IBM
PureApplication System. It describes the different forms of DB2 found in
PureApplication System, helps you decide which forms to choose in
different situations, and covers some of the recommended best practices
using DB2 inside PureApplication System.
|
11 Apr 2012 |
| DB2 10: What's new in DB2 10 for Linux, UNIX, and Windows
This article outlines the key features and enhancements in IBM DB2 10 for Linux, UNIX, and Windows. To be released in June,
this latest version delivers new functionality that directly addresses your business needs in the areas of cost reduction,
application performance, productivity, and reliability.
|
03 Apr 2012 |
| A matter of time: Temporal data management in DB2 10
You could say it was just a matter of time.
Industry regulations and competitive pressures are prompting IT managers to maintain more data for longer periods of time and to provide better ways for business users to analyze past, current, and future events.
To help organizations achieve these goals, IBM has built greater awareness of time into DB2.
Also available in:
Chinese
|
03 Apr 2012 |
| Configure automatic maintenance in DB2 for Linux, UNIX, and Windows using
IBM Data Studio
The automatic maintenance capabilities of IBM DB2 for Linux, UNIX, and Windows
relieves DBAs so that they can focus on other vital tasks such as maximizing performance.
This article demonstrate how to configure the automatic maintenance capabilities in DB2 for performing database backups, keeping
statistics current,
and reorganizing tables and indexes as necessary, using IBM Data Studio.
Also available in:
Chinese
|
29 Mar 2012 |
| Moving a PHP application to DB2 from MySQL, Part
4: Deploy your application
Learn why you should move a PHP application to DB2(R), how to plan
the migration, how to execute it, how to support it, and how to
handle
potential risks based on the experience of an IBM Intranet
application case
study. This four-part series shares lessons from a
successful
MySQL-to-DB2
migration for a mission-critical PHP Intranet
application used by 4,000 global
users within IBM to support content
production for ibm.com. Part 4 describes the
steps taken to deploy and support the application.
|
08 Mar 2012 |
| Migrate DB2 Net Search Extender indexes to DB2 Text Search
In order to leverage the latest capabilities in DB2 for Linux, UNIX, and
Windows for full text search, users of DB2 Net Search Extended should migrate
to DB2 Text Search. This article explains how to migrate from Net Search
Extender to DB2 Text Search indexes, and what to consider when
planning your migration.
|
08 Mar 2012 |
| DB2 Text Search, Part 4: High-availability setups with DB2 Text Search
DB2 Text Search enables creating full-text search applications in a DB2 Database for Linux, UNIX, and Windows. For
scenarios where a high availability of the full-text search applications is
required, a fail-over strategy must take into account
that a DB2 Text Search setup involves two components, the DB2 database server and the text search server. Text search index catalog
data and text search index administration data are stored in the database and included in the DB2 High Availability Disaster Recovery
(HADR) strategy. However, the text search index collections are managed by the text search server and are located on the file system.
An extension of the database HADR strategy is therefore required to include the objects managed by the text search server.
Also available in:
Chinese
|
01 Mar 2012 |
| Data.gov for government agencies
Because people are more aware of the value of open data,
entire new economies have sprung up around its use and management. In
2009, the U.S. Federal Government launched Data.gov, a site to aggregate
feeds of government data. Pressure on agencies to publish information at
Data.gov has been steady. The Open Government Directive of 2009 requires
all Federal agencies to post at least three high-value data sets online
and register them on Data.gov. Learn about Data.gov, the basic information
your agency needs to know to participate in this revolution in government,
and ideas for doing so efficiently.
Also available in:
Russian
Portuguese
|
28 Feb 2012 |
| DB2 Text Search, Part 3: What to consider when planning text index backups
IBM DB2 Text Search enables users to create
full-text search applications in a DB2 for Linux, UNIX, and
Windows database. Full-text search is fully integrated into database
query processing, but text-search indices are file system-based, and backup
requires synchronization with DB2 backup and recovery facilities. It is
necessary to combine database backups and text-search index backups to prepare
for recovery scenarios. This article provides information about how database
objects and text-search indices relate and provides recommendations for backup
and recovery procedures.
|
23 Feb 2012 |
| Use optimization profile in DB2 for Linux, UNIX, and Windows stored
procedure
The optimizer of DB2 for Linux, UNIX, and Windows relies on a cost-based design. Using an SQL statement input
by a user or application, the optimizer selects an execution plan with the lowest cost to achieve the best performance. If the performance
still doesn't meet requirements after you have used all the best practices for tuning the SQL statement, you can use an optimization profile
to guide DB2 to create the execution plan that the user expects. This article explains how to use
optimization profiles within DB2 stored procedures.
|
23 Feb 2012 |
| Convert single-tenant applications into multi-tenant applications
The authors share experiences gained from their work converting single-tenant
SOA application into multi-tenant cloud solutions; these best practices are packaged into seven important tips.
|
22 Feb 2012 |
| Integrated support for data deduplication devices in DB2 for Linux, UNIX,
and Windows
Learn how data deduplication offers benefits such as reducing storage
requirements, improving backup performance, and reducing traffic across your network.
This article explains the basic technology of deduplication, discusses the various
methodologies that you can use, and shows how DB2 for Linux, UNIX, and Windows has been changed to
support various deduplication devices. Finally, the article includes the
results of benchmark testing to illustrate how effective the Tivoli Storage
Manager server data deduplication feature can be with DB2.
|
14 Feb 2012 |
| Restricting database connections using trusted contexts in DB2 for Linux,
UNIX, and Windows
Security administrators are responsible for, among other things, protecting a database against unauthorized
access or misuse by authorized database users (for example, inappropriate access to sensitive information within a database). A
common requirement to mitigate such risks is ensuring that users are allowed to connect to the database only from a list of
trusted hosts -- which are known to be secure. This article gives a practical example of how such a requirement can be put in
practice by making use of the trusted context feature of DB2 for Linux, UNIX, and Windows.
Also available in:
Chinese
Portuguese
|
09 Feb 2012 |
| Developing heterogeneous database applications
using the IBM Data Server Provider for .NET
Transactional logic that works across heterogeneous databases needs to
use global transactions. The IBM Data Server Provider for .NET supports the
distributed transaction model from the System.Transactions namespace, which has
the capability to create and manage global transactions. The code examples in this article show how
to use the IBM Data Server Provider for .NET to create
and manage global transactions on the IBM data servers.
Also available in:
Chinese
|
02 Feb 2012 |
| Mainframe code page conversion customization in an IBM z/OS system
Encoding in mainframes is EBCDIC, and encoding in distributed system is ASCII.
Mainframe computers need to communicate with distributed systems that include Microsoft
Windows, UNIX, and other platforms. The EBCDIC and ASCII code page conversion happens
in each communication between the IBM z/OS operating system and the distributed system.
However, some characters cannot go round trip between EBCDIC and ASCII in some non-English
languages. As a result, the application doesn't work correctly. One solution is to modify
application code, but that is often complicated and time consuming. This article presents
a light-weight solution as an alternative. No application code change is needed, and you
can resolve the issue quickly.
|
02 Feb 2012 |
| Designing a database for multi-tenancy on the cloud
Learn some considerations that new software as a service
(SaaS) vendors need to take into account when developing applications or
modifying existing ones to enable them for multi-tenancy on the cloud. The article
discusses the considerations only from a database perspective --
specifically, from an IBM DB2 perspective. Six cases or methods are described.
Also available in:
Vietnamese
|
26 Jan 2012 |
| Leveraging pureXML in a Flex microblogging application, Part 1: Enabling Web services with DB2 pureXML
The pureXML capabilities of IBM DB2 allow you to store XML natively in a database without modification, while Adobe Flex applications can read XML directly and populate Flex user interfaces. In this three-part article series, you will create a microblogging application that takes advantage of pureXML, Web services, and Adobe Flex; and even allows you to publish your microblogging updates on Twitter.
|
24 Jan 2012 |
