topic Re: Z table size in Application Development and Automation Discussions

Z table size

Former Member — Mon, 05 May 2008 10:08:43 GMT

Hi All,

I have created a Z table and given data class as APPL1 and size category as 2 (Data records expected: 11.000 to 45.000).

After giving that size, the table has already crossed 1 lakh records.

I would like to know, even when i specify size catergory as 2, why it has crossed 45 thousand mark ?

Will be rewarded.

Thanks,

Re: Z table size

Former Member — Mon, 05 May 2008 14:44:37 GMT

Hi Ramprasad,

technical info in the data dictionary is an indication for the database system how to allocate space for the table in an efficient manner. Through some calculations it will determine the size of the table extents and with that a maximum number of records that the table can hold but this number is much bigger than the number indicated in the settings. So, while filling your table it ran out of space several times and it got automatically extended. Check with your coleagues in Basis if you want more details.

Greetings,

Gert.

Re: Z table size

Former Member — Mon, 05 May 2008 14:51:49 GMT

HI,

The table will go for dynamic extension.

Thanks

Re: Z table size

Former Member — Mon, 05 May 2008 15:01:24 GMT

Hi Ramprased,

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.

You can select the categories 0 to 9 for your table. Each category is assigned a specific fixed storage area value in the database.

For an Example : you have selected size category 2. The number of data records expected for the size category is 11.000 to 45.000 . While filling the table if the records are exceeded 45.000 then the storage space is increased for more 11.000 to 45.000 records, like that it goes on increasing.

Hope this helps...

Best regards,

raam

Re: Z table size

Former Member — Mon, 05 May 2008 16:42:19 GMT

Hi Ramprasad,

May I know which version you are using ....

Bcoz this is some problem due to patch level differences from the server side...

If u have Basis Authorizations u can have a look at Tcode SPAM..

U can find the patch levels there.

More over if u upgrade the patch levels ur problem will be resolved..

If u dont have any Authorizations ask ur Basis Admin and upgrade the patch levels.

Then try to create the table.....

may b this will resolve ur issue....

Reward points if helpful...

Thanks & Rewards,

Sudheer.

Re: Z table size

Former Member — Tue, 06 May 2008 04:50:02 GMT

The amount U have allocated is the initial extent, if it exceeds the initial extent it creates the next extent to allocate memory for the records.

Re: Z table size

Former Member — Tue, 06 May 2008 05:34:48 GMT

Hi,

If the size catagory of a table is upto '45,000' it means that

that the block size allocation is 45,000.

When a table is created the initial size is same (say 16,000), whatever may be the size catagory.

when the no. records becomes more than is mark (16,001) a block of memory space is allocated that is given by the size catagory, ie when You are entering the 16,001th record ...... instead of allocating space for one record only , a block of memory is given to the table that is given by the size catagory (45,000). so the size of the table is (16000 + 45000 = 61000) of which 16001 are filled and rest to be filled with records.

Re: Z table size

Former Member — Thu, 22 May 2008 12:31:54 GMT

Hi Ramprasad Simhadri,

Size Category

The Size Category field enables you to specify the maximum number of records you expect this table to hold. You are setting the size of the initial extent and next extents, as well as the maximum number of extents allowed for this table. An extent is the amount of space allocated for a table. The initial extent is the amount of space allocated for a table when it is created. If a table uses up that space, another extent will be allocated, causing the table's space to be extended.

The size categories are always 0 through 4, but the number of expected records in each size category will change with every table based on the length of a row. Choose an appropriate category based on the maximum number of records you expect that table to hold.

CAUTION

When choosing a size category, be generous. In R/3 it is much better to over-estimate than underestimate this parameter. If the size category is too small and the table grows larger than the initial allocation, the RDBMS allocates another extent. Secondary extents reduce performance and require a table-space reorganization to remove. Reorganizations can be very difficult to perform on a large database, especially one that requires high availability. It is much easier to reduce an overly generous size category than it is to increase an underestimated one.

Hope it will solve your doubt..

Reward points if useful...

Thanks & Regards

ilesh 24x7

Re: Z table size

Former Member — Thu, 22 May 2008 13:51:32 GMT

When a table is created, initial space is reserved in the database. If more space

is required at a later time due to data entries, additional memory will be added depending on the

selected size category.

Cheers,

Re: Z table size

former_member787646 — Thu, 22 May 2008 14:24:21 GMT

Hi,

Data Class describes how the table is stored in the Database ie., the table space required in DB.

Size Category describes how many records we can insert at one stretch..if the size (the no of records) exceeded than the limit it will create new stretch automatically to insert the records in DB.

I think it will help you.

Murthy.