Technical library

  • spacer Filter by products, topics, and types of content

    (110 Products)

    (109 Topics)

    (15 Industries)

    (15 Types)

 

1 - 100 of 1114 results | Next Show Summaries | Hide Summaries Subscribe to search results (RSS)

View Results
Title none Date down
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.
Also available in: Chinese   Korean   Korean   Russian   Vietnamese   Spanish  
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.
Also available in: Chinese   Russian   Spanish  
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 non­relational 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.
Also available in: Chinese   Russian   Japanese  
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.
Also available in: Chinese   Vietnamese   Portuguese   Spanish  
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.
Also available in: Chinese   Russian   Portuguese  
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.
Also available in: Chinese   Vietnamese   Portuguese  
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.
Also available in: Chinese   Japanese   Portuguese  
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.
Also available in: Chinese   Russian   Portuguese  
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.
Also available in: Chinese   Russian  
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.
Also available in: Chinese   Russian  
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.
Also available in: Chinese   Russian  
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.
Also available in: Chinese   Russian   Vietnamese   Portuguese   Spanish  
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.
Also available in: Chinese   Japanese   Portuguese  
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.
Also available in: Chinese   Russian   Japanese  
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.
Also available in: Chinese   Japanese  
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.
Also available in: Chinese   Russian  
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.
Also available in: Chinese   Vietnamese   Portuguese  
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.
Also available in: Chinese   Russian   Portuguese  
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.
Also available in: Chinese   Russian   Vietnamese   Portuguese  
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.
Also available in: Chinese   Japanese   Vietnamese   Portuguese   Spanish  
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.
Also available in: Chinese   Russian   Vietnamese   Portuguese  
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.
Also available in: Russian   Japanese   Vietnamese   Portuguese  
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.
Also available in: Chinese   Portuguese   Spanish  
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.
Also available in: Chinese   Japanese   Vietnamese   Portuguese  
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.
Also available in: Chinese   Korean   Russian   Japanese   Portuguese  
24 Jan 2012

1 - 100 of 1114 results | Next Show Summaries | Hide Summaries Subscribe to search results (RSS)