topic Re: size category while creating a ztable in Application Development and Automation Discussions

size category while creating a ztable

kiran_k8 — Wed, 22 Jul 2009 04:52:44 GMT

Hi,

I had created a ZTABLE with Size category(Technical Settings) as 1 which has a capacity of 1,400 to ,5700.

Just in case at a later date if the no.fo records gets increased will the system take care of the size category by itself

or it has to be changed again.

Thanks,

K.Kiran

Re: size category while creating a ztable

Former Member — Wed, 22 Jul 2009 04:54:57 GMT

if you know that this may be increased, better define it as a greater value range.

but any ways.

The size category determines the probable space requirement for a table in the database.

You can select the categories 0 to 4 for your table. Each category is assigned a specific fixed storage area value in the database. 
When you create a table, initial space is saved for it in the database. If more space is required later as a result of data that has been 
entered, the storage space is increased in accordance with the category selected.

Re: size category while creating a ztable

Former Member — Wed, 22 Jul 2009 04:55:37 GMT

Hi,

System will take the care of table size as soon we add more recors in table.

Thanks,

Re: size category while creating a ztable

Former Member — Wed, 22 Jul 2009 04:59:11 GMT

Hi Kiran,

Your current settings will work. But it is always good to know the approximately no of records from functional consultant so that we can give appropriate size category.

Thanks & Regards,

Anil Salekar

Re: size category while creating a ztable

Former Member — Wed, 22 Jul 2009 05:37:37 GMT

@ soumya..

had a question.

why do we need four different categories if system adjusts the table sizes itself. Is there any specific reason?

Regards,

Sumit Nene.

Re: size category while creating a ztable

Former Member — Wed, 22 Jul 2009 07:09:33 GMT

Okay this is how it works

suppose size category 0 indicated 1 to 100 records. Now as soon as ur table reaches the 101th record anothe 1 to 100 records will be allocated to the tablespace of this table, thereby wasting table space. If you plan ahead this wastage can be avoided.

Re: size category while creating a ztable

Former Member — Wed, 22 Jul 2009 07:16:17 GMT

@Sumit.

see. when you declare a size category the system saves that much space as default for the data base. and each time mroe records come it increases the size by that size category value.

when we know that there can be HUGE data coming to the DB for that table we define it as larger category from the beginning which wont be needing adjustments in underlying database.

got my point?