 |
|
|
|
|
|
Optimize your BAR Performance using parallel backups with Informix Dynamic Server
For optimum database backup and restore performance for your IDS database, take advantage of parallelization with the ON-Bar utility. This article introduces ON-Bar, describes the parallel backup and restore sequence, and includes a discussion of configuration parameters and dbspace sizing to achieve your performance objectives.
|
|
Articles |
|
16 Nov 2006 |
|
| |
Developing with PL/SQL in IBM Data Studio 2.2 and Optim Development Studio 2.2
This article describes how you can use
IBM Data Studio 2.2 and
Optim Development Studio 2.2
to develop routines that use Oracle PL/SQL.
It shows you how to create, edit, deploy, and debug PL/SQL packages,
procedures, and functions for the following databases:
DB2 for Linux, UNIX, and Windows Version 9.7,
Oracle 10g, and Oracle 11g.
|
|
Articles |
|
20 Aug 2009 |
|
| |
Optimize Enterprise Generation Language (EGL) applications using pureQuery and Data Studio Developer
This article describes how pureQuery and Data Studio Developer can be used to optimize data access for DB2 LUW and z/OS with EGL Java applications. The article shows how EGL and Data Studio Developer can be installed in a shell-sharing mode, and then how pureQuery can be used with the EGL Java generated code to convert dynamic statements to static statements for the DB2 versions, change captured SQL statements with better performing SQL statements,reduce SQL Injection risk, and look at execution times for the different SQL statements in special views provided in DataStudio.
|
|
Articles |
|
08 May 2009 |
|
| |
Trial: IBM Optim Development Studio and Optim pureQuery Runtime
Learn about IBM Optim Development Studio, which provides an integrated database development environment for Oracle, DB2, and Informix.
Optim Development Studio improves development productivity up to 50% for developing and testing SQL and XQuery queries, stored procedures, Web services, and Java data access layers.
|
|
Trial Downloads |
|
21 Jul 2008 |
|
| |
The Performance and Cost Optimization Ripple Effect
A look at database optimization and what every manager needs to know to make it pay off
|
|
Articles |
|
30 Jun 2009 |
|
| |
What's new and cool in Optim Development Studio 2.2
Optim(TM) Development Studio, previously known as Data Studio Developer,
takes new strides towards realizing IBM's Integrated Data Management vision.
This article explains how developers, architects, and database administrators
(DBAs) can collaborate in new and productive ways in heterogeneous database
environments with Oracle and IBM databases. Learn how you can fast track the
performance of your applications even more using Optim Development Studio and
pureQuery.
|
|
Articles |
|
18 Jun 2009 |
|
| |
Influence query optimization with optimization profiles and statistical views in DB2 9
Learn about enhancements in DB2 9 that enable you to influence the default query optimization behaviour. This capability is particularly useful when you are tuning classes of SQL queries that are not performing as expected, even though you have tuned your queries using the best practices. New techniques now make it possible to overwrite the optimizer behaviour and improve your query performance.
|
|
Articles |
|
07 Dec 2006 |
|
| |
Yet Another Implementation of Optimistic Locking in DB2 UDB EEE V7.2
Preventing lost updates may be challenging. This article describes a simple and very efficient solution to this problem using triggers and SQL stored procedures to generate unique numbers in the middle tier.
|
|
Articles |
|
17 Sep 2002 |
|
| |
Recreate optimizer access plans using db2look
The db2look tool gives you a way to recreate the same access plan for
your test environment that DB2 Universal Database is using for your production
environment. Here are all the details for setting it up.
|
|
Articles |
|
04 Aug 2005 |
|
| |
Optim solutions for accelerating Java database access
This demo shows how the staff at one fictional organization, the Great
Outdoors Company, takes advantage of Optim solutions to help them gain more value from their business-critical Java applications.
|
|
Demos |
|
27 Aug 2009 |
|
| |
DB2 Optimization Techniques for SAP Database Migration and Unicode Conversion
This book provides in-depth information about the best practices and recommendations for the source system database export, the advanced migration techniques, database layout and configuration, database import recommendations, SAP NetWeaver Business Warehouse, as well as background information about Unicode. We summarize our recommendations in one chapter that can be used as a quick reference for experienced migration consultants.
|
|
Redbooks |
|
24 Aug 2009 |
|
| |
Optimize your existing .NET applications using IBM Data Studio's
pureQuery
IBM Data Studio pureQuery Runtime 2.1 includes a new feature, called
client optimization, that enables database administrators and developers to
take advantage of the performance and security benefits of static SQL
execution against IBM DB2 databases without having to modify their existing
custom-developed or packaged .NET applications. In this tutorial, learn how to
enable this capability for an existing .NET application.
|
|
Tutorial |
|
26 Mar 2009 |
|
| |
Optimize the user interface of DB2 CommonStore for Lotus Domino
IBM DB2 CommonStore for Lotus Domino (CSLD) is an excellent and very flexible tool for e-mail archiving. Learn how the Notes mail template can be customized to accommodate typical requirements of office users and includes a sample to get you started.
|
|
Articles |
|
03 Nov 2005 |
|
| |
Distribution statistics uses with the DB2 optimizer
The DB2 optimizer is a cost-based optimizer. It makes decisions based on
statistics that are available for the tables and indexes. When generating
statistics, DB2 offers the possibility to create so-called distribution
statistics, in addition to the basic statistics. This article explains
distribution statistics, when they are important, and what application
developers should consider so that the DB2 optimizer can create efficient
access plans.
|
|
Articles |
|
15 Jun 2006 |
|
| |
Comparing real-time cardinality to the optimizer cardinality estimates
Understanding how to evaluate real cardinality can signficantly help the DBA make various decisions to improve query performance.
|
|
Articles |
|
15 Dec 2005 |
|
| |
Asked and answered: Is there any reason to change the default memory optimization setting on Windows 2000 Server?
Is there any reason to change the default memory optimization setting on Windows 2000 Server from "Maximize data throughput for file sharing" to "Maximize data throughput for network operations" when you have already instructed DB2 to avoid file caching by setting the DB2 registry variable DB2NTNOCACHE to ON? DB2 consultant Chris Fierros explains.
|
|
Articles |
|
10 Apr 2003 |
|
| |
Access Optim archive file data using Cognos
IBM Optim Data Growth Solution can help keep data volumes under control
so that critical business applications can continue to perform well. It can
also help businesses maintain appropriate data for audit purposes at lower
cost. Business intelligence users, however, may need access to information
that has been archived. Optim Data Growth Solution, through Optim Open Data
Manager, provides universal access to that archived data. In this article,
follow the necessary steps to set up connectivity to data that has been
archived by Optim Data Growth Solution so that Cognos users can report on that
archived data.
|
|
Articles |
|
21 May 2009 |
|
| |
IBM Optim Database Administrator: Trial download
Download a free trial version of IBM Optim Database Administrator V2.2, which improves database administrators' (DBAs') productivity and reduces application outages by automating and simplifying complex DB2 structural changes.
|
|
Trial Downloads |
|
30 Mar 2009 |
|
| |
Optim Development Studio and Optim pureQuery Runtime: trial download
Download a free trial version of IBM Optim Development Studio and Optim pureQuery Runtime V2.2, which provides an integrated database development environment for SQL, XQuery, and Java programming languages.
|
|
Trial Downloads |
|
30 Mar 2009 |
|
| |
Database version control with IBM Optim Database Administrator V2.2
Have you ever wondered when the database was changed? With Optim
Database Administrator (previously known as DB2 Change Management Expert),
wonder no more! IBM Optim Database Administrator (ODA) helps you keep track of
changes, work seamlessly with other team members, reverse or undo changes, and
audit any changes that were made to your database. This article describes a
scenario where the DBA organization uses ODA along with the Eclipse Team
project to enhance their collaboration and ensure a consistent audit path.
Learn about connecting to a library control system and saving change
management projects, models, and scripts in library control, as well as
auditing the changes. Also, discover how to retrieve from library control, and
use a change management script to undo the change.
|
|
Articles |
|
30 Jul 2009 |
|
| |
Cognos Controller Reporting Optimization
This document will provide information on converting large volumes of data in Controller database. This document will cover the conversion of Controller-defined reports.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Best Practices: Writing and Tuning Queries for Optimal Performance
Learn best practices for minimizing the impact of SQL statements on DB2 database performance. This paper focuses on good fundamental writing and tuning practices that can be widely applied to help improve DB2 database performance.
|
|
|
|
03 Oct 2008 |
|
| |
Optim Development Studio and pureQuery Runtime
IBM Data Studio Developer is an Eclipse-based integrated database
development environment that speeds application design, development, and
deployment while increasing data access efficiency and performance. Using Data
Studio Developer, you can develop and test routines, generate and deploy
data-centric Web services, create and run SQL and XQuery queries, and develop
and optimize Java technology applications. Designed for use with IBM Data
Studio pureQuery Runtime, together these offerings improve application
performance, security, and manageability. Integrated with the Rational
Software Delivery Platform, Data Studio Developer complements and extends the
capabilities of Rational Application Developer and Rational Developer for
System z.
|
|
|
|
19 Nov 2009 |
|
| |
Optim family
The IBM Optim product family now encompasses Data Studio to provide an
integrated data management environment that offers a comprehensive solution to
help you design, develop, deploy, and manage database applications throughout
the data lifecycle.
|
|
|
|
19 Nov 2009 |
|
| |
Optimize your existing JDBC applications using pureQuery
In Version 1.2, Data Studio Developer and Data Studio pureQuery Runtime
include a new feature called client optimization that enables DBAs and developers to
take advantage of the benefits of static SQL execution
without having to modify their
existing custom-developed, framework-based, or packaged
JDBC applications.
This tutorial shows you how to use the tooling provided by Data Studio Developer to
enable a JDBC application to use this new capability.
|
|
Tutorials |
|
21 Aug 2008 |
|
| |
Optimizing Restore and Recovery Solutions with DB2 Recovery Expert for z/OS V2.1
This IBM Redbooks publication documents how to use Recovery Expert V2.1 for all restore and recovery functions related to system level backup.
|
|
Redbooks |
|
01 Jul 2008 |
|
| |
Striving for Optimal Journal Performance on DB2 Universal Database for iSeries
Journaling is an inherent feature of OS/400 on the iSeries that has been around since the early releases of the System/38. The system employs journals to ensure data integrity and recoverability and this support can further be extended to reduce the duration of an abnormal system end. Journaling also serves as the cornerstone upon which many data replication and data warehouse refresh schemes are built.
|
|
Redbooks |
|
10 Jul 2002 |
|
| |
Using common connections with Optim solutions
Creating database connections requires users to provide specific
information, including the database vendor, version, and URL information. In
version 2.1, Data Studio Developer and Administrator introduced a simple and
efficient way to manage database connections, allowing users to easily store
and retrieve connection parameters for multiple databases. With the 2.2
release (in which these products have been renamed to Optim(TM)), there have
been additional usability improvements. Support for common connections has
also been added to InfoSphere(TM) Data Architect 7.5.2. This article describes
how to use common connections for greater efficiency in managing database
connection information.
|
|
Articles |
|
16 Jul 2009 |
|
| |
Optimize the cursor in Informix Dynamic Server with ESQL/C
IBM Informix ESQL/C has many features to reduce the network traffic
between server and client thereby, increasing the performance of the
application. Understand these features and see you how to use them to achieve
maximum performance.
|
|
Articles |
|
17 Jul 2008 |
|
| |
Optimal DB2 performance with SQLJ and JDBC
JDBC and SQLJ are used to access databases in your Java programs. This tutorial introduces SQLJ and JDBC and covers some of the ways to take advantage of the features of SQLJ when accessing DB2 to achieve the best overall performance in your Java programs.
|
|
Tutorials |
|
14 Nov 2002 |
|
| |
An overview of the IBM Informix Dynamic Server optimizer
This 30-page paper gives you a basic understanding of the Informix Dynamic
Server (IDS) optimizer, including query rewrite, plan generation, the role of statistics, and optimizer directives.
|
|
Articles |
|
11 Jul 2005 |
|
| |
Get the most out of Informix Dynamic Server optimizer through UPDATE STATISTICS
Use the UPDATE STATISTICS statement in IBM Informix Dynamic Server (IDS) to get the most out of the database optimizer. Get a brief overview of this SQL statement and see how it can be used for a variety of problems. Discover the importance of updating statistics and view illustrations that show how statistics are gathered. Finally, browse a FAQ section at the end of the article to answer any lingering questions you might have about this important SQL statement.
|
|
Articles |
|
06 Mar 2008 |
|
| |
Improve concurrency with DB2 9.5 optimistic locking
IBM DB2 Version V9.5 for Linux, UNIX and Windows provides enhanced
optimistic locking support, a technique for SQL database applications that does not
hold row locks between selecting and updating, or deleting rows. Gain an
understanding of this enhancement, and learn how applications using this programming
model benefit from this enhanced optimistic locking feature and gain improved
concurrency.
|
|
Articles |
|
17 Jan 2008 |
|
| |
Informix Dynamic Server data compression and storage optimization
Starting with IBM Informix Dynamic Server (IDS) Version 11.50.xC4, you can
compress data and optimize storage in IDS databases. The advantages of data
compression and storage optimization include significant storage savings, reduced I/O
activity, and faster backup and restore. IDS provides full online support for
enabling storage optimization and compressing existing table data, while applications
continue to use the table. This article provides an overview of IDS data compression and storage optimization functionality and shows you how to perform both tasks.
|
|
Articles |
|
27 Apr 2009 |
|
| |
Trial: IBM Optim Database Administrator
Download a free trial version of IBM Optim Database
Administrator V2.2.1 (previously Data Studio Administrator), which improves database administrators' (DBAs')
productivity and reduces application outages by automating and
simplifying complex DB2 structural changes. Version 2.2 provides enhanced overall administrative task support and extend support for partitioned database environments and high availability disaster recovery.
|
|
Trial Downloads |
|
01 Aug 2008 |
|
| |
Using a SELECTIVITY clause to influence the optimizer
This article explains how you can influence the DB2 SQL optimizer by providing the expected selectivity using a selectivity clause.
|
|
Articles |
|
04 Dec 2003 |
|
| |
Use Optim software to manage privatized test data from design to
deployment
With Optim(TM) Development Studio 2.2, built-in integration with Optim
Test Data Management enables developers and database administrators to use
copy-and-paste function to generate an Optim Test Data Management request. The
request can then be used for the efficient creation of a consistent,
right-sized, referentially intact subset of data for testing. This methodology
also enables you to enforce data privacy standards that were originally
defined in the data model that used InfoSphere(TM) Data Architect. Developers
can see which columns are private to ensure that the generated script enforces
the requirement to include the Optim Data Privacy option for de-identifying
private data. This article offers an end-to-end example scenario depicting a
data architect, a database administrator, and a developer completing the steps
needed for the solution.
|
|
Articles |
|
15 Oct 2009 |
|
| |
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 |
|
| |
Reviewing DB2 for i5/OS query optimizer and database engine feedback mechanisms
Learn how DB2(R) implements requests using various database feedback mechanisms, and understand how the database engine works. Compare the use of Visual Explain with the use of the database monitors or the SQE Plan Cache, and learn when to use which mechanism. Use DB2 for i5/OS(R) to ask for and receive feedback on demand. Then use the iSeries(TM) Navigator to analyze, understand, and tune SQL requests.
|
|
Articles |
|
09 Nov 2006 |
|
| |
De-identify flat files using Optim Data Privacy Solution and InfoSphere
Federation Server
With the current environment of data sensitivity, there is a need to
mask data not only in the traditional relational databases, but also in flat
files that could be part of a testing scenario. Customers continue to need to
send files to vendors, off-shore testers, and even internal testers, and the
data in those files could be subject to regulations. In this article, learn
how to de-identify private data in flat files by using IBM InfoSphere
Federation Server to create a relational table (nickname) for data in flat
files and then applying data privacy algorithms using IBM Optim Data Privacy
Solution.
|
|
Articles |
|
02 Jul 2009 |
|
| |
When We Think That the Optimizer Doesn't Get It Right
Taken from real life experience, author Alexander Kuznetsov shows you some simple tips to make sure the optimizer makes good decisions for your queries.
|
|
Articles |
|
09 Mar 2004 |
|
| |
Optimizing Large Database Imports
IBM Informix data movement utilities provide an easy way to move databases from one machine to another. Large databases, especially those with a large number of associated stored procedures and triggers, can pose special challenges. This article provides a sample script that you can modify to make the job easier and faster.
|
|
Articles |
|
08 Aug 2002 |
|
| |
Optimizing Performance and Scalability with the Informix Web DataBlade Module 4.x
This article describes Informix Web DataBlade performance factors and usage scenarios.
|
|
Articles |
|
29 Jan 2001 |
|
| |
Optimizing DB2 Universal Database for Linux, UNIX, and Windows for Use with WebSphere Business Integration Message Broker V5
This article outlines the use of IBM DB2 Universal Database for Linux, UNIX, and Windows by WebSphere Business Integration Message Broker V5. It explains why monitoring and tuning of database instances and databases is necessary and desirable to optimize the performance of your message flows. This article identifies the parameters that must be changed within DB2 and shows you how to make the changes. Most of the tuning and configuration information in this article also applies to WebSphere MQ Integrator Broker V2.1 and MQSeries System Integrator V2.
|
|
Articles |
|
03 Dec 2003 |
|
| |
Maximize the archiving throughput of DB2 CommonStore for Lotus Domino
DB2 CommonStore for Lotus Domino is a great tool for archiving e-mails or other Notes documents. It comes with many configuration options that influence the overall archiving throughput and performance. In medium and large environments, you should tune for optimum performance. This article gets you started in understanding the settings and provides recommendations for improving archiving throughput.
|
|
Articles |
|
16 Nov 2006 |
|
| |
DB2 Web Services
Curious about how DB2 and data managment fits into the total picture of Web services? How can Web services facilitate information integration and optimized access to a world of data? What do applicaton developers need to know before writing a DB2 Web service application? Your eduction starts here.
|
|
Articles |
|
01 Aug 2002 |
|
| |
Understand IBM Data Studio Version 2 software packaging
This article provides a brief overview of the functionality and packaging
of some of the key Data Studio products from the IBM integrated data management
portfolio. The portfolio includes
Data Studio Developer and Data Studio pureQuery Runtime, Data Studio Administrator, DB2 High Performance Unload, InfoSphere; Data Architect, DB2 Performance Expert and DB2 Performance Expert Extended Insight Feature, and
DB2 Optimization Expert for z/OS.
|
|
Articles |
|
05 Feb 2009 |
|
| |
Exploit the power of Linux with Informix Dynamic Server 10.0
IBM Informix Dynamic Server 10.0 provides transparent optimization and exploitation of Linux environments, using asynchronous, direct and vectored I/O for performance and processor affinity to achieve improved scalability and parallelism.
|
|
Articles |
|
31 Mar 2005 |
|
| |
DB2 Storage Trivia
Read this article for insights, tips and techniques for managing data in a DB2 storage system. You'll learn about storing data for optimum efficiency, EEE vs. non-partitioned databases, page size, system-managed vs. database-managed table spaces, micro-managing data storage, and more. Numerous examples are included.
|
|
Articles |
|
11 Aug 2001 |
|
| |
SQL Tuning: Not just for hardcore DBAs anymore
A look at how IBM Optim Query Tuner for Linux, UNIX, and Windows helps developers create efficient queries and build tuning skills
|
|
Articles |
|
30 Jun 2009 |
|
| |
Advanced topics for DWE users Part 2: Best practices for choosing DB2 Data Warehouse Edition SQL Warehousing variable phases
Optimize your DB2 Data Warehouse Edition flow design with a good understanding
of variable usage in order to promote user satisfaction, support flow reuse, and help
reduce administration overhead. In this article, find recommendations and best practices on how to best utilize different variable phases to maximize the benefits of variable usage in SQL Warehousing Tool data flows and control flows during design time, and how each variable
phase can impact the runtime behavior when these flows are
executed.
|
|
Articles |
|
01 Feb 2007 |
|
| |
DB2 Express-C, the developer-friendly alternative
There are many
no-charge RDBMS (Relational Database Management System) options available today. Some of these are open source, and some are available from commercial vendors at no charge. If you are developing applications using C/C++, Java, .NET, or PHP and looking for a proven data server with innovative technology and a growing developer community base that is already deployed in mission critical solutions, it's time to take a look at the new DB2 Express-C. This article will provide an introduction to what DB2 Express-C is all about. This article examines how you can get started quickly using DB2 Express-C for all of your applications, and it will also provide an automation and tuning scenario to optimize your application.
|
|
Articles |
|
02 Feb 2006 |
|
| |
Understand column group statistics in DB2
With column group statistics in DB2 for Linux, UNIX, and Windows, the optimizer can determine a better query access plan and improve query performance when there is a correlation between multiple equality local predicates or equality join predicates. In this article, learn all about how to use column group statistics.
|
|
Articles |
|
21 Dec 2006 |
|
| |
Introducing DB2 9, Part 3: Self-tuning memory in DB2 9
Tuning your database memory and buffers for optimum performance is effortless with the new self-tuning memory management feature in DB2 9. It automatically configures database memory settings and adjusts them dynamically during run time to optimize performance and improve administrator productivity. Take a look at how it works, explore the benefits, and see the results of this feature in a benchmark setting.
|
|
Articles |
|
01 Jun 2006 |
|
| |
Building efficiencies into a DBA's day
Optim Database Administrator (ODA), previously known as Data Studio Administrator, helps improve Database
Administrator (DBA) productivity by providing advanced change management capabilities as well as support for common database
administration tasks. The SQL and XQuery Editor in ODA (also available as part of Data Studio and other Optim products) provides contextual
help that makes command editing quick and command execution less error-prone.
This article shows you how to
use templates and create customized templates to improve your productivity when using database commands.
It also shows you how to test your customized templates and export them to share with other members of your team.
|
|
Articles |
|
01 Oct 2009 |
|
| |
Using Integrated Data Management To Meet Service Level Objectives
We learn how The Great Outdoor Company, a fictional retailer of outdoor products, uses Integrated Data Management solutions by IBM to optimize data management for performance, productivity, and manageability, allowing them to get the most from their data assets and to ensure they can meet service level objectives (SLOs).
We discuss how organizational and infrastructure complexities can negatively affect overall performance and productivity and how an integrated data management approach can help bridge these silos and gaps to provide end-to-end data and data application life cycle support. To illustrate, we focus on how to optimize an enterprise Java application using the Optim Development Studio (formerly Data Studio Developer) and pureQuery Runtime to improve performance, manageability, and security.
We discuss the practical aspects of managing the deployment and maintenance of pureQuery applications. Because an integrated data management approach extends to the problem solving aspect of the data life cycle, we also discuss how DB2 Performance Expert, DB2 Performance Expert Extended Insight Feature (PE/EI), and IBM Tivoli Composite Application Manager (ITCAM) can help you pinpoint problems in complex application environments.
|
|
Redbooks |
|
09 Nov 2009 |
|
| |
Transformer in Production
A guide to building cubes in Transformer. Particular attention is given to optimizing cube building and to the performance of the resulting cubes from a user perspective.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Trial: IBM InfoSphere Warehouse 9.7 Enterprise Edition
Download a free trial version of IBM InfoSphere
Warehouse V9.7 Enterprise Edition, which makes it easier to
discover hidden business opportunities. It provides a comprehensive platform to design, optimize, discover and grow departmental data marts and enterprise data warehouses.
|
|
Trial Downloads |
|
18 Aug 2009 |
|
| |
InfoSphere Warehouse: Trial download
Download a free trial of IBM InfoSphere Warehouse V9.7 Enterprise Edition, which makes it easier to discover hidden business opportunities and provides a comprehensive platform to design, optimize, discover and grow departmental data marts and enterprise data warehouses.
|
|
Trial Downloads |
|
31 Aug 2009 |
|
| |
DB2 Cube Views Version 8.2 Best Practices
DB2 Cube Views enhances OnLine Analytical Processing (OLAP) in DB2 Universal Data Base V8.2 by extending the power of DB2 summary tables to many Business Intelligence (BI) applications. The DB2 Cube Views Optimization Advisor, used in conjunction with the DB2 Design Advisor, helps you achieve a data warehouse environment that uses an optimum number of DB2 summary tables to satisfy business requirements. This article discusses how to use DB2 Cube Views and what you need to do in order to use it effectively.
|
|
Articles |
|
10 Feb 2005 |
|
| |
Using the DB2 V8.2 Design Advisor, Part 2: Expert help for designing data warehouses
Get expert help with designing data partitioning keys, materialized query tables, and multidimensional clustering for DB2 UDB, in addition to indexes. The Design Advisor offers the help you need and is built right into DB2 UDB. Part 2 of a series, this article explains how to use it to achieve an optimal design for your data warehouse.
|
|
Articles |
|
01 Sep 2005 |
|
| |
Using data federation technology in IBM WebSphere Information Integrator: Data federation usage examples and performance tuning
Data federation gives you a way to integrate the diverse data in your enterprise. This second article in a 2-part series discusses federated query optimization, demonstrates usage examples, and discusses performance tuning considerations for WebSphere Information Integrator.
|
|
Articles |
|
07 Jul 2005 |
|
| |
IBM DB2 Data Access Application Blocks for .NET
Learn how to use an optimized data access component to call stored procedures and execute SQL text commands against a DB2 Server, as well as obtain DB2DataReader, DataSet, and XmlReader objects. Download the source code for this component and learn how to use it to reduce the amount of custom code you need to write, test, and maintain.
|
|
Tutorials |
|
21 Apr 2005 |
|
| |
Scenario2 - Native vs Cognos SQL
This document outlines how to optimize a specific report by evaluating the difference between the Native and Cognos SQL generated by a specific query.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Scenario1 - Child Tabular Model
This document outlines how to optimize a specific report via a child tabular model.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Use of PowerCubes in Cognos 8
Use of PowerCubes in Cognos 8: PCOptimizer, retaining Category IDs, CubeSwap, ReadCache.
|
|
Articles |
|
01 Jan 2009 |
|
| |
Integrating JPA and pureQuery: Leveraging DB2 static execution for the Java Persistence API
IBM WebSphere Application Server V7 delivers an enhancement to its
implementation of the Java Persistence API (JPA) to enable optimization of data
access to DB2 data servers for enhanced security, and the potential to
significantly reduce overhead for data access. The optimization is achieved by
using a built-in integration between the WebSphere JPA and IBM Data Studio
pureQuery Runtime to enable static SQL access -- all without changing
application code or running extensive test cases. This article uses a sample JPA application and takes you through the steps of enabling static SQL using the JPA/pureQuery integration. It also includes the optional follow-on step of using pureQuery client optimization to capture additional queries during run time.
|
|
Articles |
|
10 Dec 2008 |
|
| |
Efficient case-insensitive search with DB2 pureXML
The values of XML elements and attributes are, by definition, case sensitive.
For example, if you search <city> elements for the value "Paris,"
you will not find "PARIS" or "paris."
This can be solved with XQuery functions such as fn:upper-case(),
but the performance will not always be optimal since the use of such functions precludes the use of XML indexes.
This article explains how to create a case-insensitive database using DB2 pureXML and what behavior to expect
for XML queries and XML indexes.
|
|
Articles |
|
13 Nov 2008 |
|
| |
Best Practices: DB2 High Availability Disaster Recovery
View recommendations for setting up and maintaining a DB2 High Availability Disaster Recovery (HADR) environment in ways that balance the protection HADR provides with performance and cost. This best practice explains optimizing for fast failovers, tuning parameters for network and logging performance, and understanding table reorganization methods and load operations in an HADR environment.
|
|
|
|
24 Oct 2008 |
|
| |
Understand the Informix Dynamic Server B-tree scanner
Gain a better understanding of how the B-tree scanner works and learn techniques for leveraging this feature to achieve optimum transaction processing performance.
|
|
Articles |
|
09 Oct 2008 |
|
| |
Further understand column group statistics in DB2
Use multi-column statistics to take advantage of the enhancements to the
SQL Optimizer in DB2 9.5 that extend their use to a broader range of predicates.
|
|
Articles |
|
04 Sep 2008 |
|
| |
Write high performance Java data access applications, Part 3: Data Studio pureQuery API best practices
pureQuery is a high-performance Java data access platform focused
on simplifying the tasks of developing, managing and optimizing applications
and services that access data. It consists of tools, APIs and a runtime engine.
The previous articles in this series introduced the two programming styles
to help users access the database through simple but powerful APIs.
This article summarizes some best practices for development using the
pureQuery API and gives you real-world scenarios to see how to implement these
practices.
|
|
Articles |
|
14 Aug 2008 |
|
| |
RUNSTATS in DB2 UDB Version 8.2
RUNSTATS is the utility in DB2 Universal Database that updates catalog statistics used by the optimizer to determine the fastest path to your data. With DB2 UDB V8.2, the number of RUNSTATS options have increased considerably. Understanding how to use RUNSTATS, with both the existing options and the new ones, can help you gain optimal performance for your database. The author includes many examples to help make it all clear.
|
|
Articles |
|
02 Dec 2004 |
|
| |
DB2 for z/OS and OS/390 Version 7: Using the New Utilities Suite
This redbook describes DB2 Version 7 (for z/OS and OS/390) Utilities Suite product, including information about using wildcards, optimizing concurrent execution of utilities, triggering utilities execution, and considerations for partitioning. Also included: new functions of LOAD (Cross Loader and Online RESUME), REORG, w UNLOAD and COPTYTOCOPY utilities.
|
|
Redbooks |
|
12 Oct 2001 |
|
| |
Seven Essential Elements Whitepaper
This paper introduces 7 elements that are critical to ensure the highest degree of performance and scalability of information integration: data pipelining, dynamic and in-flight (re-) partitioning, design once andh deploy flexibly, supporting parallel databases, real-time data processing, performance optimization tooling, and extensible framework. We highlight the unique advantages of InfoSphere Information Server to achieve the highest level of performance and scalability with the best ROI.
|
|
Articles |
|
17 Jul 2008 |
|
| |
Doing More with More
In this article you will learn about DB2 Universal Database (UDB) for Linux, Unix, and Windows v.8.2 (initially known by its codename, "Stinger". DB2 Version 8.2 continues to deliver self-configuring, self-optimizing, and self-managing database management capabilities.
|
|
Articles |
|
10 Sep 2004 |
|
| |
Use IBM Rational Data Architect to model your Oracle databases
Find out why IBM Rational Data Architect is gaining momentum as a database
modeling tool that is optimized for IBM databases, yet also provides functionality
to model other major database vendors such as Oracle. Look at alternatives to Oracle
Designer, and see how keeping up with Oracle's major enhancements is setting RDA
apart from the rest of the data modeling tools. [2009 Apr 17: Added note about Rational Data Architect changing product
name to InfoSphere Data Architect. --Ed.]
|
|
Articles |
|
17 Apr 2009 |
|
| |
Integrated Data Management: Managing data across its lifecycle
IBM is consolidating many of its
Data Studio offerings under the Optim name.
The Optim portfolio will focus on realizing integrated data management with innovative delivery of
application-aware solutions for managing data and data-driven applications across the lifecycle,
from requirements to retirement.
This overview article explains both the vision and reality of Integrated Data Management
and how you -- whether a data architect, developer or tester, DBA, or data steward -- can use
IBM solutions today to respond quickly to emerging opportunities, improve quality of service,
mitigate risk, and reduce costs.
|
|
Articles |
|
02 Jun 2009 |
|
| |
Understanding the advantages of DB2 9 autonomic computing features
The self tuning memory manager (STMM) is a revolutionary memory tuning feature
that was first introduced in IBM DB2 9. The STMM eases the task of memory configuration by
automatically setting optimal values for most memory configuration parameters,
including buffer pools, package cache, locking memory, sort heap, and total database
shared memory. When STMM is enabled, the memory tuner dynamically distributes the
available memory among the various memory consumers. This article explains the
function of the STMM, teaches you to enable the feature, and also discusses how
STMM can bring real benefits to your business environment.
|
|
Articles |
|
29 Nov 2007 |
|
| |
Comparing DB2 materialized query tables and Oracle materialized
views
Familiarize yourself with DB2 materialized query tables (MQTs) in a
side-by-side comparison with Oracle materialized views. See, also, how the DB2
optimizer uses MQTs.
|
|
Articles |
|
16 Aug 2007 |
|
| |
System Administration Certification exam 918 for IBM Informix Dynamic
Server 11 prep, Part 4: Performance tuning
Tune IBM Informix Dynamic Server
(IDS) and its different subsystems for optimum performance. After a brief overview,
follow along with examples on how to look at the database server and its
subsystems. The fourth in a series of eight tutorials, use this tutorial to help prepare for the
IDS 11 exam 918.
|
|
Tutorials |
|
19 Jul 2007 |
|
| |
Day in the life of a DBA
This demo shows how Integrated Data Management solutions from IBM help one
database administrator (DBA) respond quickly to a wide variety of requirements. The
DBA uses DB2 Performance Expert and Extended Insight Feature to help diagnose complex
performance problems quickly. With Optim Database Administrator, daily database
administration tasks are simpler and less tedious, and database changes can be managed
with less risk and greater auditability. Creating a right-sized test database is easy
to do with Optim Test Data Management, even when private data needs to be
unidentified. Finally, the DBA demonstrates how a colleague can use Optim High
Performance Unload to meet a requirement to migrate large quantities of data up to 10 times faster.
|
|
Demos |
|
21 Oct 2009 |
|
| |
IBM Data Studio pureQuery Runtime for z/OS Performance
pureQuery improves application throughput on DB2 for z/OS by making it
easy to code and deploy static SQL for Java. The new client optimization
feature in Version 1.2 extends the benefits of static SQL to any existing Java
application without changing or recompiling Java applications.
|
|
Articles |
|
01 Jul 2008 |
|
| |
DB2 9: Row compression and large RIDs
See how using large RIDs can circumvent the limits on the number of rows per page, a relevant factor for optimizing the benefits of row compression in DB2 for Linux, UNIX, and Windows, by examining a simple test case of the table ORDERS from the TPCH database.
|
|
Articles |
|
05 Jul 2007 |
|
| |
Write better distributed queries for Informix data servers
Optimize your queries for the best possible performance when accessing multiple Informix servers. Also, read the optimizer's Explain output and learn how Informix processes distributed queries. Furthermore, recognize inefficiencies in a query execution plan and write queries that avoid these pitfalls.
|
|
Articles |
|
10 May 2007 |
|
| |
Informix back up with Tivoli Storage Manager: Using OnBar and ontape utility
OnBar and ontape utilities are features and effective tools for back-up and restore operations on Informix databases. TivoliStorage Manager (TSM) is also considered an effective storage management application. Proper combination of these facilities will lead to an optimal strategy and a trusted back-up andrestore framework for Informix database administration. The main motivation of this article is to educate and encourage Informix and TSM users to use the combination and enjoy the features. This document has been prepared in assumption that the readers have basic knowledge of Informix and its underlying operating system. Preferably this document can be used as a pocket handbook for Informix database administrators and system administrators.
|
|
Articles |
|
15 Mar 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 |
|
| |
IDS locking, Part 2: Understand locking behavior and analyze lock conflicts in IDS
This is the second part of a two-part article talking about locking mechanisms in the IBM strategic data server, IDS. IDS is an optimal choice for high-end OLTP and embedded solutions. This article helps you to understand locking methodology and to run traces for analyzing lock conflicts in your own IDS environment.
|
|
Articles |
|
04 Jan 2007 |
|
| |
Download: Get Statistics Utilities
DB2 Information Integrator enables your applications to query and retrieve data located on other relational and nonrelational sources. To help the federated optimizer make better decisions, you can use these utilities to gather statistics on relational and nonrelational nicknames.
|
|
Articles |
|
01 Aug 2002 |
|
| |
Building the DB2 Health Monitor Sample Application for PHP, Part 2: DB2 pureXML or DOM? You decide
DB2 9 pureXML technology allows businesses to improve data
integrity and avoid legacy data lock-in. It enables application developers
to utilize the best storage medium for the task and eliminate the middle-tier
application logic previously required to take advantage of Web services. It
enables DBAs to centralize logic at the database server
and to help to optimize performance. More importantly, pureXML technology helps to reduce
the complexity of application development back to what it always has been by utilizing
the database for what it does best: to describe, retrieve, and store data. This
article uses the DB2 Health Monitor Sample Application as an example to show you how this
is possible.
|
|
Articles |
|
03 Jan 2008 |
|
| |
DB2 application development: Tracing with the DB2 Universal JDBC Driver
Identify program errors and optimize database access to your Java apps by using the JDBC trace facilities. This article first looks at the CLI-based trace facilities of the DB2 Legacy JDBC driver, then describes the trace facilities of the new DB2 Universal JDBC Driver and demonstrates how to use these trace facilities by example.
|
|
Articles |
|
09 Jun 2005 |
|
| |
Essential Facts about Index Covering in DB2 Universal Database
Author Alexander Kuznetsov uses examples to illustrate cases in which adding a column or two to an index can boost a query's performance by "covering" the columns used in a SELECT statement. The DB2 optimizer is very good in recognizing such situations and can choose a very efficient execution plan.
|
|
Articles |
|
13 Mar 2003 |
|
| |
Predicate Inference in Informix Dynamic Server
This article explains how the IDS optimizer can use query rewrite rules that infer relationships among predicates that are not explicitly stated.
|
|
Articles |
|
19 Jun 2002 |
|
| |
High Performance Inserts on DB2 UDB EEE using Java
Typical decision support systems load and insert large volumes of data periodically. Large scale Decision Support Systems are commonly deployed on partitioned environments. Buffered Inserts is a programming technique offered by DB2 to achieve optimal performance for insert intensive workloads on partitioned environments. This article looks at how to leverage this feature from Java. It will also study the performance gains using this technique under different configurations like varying row lengths and commit frequencies.
|
|
Articles |
|
01 Apr 2002 |
|
| |
XML full-text search in DB2
With the support of natively storing XML documents, IBM DB2 9 takes an evolutionary step towards a hybrid database system. XQuery, a new primary language in DB2, allows for optimally working with XML. However, XML also often contains large portions of text that are not easily searchable with XQuery. To efficiently search these unstructured parts of the documents, DB2 provides a full-text search solution. This article focuses on the basics of DB2 text search, including text index creation and administration. This article also explores specific features of DB2 full-text search, such as searching for keywords or phrases in the XML document structure with fuzzy search, proximity search, and stemming.
|
|
Articles |
|
29 Jun 2006 |
|
| |
Understanding and Tuning Update Statistics
The focus for this article is the collection of information for the optimizer, understanding what is collected, new performance enhancement added and a practical example of performance tuning.
|
|
Articles |
|
25 Mar 2002 |
|
| |
Informix Administration and Housekeeping for SAP R/3
Preventing potential problems in the R/3 Informix Dynamic Server (IDS) database environment is as important as fixing problems. Preventive administration is achieved by constantly managing and monitoring certain aspects of the database system for details such as optimal response times for database access and update activities, database growth, and database integrity.
|
|
Articles |
|
22 Nov 2002 |
|
| |
Performance Considerations for the Information Mining Service of IBM DB2 Information Integrator for Content
IBM DB2 Information Integrator for Content provides an information mining service that converts information that is implicit in unstructured documents to valuable metadata. This article gives you an overview of how to optimize information mining for performance.
|
|
Articles |
|
11 Sep 2003 |
|
| |
DB2 UDB Family On Common Ground
This article explores the common aspects of the DB2 Universal Database family, including SQL, administration, and query optimization.
|
|
Articles |
|
01 Apr 2002 |
|
| |
Create an intelligent and flexible solution with BPM, Business Rules, and Business Intelligence: Data warehouse visibility
This article focuses on the role of business intelligence in an intelligent and flexible BPM solution. It discusses the application of on-line analytical processing (OLAP) technology for advanced analytics, considering both OLAP access and integration. This includes drilling down to the technical details of implementing a dynamic pricing model. Finally, it introduces DB2 Cube Views, an extension to the OLAP paradigm which, when used with OLAP products, can be used to produce optimized OLAP solutions for enterprises.
|
|
Articles |
|
20 Nov 2003 |
|
| |
