Tag: IBM software

Automate the Migration to DB2 and IDS Using the IBM Migration Toolkit

IBM Leave a comment
The no-charge IBM Migration Toolkit can simplify and improve your
migration to DB2 Database for Linux, UNIX, and Windows, DB2 on iSeries, DB2 on
z/OS, and Informix Dynamic Server. This migration utility provides a wizard,
an easy-to-use graphical interface with only five steps, as well as a command
line interface to help you quickly convert existing Oracle, Sybase Adaptive
Server Enterprise (ASE), Sybase SQL Anywhere (ASA), and Microsoft SQL Server
database objects to DB2 Database for Linux, UNIX, and Windows, DB2 on iSeries,
DB2 on z/OS, and IDS.

Related:

Managing DB2 for i5/OS schemas and journals

IBM Leave a comment
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.

Related:

Simplify DB2 for i5/OS index advice

IBM Leave a comment
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..

Related:

Using the Java JoinRowSet implementation with DB2 UDB

IBM Leave a comment
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.

Related:

  • No Related Posts

An introduction to IBM DB2 Connect: It’s more than meets the eye: DB2 Connect unifies access to distributed, heterogeneous data

IBM Leave a comment
DB2 Connect
has become the choice method for opening up DB2 for z/OS databases and all of
the traditional recognized benefits of the zSeries hardware platform to the
world of applications that run off the mainframe — namely, distributed
applications. This is the second article in a two part series that will give
you an introduction into the ability for DB2 Connect to provide unified access
to distributed heterogeneous data. This capability greatly enhances your ability to deliver on demand solutions.

Related:

The Big Picture: DB2 and Visual Studio .NET

IBM Leave a comment
Want an overview of the DB2 UDB V8.2 Development Add-In and managed
provider for the Microsoft .NET platform? Learn about the key new RAD
features, DB2 database project, the rich scripting wizards, and the CLR stored
procedures support that are tightly integrated into the Visual Studio .NET IDE
and see how they will simplify your application development tasks.

Related:

DB2 UDB for iSeries cursor sensitivity enhancements

IBM Leave a comment
Kent Milligan explains what cursor sensitivity is and how it’s programmatically controlled on DB2 UDB for iSeries. In addition, the article covers the performance impacts of using the different cursor sensitivity settings.

Related: