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 file# (no options specified) | n![]() i=1 |
Unload data file# (-w option specified) |
![]() i = 1
![]() i = 1
c ![]() i = 1 } x n Fixed-length character format: c ![]() i = 1 |
Unload data file# (-j option specified or during reorganization in units of schemas)#4 | n![]() i = 1 n ![]() i = 1 m ![]() j = 1 } + 1,200 + A + B + c x 96 + D + I + F |
LOB data unload file# | n![]() i = 1 m ![]() j = 1 } + 1,200 + A + B + c x 96 + D + I + F |
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 | 1,700 + number of servers storing table x 500 + number of tables in schema x 1,000 + total number of storage RDAREAs in schema x 100 |
Work file#5 | [8 + 2 x S + 2 x {n![]() |
Work file for sorting |
|
D![]() i = 1 (number of abstract-data-type LOB attributes provided by plug-in in column i x a x 72)} + 64 + d ![]() i = 1 |
Number of pages used in the table storage RDAREA x page length of the table storage RDAREA |
Column's data type | Actual length (bytes) |
---|---|
BLOB | 16 |
Abstract data type provided by plug-ins | 2 |
BINARY# |
|
Other | Actual length of each column |
-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 19-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 | 40 | |
FLOAT | 23 | |
SMALLFLT | 23 | |
Character string data#1 | CHARACTER | Defined length + 2#2 |
VARCHAR | Actual length + 2#2 | |
Mixed character string data#1 | MCHAR | Defined length + 2#2 |
MVARCHAR | Actual length + 2#2 | |
National character data#1 | NCHAR | Defined length + 2#2 |
NVARCHAR | Actual length + 2#2 | |
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 data#1 | BINARY | Actual length + 2#2 |
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 19-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 x 2 | |
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 |