![[Contents]](FIGURE/CONTENT.GIF)
Nonstop Database, HiRDB Version 9 System Definition
![[Index]](FIGURE/INDEX.GIF)
![[Back]](FIGURE/FRONT.GIF)
![[Next]](FIGURE/AFTER.GIF)
For ALLOCATE MEMORY TABLE, determine the value if you will be using a memory-resident database.
9 + number of table columns + number of indexes defined for the table ![[Figure]](FIGURE/ZUENG005.GIF)
2 + number of tables subject to memory database processing + number of indexes having the same name as the indexes defined for the table + number of indexes stored in the same database area as for the specified index database area
3 + 2 2 + 2 + number of trigger event columns for which the object becomes invalid + 1 + number of parameters used in the triggers for which the object becomes invalid + 11
8 + number of table columns + number of indexes defined for the table 2 + number of tables subject to memory database processing that is stored in the same XDS + number of indexes having the same name as the indexes defined for the table + number of indexes stored in the same database area as for the specified index database area
2 + 2 2 + 2 + number of trigger event columns for which the object becomes invalid + 1 + number of parameters used in the triggers for which the object becomes invalid + 15 + (number of index member columns 2) + number of procedures and triggers whose objects become invalid
3 + number of resources used by procedures whose objects become invalid 5 5 +number of columns specified as the trigger event of an UPDATE trigger 3 + number of trigger action procedures that reference tables for which an index is defined 5 2 2 + number of functions that use the index type 2 21 + number of procedures and triggers whose objects become invalid
4 + (number of index member columns 2)
3 + number of resources used by procedures whose objects become invalid 5 5 + number of columns specified as the trigger event of an UPDATE trigger 3 + number of trigger action procedures that reference the table for which the index is defined 5 2 2 + number of functions that use the index type 2 25 + number of tables accessed in SQL statement preprocessing + number of view tables accessed in SQL statement preprocessing + number of base tables that serve as the base for view tables accessed in SQL statement preprocessing
2 + 3 2 + 3 2 + 11 + number of tables accessed in SQL statement preprocessing + number of view tables accessed in SQL statement preprocessing + number of base tables that serve as the base for view tables accessed in SQL statement preprocessing
5
2 + 3 2 + 3 2 + 11
5 + number of tables accessed in SQL statement preprocessing + number of view tables accessed in SQL statement preprocessing + number of base tables that serve as the base for view tables accessed in SQL statement preprocessing
4 + 3 + number of tables that define triggers owned by a target person + number of trigger event columns 2 + 1 + number of resource information items used in trigger action conditions 2 + 1 + number of parameters used by triggers 2 + 1 4 + 3 + total number of tables that define triggers + number of trigger event columns 2 + 1 + number of resource information items used in trigger action conditions 2 + 1 + number of parameters used by triggers 2 + 1 21 + number of tables accessed in SQL statement preprocessing + number of view tables accessed in SQL statement preprocessing + number of base tables that serve as the base for view tables accessed in SQL statement preprocessing
5
4 + 3 + number of tables that define triggers owned by a target person + 1 + number of trigger event columns 2 + 1 + number of resource information items used in trigger action conditions 2 + 1 + number of parameters used by triggers 2 + 1 4 + 3 + total number of tables that define triggers + 1 + number of trigger event columns 2 + 1 + number of resource information items used in trigger action conditions 2 + 1 + number of parameters used by triggers 2 + 1 21
4 + number of view tables defined based on the table
3 + 2 2 + 2 + number of defined trigger event columns + 1 + number of parameters used by defined triggers + 1 number of LOB RDAREAs used by the table 2 + 2 2 + 2 number of table partitions + 1 number of table partitions 2 + 2 number of LOB RDAREAs used by the table 2 + 2![[Figure]](FIGURE/ZUENG030.GIF)
Also add the following if partitioning key indexes are defined: number of table partitions + 1 Also add the following when BLOB columns are defined: number of table partitions Also add the following if it is a matrix-partitioned table: 2 + 2 2 + 2 2 + 2 2 + 2 2 + 2 2 + 2 2 + number of BLOB columns defined in the table + number of BLOB attributes of user-defined types defined in the table 2 + 1 number of partitions after RDAREAs are added + 1 number of partitions after RDAREAs are added number of partitions after RDAREAs are added + 1 + number of RDAREAs used by BLOB columns defined in the table 2 + 1 2 + 1 + number of BLOB attributes of user-defined types used in the table number of partitions after RDAREAs are added + 1 3 2 2 Also add the following if partitioning key indexes are defined: number of partitions + 1 number of partitions number of LOB RDAREAs used by the table number of LOB RDAREAs used by the table 2 + 1 + number of RDAREAs used by the table 2 number of partitions + 1 number of partitions + 1 3 3 number of partitions + 1 number of partitions + 1 2 number of partitions + 1 number of partitions + 1 3 + 1 4 + number of member columns in view tables defined based on the table + number of resources used by view tables defined based on the table + number of users having access permission to view tables defined based on the table 2 + number of triggers defined in the table 4 +number of resources used by triggers defined in the table 2 + number of routines used by triggers defined in the table + number of parameters used by triggers defined in the table 2 + number of routines that use columns as parameters 2 2 + 2 + number of index RDAREAs used by the table + 1 + number of member columns of indexes that use columns as member columns + 1 number of table partitions + 1 number of table partitions 2 + 2 + number of RDAREAs in which the table and indexes are no longer stored 2 2 2 + 1 number of partitions + 1 number of partitions + 1 number of partitions 2 2 + 1 + number of routines that use columns as parameters 2 number of partitions 2 + number of partitioning conditions after modification 2 + number of partitions before modification + number of partitions after modification + number of RDAREAs used by the table before modification + number of RDAREAs used by the table after modification 2 + 4 + number of indexes defined in the table + number of indexes subject to deletion + (2 + number of indexes defined in the table 2 + number of BLOB columns defined in the table) (number of RDAREAs added to the table + number of RDAREAs to be deleted from the table) number of partitions before modification + 1 + number of indexes defined in the table number of partitions after modification number of partitions before modification + 1 + number of BLOB columns defined in the table number of partitions after modification 2 + 2 + number of RDAREAs whose data will be deleted + number of RDAREAs in which the table and indexes are no longer stored 2 2 + 4 2 + number of BLOB columns defined in the table) (number of RDAREAs added to the table + number of RDAREAs to be deleted from the table) number of partitions before modification + 1 + number of indexes defined in the table number of partitions after modification number of partitions before modification + 1 + number of BLOB columns defined in the table number of partitions after modification 2 + 2 + number of RDAREAs whose data will be deleted + number of RDAREAs in which the table and indexes are no longer stored 2 2 3 + number of RDAREAs for table 2 number of RDAREAs for index 3 + 1 2 + number of RDAREAs for index 4 7 + number of index segments 3 + 1 2 + 1 number of routines that become invalid 62 + 11 + number of routines whose objects become invalid + number of view tables defined based on the table
1
3 + 2 2 + 2 + number of defined trigger event columns + 1 + number of parameters used by defined triggers + 1 2 + 2 2 + 2 number of table partitions + 1 number of table partitions 2 + 2 2 + 2 Also add the following if partitioning key indexes are defined: number of table partitions + 1 Also add the following when BLOB columns are defined: number of table partitions Also add the following if it is a matrix-partitioned table: 2 + 2 2 + 2 2 + 2 2 + 2 2 + 2 2 + 2 2 + 1 number of partitions after RDAREAs are added + 1 number of partitions after RDAREAs are added number of partitions after RDAREAs are added + 1 + number of RDAREAs used by BLOB columns defined in the table 2 + 1 2 + 1 + number of BLOB attributes of user-defined types used in the table number of partitions after RDAREAs are added + 1 3 2 2 Also add the following if partitioning key indexes are defined: number of partitions + 1 number of partitions 2 + 1 + number of RDAREAs used by the table 2 number of partitions + 1 number of partitions + 1 3 3 number of partitions + 1 number of partitions + 1 2 number of partitions + 1 number of partitions + 1 3 + 1 4 + number of member columns in view tables defined based on the table + number of resources used by view tables defined based on the table + number of users having access permission to view tables defined based on the table 2 + number of triggers defined in the table 4 + number of resources used by triggers defined in the table 2 + number of routines used by triggers defined in the table + number of parameters used by triggers defined in the table 2 + number of routines that use columns as parameters 2 2 + 2 + number of index RDAREAs used by the table + 1 + number of member columns of indexes that use columns as member columns + 1 number of table partitions + 1 number of table partitions 2 + 2 + number of RDAREAs in which the table and indexes are no longer stored 2 2 2 + 1 number of partitions + 1 number of partitions + 1 number of partitions 2 2 + 1 + number of routines that use columns as parameters 2 number of partitions 2 + number of partitioning conditions after modification 2 + number of partitions before modification + number of partitions after modification + number of RDAREAs used by the table before modification + number of RDAREAs used by the table after modification 2 + 2 + number of indexes defined in the table number of partitions before modification + 1 + number of indexes defined in the table number of partitions after modification number of partitions before modification + 1 + number of BLOB columns defined in the table number of partitions after modification 2 + 2 + number of RDAREAs whose data will be deleted + number of RDAREAs in which the table and indexes are no longer stored 2 2 + 2 + number of indexes defined in the table number of partitions before modification + 1 + number of indexes defined in the table number of partitions after modification number of partitions before modification + 1 + number of BLOB columns defined in the table number of partitions after modification 2 + 2 + number of RDAREAs whose data will be deleted + number of RDAREAs in which the table and indexes are no longer stored 2 3 + number of RDAREAs for table 2 3 + 1 2 + number of RDAREAs for index 4 2 + 1 2 + 1 number of routines that become invalid 62 + 1number of routines whose objects become invalid
number of LOB RDAREAs used by the table number of LOB RDAREAs used by the table 2 + number of BLOB columns defined in the table + number of BLOB attributes of user-defined types defined in the table number of LOB RDAREAs used by the table number of LOB RDAREAs used by the table 2 + number of BLOB columns defined in the table) (number of RDAREAs added to the table+ number of RDAREAs to be deleted from the table) 2 4 + number of index segments2
19
2 + 1 2 + 1 2 + 1 2 + 12
17
2 + 1 2 + 1 2 + 1 2 + 11
3
3
7
7
7 + number-of-users-registered-in-dictionary-table-SQL_USERS
1
6 + number-of-users-registered-in-dictionary-table-SQL_USERS
number of locked resources in CREATE [PUBLIC]PROCEDURE + number of routines whose objects become invalid
2 2 4 + 2 + number of resources of routines that become invalid 5 + 1 number of parameters + 1number of locked resources in CREATE [PUBLIC]PROCEDURE + number of routines whose objects become invalid
number of locked resources in CREATE [PUBLIC]PROCEDURE + number of routines whose objects become invalid
2 2 4 + 2 + number of resources of routines that become invalid 5 + 1 number of parameters + 120 + number of routines in which indexes become invalid + number of member columns 4
number of RDAREAs for index 4 4 + 2 5 3 + 1 31 + number of routines in which the index becomes invalid
19 + number of member columns 4
4 4 + 2 5 3 + 1 + number of routines in which the index becomes invalid 35 + number of RDAREAs for the index 2 + number of routines in which the index becomes invalid
number of routines in which indexes become invalid
2
21 + number of routines in which indexes become invalid + number of RDAREAs for index 8 + number of member columns 4 + number of functions applied 5 + ![[Figure]](FIGURE/ZUENG102.GIF)
number of parameters of the functions applied
1 + number of routines in which indexes become invalid
15 + number of RDAREAs for index 6 + number of member columns 4 + number of functions applied 5 + number of parameters of the functions applied + number of routines in which indexes become invalid
5 + number of RDAREAs for index 2 + number of routines in which indexes become invalid
13 + number of tables accessed in SQL statement preprocessing + number of view tables accessed in SQL statement preprocessing + number of base tables that are the basis of view tables accessed in SQL statement preprocessing
7 + 3 3 + 1 2 + 13 + number of tables accessed in SQL statement preprocessing + number of view tables accessed in SELECT statement preprocessing + number of base tables that are the basis of view tables accessed in SELECT statement preprocessing
15
7 + 3 3 + 1 2 + 120 + number of columns 3
3 4 6 + number of LOB attributes number of partitioned RDAREAs 4 + number of user-defined attributes 2 + 5 3 2 6 10 17 4 8 3 (2 + number of resources inside procedure 5) 928 + number of columns 4 + number of LOB columns 4 + number of RDAREAs for table 4
6 number of partitioned RDAREAs 4 2 2 + number of partitioned RDAREAs 6 + 8 + number of member columns 3 10 17 4 8 3 (2 + number of resources inside procedure 5) 929 + number of columns 4 + number of partitioned RDAREAs 21 + number of LOB columns number of partitioned RDAREAs 4
6 number of partitioned RDAREAs 4 2 2 + number of partitioned RDAREAs 6 + 8 + number of member columns 3 10 17 4 8 3 (2 + number of resources inside procedure 5) 93
20 + number of columns 3
3 number of partitioned RDAREAs 4 6 number of partitioned RDAREAs 4 2 3 6 10 17 4 8 3 (2 + number of resources inside procedure 5) 925 + number of columns 4 + number of LOB columns 4
6 number of partitioned RDAREAs 4 2 6 + 8 + number of member columns 3 10 17 4 8 3 (2 + number of resources inside procedure 5) 9 4 + number of partitioned RDAREAs 17 + number of LOB columns number of partitioned RDAREAs 4 4 + number of partitioned RDAREAs (including overlapped ones) 16 + number of LOB columns number of partitioned RDAREAs 4 + number of partitioning keys 2 + (number of storage conditions + 2) 2 + 2 6 + number of LOB attributes number of partitioned RDAREAs 4 + number of user-defined attributes 2 + 5 6 + 8 + number of member columns 3 10 17 4 8 3 (2 + number of resources inside procedure 5) 95 + number of RDAREAs for table 4
20
2
21 + number of routines in which objects become invalid 5 + number of resources used by trigger action procedures 5
5 + 3 3 + number of column types modified by old values correlation names 3 + 3 3 5 + number of resources used by routines 5 53 + number of routines in which objects become invalid
18 + number of routines in which objects become invalid + number of resources used by trigger action procedures 5
5 + 3 3 + number of column types modified by old values correlation names 3 + 3 3 5 + number of resources used by routines 5 5number of routines in which objects become invalid
22 + number of routines that become invalid + number of attributes 3
6 + 2) 4 + 2 + number of resources of the routines that become invalid 5 + 1) number of parameters + 11 + number of routines that become invalid
21 + number of attributes 3
6 + 2) 4 + 2 + number of resources of the routines that become invalid 5 + 1) number of parameters + 1number of routines that become invalid
#: Reference the lock request count of the function definition or the procedure definition.
31 + number of tables accessed in SELECT statement preprocessing + number of view tables accessed in SELECT statement preprocessing + number of base tables that are the basis of view tables accessed in SELECT statement preprocessing + number of columns 4 + number of tables that are the basis of the view table 4 + number of SELECT statements preprocessing
2 23 + number of tables accessed in SELECT statement preprocessing + number of view tables accessed in SELECT statement preprocessing + number of base tables that are the basis of view tables accessed in SELECT statements preprocessing
28 + number of columns 4 + number of tables that are the basis of the view table 4 + number of SELECT statements preprocessing
2 2For DEALLOCATE MEMORY TABLE, determine the value if you will be using a memory-resident database.
4 + number of indexes defined for the table
4 + number of indexes defined for the table
7
7
7 + number-of-users-registered-in-dictionary-table-SQL_USERS
1
6 + number-of-users-registered-in-dictionary-table-SQL_USERS
26 + number of routines that become invalid + number of attributes 3
4 4 + 2 + number of resources of the routines that become invalid 5 + 1 number of parameters + 1 7 + 1 + number of function parameters 4 + 1 + number of procedures used by the functions + 1 5 + 1 + number of procedure parameters 4 + 1 + number of resources used by procedures 5 + 1 523 + number of attributes 3 + number of routines whose objects become invalid
4 4 + 2 + number of resources of the routines that become invalid 5 + 1 number of parameters + 1 7 + 1 + number of function parameters 4 + 1 + number of procedures used by the functions 5 + 1 5 + 1 + number of procedure parameters 4 + 1 + number of resources used by procedures 5 + 1 5number of routines whose objects become invalid
Number of DROP [PUBLIC ]PROCEDURE locked resources
2 2 number of parameters + 1same as DROP [PUBLIC ]PROCEDURE
number of locked resources in DROP [PUBLIC ]PROCEDURE
2 2 number of parameters + 122 + number of routines in which objects or indexes become invalid + number of member columns 3
7 7 + 1 5 3 62 + 11 + number of routines in which objects or the index become invalid
16 + number of member columns 3 + number of routines in which objects or indexes become invalid
3 7 + 1 5 3 62 + 15 + number of RDAREAs for the index 4 + number of index segments + number of routines in which objects or the index become invalid
number of routines in which objects or indexes become invalid
2
15 + number of routines in which objects or indexes become invalid + number of RDAREAs storing the index 10 + number of member columns 4 + number of applicable functions 3 + number of index segments
62 + 11 + number of routines in which objects or indexes become invalid
9 + number of RDAREAs storing the index 6 + number of member columns 4 + number of applicable functions 3 + number of routines in which objects or indexes become invalid
62 + 15 + number of RDAREAs storing the index 4 + number of index segments + number of routines in which objects or indexes become invalid
19 + number of parameters 5 + number of resources 10 + number of routines in which objects become invalid
4 + 2 + number of resources for the routines that become invalid 5 + 1 51 + number of routines in which objects become invalid
18 + number of parameters 3 + number of resources 10 + number of routines in which objects become invalid
4 + 2 + number of resources for the routines that become invalid 5 + 1 5number of routines in which objects become invalid
11 + number of tables inside the schema + number of view tables inside the schema + number of routines inside the schema + number of view tables in other schemas that use tables or view tables inside the schema as base tables + number of indexes in other schemas that reference the tables, view tables, routines, or data types to be deleted
{number of RDAREAs storing the tables 3 + number of specified partitioning conditions 9 + number of columns 4 + (number of LOB columns 4) number of RDAREAs storing the tables + 1 + 8} + 2 (number of RDAREAs for table 10 {number of RDAREAs storing the tables 3 + number of specified RDAREAs storing the tables (including overlapped ones) 12 + number of columns 4 + (number of LOB columns 4) number of RDAREAs storing the tables + 1 + 8 + number of privilege definitions for the tables to be deleted + number of partitioning keys 2 + (number of specified storage conditions + 2) 2 + 2} + 3 (number of RDAREAs for table 10 (number of RDAREAs for indexes 7 + number of member columns 3 + number of index member substructure paths 3#1) + (number of RDAREAs for the indexes 8 + 10 + number of index segments being used) + 8 2 + number of columns for which optimization information is collected 3 + number of indexes for which optimization information is collected 3 (12 + number of base tables for view tables 4 + number of columns 4) (5 + number of resources in procedures 5 + number of defined parameters 3) (2 + number of resources 5) + number of data types defined inside the schema#2 5 8 + total number of columns specified in the UPDATE trigger definition inside the schema 3 + number of triggers that have trigger action conditions inside the schema 3 + number of resource types referenced in the trigger action conditions inside the schema 5 10 9 {(number of RDAREAs storing the tables + (number of LOB columns + number of LOB attributes) number of table-storage RDAREAs) 62} + {(number of RDAREAs for indexes + (number of LOB columns + number of LOB attributes) number of table-storage RDAREAs) 62} + 1 3 + number of sequence generators inside the schema 23 + number of tables inside the schema + number of view tables inside the schema + number of routines inside the schema + number of sequence generators inside the schema + number of view tables in other schemas that use tables or view tables inside the schema as base tables + number of routines in other schemas that reference the tables, view tables, routines, or data types to be deleted
11 + number of indexes in other schemas
{number of RDAREAs storing the tables 3 + number of specified partitioning conditions 9 + number of columns 4 + (number of LOB columns 4) number of RDAREAs storing the tables + number of privilege definitions for the tables to be deleted 3 + 6} + 11 {number of RDAREAs storing the tables 3 + number of specified RDAREAs storing the tables (including overlapped ones) 12 + number of columns 4 + (number of LOB columns 4) number of RDAREAs storing the tables + number of privilege definitions for the tables to be deleted 3 + 1 + 6 + number of partitioning keys 2 + (number of specified storage conditions + 2) 2 + 2} + 3 (number of RDAREAs for the indexes 7 + number of member columns 7 + number of index member substructure paths 3#1) + number of indexes 5 2 + number of columns for which table optimization information is collected 3 + number of indexes for which optimization information is collected 3 (18 + number of base tables for the view tables 4 + number of columns 4 + number of privilege definitions for the view tables 3) (5 + number of resources inside the procedure 10 + number of defined parameters 3) (5 + number of resources 5) + number of for data types defined inside the schema#2 5 8 + total number of columns specified in the UPDATE trigger definition inside the schema 3 + number of triggers that have trigger action conditions inside the schema 3 + number of resource types referenced in the trigger action conditions inside the schema 5 10 9 ((number of RDAREAs storing the tables + (number of LOB columns + number of LOB attributes) number of table-storage RDAREAs) 62) + ((number of RDAREAs for indexes + (number of LOB columns + number of LOB attributes) number of table-storage RDAREAs) 62) + 1 28 + number of routines whose objects or index objects become invalid
(number of RDAREAs storing tables 10 + 10 + number of table data segments being used) (number of RDAREAs for indexes 8 + 10 + number of index segments being used) 2number of tables + number of RDAREAs for indexes
#1: Add iteratively if the index is a substructure index.
#2: See the number of lock requests for user-defined deletion.
9 + 2
3 + 2 2 + 2 + number of defined trigger event columns + 1 + number of parameters used by defined triggers + 11
8
2 + 2 2 + 2 + number of defined trigger event columns + 1 + number of parameters used by defined triggers + 12
4 4 3 9 3 + number of RDAREAs storing the table (including overlapped ones) 8 + number of columns 4 + 5 + number of RDAREAs storing the table 4 + number of table data segments being used + number of partitioning keys 2 + (number of specified storage conditions + 2) 2 + 2 (number of member columns 3) + 3 (number of RDAREAs for index 2) {(number of RDAREAs for index 7) + (number of paths making up the index component 3)#1} 4) number of RDAREAs storing the table + 1 3 + number of indexes for which optimization information is collected 3 {(12 + number of base tables for the view tables) + number of columns 4} + 2 (2 + number of resources inside the procedure 5) 5 4 + number of LOB attributes number of partitioned RDAREAs 5 + number of abstract data-type attributes + 4 8 + total number of columns specified in the UPDATE trigger definition 3 + number of triggers that have trigger action conditions 3 + number of resource types referenced in the trigger action conditions 5 (![[Figure]](FIGURE/ZUENG010.GIF)
number of segments allocated to RDAREAs ![[Figure]](FIGURE/ZUENG002.GIF)
64,000 + 1)#2 10 + total number of functions in referenced tables that are affected by deletion of constraints 17 + number of referenced tables specified by CASCADE 4 8 + number of referenced tables specified by CASCADE 3 9 number of table-storage RDAREAs} 62 + 13 + number of view tables defined based on the table + number of routines that reference the table or view tables to be deleted
4 + total number of functions in referenced tables that are affected by deletion of constraints 4 3 9 3 + number of specified partitioning conditions 9 + number of columns 4 + number of routines whose objects become invalid (number of member columns 3) + 3 {(number of RDAREAs for index 7) + (number of paths making up the index component 3#1)} 4) number of RDAREAs storing the table + 1 3 + number of indexes for which optimization information is collected 3 {12 + number of base tables for the view tables) + number of columns 4} + 2 (2 + number of resources inside the procedure 5) 5 4 + number of LOB attributes number of partitioned RDAREAs 5 + number of abstract data-type attributes + 4 8 + total number of columns specified in the UPDATE trigger definition 3 + number of triggers that have trigger action conditions 3 + number of resource types referenced in the trigger action conditions 5 10 17 + number of referenced tables specified by CASCADE 4 8 + number of referenced tables specified by CASCADE 3 9 number of table-storage RDAREAs} 62 + 15 + number of RDAREAs storing the table 4 + number of table data segments being used + number of routines whose objects become invalid
(number of RDAREAs for indexes 2) + number of index segments being used (number of segments allocated to RDAREAs 64,000 + 1)#2number of routines in which objects or indexes become invalid
2
#1: Add iteratively if the index is a substructure index.
#2: Repeat and add this for the number of LOB RDAREAs.
19 + number of routines in which objects become invalid + number of resources used by trigger action procedures 5
5 + 3 3 + number of column types modified by old values correlation names 3 + 3 3 5 + number of resources used by routines 5 53 + number of routines in which objects become invalid
16 + number of routines in which objects become invalid + number of resources used by trigger action procedures 5
5 + 3 3 + number of column types modified by old values correlation names 3 + 3 3 5 + number of resources used by routines 5 5number of routines in which objects become invalid
10 + number of view tables to be deleted + number of procedures that become invalid + (15 + number of columns 4 + number of tables that are the basis of the view table 4)
(2 + number of resources in procedures 5) 5number of view tables to be deleted + number of procedures that become invalid
10 + (15 + number of columns 4 + number of tables that are the basis of the view table 4)
(2 + number of resources in routines 5) 5number of routines in which objects become invalid
3
3 + number of specified users
3 + number of specified users
3 + number of specified users
3 + number of specified users
5 + number of specified users
number of specified users5 + number of specified users
number of specified users3 + number of specified users
3 + number of specified users
4 + number of specified users
4 + number of specified users
3 + number of specified users
3 + number of specified users
3 + number of specified users
3 + number of specified users
10
number of specified users10
number of specified users5 + number of specified users
5 + number of specified users
7 + number of specified users
2 + 11
6 + number of specified users
2 + 10
All Rights Reserved. Copyright (C) 2014, Hitachi, Ltd.