Condition | Number of lock requests | |
---|---|---|
HiRDB/Single Server | 7 + number-of-users-registered-in-dictionary-table-SQL_USERS | |
HiRDB/Parallel Server | Front-end server | 1 |
Dictionary server | 6 + number-of-users-registered-in-dictionary-table-SQL_USERS |
Condition | Number of lock requests |
---|---|
Front-end server | 1 |
Dictionary server | 20 + number of member columns ![]() |
Condition | Number of lock requests |
---|---|
Dictionary server | 17 + column count![]() |
Condition | Number of lock requests | |
---|---|---|
HiRDB/Single Server | number of locked resources in CREATE PROCEDURE Add the following when parameters are involved: + parameters count ![]() Add the following when a parameter includes a user-defined type: + user-defined types count ![]() | |
HiRDB/Parallel Server | Front-end server and Back-end server | same as CREATE PROCEDURE |
Dictionary server | number of locked resources in CREATE PROCEDURE Add the following when parameters are involved: + parameters count ![]() Add the following when a parameter includes a user-defined type: + user-defined types count ![]() |
Condition | Number of lock requests | |
---|---|---|
HiRDB/Single Server | 25 + number of routines in which indexes become invalid + number of RDAREAs for index![]() ![]() 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 ![]() 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 ![]() Add the following if there are two or more RDAREAs for an index: + number of RDAREAs for index ![]() | |
HiRDB/Parallel Server | Front-end server | 1 + number of routines in which indexes become invalid |
Dictionary server | 19 + number of RDAREAs for index![]() ![]() 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 ![]() 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 ![]() Add the following if there are two or more RDAREAs for an index: + number of RDAREAs for index ![]() | |
Back-end server | 5 + number of RDAREAs for index![]() | |
Reference-only back-end server | 2 |
Condition | Number of lock requests | |
---|---|---|
HiRDB/Single Server | 21 + number of routines in which indexes become invalid + number of RDAREAs for index![]() ![]() ![]() ![]() | |
HiRDB/Parallel Server | Front-end server | 1 + number of routines in which indexes become invalid |
Dictionary server | 15 + number of RDAREAs for index![]() ![]() ![]() ![]() | |
Back-end server | 5 + number of RDAREAs for index![]() |
Condition | Number of lock requests | |
---|---|---|
HiRDB/Single Server | 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 Add the following if a resource to be used exists: + number of resources to be used ![]() Add the following if parameters are specified: + number of parameters ![]() Add the following if the parameter data type is a user-defined type: + number of user-defined type parameters ![]() | |
HiRDB/Parallel Server | Front-end server | 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 |
Dictionary server | 15 Add the following if a resource to be used exists: + number of resources to be used ![]() Add the following if parameters are specified: + number of parameters ![]() Add the following if the parameter data type is a user-defined type: + number of user-defined type parameters ![]() |
Condition | Number of lock requests |
---|---|
HiRDB/Single Server | 5 |
HiRDB/Parallel Server (Dictionary server) |
Condition | Number of lock requests |
---|---|
Dictionary server | 9 + pd_max_foreign_server operand value |
Condition | Number of lock requests | |
---|---|---|
HiRDB/Single Server | RDAREA for table is omitted and the table is not row-partitioned | 29 + number of public user RDAREAs![]() ![]() ![]() Add the following if a user-defined type is used: + number of user-defined types ![]() ![]() ![]() ![]() Add the following if a cluster key is defined: + 5 + number of RDAREAs for index ![]() ![]() ![]() Add the following if a referential constraint is defined: + number of referenced tables + number of foreign keys ![]() Add the following if CASCADE is defined for referential constraint operation: +number of CASCADEs ![]() +number of referenced tables specified by CASCADE ![]() 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 ![]() + number of referenced tables specified by CASCADE ![]() Add the following if there are functions that become invalid: + number of functions whose objects are invalid + ![]() ![]() + total number of functions that reference the referenced tables Add the following if a check constraint is defined: + number of check constraints ![]() |
RDAREA for table is specified and the table is not row-partitioned | 28 + number of columns![]() ![]() ![]() Add the following if a user-defined type is used: + number of user-defined types ![]() ![]() ![]() ![]() Add the following if a cluster key is defined: + 5 + number of RDAREAs for index ![]() ![]() ![]() Add the following if a referential constraint is defined: + number of referenced tables + number of foreign keys ![]() Add the following if CASCADE is defined for referential constraint operation: +number of CASCADEs ![]() +number of referenced tables specified by CASCADE ![]() 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 ![]() + number of referenced tables specified by CASCADE ![]() Add the following if there are functions that become invalid: + number of functions whose objects are invalid + ![]() ![]() + total number of functions that reference the referenced tables Add the following if a check constraint is defined: + number of check constraints ![]() | |
Row-partitioned table | 29 + number of columns![]() ![]() ![]() ![]() Add the following if a user-defined type is used: + number of user-defined types ![]() ![]() ![]() ![]() Add the following if a cluster key is defined: + 5 + number of RDAREAs for index ![]() ![]() ![]() Add the following if a referential constraint is defined: + number of referenced tables + number of foreign keys ![]() Add the following if CASCADE is defined for referential constraint operation: +number of CASCADEs ![]() +number of referenced tables specified by CASCADE ![]() 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 ![]() + number of referenced tables specified by CASCADE ![]() Add the following if there are functions that become invalid: + number of functions whose objects are invalid + ![]() ![]() + total number of functions that reference the referenced tables Add the following if a check constraint is defined: + number of check constraints ![]() | |
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-partitioned | 20 + number of public user RDAREAs![]() ![]() ![]() ![]() Add the following if a user-defined type is used: + number of user-defined types ![]() ![]() ![]() ![]() Add the following if a cluster key is defined: + number of partitioned RDAREAs ![]() ![]() Add the following if a referential constraint is defined: + number of foreign keys ![]() Add the following if CASCADE is defined for referential constraint operation: +number of CASCADEs ![]() +number of referenced tables specified by CASCADE ![]() 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 ![]() + number of referenced tables specified by CASCADE ![]() Add the following if there are functions that become invalid: + number of functions whose objects are invalid + ![]() ![]() Add the following if a check constraint is defined: + number of check constraints ![]() |
RDAREA for table is specified and the table is not row-partitioned | 25 + number of columns![]() ![]() Add the following if a user-defined type is used: + number of user-defined types ![]() ![]() ![]() ![]() Add the following if a cluster key is defined: + number of partitioned RDAREAs ![]() ![]() Add the following if a referential constraint is defined: + number of foreign keys ![]() Add the following if CASCADE is defined for referential constraint operation: +number of CASCADEs ![]() +number of referenced tables specified by CASCADE ![]() 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 ![]() + number of referenced tables specified by CASCADE ![]() Add the following if there are functions that become invalid: + number of functions whose objects are invalid + ![]() ![]() Add the following if a check constraint is defined: + number of check constraints ![]() | |
Row-partitioned table | Add the following when the table is not a matrix-partitioned table: 24 + number of columns ![]() ![]() ![]() ![]() Add the following when the table is a matrix-partitioned table: 21 + number of columns ![]() ![]() ![]() ![]() ![]() ![]() Add the following if a user-defined type is used: + number of user-defined types ![]() ![]() ![]() ![]() Add the following if a cluster key is defined: + number of partitioned RDAREAs ![]() ![]() Add the following if a referential constraint is defined: + number of foreign keys ![]() Add the following if CASCADE is defined for referential constraint operation: +number of CASCADEs ![]() +number of referenced tables specified by CASCADE ![]() 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 ![]() + number of referenced tables specified by CASCADE ![]() Add the following if there are functions that become invalid: + number of functions whose objects are invalid + ![]() ![]() Add the following if a check constraint is defined: + number of check constraints ![]() | |
HiRDB/Parallel Server (Back-end server) | 5 + number of RDAREAs for table![]() Add the following if a cluster key is defined: + 5 + number of RDAREAs for index ![]() | |
HiRDB/Parallel Server (reference-only back-end server) | 2 Add the following if a cluster key is defined: + 1 |
Condition | Number of lock requests | |
---|---|---|
HiRDB/Single Server | 21 + number of routines in which objects become invalid![]() ![]() Add the following if a trigger action condition is specified: + number of resources used inside trigger action condition specification ![]() 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 ![]() ![]() Add the following if trigger event columns are specified: + number of trigger event columns ![]() Add the following if there are routines that become invalid: + number of invalid routines ![]() ![]() Add the following if there are trigger action procedures in the routines that become invalid: + number of trigger action procedures ![]() | |
HiRDB/Parallel Server | Front-end server | 3 + number of routines in which objects become invalid |
Dictionary server | 18 + number of routines in which objects become invalid + number of resources used by trigger action procedures![]() Add the following if a trigger action condition is specified: + number of resources used inside trigger action condition specification ![]() 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 ![]() ![]() Add the following if trigger event columns are specified: + number of trigger event columns ![]() Add the following if there are routines that become invalid: + number of invalid routines ![]() ![]() Add the following if there are trigger action procedures in the routines that become invalid: + number of trigger action procedures ![]() | |
Back-end server | number of routines in which objects become invalid |
Condition | Number of lock requests | |
---|---|---|
HiRDB/Single Server | 22 + number of routines that become invalid + number of attributes![]() ![]() ![]() ![]() | |
HiRDB/Parallel Server | Front-end server | 1 + number of routines that become invalid + number of locked resources for function/procedure definitions4 |
Dictionary server | 21 + number of attributes![]() ![]() ![]() ![]() | |
Back-end server | number 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.
Condition | Number of lock requests |
---|---|
Dictionary server | 11 |
Condition | Number of lock requests | |
---|---|---|
HiRDB/Single Server | 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![]() ![]() | |
HiRDB/Parallel Server | Front-end server | 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 |
Dictionary server | 28 + number of columns![]() ![]() |
Condition | Number of lock requests | |
---|---|---|
HiRDB/Single Server | 7 + number-of-users-registered-in-dictionary-table-SQL_USERS | |
HiRDB/Parallel Server | Front-end server | 1 |
Dictionary server | 6 + number-of-users-registered-in-dictionary-table-SQL_USERS |
Condition | Number of lock requests | |
---|---|---|
HiRDB/Single Server | 26 + number of routines that become invalid + number of attributes![]() Add the following for a subtype: + 6 Add the following if there are user-defined type attributes: + number of user-defined type attributes ![]() Add the following if there are routines that become invalid: + number of routines that become invalid ![]() ![]() Add the following if there are function definitions: + number of function definitions ![]() ![]() ![]() Add the following if there are procedure definitions: + number of procedure definitions ![]() ![]() ![]() 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 ![]() | |
HiRDB/Parallel Server | Front-end server | 1 + number of routines that become invalid |
Dictionary server | 23 + number of attributes![]() Add the following for a subtype: + 6 Add the following if there are user-defined type attributes: + number of user-defined type attributes ![]() Add the following if there are routines that become invalid: + number of routines that become invalid ![]() ![]() Add the following if there are function definitions: + number of function definitions ![]() ![]() ![]() Add the following if there are procedure definitions: + number of procedure definitions ![]() ![]() ![]() 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 ![]() | |
Back-end server | number of routines in which objects become invalid |
Condition | Number of lock requests |
---|---|
Front-end server | 1 |
Dictionary server | 21 + number of member columns![]() Add the following when creating optimization information for a foreign index: + 4 |
Condition | Number of lock requests |
---|---|
Front-end server | 1 + 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 server | 19 + number of columns![]() ![]() Add the following if indexes are defined: + number of foreign indexes ![]() ![]() ![]() Add the following when creating optimization information: + 2 + number of columns for which optimization information is to be created ![]() ![]() Add the following for the base table of a view table: + number of view tables to be deleted + ![]() ![]() ![]() Add the following if there are routines that become invalid: + number of routines in which objects become invalid + ![]() ![]() |
Back-end server | number of routines in which objects become invalid |
Condition | Number of lock requests | |
---|---|---|
HiRDB/Single Server | number of locked resources in DROP PROCEDURE Add the following if there are parameters: + number of parameters ![]() Add the following if there are user-defined type parameters: + number of user-defined types ![]() Add the following if a trigger action condition is specified: + 15 | |
HiRDB/Parallel Server | Front-end server and Back-end server | same as DROP PROCEDURE |
Dictionary server | number of locked resources in DROP PROCEDURE Add the following if there are parameters: + number of parameters ![]() Add the following if there are user-defined type parameters: + number of user-defined types ![]() Add the following if a trigger action condition is specified: + 15 |
Condition | Number of lock requests | |
---|---|---|
HiRDB/Single Server | 22 + number of routines in which objects or indexes become invalid + number of RDAREAs for index![]() ![]() Add the following if there are routines that become invalid: + number of invalid routines ![]() 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 ![]() 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 ![]() | |
HiRDB/Parallel Server | Front-end server | 1 + number of routines in which objects or indexes become invalid |
Dictionary server | 16 + number of RDAREAs for index![]() ![]() Add the following if there are routines that become invalid: + number of invalid routines ![]() 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 ![]() 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 ![]() | |
Back-end server | 5 + number of RDAREAs for index![]() | |
Reference-only back-end server | 2 |
Condition | Number of lock requests | |
---|---|---|
HiRDB/Single Server | 15 + number of routines in which objects or indexes become invalid + number of RDAREAs storing the index![]() ![]() ![]() Add the following if the facility for predicting reorganization time is used: + number of RDAREAs for index ![]() | |
HiRDB/Parallel Server | Front-end server | 1 + number of routines in which objects or indexes become invalid |
Dictionary server | 9 + number of RDAREAs storing the index![]() ![]() ![]() Add the following if the facility for predicting reorganization time is used: + number of RDAREAs for index ![]() | |
Back-end server | 5 + number of RDAREAs storing the index![]() |
Condition | Number of lock requests | |
---|---|---|
HiRDB/Single Server | 19 + number of parameters![]() ![]() Add the following if there are trigger action procedures in the routines that become invalid: + number of trigger action procedures ![]() | |
HiRDB/Parallel Server | Front-end server | 1 + number of routines in which objects become invalid |
Dictionary server | 18 + number of parameters![]() ![]() Add the following if there are trigger action procedures in the routines that become invalid: + number of trigger action procedures ![]() | |
Back-end server | number of routines in which objects become invalid |
Condition | Number of lock requests | |
---|---|---|
HiRDB/Single Server | 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 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). + ![]() ![]() ![]() ![]() ![]() ![]() Add the number of tables in the schema that are to be deleted (when they are matrix-partitioned tables). + ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Add the number of indexes in the schema that are to be deleted. + 3 + ![]() ![]() ![]() ![]() ![]() ![]() ![]() Add the following if the index optimization information is collected: + number of tables for which optimization information is collected ![]() ![]() ![]() Add the number of view tables that are deleted along with the tables being deleted: + 2 + ![]() ![]() ![]() Add the number in the routines that use the tables, view tables, routines, or data types inside the schema: + 3 + ![]() ![]() ![]() Add the following if there are procedures that become invalid: + number of invalid procedures + ![]() ![]() 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 ![]() Add the following if there are tables for which triggers are defined: + number of triggers defined in the schema ![]() ![]() ![]() ![]() Add the following if a referential constraint is defined: + number of referenced tables + number of foreign keys ![]() Add the following if a check constraint is defined: + number of check constraints ![]() Add the following if the facility for predicting reorganization time is used: + ![]() ![]() ![]() + ![]() ![]() ![]() | |
HiRDB/Parallel Server | Front-end server | 3 + 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 server | 11 + 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). + ![]() ![]() ![]() ![]() ![]() ![]() ![]() Add the number of tables in the schema that are to be deleted (when they are matrix-partitioned tables). + ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Add the number of tables in the schema that are to be deleted (foreign tables). + ![]() ![]() ![]() Add the number of indexes and foreign indexes in the schema to be deleted. + 4 + ![]() ![]() ![]() ![]() ![]() Add the following if the optimization information is collected: + number of tables for which optimization information is collected ![]() ![]() ![]() ![]() ![]() ![]() Add the requests for the view tables that are deleted when tables or foreign tables are deleted. + 2 + ![]() ![]() ![]() ![]() Add the requests for the routines that use the tables, foreign tables, view tables, routines, and data types in the schema. + 3 + ![]() ![]() ![]() Add the following if there are procedures that become invalid: + number of invalid procedures + ![]() ![]() 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 ![]() Add the following if there are tables for which triggers are defined: + number of triggers defined in the schema ![]() ![]() ![]() ![]() Add the following if a referential constraint is defined: + number of referenced tables + number of foreign keys ![]() Add the following if a check constraint is defined: + number of check constraints ![]() Add the following if the facility for predicting reorganization time is used: + ![]() ![]() ![]() + ![]() ![]() ![]() | |
Back-end server | + ![]() ![]() + ![]() ![]() | |
Reference-only back-end server | Number of tables + number of RDAREAs for index |
Condition | Number of lock requests |
---|---|
Dictionary server | 9 + number of privilege definitions for the foreign server to be deleted |
Condition | Number of lock requests | |
---|---|---|
HiRDB/Single Server | Add 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 ![]() ![]() ![]() ![]() 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 ![]() ![]() ![]() ![]() ![]() ![]() Add the following if indexes are defined: + ![]() ![]() ![]() ![]() ![]() Add the following if LOB columns are defined: + (number of LOB columns ![]() ![]() Add the following if the index optimization information is collected: + 2 + number of columns for which optimization information is collected ![]() ![]() Add the following for the base tables of view tables: + number of view tables to be deleted + ![]() ![]() Add the following if there are routines that become invalid: + number of routines in which objects become invalid + ![]() ![]() 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 ![]() Add the following if user-defined columns are defined: + number of user-defined columns ![]() ![]() ![]() Add the following if triggers are defined: + number of defined triggers ![]() ![]() ![]() ![]() Add the following if a user-defined type that includes a LOB column or LOB attribute is defined: + ![]() ![]() ![]() ![]() Add the following if a referential constraint is defined: + number of referenced tables + number of foreign keys ![]() + 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 ![]() +number of referenced tables specified by CASCADE ![]() 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 ![]() + number of referenced tables specified by CASCADE ![]() Add the following if a check constraint is defined: + number of check constraints ![]() 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) ![]() ![]() | |
HiRDB/Parallel Server | Front-end server | 3 + 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 ![]() + total number of functions in referenced tables that are affected by deletion of constraint |
Dictionary server | Add the following if the table is not a matrix-partitioned table: 21 + number of RDAREAs for table ![]() ![]() ![]() Add the following if the table is a matrix-partitioned table: 19 + number of RDAREAs for table ![]() ![]() ![]() Add the following if indexes are defined: + ![]() ![]() ![]() Add the following if LOB columns are defined: + (number of LOB columns ![]() ![]() Add the following if indexes are defined: + ![]() ![]() ![]() Add the following if the index optimization information is collected: + 2 + number of columns for which optimization information is collected ![]() ![]() Add the following for the base tables of view tables: + number of view tables to be deleted + ![]() ![]() Add the following if there are routines that become invalid: + number of routines that become invalid + ![]() ![]() 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 ![]() Add the following if user-defined columns are defined: + number of user-defined columns ![]() ![]() ![]() Add the following if triggers are defined: + number of defined triggers ![]() ![]() ![]() ![]() Add the following if a referential constraint is defined: + number of referenced tables + number of foreign keys ![]() Add the following if CASCADE is defined for referential constraint operation: +number of CASCADEs ![]() +number of referenced tables specified by CASCADE ![]() 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 ![]() + number of referenced tables specified by CASCADE ![]() Add the following if a check constraint is defined: + number of check constraints ![]() 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) ![]() ![]() | |
Back-end server | 5 + number of RDAREAs for table![]() Add the following if indexes are defined: + ![]() ![]() Add the following if a user-defined type that includes a LOB column or LOB attribute is defined: + ![]() ![]() ![]() ![]() | |
Reference-only back-end server | 2 Add the following if shared indexes are defined: + number of RDAREAs for index |
1 Repeat and add this for the number of LOB RDAREAs.
Condition | Number of lock requests | |
---|---|---|
HiRDB/Single Server | 19 + number of routines in which objects become invalid + number of resources used by trigger action procedures![]() Add the following if a trigger action condition is specified: + number of resources used inside trigger action condition specification ![]() 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 ![]() ![]() Add the following if trigger event columns are specified: + number of trigger event columns ![]() Add the following if there are routines that become invalid: + number of invalid routines ![]() ![]() Add the following if there are trigger action procedures in the routines that become invalid: + number of trigger action procedures ![]() | |
HiRDB/Parallel Server | Front-end server | 3 + number of routines in which objects become invalid |
Dictionary server | 16 + number of routines in which objects become invalid + number of resources used by trigger action procedures![]() Add the following if a trigger action condition is specified: + number of resources used inside trigger action condition specification ![]() 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 ![]() ![]() Add the following if trigger event columns are specified: + number of trigger event columns ![]() Add the following if there are routines that become invalid: + number of invalid routines ![]() ![]() Add the following if there are trigger action procedures in the routines that become invalid: + number of trigger action procedures ![]() | |
Back-end server | number of routines in which objects become invalid |
Condition | Number of lock requests |
---|---|
Dictionary server | 9 |
Condition | Number of lock requests | |
---|---|---|
HiRDB/Single Server | 10 + number of view tables to be deleted + number of procedures that become invalid + ![]() ![]() ![]() Add the following if there are procedures that become invalid: + number of procedures that become invalid + ![]() ![]() 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 ![]() | |
HiRDB/Parallel Server | Front-end server | number of view tables to be deleted + number of procedures that become invalid |
Dictionary server | 10 + ![]() ![]() ![]() Add the following if there are routines that become invalid: + number of routines that become invalid + ![]() ![]() 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 ![]() | |
Back-end server | number of routines in which objects become invalid |