All Discussions (18)

Sort by

IDUG 2015 updates

Thank-You for attending IDUG Event in Bangalore - If you registered for DB2 Certification Voucher with your conference registration these will be sent to you directly before the end of April. Presentation Link are added to this group - check right ha

Read more…
5 Replies

Multifetch cursor size.

Hi,

I was doing performance tuning for one of the code and implemented the Multi row fetch and Multi row insert in the code.

I did design the cursor size (how many rows to fetch/insert) based on the following criteria.

1) Size of the buffer pool (I'v

Read more…
3 Replies

Temporal tables

I have a doubt and it is like.. “For a system temporal table, we have Row begin and Row end. We also have TRANSACTION START ID column” What is the use of TRANSACTION START ID column? As per my understanding, Row Begin and Row End should suffice for t

Read more…
3 Replies

DB2 MQT.

Hi,

Do any one worked on the MQT's and implemented them in the Production?..

 

I did try MQT for testing of a staic SQL application program. Though I found it improves the performance I didn't implement it in production b'cos of the maintainability.

Read more…
0 Replies