Appendix E.1 Definition SQLs

Organization of this subsection
(1) CREATE CONNECTION SECURITY
(2) CREATE FOREIGN INDEX
(3) CREATE FOREIGN TABLE
(4) CREATE FUNCTION
(5) CREATE INDEX (not a plug-in index)
(6) CREATE INDEX (plug-in index)
(7) CREATE PROCEDURE
(8) CREATE SCHEMA
(9) CREATE SERVER
(10) CREATE TABLE
(11) CREATE TRIGGER
(12) CREATE TYPE
(13) CREATE USER MAPPING
(14) CREATE VIEW
(15) DROP CONNECTION SECURITY
(16) DROP DATA TYPE
(17) DROP FOREIGN INDEX
(18) DROP FOREIGN TABLE
(19) DROP FUNCTION
(20) DROP INDEX (not a plug-in index)
(21) DROP INDEX (plug-in index)
(22) DROP PROCEDURE
(23) DROP SCHEMA
(24) DROP SERVER
(25) DROP TABLE
(26) DROP TRIGGER
(27) DROP USER MAPPING
(28) DROP VIEW

(1) CREATE CONNECTION SECURITY

ConditionNumber of lock requests
HiRDB/Single Server7 + number-of-users-registered-in-dictionary-table-SQL_USERS
HiRDB/Parallel ServerFront-end server1
Dictionary server6 + number-of-users-registered-in-dictionary-table-SQL_USERS

(2) CREATE FOREIGN INDEX

ConditionNumber of lock requests
Front-end server1
Dictionary server20 + number of member columns [Figure]5 + 2

(3) CREATE FOREIGN TABLE

ConditionNumber of lock requests
Dictionary server17 + column count[Figure] 4 + 2

(4) CREATE FUNCTION

ConditionNumber of lock requests
HiRDB/Single Servernumber of locked resources in CREATE PROCEDURE
Add the following when parameters are involved:
+ parameters count[Figure] 2
Add the following when a parameter includes a user-defined type:
+ user-defined types count[Figure] 2
HiRDB/Parallel ServerFront-end server and Back-end serversame as CREATE PROCEDURE
Dictionary servernumber of locked resources in CREATE PROCEDURE
Add the following when parameters are involved:
+ parameters count[Figure] 2
Add the following when a parameter includes a user-defined type:
+ user-defined types count[Figure] 2

(5) CREATE INDEX (not a plug-in index)

ConditionNumber of lock requests
HiRDB/Single Server25 + number of routines in which indexes become invalid + number of RDAREAs for index[Figure] 6 + number of member columns[Figure] 4
Add the following if there are routines that reference a table that defines an index:
+ number of routines that reference the table that defines an index[Figure] 4 + 2
Add the following if there are trigger action procedures that reference a table that defines an index:
+ number of trigger action procedures that reference the table that defines an index[Figure] 5
Add the following if there are two or more RDAREAs for an index:
+ number of RDAREAs for index[Figure] 3 + 1
HiRDB/Parallel ServerFront-end server1 + number of routines in which indexes become invalid
Dictionary server19 + number of RDAREAs for index[Figure] 4 + number of member columns[Figure] 4
Add the following if there are routines that reference a table that defines an index:
+ number of routines that reference the table that defines an index[Figure] 4 + 2
Add the following if there are trigger action procedures that reference a table that defines an index:
+ number of trigger action procedures that reference the table that defines an index[Figure] 5
Add the following if there are two or more RDAREAs for an index:
+ number of RDAREAs for index[Figure] 3 + 1 + number of routines in which indexes become invalid
Back-end server5 + number of RDAREAs for index[Figure] 2 + number of routines in which indexes become invalid
Reference-only back-end server2

(6) CREATE INDEX (plug-in index)

ConditionNumber of lock requests
HiRDB/Single Server21 + number of routines in which indexes become invalid + number of RDAREAs for index[Figure] 8 + number of member columns[Figure] 4 + number of functions applied[Figure] 5 + [Figure] number of parameters of the functions applied
HiRDB/Parallel ServerFront-end server1 + number of routines in which indexes become invalid
Dictionary server15 + number of RDAREAs for index[Figure] 6 + number of member columns[Figure] 4 + number of functions applied[Figure] 5 + [Figure] number of parameters of the functions applied + number of routines in which indexes become invalid
Back-end server5 + number of RDAREAs for index[Figure] 2 + number of routines in which indexes become invalid

(7) CREATE PROCEDURE

ConditionNumber of lock requests
HiRDB/Single Server13 + 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
Add the following if a resource to be used exists:
+ number of resources to be used[Figure]7 + 3
Add the following if parameters are specified:
+ number of parameters[Figure]3 + 1
Add the following if the parameter data type is a user-defined type:
+ number of user-defined type parameters[Figure]2 + 1
HiRDB/Parallel ServerFront-end server3 + 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
Dictionary server15
Add the following if a resource to be used exists:
+ number of resources to be used[Figure]7 + 3
Add the following if parameters are specified:
+ number of parameters[Figure]3 + 1
Add the following if the parameter data type is a user-defined type:
+ number of user-defined type parameters[Figure]2 + 1

(8) CREATE SCHEMA

ConditionNumber of lock requests
HiRDB/Single Server5
HiRDB/Parallel Server (Dictionary server)

(9) CREATE SERVER

ConditionNumber of lock requests
Dictionary server9 + pd_max_foreign_server operand value

(10) CREATE TABLE

ConditionNumber of lock requests
HiRDB/Single ServerRDAREA for table is omitted and the table is not row-partitioned29 + number of public user RDAREAs[Figure] 3 + number of columns[Figure] 3 + number of LOB columns[Figure] 4
Add the following if a user-defined type is used:
+ number of user-defined types[Figure] 6 + number of LOB attributes[Figure] number of partitioned RDAREAs[Figure] 4 + number of user-defined attributes[Figure] 2 + 5
Add the following if a cluster key is defined:
+ 5 + number of RDAREAs for index[Figure] 2 + number of partitioned RDAREAs[Figure] 6 + 8 + number of member columns[Figure] 3
Add the following if a referential constraint is defined:
+ number of referenced tables
+ number of foreign keys[Figure] 10
Add the following if CASCADE is defined for referential constraint operation:
+number of CASCADEs [Figure]17
+number of referenced tables specified by CASCADE[Figure] 4
Add the following if the specification of referential constraint operation is UPDATE ON CASCADE:
+ total number of primary key member columns of the referenced table for which CASCADE is specified[Figure] 8
+ number of referenced tables specified by CASCADE[Figure] 3
Add the following if there are functions that become invalid:
+ number of functions whose objects are invalid
+[Figure] (2 + number of resources inside procedure[Figure] 5)
+ total number of functions that reference the referenced tables
Add the following if a check constraint is defined:
+ number of check constraints[Figure] 9
RDAREA for table is specified and the table is not row-partitioned28 + number of columns[Figure] 4 + number of LOB columns[Figure] 4 + number of RDAREAs for table[Figure] 4
Add the following if a user-defined type is used:
+ number of user-defined types[Figure] 6 + number of LOB attributes[Figure] number of partitioned RDAREAs[Figure] 4 + number of user-defined attributes[Figure] 2 + 5
Add the following if a cluster key is defined:
+ 5 + number of RDAREAs for index[Figure] 2 + number of partitioned RDAREAs[Figure] 6 + 8 + number of member columns[Figure] 3
Add the following if a referential constraint is defined:
+ number of referenced tables
+ number of foreign keys[Figure] 10
Add the following if CASCADE is defined for referential constraint operation:
+number of CASCADEs [Figure]17
+number of referenced tables specified by CASCADE[Figure] 4
Add the following if the specification of referential constraint operation is UPDATE ON CASCADE:
+ total number of primary key member columns of the referenced table for which CASCADE is specified[Figure] 8
+ number of referenced tables specified by CASCADE[Figure] 3
Add the following if there are functions that become invalid:
+ number of functions whose objects are invalid
+[Figure] (2 + number of resources inside procedure[Figure] 5)
+ total number of functions that reference the referenced tables
Add the following if a check constraint is defined:
+ number of check constraints[Figure] 9
Row-partitioned table29 + number of columns[Figure] 4 + number of partitioned RDAREAs[Figure] 21 + number of LOB columns[Figure] number of partitioned RDAREAs[Figure] 4
Add the following if a user-defined type is used:
+ number of user-defined types[Figure] 6 + number of LOB attributes[Figure] number of partitioned RDAREAs[Figure] 4 + number of user-defined attributes[Figure] 2 + 5
Add the following if a cluster key is defined:
+ 5 + number of RDAREAs for index[Figure] 2 + number of partitioned RDAREAs[Figure] 6 + 8 + number of member columns[Figure] 3
Add the following if a referential constraint is defined:
+ number of referenced tables
+ number of foreign keys[Figure] 10
Add the following if CASCADE is defined for referential constraint operation:
+number of CASCADEs [Figure]17
+number of referenced tables specified by CASCADE[Figure] 4
Add the following if the specification of referential constraint operation is UPDATE ON CASCADE:
+ total number of primary key member columns of the referenced table for which CASCADE is specified[Figure] 8
+ number of referenced tables specified by CASCADE[Figure] 3
Add the following if there are functions that become invalid:
+ number of functions whose objects are invalid
+[Figure] (2 + number of resources inside procedure[Figure] 5)
+ total number of functions that reference the referenced tables
Add the following if a check constraint is defined:
+ number of check constraints[Figure] 9
HiRDB/Parallel Server (front-end server)3
Add the following if a referential constraint is defined:
+ number of referenced tables
+ total number of routines that reference the referenced tables
HiRDB/Parallel Server (Dictionary server)RDAREA for table is omitted and the table is not row-partitioned20 + number of public user RDAREAs[Figure] 3 + number of columns[Figure] 3 + number of LOB columns[Figure] number of partitioned RDAREAs[Figure] 4
Add the following if a user-defined type is used:
+ number of user-defined types[Figure] 6 + number of LOB attributes[Figure] number of partitioned RDAREAs[Figure] 4 + number of user-defined attributes[Figure] 2 + 5
Add the following if a cluster key is defined:
+ number of partitioned RDAREAs[Figure] 6 + 8 + number of member columns[Figure] 3
Add the following if a referential constraint is defined:
+ number of foreign keys[Figure] 10
Add the following if CASCADE is defined for referential constraint operation:
+number of CASCADEs [Figure]17
+number of referenced tables specified by CASCADE[Figure] 4
Add the following if the specification of referential constraint operation is UPDATE ON CASCADE:
+ total number of primary key member columns of the referenced table for which CASCADE is specified[Figure] 8
+ number of referenced tables specified by CASCADE[Figure] 3
Add the following if there are functions that become invalid:
+ number of functions whose objects are invalid
+[Figure] (2 + number of resources inside procedure[Figure] 5)
Add the following if a check constraint is defined:
+ number of check constraints[Figure] 9
RDAREA for table is specified and the table is not row-partitioned25 + number of columns[Figure] 4 + number of LOB columns[Figure] 4
Add the following if a user-defined type is used:
+ number of user-defined types[Figure] 6 + number of LOB attributes[Figure] number of partitioned RDAREAs[Figure] 4 + number of user-defined attributes[Figure] 2 + 5
Add the following if a cluster key is defined:
+ number of partitioned RDAREAs[Figure] 6 + 8 + number of member columns[Figure] 3
Add the following if a referential constraint is defined:
+ number of foreign keys[Figure] 10
Add the following if CASCADE is defined for referential constraint operation:
+number of CASCADEs [Figure]17
+number of referenced tables specified by CASCADE[Figure] 4
Add the following if the specification of referential constraint operation is UPDATE ON CASCADE:
+ total number of primary key member columns of the referenced table for which CASCADE is specified[Figure] 8
+ number of referenced tables specified by CASCADE[Figure] 3
Add the following if there are functions that become invalid:
+ number of functions whose objects are invalid
+[Figure] (2 + number of resources inside procedure[Figure] 5)
Add the following if a check constraint is defined:
+ number of check constraints[Figure] 9
Row-partitioned tableAdd the following when the table is not a matrix-partitioned table:
24 + number of columns[Figure] 4 + number of partitioned RDAREAs[Figure] 17 + number of LOB columns[Figure] number of partitioned RDAREAs[Figure] 4
Add the following when the table is a matrix-partitioned table:
21 + number of columns[Figure] 4 + number of partitioned RDAREAs (including overlapped ones) [Figure] 16 + number of LOB columns[Figure] number of partitioned RDAREAs[Figure] 4 + number of partitioning keys[Figure] 2 + (number of storage conditions + 2) [Figure] 2 + 2
Add the following if a user-defined type is used:
+ number of user-defined types[Figure] 6 + number of LOB attributes[Figure] number of partitioned RDAREAs[Figure] 4 + number of user-defined attributes[Figure] 2 + 5
Add the following if a cluster key is defined:
+ number of partitioned RDAREAs[Figure] 6 + 8 + number of member columns[Figure] 3
Add the following if a referential constraint is defined:
+ number of foreign keys[Figure] 10
Add the following if CASCADE is defined for referential constraint operation:
+number of CASCADEs [Figure]17
+number of referenced tables specified by CASCADE[Figure] 4
Add the following if the specification of referential constraint operation is UPDATE ON CASCADE:
+ total number of primary key member columns of the referenced table for which CASCADE is specified[Figure] 8
+ number of referenced tables specified by CASCADE[Figure] 3
Add the following if there are functions that become invalid:
+ number of functions whose objects are invalid
+[Figure] (2 + number of resources inside procedure[Figure] 5)
Add the following if a check constraint is defined:
+ number of check constraints[Figure] 9
HiRDB/Parallel Server (Back-end server)5 + number of RDAREAs for table[Figure] 4
Add the following if a cluster key is defined:
+ 5 + number of RDAREAs for index[Figure] 2
HiRDB/Parallel Server (reference-only back-end server)2
Add the following if a cluster key is defined:
+ 1

(11) CREATE TRIGGER

ConditionNumber of lock requests
HiRDB/Single Server21 + number of routines in which objects become invalid[Figure] 5 + number of resources used by trigger action procedures[Figure] 5
Add the following if a trigger action condition is specified:
+ number of resources used inside trigger action condition specification[Figure] 5 + 3
Add the following if a column name modified by an old or new values correlation name is used inside a trigger action procedure:
+ number of column types modified by new values correlation names[Figure] 3 + number of column types modified by old values correlation names[Figure] 3 + 3
Add the following if trigger event columns are specified:
+ number of trigger event columns[Figure] 3
Add the following if there are routines that become invalid:
+ number of invalid routines[Figure] 5 + number of resources used by routines[Figure] 5
Add the following if there are trigger action procedures in the routines that become invalid:
+ number of trigger action procedures[Figure] 5
HiRDB/Parallel ServerFront-end server3 + number of routines in which objects become invalid
Dictionary server18 + number of routines in which objects become invalid + number of resources used by trigger action procedures[Figure] 5
Add the following if a trigger action condition is specified:
+ number of resources used inside trigger action condition specification[Figure] 5 + 3
Add the following if a column name modified by an old or new values correlation name is used inside a trigger action procedure:
+ number of column types modified by new values correlation names[Figure] 3 + number of column types modified by old values correlation names[Figure] 3 + 3
Add the following if trigger event columns are specified:
+ number of trigger event columns[Figure] 3
Add the following if there are routines that become invalid:
+ number of invalid routines[Figure] 5 + number of resources used by routines[Figure] 5
Add the following if there are trigger action procedures in the routines that become invalid:
+ number of trigger action procedures[Figure] 5
Back-end servernumber of routines in which objects become invalid

(12) CREATE TYPE

ConditionNumber of lock requests
HiRDB/Single Server22 + number of routines that become invalid + number of attributes[Figure] 3 + (number of user-defined types[Figure] 6 + 2)1 + 112 + (number of routines that become invalid[Figure] 4 + 2 + number of resources of the routines that become invalid[Figure] 5 + 1)3 + number of locked resources for function/procedure definitions4
HiRDB/Parallel ServerFront-end server1 + number of routines that become invalid + number of locked resources for function/procedure definitions4
Dictionary server21 + number of attributes[Figure] 3 + (number of user-defined types[Figure] 6 + 2)1 + 112 + (number of routines that are invalid[Figure] 4 + 2 + number of resources of the routines that become invalid[Figure] 5 + 1)3 + number of locked resources for function or procedure definitions4
Back-end servernumber of routines that become invalid

1 Add this if a user-defined type attribute is present.

2 Add this if a subtype definition is involved.

3 Add this if there is a routine that becomes invalid.

4 Add this if a function or procedure is to be defined. Refer to the number of lock requests in the function definition or procedure definition.

(13) CREATE USER MAPPING

ConditionNumber of lock requests
Dictionary server11

(14) CREATE VIEW

ConditionNumber of lock requests
HiRDB/Single Server31 + 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[Figure] 4 + number of tables that are the basis of the view table[Figure] 4 + number of SELECT statements preprocessing
HiRDB/Parallel ServerFront-end server3 + 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
Dictionary server28 + number of columns[Figure] 4 + number of tables that are the basis of the view table[Figure] 4 + number of SELECT statements preprocessing

(15) DROP CONNECTION SECURITY

ConditionNumber of lock requests
HiRDB/Single Server7 + number-of-users-registered-in-dictionary-table-SQL_USERS
HiRDB/Parallel ServerFront-end server1
Dictionary server6 + number-of-users-registered-in-dictionary-table-SQL_USERS

(16) DROP DATA TYPE

ConditionNumber of lock requests
HiRDB/Single Server26 + number of routines that become invalid + number of attributes[Figure] 3
Add the following for a subtype:
+ 6
Add the following if there are user-defined type attributes:
+ number of user-defined type attributes[Figure] 4
Add the following if there are routines that become invalid:
+ number of routines that become invalid[Figure] 4 + 2 + number of resources of routines that become invalid[Figure] 5 + 1
Add the following if there are function definitions:
+ number of function definitions[Figure] 7 + 1 + number of function parameters[Figure] 4 + 1 + number of procedures used by the functions[Figure] 5 + 1
Add the following if there are procedure definitions:
+ number of procedure definitions[Figure] 5 + 1 + number of procedure parameters[Figure] 4 + 1 + number of resources used by procedures[Figure] 5 + 1
Add the following if a trigger action condition is specified:
+ 15
Add the following if there are trigger action procedures in the routines that become invalid:
+ number of trigger action procedures[Figure] 5
HiRDB/Parallel ServerFront-end server1 + number of routines that become invalid
Dictionary server23 + number of attributes[Figure] 3 + number of routines in which objects become invalid
Add the following for a subtype:
+ 6
Add the following if there are user-defined type attributes:
+ number of user-defined type attributes[Figure] 4
Add the following if there are routines that become invalid:
+ number of routines that become invalid[Figure] 4 + 2 + number of resources of routines that become invalid[Figure] 5 + 1
Add the following if there are function definitions:
+ number of function definitions[Figure] 7 + 1 + number of function parameters[Figure] 4 + 1 + number of procedures used by the functions[Figure] 5 + 1
Add the following if there are procedure definitions:
+ number of procedure definitions[Figure] 5 + 1 + number of procedure parameters[Figure] 4 + 1 + number of resources used by procedures[Figure] 5 + 1
Add the following if a trigger action condition is specified:
+ 15
Add the following if there are trigger action procedures in the routines that become invalid:
+ number of trigger action procedures[Figure] 5
Back-end servernumber of routines in which objects become invalid

(17) DROP FOREIGN INDEX

ConditionNumber of lock requests
Front-end server1
Dictionary server21 + number of member columns[Figure] 3
Add the following when creating optimization information for a foreign index:
+ 4

(18) DROP FOREIGN TABLE

ConditionNumber of lock requests
Front-end server1 + number of view tables defined based on foreign tables + number of routines that reference the foreign tables or view tables that are to be deleted
Dictionary server19 + number of columns[Figure] 4 + number of privilege definitions for the foreign table to be deleted[Figure] 3 + number of routines in which objects become invalid
Add the following if indexes are defined:
+ number of foreign indexes[Figure] 5 + [Figure] (number of member columns[Figure] 7 + 4)
Add the following when creating optimization information:
+ 2 + number of columns for which optimization information is to be created[Figure] 3 + number of foreign indexes for which optimization information is to be created[Figure] 3
Add the following for the base table of a view table:
+ number of view tables to be deleted
+ [Figure] {20 + number of columns[Figure] 4 + number of base tables for view tables + number of privilege definitions for view tables[Figure] 3} + 2
Add the following if there are routines that become invalid:
+ number of routines in which objects become invalid + [Figure] (2 + number of resources inside a procedure[Figure] 5) + 1
Back-end servernumber of routines in which objects become invalid

(19) DROP FUNCTION

ConditionNumber of lock requests
HiRDB/Single Servernumber of locked resources in DROP PROCEDURE
Add the following if there are parameters:
+ number of parameters[Figure] 2
Add the following if there are user-defined type parameters:
+ number of user-defined types[Figure] 2
Add the following if a trigger action condition is specified:
+ 15
HiRDB/Parallel ServerFront-end server and Back-end serversame as DROP PROCEDURE
Dictionary servernumber of locked resources in DROP PROCEDURE
Add the following if there are parameters:
+ number of parameters[Figure] 2
Add the following if there are user-defined type parameters:
+ number of user-defined types[Figure] 2
Add the following if a trigger action condition is specified:
+ 15

(20) DROP INDEX (not a plug-in index)

ConditionNumber of lock requests
HiRDB/Single Server22 + number of routines in which objects or indexes become invalid + number of RDAREAs for index[Figure] 7 + number of member columns[Figure] 3 + number of index segments
Add the following if there are routines that become invalid:
+ number of invalid routines[Figure] 7 + 1
Add the following if there are trigger action procedures that reference the table for which indexes are defined:
+ number of trigger action procedures that reference the table for which indexes are defined[Figure] 5
Add the following if the index optimization information is collected:
+ 4
Add the following if the facility for predicting reorganization time is used:
+ number of RDAREAs for index[Figure] 62 + 1
HiRDB/Parallel ServerFront-end server1 + number of routines in which objects or indexes become invalid
Dictionary server16 + number of RDAREAs for index[Figure] 3 + number of member columns[Figure] 3 + number of routines in which objects or indexes become invalid
Add the following if there are routines that become invalid:
+ number of invalid routines[Figure] 7 + 1
Add the following if there are trigger action procedures that reference the table for which indexes are defined:
+ number of trigger action procedures that reference the table for which indexes are defined[Figure] 5
Add the following if the index optimization information is collected:
+ 4
Add the following if the facility for predicting reorganization time is used:
+ number of RDAREAs for index[Figure] 62 + 1
Back-end server5 + number of RDAREAs for index[Figure] 4 + number of index segments + number of routines in which objects or indexes become invalid
Reference-only back-end server2

(21) DROP INDEX (plug-in index)

ConditionNumber of lock requests
HiRDB/Single Server15 + number of routines in which objects or indexes become invalid + number of RDAREAs storing the index[Figure] 10 + number of member columns[Figure] 4 + number of applicable functions[Figure] 3 + number of index segments
Add the following if the facility for predicting reorganization time is used:
+ number of RDAREAs for index[Figure] 62 + 1
HiRDB/Parallel ServerFront-end server1 + number of routines in which objects or indexes become invalid
Dictionary server9 + number of RDAREAs storing the index[Figure] 6 + number of member columns[Figure] 4 + number of applicable functions[Figure] 3 + number of routines in which objects or indexes become invalid
Add the following if the facility for predicting reorganization time is used:
+ number of RDAREAs for index[Figure] 62 + 1
Back-end server5 + number of RDAREAs storing the index[Figure] 4 + number of index segments + number of routines in which objects or indexes become invalid

(22) DROP PROCEDURE

ConditionNumber of lock requests
HiRDB/Single Server19 + number of parameters[Figure] 5 + number of resources[Figure] 10 + number of routines in which objects become invalid
Add the following if there are trigger action procedures in the routines that become invalid:
+ number of trigger action procedures[Figure] 5
HiRDB/Parallel ServerFront-end server1 + number of routines in which objects become invalid
Dictionary server18 + number of parameters[Figure] 3 + number of resources[Figure] 10 + number of routines in which objects become invalid
Add the following if there are trigger action procedures in the routines that become invalid:
+ number of trigger action procedures[Figure] 5
Back-end servernumber of routines in which objects become invalid

(23) DROP SCHEMA

ConditionNumber of lock requests
HiRDB/Single Server11 + 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 the 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
Add the number of tables in the schema that are to be deleted (when they are not matrix-partitioned tables).
+ [Figure] {number of RDAREAs for table[Figure] 3 + number of specified partitioning conditions[Figure] 9 + number of columns[Figure] 4 + (number of LOB columns[Figure] 4) [Figure] number of RDAREAs for table + 1 + 8} + 2
Add the number of tables in the schema that are to be deleted (when they are matrix-partitioned tables).
+ [Figure] {number of RDAREAs for table[Figure] 3 + number of specified RDAREAs for table (including overlapped ones) [Figure] 12 + number of columns[Figure] 4 + (number of LOB columns[Figure] 4) [Figure] number of RDAREAs for table + 1 + 8 + number of privilege definitions for the table to be deleted + number of partitioning keys[Figure] 2 + (number of specified storage conditions + 2) [Figure] 2 + 2} + 3
Add the number of indexes in the schema that are to be deleted.
+ 3 + [Figure] (number of RDAREAs for index[Figure] 7 + number of member columns[Figure] 3) + [Figure] (number of RDAREAs for table[Figure] 10 + 10 + number of table data segments being used) + [Figure] (number of RDAREAs for index[Figure] 8 + 10 + number of index segments being used) + 8
Add the following if the index optimization information is collected:
+ number of tables for which optimization information is collected[Figure] 2 + number of columns for which optimization information is collected[Figure] 3 + number of indexes for which optimization information is collected[Figure] 3
Add the number of view tables that are deleted along with the tables being deleted:
+ 2 + [Figure] (12 + number of base tables for the view tables[Figure] 4 + number of columns[Figure] 4)
Add the number in the routines that use the tables, view tables, routines, or data types inside the schema:
+ 3 + [Figure] (5 + number of resources inside the procedure[Figure] 5 + number of defined parameters[Figure] 3)
Add the following if there are procedures that become invalid:
+ number of invalid procedures + [Figure] (2 + number of resources[Figure] 5) + number of requests for the data types defined in the schema*
Add the following if there are trigger action procedures that reference the tables to be deleted:
+ number of trigger action procedures that reference the tables to be deleted[Figure] 5
Add the following if there are tables for which triggers are defined:
+ number of triggers defined in the schema[Figure] 8 + total number of columns specified in the UPDATE trigger definition in the schema[Figure] 3 + number of triggers that have trigger action conditions in the schema[Figure] 3 + number of resource types referenced in the trigger action conditions in the schema[Figure] 5
Add the following if a referential constraint is defined:
+ number of referenced tables
+ number of foreign keys[Figure] 10
Add the following if a check constraint is defined:
+ number of check constraints[Figure] 9
Add the following if the facility for predicting reorganization time is used:
+ [Figure] {(number of RDAREAs for table + (number of LOB columns + number of LOB attributes) [Figure] number of RDAREAs for table) [Figure] 62}
+ [Figure] {(number of RDAREAs for index + (number of LOB columns + number of LOB attributes) [Figure] number of RDAREAs for table) [Figure] 62} + 1
HiRDB/Parallel ServerFront-end server3 + number of tables in the schema + number of foreign tables in the schema + number of view tables in the schema + number of routines in the schema + number of view tables in other schemas that use the tables, foreign tables or view tables inside the schema as base tables + number of routines in other schemas that reference the tables, foreign tables, view tables, routines, or data types to be deleted
Dictionary server11 + number of indexes in other schemas
Add the number of tables in the schema that are to be deleted (when they are not matrix-partitioned tables).
+ [Figure] {number of RDAREAs for table[Figure] 3 + number of specified partitioning conditions[Figure] 9 + number of columns[Figure] 4 + (number of LOB columns[Figure] 4) [Figure] number of RDAREAs for table + number of privilege definitions for the table to be deleted[Figure] 3 + 6} + 11
Add the number of tables in the schema that are to be deleted (when they are matrix-partitioned tables).
+ [Figure] {number of RDAREAs for table[Figure] 3 + number of specified RDAREAs for table (including the overlapped ones) [Figure] 12 + number of columns[Figure] 4 + (number of LOB columns[Figure] 4) [Figure] number of RDAREAs for table + number of privilege definitions for the table to be deleted[Figure] 3 + 1 + 6 + number of partitioning keys[Figure] 2 + (number of specified storage conditions + 2) [Figure] 2 + 2} + 3
Add the number of tables in the schema that are to be deleted (foreign tables).
+ [Figure] (number of columns[Figure] 4 + number of privilege definitions for the foreign table to be deleted[Figure] 3 + 4) + 8
Add the number of indexes and foreign indexes in the schema to be deleted.
+ 4 + [Figure] (number of RDAREAs for indexes[Figure] 7 + number of member columns[Figure] 7) + number of indexes[Figure] 5 + number of foreign indexes[Figure] 5
Add the following if the optimization information is collected:
+ number of tables for which optimization information is collected[Figure] 2 + number of columns for which optimization information is collected[Figure] 3 + number of foreign tables for which optimization information is collected[Figure] 2 + number of foreign table columns for which optimization information is collected[Figure] 3 + number of indexes for which optimization is collected[Figure] 3 + number of foreign indexes for which optimization information is collected[Figure] 3
Add the requests for the view tables that are deleted when tables or foreign tables are deleted.
+ 2 + [Figure] (18 + number of base tables for the view tables[Figure] 4 + number of columns[Figure] 4 + number of privilege definitions for the view tables[Figure] 3)
Add the requests for the routines that use the tables, foreign tables, view tables, routines, and data types in the schema.
+ 3 + [Figure] (5 + number of resources inside the procedure[Figure] 10 + number of parameter definitions[Figure] 3)
Add the following if there are procedures that become invalid:
+ number of invalid procedures + [Figure] (5 + number of resources[Figure] 5) + number of requests for the data types defined in the schema*
Add the following if there are trigger action procedures that reference the tables to be deleted:
+ number of trigger action procedures that reference the tables to be deleted[Figure] 5
Add the following if there are tables for which triggers are defined:
+ number of triggers defined in the schema[Figure] 8 + total number of columns specified in the UPDATE trigger definition in the schema[Figure] 3 + number of triggers that have trigger action conditions in the schema[Figure] 3 + number of resource types referenced in the trigger action conditions in the schema[Figure] 5
Add the following if a referential constraint is defined:
+ number of referenced tables
+ number of foreign keys[Figure] 10
Add the following if a check constraint is defined:
+ number of check constraints[Figure] 9
Add the following if the facility for predicting reorganization time is used:
+ [Figure] {(number of RDAREAs for table + (number of LOB columns + number of LOB attributes) [Figure] number of RDAREAs for table) [Figure] 62}
+ [Figure] {(number of RDAREAs for index + (number of LOB columns + number of LOB attributes) [Figure] number of RDAREAs for table) [Figure] 62} + 1
Back-end server+ [Figure] (number of RDAREAs for table[Figure] 10 + 10 + number of table data segments being used)
+ [Figure] (number of RDAREAs for index[Figure] 8 + 10 + number of index segments being used) + 8 + number of routines in which objects or index objects become invalid
Reference-only back-end serverNumber of tables + number of RDAREAs for index
* See the number of lock requests for user-defined deletion.

(24) DROP SERVER

ConditionNumber of lock requests
Dictionary server9 + number of privilege definitions for the foreign server to be deleted

(25) DROP TABLE

ConditionNumber of lock requests
HiRDB/Single ServerAdd the following if the table is not a matrix-partitioned table:
24 + number of view tables defined based on the table + number of routines that reference the table or view table to be deleted + number of RDAREAs for table[Figure] 3 + number of specified partitioning conditions[Figure] 9 + number of columns[Figure] 4 + 5 + number of RDAREAs for table[Figure] 4 + number of table data segments being used
Add the following if the table is a matrix-partitioned table:
22 + number of view tables defined based on the table + number of routines that reference the table or view table to be deleted + number of RDAREAs for table[Figure] 3 + number of RDAREAs for table (including overlapped ones) [Figure] 8 + number of columns[Figure] 4 + 5 + number of RDAREAs for table[Figure] 4 + number of table data segments being used + number of partitioning keys[Figure] 2 + (number of specified storage conditions + 2) [Figure] 2 + 2
Add the following if indexes are defined:
+ [Figure] (number of RDAREAs for index[Figure] 2) + number of index segments being used + [Figure] {(number of RDAREAs for index[Figure] 7) + (number of member columns[Figure] 3)} + 3
Add the following if LOB columns are defined:
+ (number of LOB columns[Figure] 4) [Figure] number of RDAREAs for table + 1
Add the following if the index optimization information is collected:
+ 2 + number of columns for which optimization information is collected[Figure] 3 + number of indexes for which optimization information is collected[Figure] 3
Add the following for the base tables of view tables:
+ number of view tables to be deleted + [Figure] {(12 + number of base tables for view tables) + number of columns[Figure] 4} + 2
Add the following if there are routines that become invalid:
+ number of routines in which objects become invalid + [Figure] (2 + number of resources inside the procedure[Figure] 5)
Add the following if there are trigger action procedures that reference the tables to be deleted:
+ number of trigger action procedures that reference the tables to be deleted[Figure] 5
Add the following if user-defined columns are defined:
+ number of user-defined columns[Figure] 4 + number of LOB attributes[Figure] number of partitioned RDAREAs[Figure] 5 + number of abstract data-type attributes + 4
Add the following if triggers are defined:
+ number of defined triggers[Figure] 8 + total number of columns specified in the UPDATE trigger definition[Figure] 3 + number of triggers that have trigger action conditions[Figure] 3 + number of resource types referenced in the trigger action conditions[Figure] 5
Add the following if a user-defined type that includes a LOB column or LOB attribute is defined:
+ [Figure] ([Figure] number of segments allocated to RDAREAs[Figure] 64000 [Figure] + 1)1
Add the following if a referential constraint is defined:
+ number of referenced tables
+ number of foreign keys[Figure] 10
+ total number of functions in referenced tables that are affected by deletion of constraint
Add the following if CASCADE is defined for referential constraint operation:
+number of CASCADEs [Figure]17
+number of referenced tables specified by CASCADE[Figure] 4
Add the following if the specification of referential constraint operation is UPDATE ON CASCADE:
+ total number of primary key member columns of the referenced table for which CASCADE is specified[Figure] 8
+ number of referenced tables specified by CASCADE[Figure] 3
Add the following if a check constraint is defined:
+ number of check constraints[Figure] 9
Add the following if the facility for predicting reorganization time is used:
+ {number of RDAREAs for table + number of RDAREAs for index
+ (number of LOB columns + number of LOB attributes) [Figure] number of RDAREAs for table} [Figure] 62 + 1
HiRDB/Parallel ServerFront-end server3 + number of view tables defined based on tables + number of routines that reference the table or view table to be deleted
Add the following if a referential constraint is defined:
+ number of referenced tables[Figure] 4
+ total number of functions in referenced tables that are affected by deletion of constraint
Dictionary serverAdd the following if the table is not a matrix-partitioned table:
21 + number of RDAREAs for table[Figure] 3 + number of specified partitioning conditions[Figure] 9 + number of columns[Figure] 4 + number of routines in which objects become invalid
Add the following if the table is a matrix-partitioned table:
19 + number of RDAREAs for table[Figure] 3 + number of specified partitioning conditions[Figure] 9 + number of columns[Figure] 4 + number of routines in which objects become invalid
Add the following if indexes are defined:
+ [Figure] {(number of RDAREAs for index[Figure] 7) + number of member columns[Figure] 3} + 3
Add the following if LOB columns are defined:
+ (number of LOB columns[Figure] 4) [Figure] number of RDAREAs for table + 1
Add the following if indexes are defined:
+ [Figure] {(number of RDAREAs for index[Figure] 7) + number of member columns[Figure] 3} + 3
Add the following if the index optimization information is collected:
+ 2 + number of columns for which optimization information is collected[Figure] 3 + number of indexes for which optimization information is collected[Figure] 3
Add the following for the base tables of view tables:
+ number of view tables to be deleted + [Figure] {12 + number of base tables for view tables) + number of columns[Figure] 4} + 2
Add the following if there are routines that become invalid:
+ number of routines that become invalid + [Figure] (2 + number of resources inside the procedure[Figure] 5)
Add the following if there are trigger action procedures that reference the tables to be deleted:
+ number of trigger action procedures that reference the tables to be deleted[Figure] 5
Add the following if user-defined columns are defined:
+ number of user-defined columns[Figure] 4 + number of LOB attributes[Figure] number of partitioned RDAREA[Figure] 5 + number of abstract data-type attributes + 4
Add the following if triggers are defined:
+ number of defined triggers[Figure] 8 + total number of columns specified in the UPDATE trigger definition[Figure] 3 + number of triggers that have trigger action conditions[Figure] 3 + number of resource types referenced in the trigger action conditions[Figure] 5
Add the following if a referential constraint is defined:
+ number of referenced tables
+ number of foreign keys[Figure] 10
Add the following if CASCADE is defined for referential constraint operation:
+number of CASCADEs [Figure]17
+number of referenced tables specified by CASCADE[Figure] 4
Add the following if the specification of referential constraint operation is UPDATE ON CASCADE:
+ total number of primary key member columns of the referenced table for which CASCADE is specified[Figure] 8
+ number of referenced tables specified by CASCADE[Figure] 3
Add the following if a check constraint is defined:
+ number of check constraints[Figure] 9
Add the following if the facility for predicting reorganization time is used:
+ {number of RDAREAs for table + number of RDAREAs for index
+ (number of LOB columns + number of LOB attributes) [Figure] number of RDAREAs for table} [Figure] 62 + 1
Back-end server5 + number of RDAREAs for table[Figure] 4 + number of table data segments being used + number of routines in which objects become invalid
Add the following if indexes are defined:
+ [Figure] (number of RDAREAs for index[Figure] 2) + number of index segments being used
Add the following if a user-defined type that includes a LOB column or LOB attribute is defined:
+ [Figure] ([Figure] number of segments allocated to RDAREAs[Figure] 64000 [Figure] + 1)1
Reference-only back-end server2
Add the following if shared indexes are defined:
+ number of RDAREAs for index

1 Repeat and add this for the number of LOB RDAREAs.

(26) DROP TRIGGER

ConditionNumber of lock requests
HiRDB/Single Server19 + number of routines in which objects become invalid + number of resources used by trigger action procedures[Figure] 5
Add the following if a trigger action condition is specified:
+ number of resources used inside trigger action condition specification[Figure] 5 + 3
Add the following if a column name modified by an old or new values correlation name is used inside a trigger action procedure:
+ number of column types modified by new values correlation names[Figure] 3 + number of column types modified by old values correlation names[Figure] 3 + 3
Add the following if trigger event columns are specified:
+ number of trigger event columns[Figure] 3
Add the following if there are routines that become invalid:
+ number of invalid routines[Figure] 5 + number of resources used by routines[Figure] 5
Add the following if there are trigger action procedures in the routines that become invalid:
+ number of trigger action procedures[Figure] 5
HiRDB/Parallel ServerFront-end server3 + number of routines in which objects become invalid
Dictionary server16 + number of routines in which objects become invalid + number of resources used by trigger action procedures[Figure] 5
Add the following if a trigger action condition is specified:
+ number of resources used inside trigger action condition specification[Figure] 5 + 3
Add the following if a column name modified by an old or new values correlation name is used inside a trigger action procedure:
+ number of column types modified by new values correlation names[Figure] 3 + number of column types modified by old values correlation names[Figure] 3 + 3
Add the following if trigger event columns are specified:
+ number of trigger event columns[Figure] 3
Add the following if there are routines that become invalid:
+ number of invalid routines[Figure] 5 + number of resources used by routines[Figure] 5
Add the following if there are trigger action procedures in the routines that become invalid:
+ number of trigger action procedures[Figure] 5
Back-end servernumber of routines in which objects become invalid

(27) DROP USER MAPPING

ConditionNumber of lock requests
Dictionary server9

(28) DROP VIEW

ConditionNumber of lock requests
HiRDB/Single Server10 + number of view tables to be deleted + number of procedures that become invalid + [Figure] (15 + number of columns[Figure] 4 + number of tables that are the basis of the view table[Figure] 4)
Add the following if there are procedures that become invalid:
+ number of procedures that become invalid + [Figure] (2 + number of resources in procedures[Figure] 5)
Add the following if there are trigger action procedures that reference the view tables to be deleted:
+ number of trigger action procedures that reference the view tables to be deleted[Figure] 5
HiRDB/Parallel ServerFront-end servernumber of view tables to be deleted + number of procedures that become invalid
Dictionary server10 + [Figure] (15 + number of columns[Figure] 4 + number of tables that are the basis of the view table[Figure] 4)
Add the following if there are routines that become invalid:
+ number of routines that become invalid + [Figure] (2 + number of resources in routines[Figure] 5)
Add the following if there are trigger action procedures that reference the view tables to be deleted:
+ number of trigger action procedures that reference the view tables to be deleted[Figure] 5
Back-end servernumber of routines in which objects become invalid