MVSFORUMS.com

SBS · Beginner Joined: 08 Dec 2004 Posts: 1 Topics: 1

Hello,

I am working on an assignment which will generate a file with 50 million records. Then this file has to be loaded to DB2 table. Finally the report needs to be generated from this table by using Business Objects. Here I face a problem on performance. Could anybody suggest what are the steps needs to be taken for improving performance.

One possible solution, I can think of is concept of partitioning and then indexing.
It will be beter if anybody could share the working of above concept in real time to improve the performance.

Thanks & Regrads,
SBS

kolusu · Posted: Wed Dec 08, 2004 9:50 am Post subject:

SBS,

Check this link which explains in detail about Partitioning for optimal parallel performance

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNAGH10/5.11.2?DT=20010212102121

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu