MVSFORUMS.com

Kbatch · Beginner Joined: 23 Apr 2005 Posts: 1 Topics: 1

I am working on data conversion, from flat files into DB2 table.
Current system is having flat files and now we are converting them to DB2 tables.

There are approximately 6000K records to be loaded into a single table. And going forward the records will be added to this table on a daily basis.

Will there be any performance/size issue to store those many records in a single table? Is there any recommandable table size assuming the future growth of the same?

Can some one help me to chose the best approach?

kolusu · Posted: Mon Apr 25, 2005 7:53 am Post subject:

kbatch,

check this link which explains in detail about Estimating disk storage for user data

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

Hope this helps...

Cheers

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