Technical library

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

    (115 Products)

    (114 Topics)

    (15 Industries)

    (14 Types)

Develop and deploy your next
app on the IBM Bluemix
cloud platform.

 

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

View Results
Title none Type none Date down
Selected common SQL features for developers of portable DB2 applications
Are you writing SQL applications that need to be portable across platforms? Here's the information you need to make sure your applications are portable. The tables in this article summarize the common SQL application features and make it easy for you to develop applications using SQL that is portable across the DB2 family, including DB2 for z/OS, DB2 for i, and DB2 for Linux, UNIX, and Windows.
Also available in: Chinese   Russian   Spanish  
Articles 09 Aug 2016
Predictive Cloud Computing for professional golf and tennis, Part 7: Big Data Storage & Analytics—IBM DB2 and Graphite
Management of large amounts of data is a challenge that provides the opportunity to explore different approaches to managing complex states and analyzing numerous metrics. Our professional golf and tennis tournaments generate terabytes of data from site traffic alone. The Predictive Cloud Computing (PCC) system utilizes IBM DB2 to store aggregated information generated from the source data and Graphite to analyze metrics and profile our codebase. Each of these tools gives the PCC system the ability to store and analyze large amounts of data and provide straightforward retrieval for latent analysis.
Articles 05 Aug 2016
Manage spatial data with IBM DB2 Spatial Extender, Part 1: Acquiring spatial data and developing applications
This tutorial series describes common tasks to manage spatial data with IBM DB2 Spatial Extender, including importing and creating spatial data, constructing and executing spatial queries, working with IBM, third-party, and open source spatial tools, tuning performance, and considering special circumstances in a data warehouse environment. In this first article in the series, learn how to acquire spatial data and build applications. Learn how to use shapefiles, spatial data tables, and spatial indices.
Also available in: Chinese   Russian   Portuguese   Spanish  
Articles 24 Jul 2016
Dropped object recovery: A DBA's nightmare
Dropped objects in a DB2 for z/OS environment can be a database administrator's (DBA) nightmare. Not only is the data lost, but traditional recovery methods do not work in this situation. This article examines the dropped object dilemma and gives you four steps you can take to recover lost data and objects.
Tutorial 16 Jun 2016
Apply middleware maintenance to patterns and instances in IBM PureApplication System
Learn how to apply middleware maintenance on IBM PureApplication System by using IBM Installation Manager. In this video, you go through the contents and structure of the IBM Installation Manager Repository. Then, you learn how to apply emergency fix packs and content from the IBM Installation Manager repository to patterns and deployed pattern instances.
Tutorial 26 Apr 2016
Temporary storage and the database – Part 1
A healthy IBM® DB2® workload needs temporary storage to perform efficiently. Understanding and managing this storage is the key to keep your system running effectively. This article describes five important temporary storage types that the SQL Query Engine (SQE) uses on IBM i.
Articles 05 Apr 2016
Automated cluster controlled HADR configuration setup using the IBM DB2 high availability instance configuration utility
Learn how to configure a failover solution for DB2 for Linux, UNIX, and Windows, using the DB2 high availability disaster recovery (HADR) feature and the the DB2 high availability instance configuration utility (db2haicu). This article walks you through the concepts and then shows how to set up two distinct configurations for automated failover.
Articles 01 Apr 2016
Build a DB2 for z/OS mobile application using DB2 Adapter for z/OS Connect, Part 2: Consume a DB2 Adapter service
To create effective, enterprise-ready mobile applications, you need to make the back-end data easier to consume. APIs in IBM DB2 Adapter for z/OS expose DB2 for z/OS functionality to applications. In Part 2 of the series, learn how to build a mobile application using IBM MobileFirst Developer Edition by consuming a DB2 Adapter service.
Also available in: Chinese  
Articles 05 Mar 2016
Accelerating SAP CO-PA with DB2 for Linux, UNIX, and Windows
SAP Profitability Analysis (CO-PA) reports, which are primarily used for drill-down analysis, fetch a significant number of records and aggregate them to a small result set. Using intrapartition parallelism, a feature available in DB2, can speed up the query processing by eight times or more, depending on hardware resources and data distribution. In this tutorial, we’ll demonstrate the benefits of intrapartition parallelism and discuss how to use it effectively for reporting queries.
Also available in: Chinese  
Articles 01 Mar 2016
SQL indexes and native I/O – no contradiction
Native I/O is widely used in RPG and COBOL programs for getting access to the data stored in the database. Data access is mostly performed with the help of data description specifications (DDS) keyed physical and logical files. Unfortunately DDS is an outdated technology, while all future development regarding the database and data access is only integrated into SQL. For profiting from the new indexing technologies in release 6.1, native I/O does not need to be replaced with embedded SQL. SQL indexes can be used with native I/O like any keyed logical file. Moreover, the enhanced indexing technologies could first be used with native I/O while the SQL query optimizer could only partially profit from these enhancements.This article explains how SQL indexes can be used in conjunction with native I/O and how native I/O can profit from the enhanced indexing technologies.
Articles 24 Feb 2016
Cost-effective data management with DB2 10.5 and EMC FAST VP, Part 4: Monitoring considerations
You need a cost-effective way to structure your company's data so that you can instantly access hot dataor data that is accessed frequentlywhile also storing enormous amounts of cold datadata that is not accessed very often. In this series, we'll show you how to use the multi-temperature data feature, introduced in IBM DB2 Version 10.1 for Linux, UNIX, and Windows (DB2 10.1) with EMC Symmetrix VMAX Fully Automated Storage Tiering for Virtual Pools (FAST VP) technology to place the right data on the right storage at the right time to keep hardware costs to a minimum and help you achieve your SLA goals. In part 4 of this series, learn how the DB2 In-Memory Metrics Monitor can be used to identify data temperature and see how to use SQL queries to monitor I/O performance. Also, get a brief introduction to EMC FAST VP I/O performance monitoring.
Also available in: Chinese  
Articles 05 Feb 2016
Considerations for building and deploying DB2 Docker containers
Docker containers enable you to package applications with their dependenciescode, runtimes, libraries, and toolsinto a complete file system that you can run in any environment. In this tutorial, we discuss what you need to consider when deploying IBM DB2 for Linux, UNIX and Windows in Docker containers.
Also available in: Chinese  
Articles 04 Feb 2016
Build a DB2 for z/OS mobile application using DB2 Adapter for z/OS Connect, Part 1: Expose DB2's functionality
To create effective, enterprise-ready mobile applications, you need to make the back-end data easier to consume. APIs in IBM DB2 Adapter for z/OS expose DB2 for z/OS functionality to applications. See an easy-to adapt example to learn how you can build a DB2 for z/OS mobile application using DB2 Adapter for z/OS Connect and IBM MobileFirst Developer Edition.
Also available in: Chinese  
Articles 02 Feb 2016
Cost-effective data management with DB2 10.5 and EMC FAST VP, Part 3: Integration strategies
You need a cost-effective way to structure your company's data so that you can instantly access hot dataor data that is accessed frequentlywhile also storing enormous amounts of cold datadata that is not accessed very often. In this series, we'll show you how to use the multi-temperature data feature, introduced in IBM DB2 Version 10.1 for Linux, UNIX, and Windows (DB2 10.1) with EMC Symmetrix VMAX Fully Automated Storage Tiering for Virtual Pools (FAST VP) technology to place the right data on the right storage at the right time to keep hardware costs to a minimum and help you achieve your SLA goals. In part 3 of this series, get tips for how to integrate DB2 10.5 and EMC FAST VP.
Also available in: Chinese  
Articles 28 Jan 2016
Cost-effective data management with DB2 10.5 and EMC FAST VP, Part 2: EMC Virtual Provisioning and FAST VP
You need a cost-effective way to structure your company's data so that you can instantly access hot dataor data that is accessed frequentlywhile also storing enormous amounts of cold datadata that is not accessed very often. In this series, we'll show you how to use the multi-temperature data feature, introduced in IBM DB2 Version 10.1 for Linux, UNIX, and Windows (DB2 10.1) with EMC Symmetrix VMAX Fully Automated Storage Tiering for Virtual Pools (FAST VP) technology to place the right data on the right storage at the right time to keep hardware costs to a minimum and help you achieve your SLA goals. Part 2 illustrates how EMC Symmetrix VMAX Fully Automated Storage Tiering for Virtual Pools (FAST VP) technology works and shows you how to configure and deploy the product.
Also available in: Chinese  
Articles 21 Jan 2016
Cost-effective data management with DB2 10.5 and EMC FAST VP, Part 1: The multi-temperature data feature
You need a cost-effective way to structure your company's data so that you can instantly access hot dataor data that is accessed frequentlywhile also storing enormous amounts of cold datadata that is not accessed very often. In this series, we'll show you how to use the multi-temperature data feature, introduced in IBM DB2 Version 10.1 for Linux, UNIX, and Windows (DB2 10.1) with EMC Symmetrix VMAX Fully Automated Storage Tiering for Virtual Pools (FAST VP) technology to place the right data on the right storage at the right time to keep hardware costs to a minimum and help you achieve your SLA goals. Part 1 introduces the DB2 multi-temperature data feature and shows you how to use its features.
Also available in: Chinese  
Articles 15 Jan 2016
5 steps for real-time data replication with IBM i remote journaling
Enterprises need real-time, trusted data to make decisions and stay competitive. Data loss is unacceptable, but the process to collect and synchronize data must have little to no effect on production environments. This article shows you how to use a remote journal to configure IBM InfoSphere Data Replication (IIDR) for IBM i. This trusted solution will help you effectively gather data without affecting your other business functions.
Also available in: Chinese  
Articles 20 Nov 2015
Compare the distributed DB2 10.5 database servers
In a side-by-side comparison table, the authors make it easy to understand the basic licensing rules, functions, and feature differences among the members of the distributed DB2 10.5 for Linux, UNIX, and Windows server family as of June 14, 2013.
Also available in: Chinese   Russian   Japanese  
Articles 01 Nov 2015
Building Scala applications that access IBM Data Servers
Build applications in Scala that access IBM Data Servers like IBM DB2 for Linux, Unix and Windows, IBM DB2 for z/OS, IBM Big SQL, IBM dashDB, and IBM Informix. This article includes sample code and instructions for creating Scala applications that access IBM data servers using IBM Data Server Driver for JDBC and SQLJ. I discuss multiple implementation options as samples of different approaches that you can take to create such applications.
Also available in: Chinese   Portuguese  
Articles 01 Oct 2015
A how-to guide: Backup and recovery in DB2 for z/OS
This article explains with a hands-on laboratory exercise how to backup and recover in DB2 for z/OS. It shows in a concise way how to create backups of DB2 and how to recover lost data, using DB2 utilities and JCL (Job Control Language). An excellent method to show a customer how to use the backup and recovery features of DB2 and get him or her familiar with it.
Also available in: Chinese  
Articles 11 Sep 2015
Configure parameters for IBM Data Server Driver for JDBC and SQLJ against HADR for DB2 pureScale
IBM High Availability Disaster Recovery (HADR) for DB2 pureScale (on DB2 for Linux, UNIX, and Windows) offers functionality high availability and scalability through IBM Data Server Driver for JDBC and SQLJ. Mission-critical applications that lack end-to-end optimal configurations don't failover/failback for transactions. This tutorial explains configuration parameters for IBM Data Server Driver for JDBC and SQLJ against HADR for DB2 pureScale, such as covering different scenarios/criteria in deciding values of configuration parameters suited as per application/environment needs.
Also available in: Chinese  
Articles 04 Sep 2015
Translating the monetary cost of SQL statements, Part 1: SQL cost in DB2 9.7 and 10.1
What's a timeron worth to you? Who knows? DB2 SQL statement cost is measured in timerons, not dollars. This tutorial will discuss an approach to translating a timeron cost, and the associated administrative and computing resource costs into a cost metric that matters: dollars! You will learn the features and resources we considered for this calculation. We will discuss the resulting statistical monitors and measures available in DB2 and AIX that monitor I/O, memory, and CPU, which were used in determining the actual dollar-cost calculations, jointly created by IBM and a partner. We will then show the calculation for assigning a dollar cost to an SQL statement by way of examples. Using this data, you will learn about our formulas for predicting a dollar cost for a system. Steps used to derive the formula will also be provided. Lastly, we will cover some of the items that caused skew.
Articles 04 Aug 2015
Leverage DB2 BLU Acceleration technology for tables involving unsupported data types
DB2 BLU Acceleration can provide performance improvements ranging from 35x to 73x and beyond for analytical queries with minimal tuning. In the mixed environment between OLTP and OLAP called OLTAP, DB2 shadow tables can be used to leverage BLU Acceleration without sacrificing OLTP performance. On the other hand, there are some restrictions such as data types. Though most data types are supported, some data types such as LOB and XML are not supported. For example, if your fact table contains invoice PDF data stored in a BLOB column, you cannot use BLU Acceleration as it is, which means you cannot create tables such as column-organized table. But there are ways to leverage BLU Acceleration even in such cases. This article guides you through those steps.
Articles 24 Jul 2015
Using IBM Database Add-ins for Visual Studio 2013 in DB2 Cancun (10.5 Fix Pack 4)
This tutorial explains the key new capabilities in IBM Database Add-ins for Visual Studio 2013 available with the DB2 10.5 Fix Pack 4. The authors explain support of the Microsoft Visual Studio 2013 feature set with IBM data servers (DB2 for z/OS; DB2 for i; DB2 for Linux, UNIX, and Windows; and Informix).
Tutorial 16 Jul 2015
DB2 Advanced Copy Services: The scripted interface, Part 4: Implementation for DB2 ACS
IBM DB2 Advanced Copy Services (DB2 ACS) supports taking snapshots for backup purposes in DB2 for Linux, UNIX, and Windows databases. You can use the DB2 ACS API through libraries implemented by your storage hardware vendors, or you can implement this API yourself. As of IBM DB2 10.5, a feature called Scripted Interface for DB2 Advanced Copy Services was introduced. It allows you to implement shell scripts instead of C libraries. These scripts can use the tools provided by the storage vendors to run the snapshot operations. The scripted interface can be used independently from your storage hardware. Additionally, DB2 supports storage hardware as soon as it becomes available. The feature supports all three architectures of DB2: enterprise server, multi-partitioned database using the database partitioning feature (DPF), and databases using pureScale. And it's supported on all UNIX and Linux platforms on which DB2 is certified. Part 4 of this "DB2 Advanced Copy Services: The scripted interface" series demonstrates the usage of the scripted interface together with IBM System Storage and IBM Storage Manager. The DB2 database in this example is used by an SAP NetWeaver system.
Articles 25 Jun 2015
Know your online fix-pack update progress using the db2pd tool
The fix-pack update for DB2 pureScale is now made easy and simple from DB2 10.5 and higher. You can apply the new fix-pack level online, while the client's workload or a query is running on the server instance. This tutorial explains how to determine the progress of an online fix-pack update to your DB2 pureScale instance, using the db2pd command.
Also available in: Chinese  
Articles 18 Jun 2015
Design a DB2 for z/OS table to hold just one row
DB2 tables are meant to hold enormous amounts of data for application testing, development, and production purposes. But at times, the need arises to design the table to hold just one row at a time dynamically. This tutorial introduces the basic concepts of having a DB2 for z/OS table hold one row.
Also available in: Chinese  
Articles 04 Jun 2015
Predictive analytics using IBM SPSS Modeler in DB2 for z/OS
This tutorial focuses on predictive analytics using IBM SPSS Modeler and data stored in DB2 for z/OS. We illustrate how to use the SPSS Modeler workbench to create predictive models with in-database mining, SQL push-back, and UDF scoring. We walk through the steps for integrating real-time scoring for DB2 for z/OS into an OLTP application. We also show what needs to be done in the DB2 server and the information an application developer needs to know to create an enterprise solution for in-database transactional scoring and batch scoring.
Also available in: Russian  
Articles 29 May 2015
DB2 with BLU Acceleration: A rapid adoption guide
You have probably heard how DB2 with BLU Acceleration can provide performance improvements ranging from 10x to 25x and beyond for analytical queries with minimal tuning. You are probably eager to understand how your business can leverage this cool technology for your warehouse or data mart. The goal of this article is to provide you with a quick and easy way to get started with BLU. We present a few scenarios to illustrate the key setup requirements to start leveraging BLU technology for your workload.
Also available in: Chinese   Russian  
Articles 07 May 2015
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 11, DB2 for i Version 7.2, and DB2 for Linux, UNIX, and Windows Version 10.5.
Also available in: Chinese   Russian  
Articles 07 May 2015
Improve ETL performance in BLU Acceleration
IBM DB2 with BLU Acceleration is a leap forward in database technology to improve query performance, particularly in the data warehouse (DWH) and decision support system (DSS) environments. It leverages dynamic in-memory, actionable compression, parallel vector processing, and data-skipping innovations from IBM Research to deliver a unique combination of performance, ease of use, and cost efficiency. In real-time reporting systems where the ETL process needs to update/delete data frequently from column-organized tables, it usually takes more time, resulting in performance issues for reports and dashboards. Learn how to improve these functions.
Also available in: Chinese  
Articles 23 Apr 2015
Which distributed edition of DB2 10.5 is right for you?
Learn the details of what makes each edition of IBM® DB2® 10.5 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 that customers are doing with DB2. This popular article will be updated during the release with any intra-version licensing changes that are announced in future fix packs.
Also available in: Chinese   Russian   Japanese  
Articles 02 Apr 2015
I encrypted my database! How do I manage my master keys now?
After your database is encrypted with DB2 native encryption, learn to manage your master keys to ensure that they are secured and protected. DB2 native encryption is available through the DB2 Encryption Offering as of DB2 10.5 Fix Pack 5. It supports master key management based on the public-key cryptography standard 12 (PKCS#12). This tutorial provides an easy-to-follow step-by-step guide to manage a GSKit PKCS#12-compliant keystore.
Also available in: Russian  
Articles 02 Apr 2015
Analyze DB2 spatial data with a free geobrowser
A geobrowser for DB2, Informix and Netezza is now available as a free download. You can easily list tables containing spatial data and select the tables to be displayed as a map using a combination of points, lines and polygons. The color, symbols, linestyle and shading are user selectable. Map navigation tools allow you to zoom in and out, pan the map and select and display the alphanumeric values associated with each graphic object. The geobrowser can render the results of spatial analysis using DB2, Informix or Netezza. Application developers can use these components to construct custom spatial visualization applications. This tutorial shows you step-by-step how to use the free geobrowser to visualize data from DB2 tables.
Also available in: Chinese   Russian   Vietnamese   Portuguese  
Articles 23 Mar 2015
Manage performance and administer DB2 databases using IBM Data Server Manager
IBM Data Server Manager is a new, integrated tool for managing performance and administering DB2 for Linux, UNIX, and Windows databases. This tutorial starts with a brief introduction of Data Server Manager and a high-level explanation of the quick up-and-running process. The majority shows how Eric, a database administrator (DBA), can use Data Server Manager to investigate a statement performance alert. From start to finish, Eric uses one tool to learn about the alert, investigate the statement performance, review configuration changes, tune the statement, and review and implement the recommendations.
Also available in: Russian  
Articles 20 Mar 2015
Deploying DB2 pureScale Feature 10.5.0.3 on AIX with RDMA over Converged Ethernet
This tutorial is intended to show users how they can deploy DB2 pureScale on AIX using Remote Direct Memory Access (RDMA) over converged Ethernet. The step-by-step guide will provide details of a sample deployment that could be replicated to allow for other successful pureScale deployments.
Tutorial 12 Mar 2015
Connect your apps to DB2 with high-security Kerberos
This tutorial is a primer to help programmers using IBM Data Server Drivers get applications quickly running in a Kerberos environment. We will be setting up a simple Kerberos environment on Windows, configuring DB2 to use Kerberos authentication, and enabling the client drivers to securely authenticate using Kerberos.
Also available in: Chinese  
Tutorial 02 Mar 2015
Manage spatial data with IBM DB2 Spatial Extender, Part 2: Implementing typical spatial use cases
This series of tutorials takes you through common tasks that work with spatial data in the DB2/reg> Spatial Extender. These tasks include importing and creating spatial data, constructing and executing spatial queries, working with IBM spatial tools, working with third-party and open source software, improving application performance, and taking special considerations in a data warehouse environment.
Also available in: Russian  
Articles 01 Mar 2015
Leverage DB2 Connect for insert operations in existing C/C++ IBM Data Server applications
This tutorial explains the key best practices when developing C/C++ applications against the IBM Data Servers; (DB2 for z/OS; DB2 for i; DB2 for Linux, UNIX, and Windows; and Informix). It provides details for leveraging several of the features in DB2 Connect that pave the way for better performance and align with best-practice recommendations. You can use this information while developing/enhancing existing applications in C/C++ targeting IBM Data Servers.
Tutorial 20 Feb 2015
Optimizing cloud applications with DB2 stored procedures
This tutorial describes the IBM DB2 stored procedure framework, methods to monitor stored procedure performance, and methods to optimize stored procedure performance. DB2 provides a routine monitoring framework that helps pinpoint the statements or parts of the procedure code that can be tuned for better performance. The tutorial also describes good practices for writing DB2 SQL/PL and Oracle PL/SQL procedures and simple way of migrating Oracle PL/SQL procedures to DB2.
Tutorial 12 Feb 2015
Setting up your DB2 subsystem for query acceleration with DB2 Analytics Accelerator for z/OS
Adding IBM DB2 Analytics Accelerator for z/OS to the DB2 for z/OS environments has enabled companies in a variety of industries from major banks and retailers to IT services and healthcare providers to significantly improve query processing and increase analytics capabilities. Providing efficiency and cost-effectiveness, DB2 Analytics Accelerator can process certain types of eligible queries, especially business intelligence queries, faster than DB2.
Also available in: Russian  
Tutorial 05 Feb 2015
Licensing distributed DB2 10.5 servers in a high availability (HA) environment
Are you trying to license your IBM DB2 10.5 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.5 release that became generally available on June 14, 2013.
Also available in: Chinese   Russian   Japanese  
Articles 04 Feb 2015
Data purge algorithm: Efficiently delete terabytes of data from DB2 for Linux, UNIX, and Windows
Big data introduces data storage and system performance challenges. Keeping your growing tables small and efficient improves system performance as the smaller tables and indices are accessed faster; all other things being equal, a small database performs better than a large one. While traditional data purge techniques work well for smaller databases, they fail as the database size scales up into a few terabytes. This tutorial will discuss an algorithm to efficiently delete terabytes of data from the DB2 database.
Also available in: Chinese   Russian  
Tutorial 29 Jan 2015
Use a SQL interface to handle JSON data in DB2 11 for z/OS
This tutorial focuses on a SQL interface recently introduced in DB2 11 for z/OS that allows extraction and retrieval of JSON data from BSON objects and conversion from JSON to BSON. With this new feature, users can manage JSON data without relying on DB2 NoSQL JSON APIs. Instead, SQL interfaces can be used for JSON manipulation. Learn about the setup/configuration and get illustrations for common JSON usage inside DB2 11 for z/OS. Hints and tips are provided to improve performance and prevent potential pitfalls.
Also available in: Russian  
Tutorial 22 Jan 2015
Unit test SQL PL routines by using db2unit framework in DB2 LUW
SQL PL routines stored in DB2 databases contain business logic that can be used by all applications that access the database. However, these routines are not always completely tested. Until now, no standard procedure existed to perform automatic tests against them. With the incursion of test-driven development from the eXtreme Programming paradigm, it is important to write test cases that check all possible conditions. Doing so even before starting development ensures the quality of the software. db2unit is a framework that helps you follow these guidelines by writing better code and creating more reliable applications. Learn how to use the innovative framework that, automating unit tests for the SQL PL routines.
Also available in: Russian  
Tutorial 09 Jan 2015
Increase throughput with z/OS Language Environment heap storage tuning method
The z/OS Language Environment (LE) component provides a common runtime environment for the IBM version of certain high-level languages. LE provides runtime options that can be customized according to the programs behaviors to achieve better execution performance. This paper puts forward an LE heap storage tuning method for IBM's InfoSphere Data Replication for DB2 for z/OS (Q Replication). The tuning reduces contentions of concurrent heap storage allocation requests among multiple threads of the Q Capture program and Q Apply program of Q Replication for z/OS while keeping the heap storage overall allocation to a minimum. After applying the heap tuning techniques outline in this paper, a notable 13% throughput performance was achieved for OLTP type workloads and CPU reduction was noticed for all workload types
Tutorial 23 Oct 2014
Using temporal tables in DB2 10 for z/OS and DB2 11 for z/OS
Temporal tables were introduced in IBM DB2 10 for z/OS and enhanced in V11. If you have to maintain historical versions of data over several years, temporal tables can be helpful for period-based data. In this tutorial, explore how your applications can use temporal tables to manage different versions of data, simplify service logic, and provide information for auditing. Learn about when and how to use three types of temporal tables to manage period-based data.
Also available in: Chinese   Russian  
Tutorial 16 Oct 2014
DB2 Connect: Get the most from new features in DB2 Cancun 10.5.0.4
DB2 Connect in DB2 Cancun Release 10.5.0.4 includes many rich features. Get a high-level overview of the key features across the various client drivers for DB2, including Java driver and non-Java drivers (CLI and .NET). Learn about the practical application of the new DB2 Connect features that provide big returns. Key features can help alleviate several business problems. The information in this tutorial will be useful when deciding on release upgrades.
Also available in: Chinese   Russian  
Tutorial 02 Oct 2014
Improve performance of mixed OLTAP workloads with DB2 shadow tables
DB2 with BLU acceleration has introduced a new innovative feature to make analytics faster and simpler. Learn how Shadow tables utilize BLU acceleration technologies to improve performance of analytic queries within your OLTP environment. Experience the power of complex reporting on real-time data in a single database. The goal of this article is to introduce you to the power of shadow tables and walk you through the simple steps of setting your environment for their use.
Also available in: Chinese   Russian  
Tutorial 25 Sep 2014
Configure multiple HADR databases in a DB2 instance for automated failover using Tivoli System Automation for Multiplatforms
Learn how to enable automated failover support using IBM Tivoli System Automation for Multiplatforms for multiple databases configured for High Availability Disaster Recovery in a single DB2 instance. Walk through scenarios that use db2haicu in interactive mode and with an XML file as input. The example setup is for DB2 Enterprise Server Edition environments in Linux or AIX with DB2 9.5 and higher.
Also available in: Chinese  
Tutorial 22 Sep 2014
Achieve improved database interoperability with SQL and RDB aliases
In today's complex environments, where data is spread across numerous homogeneous and heterogeneous databases, simplification is a necessity. Three-part naming offers that simplification for database connectivity by allowing skilled data architects, programmers, and system administrators the ability to easily manage remote Distributed Relational Database Architecture (DRDA) connections within SQL applications and data centers. This article gives you insight into the options available to use DRDA more proficiently through three-part naming and RDB aliases. Understanding these concepts can enable you to improve your SQL database interoperability in your SQL applications or daily use and also gain a level of database abstraction and portability.
Articles 18 Sep 2014
Selected common SQL features for developers of portable DB2 applications
Are you writing SQL applications that need to be portable across platforms? Here's the information you need to make sure your applications are portable. The tables in this article summarize the common SQL application features and make it easy for you to develop applications using SQL that is portable across the DB2 family, including DB2 for z/OS, DB2 for i, and DB2 for Linux, UNIX, and Windows.
Also available in: Spanish  
Articles 01 Sep 2014
Selected common SQL features for developers of portable DB2 applications
Are you writing SQL applications that need to be portable across platforms? Here's the information you need to make sure your applications are portable. The tables in this article summarize the common SQL application features and make it easy for you to develop applications using SQL that is portable across the DB2 family, including DB2 for z/OS, DB2 for i, and DB2 for Linux, UNIX, and Windows.
Also available in: Spanish  
Articles 01 Sep 2014
Selected common SQL features for developers of portable DB2 applications
Are you writing SQL applications that need to be portable across platforms? Here's the information you need to make sure your applications are portable. The tables in this article summarize the common SQL application features and make it easy for you to develop applications using SQL that is portable across the DB2 family, including DB2 for z/OS, DB2 for i, and DB2 for Linux, UNIX, and Windows.
Articles 01 Sep 2014
Generate reports remotely and offline with InfoSphere Optim Performance Manager command-line utility
You can use predefined report features in the InfoSphere Optim Performance Manager for DB2 for Linux, UNIX and Windows web console to generate reports in HTML, PDF, PPT, and XLS formats. In this tutorial, learn how to extend these features with the command-line utility (CLU). With the CLU, you can generate reports in offline and batch mode without logging on to the web console, schedule reports to run at periodic intervals, and send reports as attachments to team members.
Also available in: Chinese  
Articles 14 Aug 2014
Remove and reintegrate an auxiliary standby in an HADR setup
Starting with IBM DB2 10.1, the High Availability Disaster Recovery (HADR) feature supports multiple standbys. With multiple standbys, you can have your data in more than two sites for improved data protection with a single technology. This article provides detailed steps for removing and reintegrating the auxiliary standby in a multiple standby HADR setup.
Also available in: Chinese   Russian  
Articles 13 Aug 2014
Gain confidence about data security in the cloud
This tutorial demystifies cloud security and arms you with the know-how to adopt the cloud with confidence. Learn how cloud security is a shared responsibility between the cloud service provider and the client. The responsibilities of each party are explored. Also walk through a data security use case involving dashDB. When certain criteria are met, clients can achieve data security equal to or better than what they can achieve onsite.
Also available in: Chinese   Russian   Spanish  
Articles 07 Aug 2014
Use the DB2 with BLU Acceleration Pattern to easily deploy a database
The database as a service (DBaaS) 1.1.0.8 component of the IBM PureApplication System introduced many new features. This article describes some of them, including deployment of DB2 with BLU, increasing the database resources, and backup. You also will learn how the DB2 with BLU Acceleration Pattern can make it easier and faster to create and deploy BLU-enabled datasets in DBaaS 1.1.0.8.
Also available in: Chinese   Russian  
Articles 24 Jul 2014
DB2 monitoring enhancements for BLU Acceleration
BLU Acceleration is a collection of technologies for analytic queries that was introduced in IBM DB2 for Linux, UNIX and Windows (LUW) Version 10.5. BLU Acceleration can provide significant benefits in many areas including performance, storage savings, and overall time to value. This article provides an overview of the monitoring capabilities that support BLU Acceleration. These capabilities provide insight into the behavior of the database server and assist with tuning and problem determination activities. Extensive example queries help you start monitoring workloads that take advantage of BLU Acceleration.
Also available in: Russian  
Articles 24 Jul 2014
DB2 monitoring: Migrate from snapshot monitor interfaces to in-memory metrics monitor interfaces
This article helps you migrate from the snapshot monitor interfaces to the in-memory metrics monitor interfaces that were first introduced in DB2 for Linux, UNIX, and Windows Version 9.7.
Also available in: Russian  
Articles 17 Jul 2014
Increase DB2 availability
This article demonstrates how to use a cloud provider to create a reliable tie-breaking method to avoid a split brain scenario. The procedure is for two node clusters running IBM DB2 for Linux, UNIX and Windows (LUW) and the integrated high availability (HA) infrastructure. See how to automate any two-node failover for DB2 LUW 10.1 or higher.
Also available in: Russian  
Articles 19 Jun 2014
Integrate DB2 for z/OS with InfoSphere BigInsights, Part 1: Set up the InfoSphere BigInsights connector for DB2 for z/OS
Learn how to set up integration between IBM DB2 11 for z/OS and IBM InfoSphere BigInsights. Enable access to structured and non-structured data that is stored in the Hadoop Distributed File System and send the results back to DB2, where the data can be integrated with online transactional data. Using a scenario that is common to all DB2 for z/OS users, learn to create a big data solution that uses the user-defined functions JAQL_SUBMIT and HDFS_READ to run jobs on InfoSphere BigInsights and retrieve the results with SQL.
Also available in: Russian  
Articles 17 Jun 2014
Calculate storage capacity of indexes in DB2 for z/OS
With the drastic growth of data stored in IBM DB2 tables, index sizes are bound to increase. Most indexes are still uncompressed, so there's an urgent need to monitor indexes to avoid unforeseen outages related to index capacity. This article describes a process to calculate the capacity limit for various types of indexes. Once you know how to calculate the capacity of indexes in different situations, you can monitor their growth to avoid outages.
Also available in: Russian  
Articles 12 Jun 2014
Convert row-organized tables to column-organized tables in DB2 10.5 with BLU Acceleration
With IBM DB2 10.5 you can easily convert row-organized tables to column-organized tables by using command line utilities or IBM Optim Data Studio 4.1. This article introduces two approaches for table conversions: the db2convert command and the ADMIN_MOVE_TABLE stored procedure. We also describe a manual conversion. Learn the advantages and disadvantages of the different conversion approaches. Best practices are also discussed.
Also available in: Russian  
Articles 12 Jun 2014
DB2 10.1 fundamentals certification exam 610 prep, Part 2: DB2 security
This tutorial introduces authentication, authorization, privileges, and roles as they relate to IBM DB2 10.1. It also introduces granular access control and trusted contexts. This is the second in a series of six tutorials designed to help you prepare for the DB2 10.1 Fundamentals certification exam (610). It is assumed that you already have basic knowledge of database concepts and operating system security.
Also available in: Chinese  
Articles 05 Jun 2014
Measure the impact of DB2 with BLU Acceleration using IBM InfoSphere Optim Workload Replay
In this article, learn to use IBM InfoSphere Workload Replay to validate the performance improvement of InfoSphere Optim Query Workload Tuner (OQWT) driven implementation of DB2 with BLU Acceleration on your production databases. The validation is done by measuring the actual runtime change of production workloads that are replayed in an isolated pre-production environment.
Also available in: Chinese   Russian  
Articles 08 May 2014
DB2 10.1 DBA for Linux, UNIX, and Windows certification exam 611 prep, Part 6: High availability
This tutorial highlights the data integrity skills you need in order to protect your database against unexpected failures. Learn how to configure and manage the high availability (HA) features of DB2 V10.1, which introduced the HADR multiple standby setup that provides a true HA and disaster recovery (DR) solution for your mission-critical databases. Examples illustrate how to configure this feature. You also learn about the DB2 pureScale technology that provides continuous HA to your critical business operations. This is part 6 of a series of eight DB2 10.1 DBA for Linux, UNIX, and Windows certification exam 611 tutorials.
Also available in: Chinese  
Articles 01 May 2014
XML or JSON: Guidelines for what to choose for DB2 for z/OS
IBM DB2 for z/OS offers document storage support for both JSON and XML. It is not always apparent whether JSON or XML is most suitable for a particular application. This article provides guidelines to help you select XML or JSON. It includes examples of creating, querying, updating, and managing in both JSON and XML in DB2 for z/OS.
Also available in: Chinese   Russian  
Articles 27 Mar 2014
Parallel processing of unstructured data, Part 2: Use AWS S3 as an unstructured data repository
See how unstructured data can be processed in parallel fashion. Leverage the power of IBM DB2 for Linux, UNIX and Windows to provide efficient highly scalable access to unstructured data stored on the cloud.
Also available in: Russian  
Articles 13 Mar 2014
RUNSTATS: What's new in DB2 10 for Linux, UNIX, and Windows
DB2 10.1 provides significant usability, performance, serviceability, and database administration enhancements for database statistics. In this article, learn about the significant performance enhancements to the RUNSTATS facility. Examples show how to take advantage of new features such as new keywords, index sampling options, enhancements to automatic statistics collection, and functions to query asynchronous automatic runstats work.
Also available in: Russian  
Articles 13 Feb 2014
Using R with databases
R is not just the 18th letter of the English language alphabet, it is a very powerful open source programming language that excels at data analysis and graphics. This article explains how to use the power of R with data that's housed in relational database servers. Learn how to use R to access data stored in DB2 with dashDB and dashDB for Cloud environments, formerly IBM BLU Acceleration. Detailed examples show how R can help you explore data and perform data analysis tasks.
Also available in: Russian  
Articles 06 Feb 2014
Parallel processing of unstructured data, Part 1: With DB2 LUW and GPFS SNC
Learn how unstructured data can be processed in parallel fashion -- within a machine and across a series of machines -- by leveraging DB2 Linux, UNIX, and Windows and GPFS SNC to provide efficient highly scalable access to unstructured data, all through a standard SQL interface. Realize this capability with clusters of commodity hardware, suitable for provisioning in the cloud or directly on bare metal clusters of commodity hardware. Scalability is achieved within the framework via the principle of computation locality. Computation is performed local to the host which has direct data access, thus minimizing or eliminating network bandwidth requirements and eliminating the need for any shared compute resource.
Also available in: Russian  
Articles 30 Jan 2014
Migrating from Sybase to DB2, Part 1: Project description
This article describes the processes and techniques used to migrate trigger code from Transact SQL (Sybase) into SQL PL (DB2). Part 1 describes the intended goal and scope of the project. Part 2 talks about the considerations and challenges we had to overcome to make the database vendor transparent to the application.
Also available in: Russian  
Articles 16 Jan 2014
What's new in InfoSphere Workload Replay for DB2 for z/OS v2.1
InfoSphere Optim Workload Replay for DB2 for z/OS (Workload Replay) extends traditional database test coverage. Now you can capture production workloads and replay them in your test environment without the need to set up a complex client and middle-ware infrastructure. In October 2013, version 2.1 of Workload Replay was released, with key enhancements that we describe in this article.
Also available in: Chinese  
Articles 19 Dec 2013
DB2 Advanced Copy Services: The scripted interface for DB2 Advanced Copy Services, Part 3
The IBM DB2 Advanced Copy Services (DB2 ACS) support taking snapshots for backup purposes in DB2 for Linux, UNIX and Windows databases. You can use the DB2 ACS API either through libraries implemented by your storage hardware vendors (wheras until now, only some do) or you can implement this API yourself which however, involve a high effort. This changes with IBM DB2 10.5.
Also available in: Chinese  
Articles 07 Nov 2013
DB2 Linux, Unix and Windows HADR Simulator use case and troubleshooting guide
Although DB2 high availability disaster recovery (HADR) is billed as a feature that's easy to set up, customers often have problems picking the right settings for their environment. This article is a use case, and it shows how you can use the HADR simulator tool to configure and troubleshoot your HADR configuration in a real-world scenario. Using the examples and generalized guidance that this article provides, you should be able to test your own setups and pick the optimal settings.
Articles 17 Oct 2013
DB2 Advanced Copy Services: The scripted interface for DB2 Advanced Copy Services, Part 2
The DB2 Advanced Copy Services supports taking snapshots for backup purposes in DB2 for Linux, UNIX and Windows databases. Customers can use the DB2 ACS API either through libraries implemented by their storage hardware vendors or implement this API on their own. Additionally, it requires a high degree of effort for customers to implement. This changes with IBM DB2 10.5.
Also available in: Chinese  
Articles 10 Oct 2013
Why low cardinality indexes negatively impact performance
Low cardinality indexes can be bad for performance. But, why? There are many best practices like this that DBAs hear and follow but don't always understand the reason behind. This article will empower the DBA to understand the logic behind why low cardinality indexes can be bad for performance or cause erratic performance. The topics that are covered in this article include B-tree indexes, understanding index cardinality, hypothetical examples of the effects of low cardinality indexes, a real-world example of the effects of a low cardinality index, and tips on how to identify low cardinality indexes and reduce their impact on performance.
Also available in: Chinese  
Articles 26 Sep 2013
DB2 SQL development: Best practices
Most relational tuning experts agree that the majority of performance problems among applications that access a relational database are caused by poorly coded programs or improperly coded SQL. This article provides a reference for developers who need to tune an SQL statement or program. Most times, the slowness is directly related to how you design your programs or structure your SQL statements. This article gives you something to fall back on before calling DBAs or others, to try to improve the performance issue(s) at hand first.
Also available in: Chinese  
Articles 15 Aug 2013
Use Optim Data Tools to get the most out of BLU Acceleration
BLU Acceleration is an exciting new feature in IBM DB2 10.5 that can speed up complex analytic workloads tremendously. Workloads run faster without the need for tuning. At the heart of this new technology is the column-organized format for user tables. It's easy to create and load tables in the new column-organized format, as is ongoing maintenance because there is no need for indexes or tuning materialized query tables (MQTs). This article walks you through three scenarios that illustrate how to use Data Studio and IBM InfoSphere Optim Query Workload Tuner (OQWT) with the new BLU Acceleration feature.
Also available in: Chinese   Russian  
Articles 08 Aug 2013
DB2 Advanced Copy Services: The scripted interface
The DB2 Advanced Copy Services supports taking snapshots for backup purposes in DB2 for Linux, UNIX and Windows databases. Customers can use the DB2 ACS API either through libraries implemented by their storage hardware vendors or implement this API on their own. Additionally, it requires a high degree of effort for customers to implement the C-API of DB2 ACS.
Also available in: Chinese  
Articles 01 Aug 2013
Implementing disaster recovery in IBM PureData System for Transactions
Learn how to set up and execute disaster recovery for DB2 V10.5 databases on the IBM PureData System for Transactions. The solution is based on the DB2 High Availability and Disaster Recovery feature.
Also available in: Chinese   Russian  
Articles 31 Jul 2013
Deploy and explore the DB2 10 pureScale Feature on WebSphere Application Server V8
The IBM DB2 pureScale Feature is designed for continuous availability and tolerance of both planned maintenance and unplanned accidental component failure. DB2 pureScale is a separately priced feature for both IBM DB2 Enterprise Server Edition and DB2 Advanced Enterprise Server Edition. This article describes how to deploy the DB2 10.1 pureScale Feature with IBM WebSphere Application Server (WAS) V8.0.0.1, and also explores the client reroute and workload balancing (WLB) capabilities by using a WAS application. We also examine how a DB2 pureScale cluster recovers from a failure and the impacts on WAS applications. You can apply the information from this article to WAS V8.5.
Also available in: Chinese  
Articles 25 Jul 2013
Load and import error checking for ETL users in DB2 for Linux, UNIX, and Windows
This article demonstrates how to check LOAD and IMPORT operations through ETL calls to SYSPROC.ADMIN_CMD in a DB2 for Linux, UNIX, and Windows database partitioning (DPF) environment. Using ETL calls, you can accomplish error checking with more control and precision than most ETL tools provide.
Also available in: Chinese   Russian  
Articles 11 Jul 2013
Optimizing RUNSTATS in DB2 for Linux, UNIX, and Windows: Troubleshooting index fragmentation
Accurate database statistics allow the DB2 query optimizer to determine efficient access plans. Whether you manage statistics collection yourself or use DB2's automatic statistics collection facility, a slow RUNSTATS can be a problem. In this article, you will learn how to assess if index fragmentation is the root cause of a slow RUNSTATS.
Also available in: Chinese   Russian  
Articles 11 Jul 2013
DB2 JSON capabilities, Part 3: Writing applications with the Java API
DB2 JSON enables developers to write applications using a popular JSON-oriented query language created by MongoDB to interact with data stored in IBM DB2 for Linux, UNIX, and Windows or IBM DB2 for z/OS. This driver-based solution embraces the flexibility of the JSON data representation within the context of a RDBMS with well-known enterprise features and quality of service. This DB2 NoSQL capability supports a command-line processor, a Java API, and a wire listener to work with JSON documents. The DB2 JSON Java API is the backbone of the command-line processor and the wire listener, and supports writing custom applications. The article introduces basic methods with a sample Java program and discusses options to optimize storing and querying JSON documents.
Also available in: Chinese   Japanese  
Articles 03 Jul 2013
DB2 Merge Backup for Linux, UNIX and Windows
Download a free trial version of DB2 Merge Backup for Linux, UNIX and Windows V2.1.0, which shortens recovery times and improves the speed and efficiency of your backup processes. As application databases increase in size and number, so does the amount of time required to complete backup procedures. IBM DB2 Merge Backup for Linux, Unix and Windows lets DBAs perform backups transparent to end users, without taking databases off-line or disrupting applications. This minimizes the costs of downtime, which can include lost business and missed service targets.
Also available in: Chinese  
Trial Downloads 28 Jun 2013
DB2 Recovery Expert for Linux, UNIX and Windows
Download a free trial version of DB2 Recovery Expert for Linux, UNIX, and Windows, V4.1.0 which helps you recover faster and with greater granularity while protecting your critical business data.
Also available in: Chinese   Portuguese  
Trial Downloads 28 Jun 2013
DB2 JSON capabilities, Part 4: Using the IBM NoSQL Wire Listener for DB2
DB2 JSON enables developers to write applications using a popular JSON-oriented query language created by MongoDB to interact with data stored in IBM DB2 for Linux, UNIX, and Windows or IBM DB2 on z/OS. This driver-based solution embraces the flexibility of the JSON data representation within the context of a RDBMS with well-known enterprise features and quality of service. This DB2 NoSQL capability supports a command-line processor, a Java API, and a wire listener to work with JSON documents. In this article, the IBM NoSQL Wire Listener for DB2 is introduced. It parses messages based on the MongoDB wire protocol. It thus enables using MongoDB community drivers, and the skills acquired when working with these drivers, to store, update and query JSON documents with DB2 as JSON store.
Also available in: Chinese   Japanese  
Articles 27 Jun 2013
Optimize DB2 10.5 for Linux, UNIX, and Windows performance using InfoSphere Optim Query Workload Tuner with the DB2 BLU accelerator feature
The new BLU Acceleration feature in IBM DB2 10.5 for Linux, UNIX, and Windows can help improve the performance of your workload by converting row-organized tables to column-organized tables. However, the challenge is to know what tables could be converted and how much performance would improve. In this step-by-step article, you will learn how to use Optim Query Workload Tuner to perform column organization conversion, analyze what-ifs, and improve the performance of your workload.
Also available in: Chinese  
Articles 27 Jun 2013
Performance considerations of the DB2 for Linux, UNIX, and Windows stored procedure ADMIN_MOVE_TABLE
This article describes performance considerations for IBM DB2 for Linux, UNIX, and Windows stored procedure ADMIN_MOVE_TABLE in a SAP system environment. We will examine tables with the characteristics of typical SAP systems.
Also available in: Chinese  
Articles 27 Jun 2013
DB2 JSON capabilities, Part 1: Introduction to DB2 JSON
DB2 JSON enables developers to write applications using a popular JSON-oriented query language created by MongoDB to interact with data stored in IBM DB2 for Linux, UNIX, and Windows or in IBM DB2 for z/OS. This driver-based solution embraces the flexibility of the JSON data representation within the context of an RDBMS, which provides established enterprise features and quality of service. This DB2 JSON capability supports a command-line processor, a Java API, and a wire listener to work with JSON documents. In this article, get an introduction to the DB2 JSON technology.
Also available in: Chinese   Japanese  
Articles 20 Jun 2013
DB2 JSON capabilities, Part 2: Using the command-line processor
Rapidly changing application environments require a flexible mechanism to store and communicate data between different application tiers. JSON (Java Script Object Notation) has proven to be a key technology for mobile, interactive applications by reducing overhead for schema designs and eliminating the need for data transformations. DB2 JSON enables developers to write applications using a popular JSON-oriented query language created by MongoDB to interact with data stored in IBM DB2 for Linux, UNIX, and Windows or IBM DB2 for z/OS. This driver-based solution embraces the flexibility of the JSON data representation within the context of a RDBMS, which provides established enterprise features and quality of service. This DB2 NoSQL capability supports a command-line processor, a Java API, and a wire listener to work with JSON documents. In this article, you will set up a DB2 database to support NoSQL applications and walk through a scenario that introduces basic features of the DB2 JSON command-line processor to help you get started with your own applications.
Also available in: Chinese   Japanese  
Articles 20 Jun 2013
Snapshot monitoring administrative views on DB2 version 10.1 for Linux, UNIX, and Windows
This article demonstrates some of the important and frequently used DB2 snapshot monitoring administrative views in version 10.1. This article is for DB2 database administrators tasked with DB2 monitoring. Snapshot monitoring views are now the preferred means of accessing snapshot data, which represents a huge leap forward by giving administrator access to snapshot data via SQL. All of the information that database administrators have been used to getting from snapshots can be selected from the administrative views.
Also available in: Chinese  
Articles 13 Jun 2013
Secure Sockets Layer (SSL) support in DB2 for Linux, UNIX, and Windows
Using Secure Sockets Layer (SSL) with IBM DB2 means your data can be sent securely over the network. In this article, learn how to configure this protocol for DB2 V9.7 and newer releases.
Also available in: Chinese  
Articles 13 Jun 2013
Backup and restore procedures for the DB2 instance shared directory in a DB2 pureScale environment
In this article, learn about the recovery procedure for a DB2 pureScale instance shared directory (sqllib_shared). By following the procedures described here, you should be able to restore a pureScale instance to its last backup state in the case where some or all files or directories within it become unavailable or unusable.
Also available in: Chinese  
Articles 06 Jun 2013
e-Learning Course for InfoSphere Optim Workload Replay for DB2 for z/OS
Get an overview of IBM InfoSphere Optim Workload Replay for DB2 for z/OS, its architecture, and the capture and replay workflow in this interactive tutorial that shows you how to complete the basic capture and replay workflow in a DB2 for z/OS environment.
Demos 03 Jun 2013
A complete connectivity guide from InfoSphere Information Server to DB2 for i
IBM Information Server supports extracting from and writing to DB2 for System i. To help you overcome any challenges in setting up the connection from Information Server to DB2 for i, this article provides clear, step-by-step instructions, from checking prerequisite information and components to connecting to DB2 for i and defining DataStage jobs.
Also available in: Chinese   Vietnamese  
Articles 30 May 2013
DB2 10.x certification: Everything you need to know
Certification has long been a popular trend in the Information Technology (IT) industry. Consequently, many hardware and software vendors, including IBM, now have certification programs in place that are designed to evaluate and validate an individual's proficiency with their product offerings. But as a DB2 professional, should you become certified? Will being certified increase your ability to administer DB2 databases? Or advance your career? This article is designed to answer these and other questions; it can help you decide if DB2 certification is right for you, and it will show you the path to follow should you decide to acquire one or more of the DB2 certifications that are currently available.
Also available in: Chinese  
Articles 30 May 2013
Technical tip: High availability on DB2 for z/OS on single LPAR systems
This article introduces a high data availability solution on DB2 for z/OS using DB2 BINDs for shops having their test, development and production environments on a single LPAR. Using this method, it is possible to map the test program onto production qualifiers and retrieve data directly from production without the need of data refresh.
Tips 23 May 2013

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