|
| |||
|
|
|
|||
|
developerWorks
>
My developerWorks
>
Spaces
>
|
|
|
|
db2ude |
|
|
|
|
||||||
|
||||||||||||||||
|
|
| Explain plan for Stored Procedures |
|
This article explains how to generate explain plan from DB2 SQL Procedures particularly when dynamic SQL statements are used in procedures.
|
|
| Optimistic Locking in DB2 |
|
This article explain optimistic locking in DB2. IBM® DB2®, Version 9.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.
|
|
| DB2 LUW Deep Compression |
|
This article discusses DB2 LUW Deep Compression from the perspective of someone who planned, organized, communicated and coordinated the implementation of this in development, test, regression test and production environments for multi-terabyte data warehouse databases.
|
|
| High performance INSERT in DB2 using column wise Arrays |
|
This article explains a program giving an an example of CLI and embedded SQL statements in the same C program to perform array inserts to achieve high performance. Why do you need to use a mixture of CLI and embedded SQL program? Sometimes, it is desirable from the coding perspective as you use the power of CLI to use array inserts, import, export and load tables and use normal embedded SQL statements as usual.
|
|
| DB2 JDBC Driver Secrets |
|
Some useful tricks and things you wanted to know about JDBC driver
|
|
|
||||
|
|
||||
|
||||
|
||||
|
| C Table UDF |
|
Sometimes, it may be necessary to expose data in your flat file with the relational data. There might be some situations where there is no option to load that data in a table. But still, you need a way to use this flat file data in your SQL statements.
DB2 provides the concept of a table function that you can write. Here is one C table UDF example that reads a file and returns that data through your SQL statement.
|
|
| How to setup STMM? |
|
Self-tuning memory was first introduced in IBM ® DB2 ® 9.1 and simplifies 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 the self tuning memory manager (STMM) is enabled, the memory tuner dynamically distributes the available memory among the various memory consumers.
|
|
| Case insensitive string comparison in DB2 |
|
This article explains how to perform case in-sensitive search in DB2
|
|
