topic Re: Tables in Application Development and Automation Discussions

Tables

Former Member — Thu, 10 Jan 2008 07:58:04 GMT

Hi friends,

How to calculate the size category when we creating a ztable ???

Re: Tables

Former Member — Thu, 10 Jan 2008 08:04:16 GMT

Hi,

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.

Press F4 on the field Size category to see the number of data records

that can be maintained for the individual categories of your table

without complications ensuing. These complications could be for example

a reorganization becoming necessary because the maximum space to be

reserved for the table was exceeded due to the maintained size category.

regards,

Renjith Michael.

Re: Tables

Former Member — Thu, 10 Jan 2008 08:08:10 GMT

Hi sekhar,

Depending upon number of expected records you can specify size category

0 0 to 900

1 900 to 3,600

2 3,600 to 14,000

3 14,000 to 57,000

4 57,000 to 230,000

5 230,000 to 460,000

6 460,000 to 18,000,000.

Regards,

Mohaiyuddin

Re: Tables

Former Member — Thu, 10 Jan 2008 08:27:12 GMT

Hi,

The Size category describes the probable space requirement of the table in the database.

types of size categories :

There are five size categories (0-4)

SzCat Number of data records of table expected

0 --> 0 to 510

1 --> 510 to 2,000

2 --> 2,000 to 8,200

3 --> 8,200 to 33,000

4 --> 33,000 to 2,600,000

You can specify the extent sizes and the tablespace (physical storage area in the database) in which a transparent table is to be stored by setting the size category and data class.

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.

Press F4 on the field Size category to see the number of data records that can be maintained for the individual categories of your table without complications ensuing. These complications could be for example a reorganization becoming necessary because the maximum space to be reserved for the table was exceeded due to the maintained size category.

Regds

Sivaparvathi.

Please reward points if helpful..