01-10-2008 7:58 AM
Hi friends,
How to calculate the size category when we creating a ztable ???
01-10-2008 8:04 AM
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.
01-10-2008 8:08 AM
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
01-10-2008 8:27 AM
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..