|Concurrently Move DB2 for i Tables and Indexes to Solid State Disks
Significant performance benefits can be achieved when DB2 for i indexes or tables reside on Solid State Disks (SSD). The Change Physical File Member (CHGPFM) and Change Logical File (CHGLFM) commands can now be used to concurrently move a member (or partition) of an index or table on or off SSD storage.
|Articles||13 Jun 2011|
|IBM i Performance Data Investigator
The Performance Data Investigator (PDI) is available with the IBM Systems Director Navigator Web console. Using PDI, you can do analysis of performance data from Collection Services, Job Watcher, Disk Watcher, and Performance Explorer. This article reviews the key features of PDI.
|Articles||12 Apr 2011|
|PowerHA SystemMirror for i
PowerHA SystemMirror for i is low maintenance, easy to manage, and always ready to switch. Read about how PowerHA SystemMirror has a replication technology to fit every IBM i environment.
|Articles||12 Apr 2011|
|How to boost application performance using Solid State Disk devices
This article provides an overview of Solid State Disks (SSDs), and how they can be implemented and used effectively on IBM i. It also discusses a simple method to determine and move potential frequently referenced objects to SSDs to take full advantage at the lowest cost of implementation.
|Articles||12 Apr 2011|
|Accelerate Hibernate and iBATIS applications
using pureQuery, Part 2: Using the IBM Integration Module for iBATIS and pureQuery
When extended with the downloadable IBM Integration Module, the IBM Optim pureQuery Runtime simplifies the process of generating DB2 static SQL for Hibernate and iBATIS applications. It does this without requiring you to make changes to your application code or to gather SQL from production workloads. The Optim pureQuery Runtime also enables Hibernate and iBATIS applications that access DB2 or Informix to benefit from the heterogeneous batching feature in pureQuery. With the heterogeneous batching feature, you can batch multiple INSERT, UPDATE, and DELETE requests before sending them across the network, even when the requests reference multiple tables. This article is part two of a two-part series. It describes using the IBM Integration Module with iBATIS applications. This article includes a downloadable sample application that illustrates how you can easily enable static SQL and heterogeneous batch functions with iBATIS applications. Part one of the series focuses on Hibernate applications.
|Articles||16 Sep 2010|
|Process your DB2 for i indexes in parallel
With DB2 for i, parallel processing is useful for more than just queries. Batch processing, data loads, and index builds can all occur much faster if you use multiple processors to do that work. [2010 Aug 19: The author updated this article with content based on enhancements in DB2 for i Version 7.1. --Ed.]
Also available in: Spanish
|Articles||19 Aug 2010|
|Maximize SQE usage with DDS-created DB2 for i databases
Applications utilizing SQL experience the best performance when processed by the DB2 for i SQL Query Engine (SQE). However, your use of SQE may be hampered if your database uses keyed logical files containing select/omit criteria. This article describes how you can use the IGNORE_DERIVED_INDEX query options attribute to maximize the use of the SQL Query Engine with databases that contain keyed logical files.
Also available in: Portuguese
|Articles||14 Jan 2010|
|Gauge SQE use in DB2 for i 6.1
This article explains how to collect a SQL Performance Monitor and understand how many of the SQL queries are using SQE and why other SQL statements continue to use CQE. SQE is the strategic query engine on DB2 for i, with better performance, scaling and tooling such as the SQL Plan Cache.
|Articles||22 Nov 2009|
|IBM DB2 for i 6.1 -- Sophistication simplified
The IBM DB2 for i 6.1 enhancements provide a great foundation for taking your business solutions to new levels. In this article, discover how IBM has delivered the new, sophisticated technology while still maintaining the easy-to-use nature of DB2 for i that has spoiled developers and administrators through the years.
|Articles||12 Jun 2008|
|Managing DB2 for i5/OS schemas and journals
Many System i developers are starting to use SQL to create their database objects instead of the proprietary non-SQL interfaces. This article will show you how to use a schema with DB2 for i5/OS to group related database objects. This article, formerly entitled "Managing DB2 UDB for iSeries Schemas and Journals", has been updated for DB2 for i5/OS.
|Articles||10 Jul 2007|
|Simplify DB2 for i5/OS index advice
DB2 for i5/OS on V5R4 has been enhanced to include an index advice condenser feature to simplify the analysis of index advice from the query optimizer. Much of the raw index advice generated by DB2 has some redundancy and overlap that should be considered when creating indexes based on the advice. This article explains how the new index advisor condenser simplifies this task as well as the interfaces available for using the ondenser..
|Articles||25 Jan 2007|
|Handle distributed transactions with federated two-phase commit in WebSphere Federation Server Version 9.1
So, what's new in the distributed transaction processing area? Federated two-phase commit, a new feature in WebSphere Federation Server Version 9.1 that enables multi-site updates in a distributed transaction environment. Learn how this feature provides location transparency, transaction coordination, error recovery during two-phase commit, resynchronization, and performs indoubt transaction resolution manually.
|Articles||30 Nov 2006|
|Score optimization goals with SQL performance on DB2 for i5/OS
Implement the new performance tuning enhancement in the CLI. As an added benefit, you will have to leverage iSeries Navigator's Performance Monitor feature to analyze any query's optimization goal.
|Articles||16 Nov 2006|
|Leverage the Spatial Extender: Creating an automatically maintained spatial
table from latitude-longitude column data (DB2 Edition)
To take full advantage of the spatial intelligence in your data, turn the separate numeric columns containing coordinate data into a single spatial column, so you can display the locations on a map and analyze spatial relationships using a Geographic Information System (GIS) or the DB2 Spatial Extender. This article shows you how to create and maintain such a column and covers all the aspects of this simple process, including map projections, spatial indexing, and error handling. As an application example, it shows how to perform simple, distance-based queries. Sample code included.
|Articles||13 Apr 2006|
|Using the Java JoinRowSet implementation with DB2 UDB
The efforts of JSR114 bring you the offering of serializable disconnected objects in Java 1.5. With these objects, you can connect to a DB2 UDB database and grab data locally. You can then release your database connection and manipulate the data offline. At a later time, you can reconnect to your database and synchronize changes made to the disconnected objects. In this article, I will show you how you can perform offline JOIN operations on your DB2 Universal Database data using the JoinRowSet interface. Sample code included.
|Articles||07 Jul 2005|
|DB2 UDB, WebSphere, and iBATIS
Learn how to use iBATIS in Java applications and J2EE applications. This article covers the iBATIS syntax, accessing data sources, setting up WebSphere Studio projects to support iBATIS, and querying DB2 using iBATIS.
|Articles||03 Feb 2005|