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 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
1
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
5 + (number of index member columns 2) + number of procedures and triggers whose objects become invalid
1 + number of procedures and triggers whose objects become invalid
4 + (number of index member columns 2)
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
1 + 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
1
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
1 + 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
1
4 + number of view tables defined based on the table
1 + number of routines whose objects become invalid + number of view tables defined based on the table
1
number of routines whose objects become invalid
2
#: If the inner replica facility is used, as many resources are required as there are generations.
19
2
17
1
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
number 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
20 + number of routines in which indexes become invalid + number of member columns 4
1 + number of routines in which the index becomes invalid
19 + number of member columns 4
5 + 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
#: If the inner replica facility is used, a number of lock requests equaling the number of generations is required.
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 +
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
#: If the inner replica facility is used, a number of lock requests equaling the number of generations is required.
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
3 + 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
5
5
20 + number of columns 3
28 + number of columns 4 + number of LOB columns
4 + number of RDAREAs for table
4
29 + number of columns 4 + number of partitioned RDAREAs
21 + number of LOB columns
number of partitioned RDAREAs
4
3
20 + number of columns 3
25 + number of columns 4 + number of LOB columns
4
5 + number of RDAREAs for table 4
0
2
#: If the inner replica facility is used, a number of lock requests equaling the number of generations is required.
21 + number of routines in which objects become invalid 5 + number of resources used by trigger action procedures
5
3 + 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
number of routines in which objects become invalid
22 + number of routines that become invalid + number of attributes 3
1 + number of routines that become invalid
21 + number of attributes 3
number 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
3 + 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
For 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
23 + number of attributes 3 + number of routines whose objects become invalid
number of routines whose objects become invalid
Number of DROP [PUBLIC ]PROCEDURE locked resources
same as DROP [PUBLIC ]PROCEDURE
number of locked resources in DROP [PUBLIC ]PROCEDURE
22 + number of routines in which objects or indexes become invalid + number of member columns 3
1 + 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
5 + 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
#: If the inner replica facility is used, a number of lock requests equaling the number of generations is required.
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
1 + 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
5 + number of RDAREAs storing the index 4 + number of index segments + number of routines in which objects or indexes become invalid
#: If the inner replica facility is used, a number of lock requests equaling the number of generations is required.
19 + number of parameters 5 + number of resources
10 + number of routines in which objects become invalid
1 + 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
number 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
3 + 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
8 + number of routines whose objects or index objects become invalid
number of tables + number of RDAREAs for indexes
#1: If the inner replica facility is used, a number of lock requests equaling the number of generations is required.
#2: Add iteratively if the index is a substructure index.
#3: See the number of lock requests for user-defined deletion.
9 + 2
1
8
2
3 + number of view tables defined based on the table + number of routines that reference the table or view tables to be deleted
5 + number of RDAREAs storing the table 4 + number of table data segments being used + number of routines whose objects become invalid
number of routines in which objects or indexes become invalid
2
#1: If the inner replica facility is used, a number of lock requests equaling the number of generations is required.
#2: Add iteratively if the index is a substructure index.
#3: 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
3 + 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
number 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)
number 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)
number 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
5 + number of specified users
3 + 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
10
5 + number of specified users
5 + number of specified users
7 + number of specified users
1
6 + number of specified users
0