Condition | Formula for determining memory size (KB) |
---|
MGR | 14983 + 2 + 0.05 number of columns + 0.05 number of RDAREAs + 0.15 number of indexes + 0.05 number of index storage RDAREAs + (0.09 + average index statement file length 1024 ) number of index statements) + (0.02 + average directory length 1024 ) (number of idxwork statements + number of sort statements) + (length of control information file + length of execution results file) 1024![[Figure]](figure/zueng010.gif)
- Applicable table containing LOB columns:
+ 0.08 number of LOB storage RDAREAs
- Applicable table containing an abstract data type provided by plug-in:
+ 0.19 number of unld_func statements + ( average length of unld_func statement 1024![[Figure]](figure/zueng010.gif) number of unld_func statements)
- + (
average length of reld_func statement 1024![[Figure]](figure/zueng010.gif) number of reld_func statements)
|
DS | 14554 + 32 + 0.33 number of target BESs + 0.3 number of source BESs + 0.2 number of target RDAREAs + 0.22 number of source RDAREAs + 0.34 number of FESs + (0.09 + average index statement file length 1024 ) number of index statements + (0.02 + average directory length 1024 ) (number of idxwork statements + number of sort statements) + 0.05 number of columns + 0.05 number of RDAREAs + 0.15 number of indexes + 0.05 number of index storage RDAREAs
- Applicable table containing LOB columns:
+ 0.08 number of LOB storage RDAREAs
- When the target table contain BINARY columns:
+ 33 (number of BINARY columns number of target RDAREAs number of source RDAREAs)
- Applicable table containing an abstract data type provided by plug-in:
+ 0.01 number of target BESs + 0.19 number of unld_func statements + ( average length of unld_func statements ![[Figure]](figure/zueng002.gif) 1024![[Figure]](figure/zueng010.gif) number of unld_func statements) + ( average length of reld_func statements ![[Figure]](figure/zueng002.gif) 1024![[Figure]](figure/zueng010.gif) number of reld_func statements) + number of abstract data type columns 1 + (number of LOB attributes 0.05) number of RDAREAs + number of data type plug-ins 10 + number of plug-in indexes 10 |
BES | 66015 + 50 + (517 + 0.01 number of columns) number of target BESs + (33 + 0.01 number of columns) number of source BESs + 0.2 number of target RDAREAs + 1.7 number of source RDAREAs + 0.01 number of columns + 0.26 number of target RDAREAs number of indexes + (0.09 + average index statement file length 1024 ) number of index statements + (0.02 + average directory length 1024 ) (number of idxwork statements + number of sort statements) + 0.05 number of columns + 0.05 number of RDAREAs + 0.15 number of indexes + 0.05 number of index storage RDAREAs + 550 1024 + size of work file for sorting1
- -n option specified:
+ page length of RDAREA2 number of batch input/output buffer sectors y
- Applicable table containing LOB columns:
+ 32 + 0.01 number of LOB columns + (32 + 0.01 number of LOB columns) number of target BESs + 0.18 number of target RDAREAs + 0.1 number of source RDAREAs + 0.08 number of LOB storage RDAREAs
- When the target table contain BINARY columns:
+ 33 (number of BINARY columns number of target RDAREAs number of source RDAREAs)
- When the target table contains abstract data types provided by plug-ins:
+ 40 + (0.27 + 2 length of abstract data type) number of abstract data-type columns + 0.3 number of unld_func statements + {(64 + 0.05 number of LOB attributes) number of abstract data-type columns} number or target BESs + {(64 + 0.01 number of functions specifying unld_func + 0.07 number of abstract data type attributes + 0.05 number of LOB attributes) number of abstract data-type columns} number of source BESs + (33 number of BINARY attributes number of target RDAREAs number of source RDAREAs) 2 + 0.01 number of plug-in indexes + 0.19 number of unld_func statements + ( average length of unld_func statements 1024![[Figure]](figure/zueng010.gif) number of unld_func statements) + ( average length of reld_func statements 1024![[Figure]](figure/zueng010.gif) number of reld_func statements) + number of abstract data-type columns 1 + (number of LOB attributes 0.05) number of RDAREAs + number of data type plug-ins 10 + number of plug-in indexes 10 + memory required for plug-ins
- When the specified index creation method is the batch index creation mode or the index information output mode and the following condition is satisfied:
Number of table partitions number of index definitions > maximum number of processes that can be open - 576 + 2048 |