Hello, you are not logged in.  Login or sign up
KNOWLEDGE >> Database Knowledge >> Database Tips >> DB2 Tips
Search Toad World Search
Tip Categories
 
DB2 Tips
 

The DB2 tips below have been submitted by users and Quest Experts. An original posting date denotes a tip that was previously published on the Quest Pipelines site.

Do you have a tip you want to submit? Send it to us today!

DB2 LUW Tips
Tips for DB2 on Linux, Unix and Windows...

Coding Efficient SQL
There are several steps to consider in coding efficient SQL statements...   Read More...
Working with Data in a DGTT
Declared Global Temporary Tables (DGTTs) support data manipulation language (DML) constructs. However, you can only retrieve data from a DGTT table using the SELECT SQL statement (or a stored procedure that issues a SELECT statement). Since the schema definition for a DGTT is always SESSION, you must refer to your DGTTs using the SESSION schema qualifier either explicitly or by setting the default schema to resolve it.   Read More...
Migrate UNION ALL views to a Range Partitioned Table
Prior to range partitions, many applications were developed that used the UNION ALL view capability of DB2 to create a form of range partitioning. Only three steps are required in order to migrate existing UNION ALL views to a range partitioned table.   Read More...
Joining Tables Together with XML Functions
There are a number of techniques that can be used to join tables together within the XML functions. The easiest way to accomplish this is with the WHERE clause using normal column comparisons.   Read More...
Rollin/Rollout Operations with MDC Tables
The DB2 UDB V8.2.2 release (also known as Fix Pack 9) introduced key features for MDC tables that make roll-in and roll-out operations more efficient.   Read More...
Backing up a Database with Split Mirroring
Backing up an entire database or several tablespaces of a large database can put a strain on system resources, require a considerable amount of additional storage space (to hold the backup images), and can reduce the availability of the database system (particularly if the system has to be taken off line in order to be backed up). This tip discusses a popular alternative to creating and maintaining backup images of such databases known as a split mirror.   Read More...
Retrieving Yesterday's Date
The following question was asked recently on the DB2 Pipetalk: "Can anyone tell how to get yesterday's date from DB2?..."   Read More...
DB2 UDB’s Configuration Parameters
DB2 UDB uses an extensive array of configuration parameters to control how system and database resources are allocated and used. Unfortunately, the default values provided for many of these configuration parameters were produced with very simple systems in mind...   Read More...
Copyright 2009 by Quest Software  | Terms Of Use | Privacy Statement | Contact Us