The following table shows the formulas for determining the file sizes required for the execution of the database reorganization utility (pdrorg):
File type | Formula (bytes) |
---|---|
Unload data file1 (no options specified) | n![]() ![]() i = 1 |
Unload data file1 (-w option specified) |
![]() ![]() i = 1
![]() ![]() i = 1
c ![]() ![]() i = 1 } ![]() Fixed-length character format: c ![]() ![]() i = 1 |
Unload data file1 (-j option specified or during reorganization in units of schemas)5 | n![]() i = 1 n ![]() i = 1 m ![]() j = 1 } + 1200 + A + B + c ![]() |
LOB data unload file1 | n![]() i = 1 m ![]() j = 1 } + 1200 + A + B + c ![]() |
Index information file |
![]()
![]() These formulas are for the size of one index. If there are multiple indexes, determine the size of each index. |
Process results file | 1700 + number of servers storing table ![]() ![]() ![]() |
Work file for sorting |
![]()
![]() ![]()
|
d![]() ![]() i = 1 (number of abstract-data-type LOB attributes provided by plug-in in column i ![]() ![]() + 64 + d ![]() ![]() i = 1 |
-W option value | Value to be added | |
---|---|---|
-W dat or -W extdat | ,cr | 1 |
,crlf | 2 | |
Not specified | 1 | |
-W fixtext | ,cr | 1 |
,crlf | 2 | |
Not specified | 0 |
Table 20-1 Maximum lengths of converted character strings for columns (in DAT or extended DAT format)
Data type | Maximum length of converted character string (bytes) | |
---|---|---|
Numeric data | INTEGER | 11 |
SMALLINT | 11 | |
DECIMAL | 31 | |
FLOAT | 23 | |
SMALLFLT | 23 | |
Character string data1 | CHARACTER | Defined length + 22 |
VARCHAR | Actual length + 22 | |
Mixed character string data1 | MCHAR | Defined length + 22 |
MVARCHAR | Actual length + 22 | |
National character data1 | NCHAR | Defined length + 22 |
NVARCHAR | Actual length + 22 | |
Date data | DATE | 10 |
Time data | TIME | 8 |
Date interval data | INTERVAL YEAR TO DAY | 9 |
Time interval data | INTERVAL HOUR TO SECOND | 7 |
Time stamp data | TIMESTAMP | 19 If the number of digits for fractions of a second is not 0, add the number of digits for fractions of a second + 1. |
Binary data1 | BINARY | Actual length + 22 |
Data type | Maximum lengths of converted character string (bytes) | |
---|---|---|
Character string data | CHARACTER | Actual length + 2 |
Mixed character string data | MCHAR | Actual length + 2 |
National character data | NCHAR | Actual length + 2 |
Table 20-2 Maximum lengths of converted character strings for columns (fixed-length character format)
Data type | Maximum lengths of converted character string (bytes) | ||
---|---|---|---|
Numeric data | INTEGER | 11 | |
SMALLINT | 6 | ||
DECIMAL | Number of digits + 2 | ||
FLOAT | 23 | ||
SMALLFLT | 23 | ||
Character string data | CHARACTER VARCHAR | Defined length | If fixtext_option is specified in the enclose operand, add 2 to the output length. |
Mixed character string data | MCHAR MVARCHAR | Defined length | |
National character data | NCHAR NVARCHAR | Defined length ![]() | |
Date data | DATE | 10 | |
Time data | TIME | 8 | |
Date interval data | INTERVAL YEAR TO DAY | 10 | |
Time interval data | INTERVAL HOUR TO SECOUND | 8 | |
Time stamp data | TIMESTAMP | Decimal part 0:19 2:22 4:24 6:26 | |
Large object data | BLOB | 0 | |
Binary data | BINARY | 0 | |
Abstract data type | ADT | 0 |