MVSFORUMS.com

vani · Beginner Joined: 28 May 2003 Posts: 51 Topics: 30

Please find the description of the problem below:

One of the tables being used by our project has a row of length greater than 10k(one of the columns is of size 10k). This required the creation of a tablespace with a 32k bufferpool. But the client side insists on the use of 4k bufferpool .
Now the tables cannot be Normalized any further . One solution is to break up the contents of the 10k column and store them.This is not a decent solution , because of the processing involved in the break up before storage and then the reconstruction during retrieval.This is because the contents of this column is always required in the complete format for any processing to be performed.

Could you please provide me with the other options if available in such situations?
Do write in your opinions on the above issue.

kolusu · Posted: Wed Nov 19, 2003 11:06 am Post subject:

Vani,

First of all you don't need a 32K buffer pool for your requirement.As such your record length is little over 10k and and you can use a PAGESIZE = 16KB which will be able to store the record.

Another option is to compress the data.You can reduce the space required for a table by using data compression if your system meets the requirements. To find out how much space you can save by compressing your data, run the DSN1COMP utility on your data sets. Message DSN1940I of DSN1COMP reports an estimate of the percentage of kilobytes that would be saved by using data compression.check this link for more information on the DSN1COMP utility.

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNUGH12/3.6?DT=20020426135826

IF the compression of the data brings down the length to 8138 then you can go with a pagesize of 8 kb.

Check this link for Calculating the space required for a table

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNAGH11/2.6.2?DT=20010726121552

Hope this helps...

cheers

kolusu