Appendix D.1 Definition SQLs

Organization of this subsection
(1) ALLOCATE MEMORY TABLE
(2) ALTER INDEX
(3) ALTER PROCEDURE
(4) ALTER ROUTINE
(5) ALTER TABLE
(6) ALTER TRIGGER
(7) COMMENT
(8) CREATE AUDIT
(9) CREATE CONNECTION SECURITY
(10) CREATE [PUBLIC] FUNCTION
(11) CREATE INDEX (not a plug-in index)
(12) CREATE INDEX (plug-in index)
(13) CREATE [PUBLIC] PROCEDURE
(14) CREATE SCHEMA
(15) CREATE SEQUENCE
(16) CREATE TABLE
(17) CREATE TRIGGER
(18) CREATE TYPE
(19) CREATE [PUBLIC] VIEW
(20) DEALLOCATE MEMORY TABLE
(21) DROP AUDIT
(22) DROP CONNECTION SECURITY
(23) DROP DATA TYPE
(24) DROP [PUBLIC] FUNCTION
(25) DROP INDEX (not a plug-in index)
(26) DROP INDEX (plug-in index)
(27) DROP [PUBLIC] PROCEDURE
(28) DROP SCHEMA
(29) DROP SEQUENCE
(30) DROP TABLE
(31) DROP TRIGGER
(32) DROP [PUBLIC] VIEW
(33) GRANT AUDIT
(34) GRANT CONNECT
(35) GRANT DBA
(36) GRANT RDAREA
(37) GRANT SCHEMA
(38) GRANT access privileges
(39) REVOKE CONNECT
(40) REVOKE DBA
(41) REVOKE RDAREA
(42) REVOKE SCHEMA
(43) REVOKE access privileges

(1) ALLOCATE MEMORY TABLE

For ALLOCATE MEMORY TABLE, determine the value if you will be using a memory-resident database.

(a) For a HiRDB single server configuration

9 + number of table columns + number of indexes defined for the table[Figure] 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

Add the following if there are routines that become invalid:
+ number of routines in which the object becomes invalid[Figure] 3 + 2
Add the following if there are triggers that become invalid:
+ number of triggers for which the object becomes invalid[Figure] 2 + 2 + number of trigger event columns for which the object becomes invalid + 1 + number of parameters used in the triggers for which the object becomes invalid + 1
(b) For a HiRDB parallel server configuration (front-end server)

1

Add the following if there are routines that become invalid:
+ number of routines in which the object becomes invalid
(c) For a HiRDB parallel server configuration (dictionary server)

8 + number of table columns + number of indexes defined for the table[Figure] 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

Add the following if there are routines that become invalid:
+ number of routines in which the object becomes invalid[Figure] 2 + 2
Add the following if there are triggers that become invalid:
+ number of triggers for which the object becomes invalid[Figure] 2 + 2 + number of trigger event columns for which the object becomes invalid + 1 + number of parameters used in the triggers for which the object becomes invalid + 1

(2) ALTER INDEX

(a) For a HiRDB single server configuration

5 + (number of index member columns[Figure] 2) + number of procedures and triggers whose objects become invalid

Add the following if there is a procedure whose objects become invalid:
+ number of procedures whose objects become invalid[Figure] 3 + number of resources used by procedures whose objects become invalid[Figure] 5
Add the following if there is a trigger whose objects become invalid:
+ number of triggers whose objects become invalid[Figure] 5 +number of columns specified as the trigger event of an UPDATE trigger[Figure] 3 + number of trigger action procedures that reference tables for which an index is defined[Figure] 5
Add the following if there is an old or new value correlation name:
+ 4
Add the following if statistical information regarding the index is output:
+ 2
Add the following if it is a partitioning key index:
+ number of partitioning conditions[Figure] 2
Add the following if it is an index that uses index types:
+ 1 + number of abstract data types that use types that define the index type[Figure] 2 + number of functions that use the index type[Figure] 2
Add the following if it is a substructure index:
+ number of member substructure paths[Figure] 2
Add the following if an exception value is specified:
+ 2
(b) For a HiRDB parallel server configuration (front-end server)

1 + number of procedures and triggers whose objects become invalid

(c) For a HiRDB parallel server configuration (dictionary server)

4 + (number of index member columns[Figure] 2)

Add the following if there is a procedure whose objects become invalid:
+ number of procedures whose objects become invalid[Figure] 3 + number of resources used by procedures whose objects become invalid[Figure] 5
Add the following if there is a trigger whose objects become invalid:
+ number of triggers whose objects become invalid[Figure] 5 + number of columns specified as the trigger event of an UPDATE trigger[Figure] 3 + number of trigger action procedures that reference the table for which the index is defined[Figure] 5
Add the following if there is an old or new value correlation name:
+ 4
Add the following if statistical information regarding the index is output:
+ 2
Add the following if it is a partitioning key index:
+ number of partitioning conditions[Figure] 2
Add the following if it is an index that uses the index type:
+ 1 + number of abstract data types that use types that define the index type[Figure] 2 + number of functions that use the index type[Figure] 2
Add the following if it is a substructure index:
+ number of member substructure paths[Figure] 2
Add the following if an exception value is specified:
+ 2

(3) ALTER PROCEDURE

(a) For a HiRDB single server configuration

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

Add the following if the executer is not the owner:
+ 2
Add the following if a procedure name is specified:
+ 2
Add the following if AUTHORIZATION is specified:
+ number of invalid routines owned by a target person + number of invalid PUBLIC routines defined by a target person + 2
Also add the following if ALL is specified:
+ total number of routines owned by a target person + total number of PUBLIC routines defined by a target person + 1
Also add the following if INDEX USING is specified:
+ number of routines that use the specified table as a resource[Figure] 2 + 3
Add the following if AUTHORIZATION is not specified:
+ total number of invalid routines in the system
Also add the following if ALL is specified:
+ total number of routines in the system
Also add the following if INDEX USING is specified:
+ number of routines that use the specified table as a resource[Figure] 2 + 3
Add the following if there are resources used in routines:
+ number of routines used[Figure] 2 + 1
Add the following if there are tables in the resources used:
+ number of tables used + 1
Add the following if there are view tables in the resources used:
+ number of view tables used + 1 + number of utilized resources used in view tables used + 1
Add the following if there are indexes in the resources to be used:
+ number of indexes to be used + 1
Add the following if there are routines in the resources to be used:
+ number of routines used + 1
Add the following if there are user-defined types in the resources to be used:
+ user-defined types to be used + 1
Add the following if parameters are specified:
+ number of parameters + 1
(b) For a HiRDB parallel server configuration (front-end server)

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

(c) For a HiRDB parallel server configuration (dictionary server)

5

Add the following if the executer is not the owner:
+ 2
Add the following if a procedure name is specified:
+ 2
Add the following if AUTHORIZATION is specified:
+ number of invalid routines owned by a target person + number of invalid PUBLIC routines defined by a target person
Also add the following if ALL is specified:
+ total number of routines owned by a target person + total number of PUBLIC routines defined by a target person
Also add the following if INDEX USING is specified:
+ number of routines that use the specified table as a resource[Figure] 2 + 3
Add the following if AUTHORIZATION is not specified:
+ total number of invalid routines in system
Also add the following if ALL is specified:
+ total number of routines in system
Also add the following if INDEX USING is specified:
+ number of routines that use the specified table as a resource[Figure] 2 + 3
Add the following if there are resources used in routines:
+ number of routines used[Figure] 2 + 1
Add the following if there are tables in the resources used:
+ number of tables used + 1
Add the following if there are view tables in the resources used:
+ number of view tables used + 1 + number of utilized resources used in view tables used + 1
Add the following if there are indexes in the resources to be used:
+ number of indexes to be used + 1
Add the following if there are routines in the resources to be used:
+ number of routines used + 1
Add the following if there are user-defined types in the resources to be used:
+ user-defined types to be used + 1
Add the following if parameters are specified:
+ number of parameters + 1
(d) For a HiRDB parallel server configuration (back-end server)

1

(4) ALTER ROUTINE

(a) For a HiRDB single server configuration

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

Add the following if there are triggers:
+ 1
Add the following if the executer is not the owner:
+ 2
Add the following if AUTHORIZATION is specified:
+ number of invalid routines owned by a target person + number of invalid PUBLIC routines defined by a target person + 1
Also add the following if ALL is specified:
+ total number of routines owned by a target person + total number of PUBLIC routines defined by a target person
Also add the following if there are triggers owned by a target person:
+ number of triggers owned by a target person[Figure] 4 + 3 + number of tables that define triggers owned by a target person + number of trigger event columns[Figure] 2 + 1 + number of resource information items used in trigger action conditions[Figure] 2 + 1 + number of parameters used by triggers[Figure] 2 + 1
Add the following if AUTHORIZATION is not specified:
+ total number of invalid routines in the system
Also add the following if ALL is specified:
+ total number of routines in the system
Also add the following if there are triggers in the system:
+ total number of triggers[Figure] 4 + 3 + total number of tables that define triggers + number of trigger event columns[Figure] 2 + 1 + number of resource information items used in trigger action conditions[Figure] 2 + 1 + number of parameters used by triggers[Figure] 2 + 1
Add the following if there are resources used in routines:
+ number of routines used[Figure] 2
Add the following if there are tables in the resources used:
+ number of tables used + 1
Add the following if there are view tables in the resources used:
+ number of view tables used + 1 + number of utilized resources used in view tables used + 1
Add the following if there are indexes in the resources to be used:
+ number of indexes to be used + 1
Add the following if there are routines in the resources to be used:
+ number of routines used + 1
Add the following if there are user-defined types in the resources to be used:
+ user-defined types to be used + 1
Add the following if parameters are specified:
+ number of parameters + 1
(b) For a HiRDB parallel server configuration (front-end server)

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

Add the following if there are triggers:
+ 1
(c) For a HiRDB parallel server configuration (dictionary server)

5

Add the following if the executer is not the owner:
+ 2
Add the following if AUTHORIZATION is specified:
+ number of invalid routines owned by a target person + number of invalid PUBLIC routines defined by a target person
Also add the following if ALL is specified:
+ total number of routines owned by a target person + total number of PUBLIC routines defined by a target person
Also add the following if there are triggers owned by a target person:
+ number of triggers owned by a target person[Figure] 4 + 3 + number of tables that define triggers owned by a target person + 1 + number of trigger event columns[Figure] 2 + 1 + number of resource information items used in trigger action conditions[Figure] 2 + 1 + number of parameters used by triggers[Figure] 2 + 1
Add the following if AUTHORIZATION is not specified:
+ total number of invalid routines in the system
Also add the following if ALL is specified:
+ total number of routines in the system
Also add the following if there are triggers in the system:
+ total number of triggers[Figure] 4 + 3 + total number of tables that define triggers + 1 + number of trigger event columns[Figure] 2 + 1 + number of resource information items used in trigger action conditions[Figure] 2 + 1 + number of parameters used by triggers[Figure] 2 + 1
Add the following if there are resources used in routines:
+ number of routines used[Figure] 2
Add the following if there are tables in the resources used:
+ number of tables used + 1
Add the following if there are view tables in the resources used:
+ number of view tables used + 1 + number of utilized resources used in view tables used + 1
Add the following if there are indexes in the resources to be used:
+ number of indexes to be used + 1
Add the following if there are routines in the resources to be used:
+ number of routines used + 1
Add the following if there are user-defined types in the resources to be used:
+ user-defined types to be used + 1
Add the following if parameters are specified:
+ number of parameters + 1
(d) For a HiRDB parallel server configuration (back-end server)

1

(5) ALTER TABLE

(a) For a HiRDB single server configuration (operations other than the addition or deletion of primary keys)

4 + number of view tables defined based on the table

Add the following if there are routines that become invalid:
+ number of routines whose objects become invalid[Figure] 3 + 2
Add the following if triggers are defined:
+ number of trigger definitions[Figure] 2 + 2 + number of defined trigger event columns + 1 + number of parameters used by defined triggers + 1
Add the following if the inner replica facility is used:
+ number of RDAREAs used by the table + 1
Also add the following if indexes are defined:
+ number of indexes defined in the table + 1
Also add the following when BLOB columns are defined:
+ number of BLOB columns defined in the table + 1
Also add the following if the table is a partitioned table:
+ number of table partitions + 1
  • Also add the following if partitioning key indexes are defined:
    + number of table partitions[Figure] number of partitioning key indexes + 1
  • Also add the following when BLOB columns are defined:
    + number of table partitions[Figure] number of BLOB columns + 1
Add the following if specifying ADD column-name:
+ 5
Also add the following if there are view tables defined based on the table:
+ number of view tables defined based on the table
Also add the following if adding BLOB columns:
+ number of RDAREAs added to the table + 1 + number of RDAREAs used by the table + 1 + number of table BLOB columns + 2 + (1 + number of indexes defined in the table + number of BLOB columns defined in the table + number of BLOB attributes of user-defined types defined in the table) [Figure] number of LOB RDAREAs used by the table
  • Also add the following if there are routines that use the table as a resource:
    + number of routines that use the table as a resource + 1
  • Also add the following if there are view tables defined based on the table:
    + number of view tables defined based on the table[Figure] 2 + 2
  • Also add the following if indexes are defined:
    + number of indexes defined in the table + 1
  • Also add the following if the table is a partitioned table:
    + number of table partitions[Figure] 2 + 2
    Also add the following if partitioning key indexes are defined:
    + number of partitioning key indexes[Figure] number of table partitions + 1
    Also add the following when BLOB columns are defined:
    + number of table BLOB columns[Figure] number of table partitions
    Also add the following if it is a matrix-partitioned table:
    + 3
Also add the following if the inner replica facility is used:
+ 2 + (1 + number of indexes defined in the table + number of BLOB columns defined in the table + number of BLOB attributes of user-defined types defined in the table) [Figure] number of LOB RDAREAs used by the table[Figure] (number of generations + 1)
Also add the following if adding user-defined type columns:
+ 4 + number of attributes used by user-defined types
  • Also add the following if there are routines that use the table as a resource:
    + number of routines that use the table as a resource + 1
  • Also add the following if there are view tables defined based on the table:
    + number of view tables defined based on the table[Figure] 2 + 2
  • Also add the following if there are user-defined types for which the BLOB attribute is defined:
    + number of RDAREAs added to the table + 1 + number of RDAREAs used by the able + 1 + number of table BLOB columns + 2 + (1 + number of indexes defined in the table + number of BLOB columns defined in the table + number of BLOB attributes of user-defined types defined in the table) [Figure] number of LOB RDAREAs used by the table
    Also add the following if indexes are defined:
    + number of indexes defined in the table + 1
    Also add the following if the table is a partitioned table:
    + number of table partitions[Figure] 2 + 2
    [Figure]Also add the following if partitioning key indexes are defined:
    + number of partitioning key indexes[Figure] number of table partitions + 1
    [Figure]Also add the following when BLOB columns are defined:
    + number of table BLOB columns[Figure] number of table partitions
    [Figure] Also add the following if it is a matrix-partitioned table:
    + 3
    Also add the following if abstract data types of plug-ins are used:
    + number of plug-ins used + 1 + number of routines of plug-ins used + 1 + number of parameters of plug-in routines used + 1
    Also add the following if the inner replica facility is used:
    + 2 + (1 + number of indexes defined in the table + number of BLOB columns defined in the table + number of BLOB attributes of user-defined types defined in the table) [Figure] number of LOB RDAREAs used by the table[Figure] (number of generations + 1)
Also add the following if the table is a FIX table:
+ number of RDAREAs used by the table
  • Also add the following if there are routines that use the table as a resource:
    + number of routines that use the table as a resource + 1
  • Also add the following if there are view tables defined based on the table:
    + number of view tables defined based on the table[Figure] 2 + 2
  • Also add the following if the table is a partitioned table:
    + number of table partitions[Figure] 2 + 2
Also add the following if adding a NOT NULL column to a non-FIX table:
+ number of RDAREAs used by the table
  • Also add the following if there are routines that use the table as resources:
    + number of routines that use the table as resources + 1
  • Also add the following if there are view tables defined based on the table:
    + number of view tables defined based on the table[Figure] 2 + 2
  • Also add the following if the table is a partitioned table:
    + number of table partitions[Figure] 2 + 2
Also add the following if adding a column that has a DEFAULT clause specification:
+ number of RDAREAs used by the table
  • Also add the following if there are routines that use the table as a resource:
    + number of routines that use the table as a resource + 1
  • Also add the following if there are view tables defined based on the table:
    + number of view tables defined based on the table[Figure] 2 + 2
  • Also add the following if the table is a partitioned table:
    + number of table partitions[Figure] 2 + 2
Also add the following if columns are extracted:
+ 1
Add the following if there is an ADD RDAREA:
+ 9 + number of member columns in the table + 2 + number of indexes defined in the table + 4 + number of indexes defined in the table[Figure] 2 + number of BLOB columns defined in the table + number of BLOB attributes of user-defined types defined in the table
Add the following if it is a FIX hash table:
+ number of table-dedicated RDAREAs used by the table + number of table partitions
Also add the following if adding RDAREAs that are already being used for tables:
+ number of RDAREAs already being used
Also add the following if adding RDAREAs not being used for tables:
+ number of RDAREAs added + 1
Also add the following if there are routines that use the table as a resource:
+ number of routines that use the table as a resource
Also add the following if indexes are defined in the table:
+ number of indexes defined in the table + 1 + number of member columns of indexes defined in the table + 1 + number of RDAREAs used by indexes defined in the table[Figure] 2 + 1
  • Also add the following if adding RDAREAs not being used for tables:
    + number of indexes defined in the table
  • Also add the following if partitioning key indexes are defined:
    + number of partitioning key indexes[Figure] number of partitions after RDAREAs are added + 1
  • Also add the following if plug-in indexes are defined:
    + 2 + number of plug-in columns + 1 + number of attributes of plug-ins used by the table + 1 + number of routines of plug-ins used by the table + 1 + number of parameters of plug-in routines used by the table + 1 + number of BLOB attributes of plug-ins used by the table[Figure] number of partitions after RDAREAs are added
  • Also add the following if substructure indexes are defined:
    + number of substructure indexes defined in the table + 1
Also add the following if BLOB columns are defined in the table:
+ number of BLOB columns defined in the table + 1 + number of BLOB columns defined in the table[Figure] number of partitions after RDAREAs are added + 1 + number of RDAREAs used by BLOB columns defined in the table[Figure] 2 + 1
  • Also add the following if adding RDAREAs not being used for tables:
    + number of BLOB columns defined in the table
Also add the following if user-defined type columns are defined in the table:
+ number of user-defined type columns defined in the table + 1 + number of attributes of user-defined types used in the table + 1
  • Also add the following if BLOB attributes are defined in user-defined types:
    + number of BLOB attributes of user-defined types used in the table + 1 + number of RDAREAs used by BLOB attributes of user-defined types used in the table[Figure] 2 + 1 + number of BLOB attributes of user-defined types used in the table[Figure] number of partitions after RDAREAs are added + 1
  • Also add the following if adding RDAREAs not being used for tables:
    + number of user-defined type columns defined in the table
Also add the following if the inner replica facility is used:
+ number of RDAREAs added[Figure] number of generations + 2 + (number of indexes defined in the table[Figure] 2 + number of BLOB columns defined in the table + 2 + number of BLOB attributes of user-defined types defined in the table) [Figure] (number of RDAREAs used by the table+ 1) [Figure] (number of generations + 1)
Add the following if there is a CHANGE column-name:
+ 11
Also add the following if there are view tables defined based on the table:
+ number of view tables defined based on the table[Figure] 3
Also add the following if triggers are defined in the table:
+ number of triggers that use columns as resources[Figure] 2
Also add the following if there are routines that use the table as a resource:
+ number of routines that use the table as a resource + number of routines that use columns as parameters[Figure] 2
Also add the following if indexes are defined in the table:
+ number of indexes defined in the table
  • Also add the following if columns are index member columns:
    Also add the following if the column data types are VARCHAR, NVARCHAR, or MVARCHAR:
    + number of member columns in the table + number of index RDAREAs used by the table + 1 + number of member columns of indexes defined in the table + 1
    [Figure]Also add the following if partitioning key indexes are defined:
    + number of partitioning key indexes[Figure] number of partitions + 1
Also add the following if columns are BLOB columns:
+ 1
Also add the following if columns are user-defined type columns:
+ 2 + number of attributes of user-defined types used by columns + 1
Also add the following if NO SPLIT or RECOVERY is specified:
+ number of RDAREAs used by the table
  • Also add the following if it is a partitioned table:
    + number of table partitions + 1
    Also add the following when BLOB columns are defined:
    + number of BLOB columns defined in the table[Figure] number of partitions
Also add the following if data size changes:
  • Also add the following if an index is defined in the table:
    + 1
Also add the following if a column recovery restriction is defined:
  • Also add the following if columns are BLOB columns:
    + 2 + (1 + number of indexes defined in the table + number of BLOB columns defined in the table + number of BLOB attributes of user-defined types defined in the table) [Figure] number of LOB RDAREAs used by the table
Also add the following if a column is a user-defined type column that has the BLOB attribute:
+ 2 + (1 + number of indexes defined in the table + number of BLOB columns defined in the table + number of BLOB attributes of user-defined types defined in the table) [Figure] number of LOB RDAREAs used by the table
Also add the following if the inner replica facility is used:
  • Also add the following if columns are BLOB columns:
    + 2 + (1 + number of indexes defined in the table + number of BLOB columns defined in the table + number of LOB attributes of user-defined types defined in the table) [Figure] number of LOB RDAREAs used by the table[Figure] (number of generations + 1)
  • Also add the following if a column is a user-defined type column that has the BLOB attribute:
    + 2 + (1 + number of indexes defined in the table + number of BLOB columns defined in the table + number of BLOB attributes of user-defined types defined in the table) [Figure] number of LOB RDAREAs used by the table[Figure] (number of generations + 1)
Add the following if there is a CHANGE CLUSTER KEY:
+ 10 + number of member columns of the cluster key index[Figure] 2 + 1 + number of RDAREAs used by the table
Also add the following if there are routines with objects that become invalid:
+ number of routines whose objects become invalid[Figure] 2
Also add the following if indexes are defined in the table:
+ number of indexes defined in the table
  • Also add the following if partitioning key indexes are defined:
    + number of partitioning key indexes[Figure] number of partitions + 1
Also add the following if BLOB columns are defined in the table:
+ number of BLOB columns defined in the table
  • Also add the following if it is a partitioned table:
    + number of BLOB columns defined in the table[Figure] number of partitions + 1
Also add the following if it is a partitioned table:
+ number of table partitions + 1
  • Also add the following if it is a mixed hash and matrix partitioned table:
    + 2
Also add the following if it is a FIX table:
+ number of member columns in the table
Add the following if there is a CHANGE LOCK:
+ 5 + number of RDAREAs used by the table
Also add the following if there are view tables defined based on the table:
+ number of view tables defined based on the table[Figure] 3
Also add the following if there are routines that use the table as a resource:
+ number of routines that use the table as a resource
Also add the following if it is a partitioned table:
+ number of table partitions + 1
Add the following if there is a CHANGE HASH:
+ 5 + number of member columns in the table
Also add the following if there are view tables defined based on the table:
+ number of view tables defined based on the table[Figure] 3
Also add the following if there are routines that use the table as a resource:
+ number of routines that use the table as a resource
Also add the following if indexes are defined in the table:
+ number of indexes defined in the table + 1
  • Also add the following if partitioning key indexes are defined:
    + number of partitioning key indexes[Figure] number of partitions + 1
Also add the following if BLOB columns are defined in the table:
+ number of BLOB columns defined in the table[Figure] number of partitions + 1
Also add the following if it is a FIX hash partitioned table:
+ number of table partitions + 1 + number of RDAREAs used by the table + 1
Add the following if there is a CHANGE SEGMENT REUSE:
+ 4 + 2 + number of RDAREAs used by the table
Also add the following if it is a partitioned table:
+ number of table partitions + number of table partitioning conditions[Figure] 2
Also add the following if there are view tables defined based on the table:
+ number of view tables defined based on the table
Also add the following if there are routines that use the table as a resource:
+ number of routines that use the table as a resource
Also add the following if the SEGMENT REUSE specification is changed:
+ number of RDAREAs used by the table + 1
  • Also add the following if indexes are defined in the table:
    + number of indexes defined in the table + 1
    Also add the following if partitioning key indexes are defined:
    + number of partitioning key indexes[Figure] number of partitions + 1
  • Also add the following if BLOB columns are defined in the table:
    + number of BLOB columns defined in the table[Figure] number of partitions + 1
Also add the following if the inner replica facility is used:
+ 2 + (1 + number of indexes defined in the table + number of BLOB columns defined in the table + number of BLOB attributes of user-defined types defined in the table) [Figure] number of RDAREAs used by the table [Figure](number of generations + 1)
Add the following if there is a CHANGE INSERT ONLY:
+ 5 + number of RDAREAs used by the table
Also add the following if it is a partitioned table:
+ number of table partitions + 1
Also add the following if there are view tables defined based on the table:
+ number of view tables defined based on the table[Figure] 3 + 1
Also add the following if there are routines that use the table as a resource:
+ number of routines that use the table as a resource + 1
Also add the following if a row deletion period is specified:
+ 1
Add the following if there is a DROP column name:
+ 18 + number of member columns in the table
Also add the following if there are view tables defined based on the table:
+ number of view tables defined based on the table[Figure] 4 + number of member columns in view tables defined based on the table + number of resources used by view tables defined based on the table + number of users having access permission to view tables defined based on the table
  • Also add the following if there is a public view table defined based on the table:
    + 4
Also add the following if triggers are defined in the table:
+ number of triggers that use columns as event columns[Figure] 2 + number of triggers defined in the table[Figure] 4 +number of resources used by triggers defined in the table[Figure] 2 + number of routines used by triggers defined in the table + number of parameters used by triggers defined in the table
Also add the following if there are routines that use the table as a resource:
+ number of routines that use the table as a resource[Figure] 2 + number of routines that use columns as parameters[Figure] 2
Also add the following if statistical information relating to columns is output:
+ 2
Also add the following if indexes are defined in the table:
+ number of indexes defined in the table
  • Also add the following if columns are index member columns:
    + number of indexes that use columns as member columns[Figure] 2 + 2 + number of index RDAREAs used by the table + 1 + number of member columns of indexes that use columns as member columns + 1
    Also add the following if partitioning key indexes are defined:
    + number of partitioning key indexes[Figure] number of table partitions + 1
    Also add the following if statistical information relating to indexes is output:
    + number of indexes that use columns as member columns + 1
    Also add the following if exception values are specified for indexes:
    + number of exception values of indexes that use columns as member columns + 1
    Also add the following if the inner replica facility is used:
    + number of index RDAREAs used by the table[Figure] number of generations
Also add the following if BLOB columns are defined in the table:
+ number of BLOB columns defined in the table
  • Also add the following if it is a partitioned table:
    + number of BLOB columns defined in the table[Figure] number of table partitions
Also add the following if it is a partitioned table:
+ number of table partitions + 1
  • Also add the following if it is a matrix-partitioned table:
    + 2
Also add the following if the facility for predicting reorganization time is used:
+ number of index RDAREAs no longer used by the table[Figure] 2 + 2 + number of RDAREAs in which the table and indexes are no longer stored[Figure] 2
Add the following if there is a RENAME TABLE:
+ 7 + number of member columns in the table + number of users with permission to access the table
Also add the following if there are view tables defined based on the table:
+ number of view tables defined based on the table[Figure] 2
Also add the following if statistical information relating to the table is output:
+ 2
Also add the following if statistical information relating to columns is output:
+ number of columns for which statistical information exists + 1
Also add the following if there are routines that use the table as a resource:
+ number of routines that use the table as a resource
Also add the following if it is a partitioned table:
+ number of table partitions + 1
  • Also add the following if it is a row partitioned table:
    + number of table partitioning conditions[Figure] 2 + 1
  • Also add the following if it is a matrix-partitioned table:
    + number of table partitioning conditions + 4
    Also add the following if it is a mixed hash and matrix partitioned table:
    + number of table partitioning keys + 1
  • Also add the following if indexes are defined in the table:
    + number of indexes defined in the table + 1 + number of member columns of indexes defined in the table + 1
    Also add the following if partitioning key indexes are defined:
    + number of partitioning key indexes[Figure] number of partitions + 1
    Also add the following if substructure indexes are defined:
    + number of substructure indexes + 1
    Also add the following if plug-in indexes are defined:
    + number of functions that plug-in indexes use + 1
    Also add the following if exception values are specified for indexes:
    + number of exception values of indexes that are defined in the table + 1
    Also add the following if statistical information relating to indexes is output:
    + number of indexes defined in the table + 1
Also add the following if BLOB columns are defined in the table:
+ number of BLOB columns defined in the table + 1
  • Also add the following if it is a partitioned table:
    + number of BLOB columns defined in the table[Figure] number of partitions + 1
Also add the following if user-defined type columns are defined in the table:
+ number of user-defined type columns defined in the table + 1
  • Also add the following if indexes that use index types in the table are defined:
    + number of user-defined types to be used in indexes + 1
  • Also add the following if BLOB attributes are defined in user-defined types:
    + number of BLOB attributes used in user-defined types + 1
    Also add the following if it is a partitioned table:
    + number of BLOB attributes used in user-defined types[Figure] number of partitions
Also add the following if it is a public view table with a name that is the same as the table name before modification:
+ 3
Also add the following if it is a public view table with a name that is the same as the table name after modification:
+ 3
Add the following if there is a RENAME COLUMN:
+ 7 + number of member columns in the table
Also add the following if there are view tables defined based on the table:
+ number of view tables defined based on the table[Figure] 2
Also add the following if statistical information relating to columns is output:
+ 2
Also add the following if there are routines that use the table as a resource:
+ number of routines that use the table as a resource[Figure] 2 + 1 + number of routines that use columns as parameters[Figure] 2
Also add the following if it is a matrix-partitioned table:
+ 2
Also add the following if columns are index member columns:
+ number of indexes that use columns as member columns + 1
  • Also add the following if there are columns that are plug-in index member columns:
    + number of functions that plug-in indexes use + 1
Also add the following if columns are BLOB columns:
+ 2
  • Also add the following if it is a partitioned table:
    + number of partitions
Also add the following if columns are user-defined type columns:
  • Also add the following if there are columns that are index member columns that use the index type:
    + number of user-defined types to be used in indexes + 1
  • Also add the following if BLOB attributes are defined in user-defined types:
    + number of BLOB attributes used in user-defined types + 1
    Also add the following if it is a partitioned table:
    + number of BLOB attributes used in user-defined types[Figure] number of partitions
Add the following if there is a CHANGE RDAREA for a row partitioning table:
+ 8 + number of member columns in the table + number of partitioning conditions before modification[Figure] 2 + number of partitioning conditions after modification[Figure] 2 + number of partitions before modification + number of partitions after modification + number of RDAREAs used by the table before modification + number of RDAREAs used by the table after modification[Figure] 2 + 4 + number of indexes defined in the table + number of indexes subject to deletion + (2 + number of indexes defined in the table[Figure] 2 + number of BLOB columns defined in the table) [Figure] (number of RDAREAs added to the table + number of RDAREAs to be deleted from the table)
Also add the following if there are routines that use the table as a resource:
+ number of routines that use the table as a resource
Also add the following if there are view tables defined based on the table:
+ number of view tables defined based on the table
Also add the following if indexes are defined in the table:
+ number of indexes defined in the table + 1 + number of member columns of indexes defined in the table + 1 + number of indexes defined in the table[Figure] number of partitions before modification + 1 + number of indexes defined in the table[Figure] number of partitions after modification
  • Also add the following if substructure indexes are defined:
    + number of substructure indexes defined in the table + 1
Also add the following if BLOB columns are defined in the table:
+ number of BLOB columns defined in the table[Figure] number of partitions before modification + 1 + number of BLOB columns defined in the table[Figure] number of partitions after modification
Also add the following if a referential constraint is defined that makes the table a referenced table:
+ number of referential constraints that make the table a referenced table + 1 + number of referencing tables that make the table a referenced table
Also add the following if a referential constraint is defined that makes the table a referencing table:
+ number of referential constraints of the table + 1
Also add the following if a check constraint is defined in the table:
+ number of check constraints in the table + 1
Also add the following if the facility for predicting reorganization time is used:
+ number of RDAREAs no longer used by the table[Figure] 2 + 2 + number of RDAREAs whose data will be deleted + number of RDAREAs in which the table and indexes are no longer stored[Figure] 2
Also add the following if the inner replica facility is used:
+ number of RDAREAs used by the table after modification[Figure] number of generations + 2 + number of indexes subject to deletion + (2 + number of indexes defined in the table[Figure] 2 + number of BLOB columns defined in the table) [Figure] (number of RDAREAs added to the table + number of RDAREAs to be deleted from the table) [Figure] (number of generations + 1)
Also add the following if there is a CHANGE RDAREA for a matrix-partitioned table:
+ 11
+ number of member columns in the table + number of partitioning conditions before modification + number of partitioning conditions after modification + number of partitions before modification + number of partitions after modification + number of RDAREAs used by the table before modification
+ number of RDAREAs used by the table after modification[Figure] 2 + 4
+ number of indexes defined in the table + number of indexes subject to deletion + (2 + number of indexes defined in the table[Figure] 2 + number of BLOB columns defined in the table) [Figure] (number of RDAREAs added to the table + number of RDAREAs to be deleted from the table)
Also add the following if there are routines that use the table as a resource:
+ number of routines that use the tables as a resource
Also add the following if there are view tables defined based on the table:
+ number of view tables defined based on the table
Also add the following if indexes are defined in the table:
+ number of indexes defined in the table + 1 + number of member columns of indexes defined in the table + 1 + number of indexes defined in the table[Figure] number of partitions before modification + 1 + number of indexes defined in the table[Figure] number of partitions after modification
  • Also add the following if substructure indexes are defined:
    + number of substructure indexes defined in the table + 1
Also add the following if BLOB columns are defined in the table:
+ number of BLOB columns defined in the table[Figure] number of partitions before modification + 1 + number of BLOB columns defined in the table[Figure] number of partitions after modification
Also add the following if a referential constraint is defined that makes the table a referenced table:
+ number of referential constraints that make the table a referenced table + 1 + number of referencing tables that make the table a referenced table
Also add the following if a referential constraint is defined that makes the table a referencing table:
+ number of referential constraints of the table + 1
Also add the following if a check constraint is defined in the table:
+ number of check constraints in the table + 1
Also add the following if the facility for predicting reorganization time is used:
+ number of RDAREAs no longer used by the table[Figure] 2 + 2 + number of RDAREAs whose data will be deleted + number of RDAREAs in which the table and indexes are no longer stored[Figure] 2
Also add the following if the inner replica facility is used:
+ number of RDAREAs used by the table after modification[Figure] number of generations + 2 + number of indexes subject to deletion + (2 + number of indexes defined in the tables[Figure] 2 + number of BLOB columns defined in the table) [Figure] (number of RDAREAs added to the table + number of RDAREAs to be deleted from the table) [Figure] (number of generations + 1)
(b) For a HiRDB single server configuration (addition and deletion of primary keys)
(i) Addition of primary keys
15 + number of columns in the target table + number of member columns of the primary key[Figure] 2
+ number of RDAREAs for index#[Figure] 3 + number of RDAREAs for table[Figure] 2
+ 5 + 2 [Figure] number of RDAREAs for index
Also add the following if the target table is a matrix-partitioned table:
+ 3 + number of table partitioning information items
Also add the following if there are routines that reference the target table:
+ number of routines that reference the target table[Figure] 3 + 1
Also add the following if there are trigger action procedures that reference the target table:
+ number of trigger action procedures that reference the target table + 1
Also add the following if the inner replica facility is used:
  • Also add the following if a LOB column or a LOB attribute is defined for the target table:
    + number of RDAREAs for LOB column
    + number of RDAREAs for LOB attribute
    + 1 + (number of RDAREAs for LOB column[Figure] number of LOB columns) [Figure] 2
    + (number of RDAREAs for LOB attribute[Figure] number of LOB attribute columns) [Figure] 2
  • Also add the following if indexes are defined for the target table:
    + number of indexes
    + (number of RDAREAs for index[Figure] number of indexes) [Figure] 2
(ii) Deletion of primary keys
15 + number of member columns of the primary key[Figure] 2 + number of RDAREAs for index#[Figure] 4
+ number of RDAREAs for index[Figure] 7 + number of index segments
Also add the following if there are routines that reference the target table:
+ number of routines that reference the target table[Figure] 3 + 1
Also add the following if there are trigger action procedures that reference the target table:
+ number of trigger action procedures that reference the target table + 1
Also add the following if there are routines that become invalid:
+ number of routines that become invalid[Figure] 2 + 1
+ number of resources held by a routine that becomes invalid[Figure] number of routines that become invalid
Also add the following if there are triggers that become invalid:
+ number of triggers that become invalid + 1
+ number of resources referenced in the trigger action conditions that become invalid + 1
+ number of parameters in the trigger action procedures of the triggers that become invalid + 1
+ number of trigger event column information items for the triggers that become invalid + 1
Also add the following if index optimization information is collected:
+ 2
Also add the following if the inner replica facility is used:
+ number of RDAREAs for table
  • Also add the following if a LOB column or LOB attribute is defined in the table for which indexes are defined:
    + number of RDAREAs for LOB column
    + number of RDAREAs for LOB attribute
  • Also add the following if a LOB column or a LOB attribute is defined for the target table:
    + 1 + (number of RDAREAs for LOB column[Figure] number of LOB columns) [Figure] 2
    + (number of RDAREAs for LOB attribute[Figure] number of LOB attribute columns) [Figure] 2
  • Also add the following if indexes are defined for the target table:
    + number of indexes
    + (number of RDAREAs for index[Figure] number of indexes) [Figure] 2
Add the following if the facility for predicting reorganization time is used:
+ number of RDAREAs for index[Figure] 62 + 1
(c) For a HiRDB parallel server configuration (front-end server) (operations other than the addition or deletion of primary keys)

1 + number of routines whose objects become invalid + number of view tables defined based on the table

Add the following if there is a DROP COLUMN:
+ number of triggers defined in the table
(d) For a HiRDB parallel server configuration (front-end server) (addition and deletion of primary keys)
(i) Addition of primary keys
1
Also add the following if there are routines that reference the target table:
+ number of routines that reference the target table
(ii) Deletion of primary keys
1
Also add the following if there are routines that reference the target table:
+ number of routines that reference the target table
Also add the following if there are routines that become invalid:
+ number of routines that become invalid
(e) For a HiRDB parallel server configuration (dictionary server) (operations other than the addition or deletion of primary keys)

1

Add the following if there are routines that become invalid:
+ number of routines whose objects become invalid[Figure] 3 + 2
Add the following if triggers are defined:
+ number of trigger definitions[Figure] 2 + 2 + number of defined trigger event columns + 1 + number of parameters used by defined triggers + 1
Also add the following if there is a DROP COLUMN:
+ number of triggers defined in the table
Add the following if the inner replica facility is used:
+ number of RDAREAs used by the table + 1
Also add the following if indexes are defined:
+ number of indexes defined in the table + 1 + number of RDAREAs used by indexes defined in the table
Also add the following when BLOB columns are defined:
+ number of BLOB columns defined in the table + 1 + number of RDAREAs used by BLOB columns defined in the table
Also add the following if the table is a partitioned table:
+ number of table partitions + 1
  • Also add the following if partitioning key indexes are defined:
    + number of table partitions[Figure] number of partitioning key indexes + 1
  • Also add the following when BLOB columns are defined:
    + number of table partitions[Figure] number of BLOB columns + 1
Add the following if there is an ADD column-name:
+ 5
Also add the following if there are view tables defined based on the table:
+ number of view tables defined based on the table
Also add the following if adding BLOB columns:
+ number of RDAREAs added to the table + 1 + number of RDAREAs used by the table + 1 + number of table BLOB columns
  • Also add the following if there are routines that use the table as a resource:
    + number of routines that use the table as a resource + 1
  • Also add the following if there are view tables defined based on the table:
    + number of view tables defined based on the table[Figure] 2 + 2
  • Also add the following if indexes are defined:
    + number of indexes defined in the table + 1
    Also add the following if the table is a partitioned table:
    + number of table partitions[Figure] 2 + 2
    Also add the following if partitioning key indexes are defined:
    + number of partitioning key indexes[Figure] number of table partitions + 1
    Also add the following when BLOB columns are defined:
    + number of table BLOB columns[Figure] number of table partitions
    Also add the following if it is a matrix-partitioned table:
    + 3
Also add the following if adding user-defined type columns:
+ 4 + number of attributes used by user-defined types
  • Also add the following if there are routines that use the table as a resource:
    + number of routines that use the able as a resource + 1
  • Also add the following if there are view tables defined based on the table:
    + number of view tables defined based on the table[Figure] 2 + 2
  • Also add the following if there are user-defined types for which BLOB attributes are defined:
    + number of RDAREAs added to the table + 1 + number of RDAREAs used by the table + 1 + number of table BLOB columns
    Also add the following if indexes are defined:
    + number of indexes defined in the table + 1
    Also add the following if the table is a partitioned table:
    + number of table partitions[Figure] 2 + 2
    [Figure]Also add the following if partitioning key indexes are defined:
    + number of partitioning key indexes[Figure] number of table partitions + 1
    [Figure]Also add the following when BLOB columns are defined:
    + number of table BLOB columns[Figure] number of table partitions
    [Figure] Also add the following if it is a matrix-partitioned table:
    + 3
    Also add the following if abstract data types of plug-ins are used:
    + number of plug-ins used + 1 + number of routines of plug-ins used + 1 + number of parameters of plug-in routines used + 1
Also add the following if the table is a FIX table:
+ number of RDAREAs used by the table
  • Also add the following if there are routines that use the table as a resource:
    + number of routines that use the table as a resource + 1
  • Also add the following if there are view tables defined based on the table:
    + number of view tables defined based on the table[Figure] 2 + 2
  • Also add the following if the table is a partitioned table:
    + number of table partitions[Figure] 2 + 2
Also add the following if adding a NOT NULL column to a non-FIX table:
+ number of RDAREAs used by the table
  • Also add the following if there are routines that use the table as a resource:
    + number of routines that use the table as a resource + 1
  • Also add the following if there are view tables defined based on the table:
    + number of view tables defined based on the table[Figure] 2 + 2
  • Also add the following if the table is a partitioned table:
    + number of table partitions[Figure] 2 + 2
  • Also add the following if columns are extracted:
    + 1
Also add the following if adding a column that has a DEFAULT clause specification:
+ number of RDAREAs used by the table
  • Also add the following if there are routines that use the table as a resource:
    + number of routines that use the table as a resource + 1
  • Also add the following if there are view tables defined based on the table:
    + number of view tables defined based on the table[Figure] 2 + 2
  • Also add the following if the table is a partitioned table:
    + number of table partitions[Figure] 2 + 2
Add the following if there is an ADD RDAREA:
+ 9 + number of member columns in the table + 2 + number of indexes defined in the table
Also add the following if it is a FIX hash table:
+ number of table-dedicated RDAREAs used by the table + number of table partitions
Also add the following if adding RDAREAs that are already being used for tables:
+ number of RDAREAs already being used
Also add the following if adding RDAREAs not being used for tables:
+ number of RDAREAs added + 1
Also add the following if the inner replica facility is used:
+ number of RDAREAs added[Figure] number of generations
Also add the following if there are routines that use the table as a resource:
+ number of routines that use the table as a resource
Also add the following if indexes are defined in the table:
+ number of indexes defined in the table + 1 + number of member columns of indexes defined in the table + 1 + number of RDAREAs used by indexes defined in the table[Figure] 2 + 1
  • Also add the following if adding RDAREAs not being used for tables:
    + number of indexes defined in the table
  • Also add the following if partitioning key indexes are defined:
    + number of partitioning key indexes[Figure] number of partitions after RDAREAs are added + 1
  • Also add the following if plug-in indexes are defined:
    + 2 + number of plug-in columns + 1 + number of attributes of plug-ins used by the table + 1 + number of routines of plug-ins used by the table + 1 + number of parameters of plug-in routines used by the table + 1 + number of BLOB attributes of plug-ins used by the table[Figure] number of partitions after RDAREAs are added
  • Also add the following if substructure indexes are defined:
    + number of substructure indexes defined in the table + 1
Also add the following if BLOB columns are defined in the table:
+ number of BLOB columns defined in the table + 1 + number of BLOB columns defined in the table[Figure] number of partitions after RDAREAs are added + 1 + number of RDAREAs used by BLOB columns defined in the table[Figure] 2 + 1
  • Also add the following if adding RDAREAs not being used for tables:
    + number of BLOB columns defined in the table
Also add the following if user-defined type columns are defined in the table:
+ number of user-defined type columns defined in the table + 1 + number of attributes of user-defined types used in the table + 1
  • Also add the following if BLOB attributes are defined in user-defined types:
    + number of BLOB attributes of user-defined types used in the table + 1 + number of RDAREAs used by BLOB attributes of user-defined types used in the table[Figure] 2 + 1 + number of BLOB attributes of user-defined types used in the table[Figure] number of partitions after RDAREAs are added + 1
  • Also add the following if adding RDAREAs not being used for tables:
    + number of user-defined type columns defined in the table
Add the following if there is a CHANGE column-name:
+ 11
Also add the following if there are view tables defined based on the table:
+ number of view tables defined based on the table[Figure] 3
Also add the following if triggers are defined in the table:
+ number of triggers that use columns as resources[Figure] 2
Also add the following if there are routines that use the table as a resource:
+ number of routines that use the table as a resource + number of routines that use columns as parameters[Figure] 2
Also add the following if indexes are defined in the table:
+ number of indexes defined in the table
  • Also add the following if columns are index member columns:
    Also add the following if the column data types are VARCHAR, NVARCHAR, or MVARCHAR:
    + number of member columns in the table + number of index RDAREAs used by the table + 1 + number of member columns of indexes defined in the table + 1
    [Figure]Also add the following if partitioning key indexes are defined:
    + number of partitioning key indexes[Figure] number of partitions + 1
Also add the following if columns are BLOB columns:
+ 1
Also add the following if columns are user-defined type columns:
+ 2 + number of attributes of user-defined types used by column + 1
Also add the following if NO SPLIT or RECOVERY is specified:
+ number of RDAREAs used by the table
  • Also add the following if it is a partitioned table:
    + number of table partitions + 1
    Also add the following when BLOB columns are defined:
    + number of BLOB columns defined in the table[Figure] number of partitions
Also add the following if data size changes:
  • Also add the following if an index is defined in the table:
    + 1
Add the following if there is a CHANGE CLUSTER KEY:
+ 10 + number of cluster key member columns[Figure] 2 + 1 + number of RDAREAs used by the table
Also add the following if there are routines with objects that become invalid:
+ number of routines whose objects become invalid[Figure] 2
Also add the following if indexes are defined in the table:
+ number of indexes defined in the table
  • Also add the following if partitioning key indexes are defined:
    + number of partitioning key indexes[Figure] number of partitions + 1
Also add the following if BLOB columns are defined in the table:
+ number of BLOB columns defined in the table
  • Also add the following if it is a partitioned table:
    + number of BLOB columns defined in the table[Figure] number of partitions + 1
Also add the following if it is a partitioned table:
+ number of table partitions + 1
  • Also add the following if it is a mixed hash and matrix partitioned table:
    + 2
Also add the following if it is a FIX table:
+ number of member columns in the table
Add the following if there is a CHANGE LOCK:
+ 5 + number of RDAREAs used by the table
Also add the following if there are view tables defined based on the table:
+ number of view tables defined based on the table[Figure] 3
Also add the following if there are routines that use the table as a resource:
+ number of routines that use the table as a resource
Also add the following if it is a partitioned table:
+ number of table partitions + 1
Add the following if there is a CHANGE HASH:
+ 5 + number of member columns in the table
Also add the following if there are view tables defined based on the table:
+ number of view tables defined based on the table[Figure] 3
Also add the following if there are routines that use the table as a resource:
+ number of routines that use the table as a resource
Also add the following if indexes are defined in the table:
+ number of indexes defined in the table + 1
  • Also add the following if partitioning key indexes are defined:
    + number of partitioning key indexes[Figure] number of partitions + 1
Also add the following if BLOB columns are defined in the table:
+ number of BLOB columns defined in the table[Figure] number of partitions + 1
Also add the following if it is a FIX hash partitioned table:
+ number of table partitions + 1 + number of RDAREAs used by the table+ 1
Add the following if there is a CHANGE SEGMENT REUSE:
+ 4
Also add the following if it is a partitioned table:
+ number of table partitions + number of table partitioning conditions[Figure] 2
Also add the following if there are view tables defined based on the table:
+ number of view tables defined based on the table
Also add the following if there are routines that use the table as a resource:
+ number of routines that use the table as a resource
Also add the following if SEGMENT REUSE specification is changed:
+ number of RDAREAs used by the table + 1
  • Also add the following if indexes are defined in the table:
    + number of indexes defined in the table + 1
    Also add the following if partitioning key indexes are defined:
    + number of partitioning key indexes[Figure] number of partitions + 1
  • Also add the following if BLOB columns are defined in the table:
    + number of BLOB columns defined in the table[Figure] number of partitions + 1
Add the following if there is a CHANGE INSERT ONLY:
+ 5 + number of RDAREAs used by the table
Also add the following if it is a partitioned table:
+ number of table partitions + 1
Also add the following if there are view tables defined based on the table:
+ number of view tables defined based on the table[Figure] 3 + 1
Also add the following if there are routines that use the table as a resource:
+ number of routines that use the table as a resource + 1
Also add the following if a row deletion period is specified:
+ 1
Add the following if there is a DROP column-name:
+ 18 + number of member columns in the table
Also add the following if there are view tables defined based on the table:
+ number of view tables defined based on the table[Figure] 4 + number of member columns in view tables defined based on the table + number of resources used by view tables defined based on the table + number of users having access permission to view tables defined based on the table
  • Also add the following if there is a public view table defined based on the table:
    + 4
Also add the following if triggers are defined in the table:
+ number of triggers that use columns as event columns[Figure] 2 + number of triggers defined in the table[Figure] 4 + number of resources used by triggers defined in the table[Figure] 2 + number of routines used by triggers defined in the table + number of parameters used by triggers defined in the table
Also add the following if there are routines that use the tables as a resource:
+ number of routines that use the table as a resource[Figure] 2 + number of routines that use columns as parameters[Figure] 2
Also add the following if statistical information relating to columns is output:
+ 2
Also add the following if indexes are defined in the table:
+ number of indexes defined in the table
  • Also add the following if columns are index member columns:
    + number of indexes that use columns as member columns[Figure] 2 + 2 + number of index RDAREAs used by the table + 1 + number of member columns of indexes that use columns as member columns + 1
    Also add the following if partitioning key indexes are defined:
    + number of partitioning key indexes[Figure] number of table partitions + 1
    Also add the following if statistical information relating to indexes is output:
    + number of indexes that use columns as member columns + 1
    Also add the following if exception values are specified for indexes:
    + number of exception values of indexes that use columns as member columns + 1
    Also add the following if the inner replica facility is used:
    + number of index RDAREAs used by the table[Figure] number of generations
Also add the following if BLOB columns are defined in the table:
+ number of BLOB columns defined in the table
  • Also add the following if it is a partitioned table:
    + number of BLOB columns defined in the table[Figure] number of table partitions
Also add the following if it is a partitioned table:
+ number of table partitions + 1
  • Also add the following if it is a matrix-partitioned table:
    + 2
Also add the following if the facility for predicting reorganization time is used:
+ number of index RDAREAs no longer used by the table[Figure] 2 + 2 + number of RDAREAs in which the table and indexes are no longer stored[Figure] 2
Add the following if there is a RENAME TABLE:
+ 7 + number of member columns in the table + number of users with permission to access the table
Also add the following if there are view tables defined based on the table:
+ number of view tables defined based on the table[Figure] 2
Also add the following if statistical information relating to the table is output:
+ 2
Also add the following if statistical information relating to columns is output:
+ number of columns for which statistical information exists + 1
Also add the following if there are routines that use the table as a resource:
+ number of routines that use the table as a resource
Also add the following if it is a partitioned table:
+ number of table partitions + 1
  • Also add the following if it is a row partitioned table:
    + number of table partitioning conditions[Figure] 2 + 1
  • Also add the following if it is a matrix-partitioned table:
    + number of table partitioning conditions + 4
    Also add the following if it is a mixed hash and matrix partitioned table:
    + number of table partitioning keys + 1
Also add the following if indexes are defined in the table:
+ number of indexes defined in the table + 1 + number of member columns of indexes defined in the table + 1
  • Also add the following if partitioning key indexes are defined:
    + number of partitioning key indexes[Figure] number of partitions + 1
  • Also add the following if substructure indexes are defined:
    + number of substructure indexes + 1
  • Also add the following if plug-in indexes are defined:
    + number of functions that plug-in indexes use + 1
  • Also add the following if exception values are specified for indexes:
    + number of exception values of indexes that are defined in the table + 1
  • Also add the following if statistical information relating to indexes is output:
    + number of indexes defined in the table + 1
Also add the following if BLOB columns are defined in the table:
+ number of BLOB columns defined in the table + 1
  • Also add the following if it is a partitioned table:
    + number of BLOB columns defined in the table[Figure] number of partitions + 1
Also add the following if user-defined type columns are defined in the table:
+ number of user-defined type columns defined in the table + 1
  • Also add the following if indexes that use index types in the table are defined:
    + number of user-defined types to be used in indexes + 1
  • Also add the following if BLOB attributes are defined in user-defined types:
    + number of BLOB attributes used in user-defined types + 1
    Also add the following if it is a partitioned table:
    + number of BLOB attributes used in user-defined types[Figure] number of partitions
Also add the following if it is a public view table with a name that is the same as the table name before modification:
+ 3
Also add the following if it is a public view table with a name that is the same as the table name after modification:
+ 3
Add the following if there is a RENAME COLUMN:
+ 7 + number of member columns in the table
Also add the following if there are view tables defined based on the table:
+ number of view tables defined based on the table[Figure] 2
Also add the following if statistical information relating to columns is output:
+ 2
Also add the following if there are routines that use the table as a resource:
+ number of routines that use the table as a resource[Figure] 2 + 1 + number of routines that use columns as parameters[Figure] 2
Also add the following if it is a matrix-partitioned table:
+ 2
Also add the following if columns are index member columns:
+ number of indexes that use columns as member columns + 1
  • Also add the following if there are columns that are plug-in index member columns:
    + number of functions that plug-in indexes use + 1
Also add the following if columns are BLOB columns:
+ 2
  • Also add the following if it is a partitioned table:
    + number of partitions
Also add the following if columns are user-defined type columns:
  • Also add the following if there are columns that are index member columns that use the index type:
    + number of user-defined types to be used in indexes + 1
  • Also add the following if BLOB attributes are defined in user-defined types:
    + number of BLOB attributes used in user-defined types + 1
    Also add the following if it is a partitioned table:
    + number of BLOB attributes used in user-defined types[Figure] number of partitions
Add the following if there is a CHANGE RDAREA for a row-partitioned table:
+ 8 + number of member columns in the table + number of partitioning conditions before modification[Figure] 2 + number of partitioning conditions after modification[Figure] 2 + number of partitions before modification + number of partitions after modification + number of RDAREAs used by the table before modification + number of RDAREAs used by the table after modification[Figure] 2 + 2 + number of indexes defined in the table
Also add the following if the inner replica facility is used:
+ number of RDAREAs used by the table after modification[Figure] number of generations
Also add the following if there are routines that use the table as a resource:
+ number of routines that use the table as a resource
Also add the following if there are view tables defined based on the table:
+ number of view tables defined based on the table
Also add the following if indexes are defined in the table:
+ number of indexes defined in the table + 1 + number of member columns of indexes defined in the table + 1 + number of indexes defined in the table[Figure] number of partitions before modification + 1 + number of indexes defined in the table[Figure] number of partitions after modification
  • Also add the following if substructure indexes are defined:
    + number of substructure indexes defined in the table + 1
Also add the following if BLOB columns are defined in the table:
+ number of BLOB columns defined in the table[Figure] number of partitions before modification + 1 + number of BLOB columns defined in the table[Figure] number of partitions after modification
Also add the following if a referential constraint is defined that makes the table a referenced table:
+ number of referential constraints that make the table a referenced table + 1 + number of referencing tables that make the table a referenced table
Also add the following if a referential constraint is defined that makes the table a referencing table:
+ number of referential constraints of the table + 1
Also add the following if a check constraint is defined in the table:
+ number of check constraints of the table + 1
Also add the following if the facility for predicting reorganization time is used:
+ number of RDAREAs no longer used by the table[Figure] 2 + 2 + number of RDAREAs whose data will be deleted + number of RDAREAs in which the table and indexes are no longer stored[Figure] 2
Add the following if there is a CHANGE RDAREA for a matrix-partitioned table:
+ 11 + number of member columns in the table + number of partitioning conditions before modification + number of partitioning conditions after modification + number of partitions before modification + number of partitions after modification + number of RDAREAs used by the table before modification + number of RDAREAs used by the table after modification[Figure] 2 + 2 + number of indexes defined in the table
Also add the following if the inner replica facility is used:
+ number of RDAREAs used by the table after modification[Figure] number of generations
Also add the following if there are routines that use the table as a resource:
+ number of routines that use the table as a resource
Also add the following if there are view tables defined based on the table:
+ number of view tables defined based on the table
Also add the following if indexes are defined in the table:
+ number of indexes defined in the table + 1 + number of member columns of indexes defined in the table + 1 + number of indexes defined in the table[Figure] number of partitions before modification + 1 + number of indexes defined in the table[Figure] number of partitions after modification
  • Also add the following if substructure indexes are defined:
    + number of substructure indexes defined in the table + 1
Also add the following if BLOB columns are defined in the table:
+ number of BLOB columns defined in the table[Figure] number of partitions before modification + 1 + number of BLOB columns defined in the table[Figure] number of partitions after modification
Also add the following if a referential constraint is defined that makes the table a referenced table:
+ number of referential constraints that make the table a referenced table + 1 + number of referencing tables that make the table a referenced table
Also add the following if a referential constraint is defined that makes the table a referencing table:
+ number of referential constraints of the table + 1
Also add the following if a check constraint is defined in the table:
+ number of check constraints of the table + 1
Also add the following if the facility for predicting reorganization time is used:
+ number of RDAREAs no longer used by the table[Figure] 2 + 2 + number of RDAREAs whose data will be deleted + number of RDAREAs in which the table and indexes are no longer stored[Figure] 2
(f) For a HiRDB parallel server configuration (dictionary server) (addition and deletion of primary keys)
(i) Addition of primary keys
9 + number of columns in the target table + number of member columns of the primary key
+ number of RDAREAs for index#[Figure] 3 + number of RDAREAs for table[Figure] 2
Also add the following if the target table is a matrix-partitioned table:
+ 3 + number of table partitioning information items
Also add the following if there are routines that reference the target table:
+ number of routines that reference the target table[Figure] 3 + 1
Also add the following if there are trigger action procedures that reference the target table:
+ number of trigger action procedures that reference the target table + 1
Also add the following if the inner replica facility is used:
  • Also add the following if a LOB column or a LOB attribute is defined for the target table:
    + 1 + (number of RDAREAs for LOB column[Figure] number of LOB columns) [Figure] 2
    + (number of RDAREAs for LOB attribute[Figure] number of LOB attribute columns) [Figure] 2
  • Also add the following if indexes are defined for the target table:
    + number of indexes
    + (number of RDAREAs for index[Figure] number of indexes) [Figure] 2
(ii) Deletion of primary keys
9 + number of member columns of the primary key[Figure] 2 + number of RDAREAs for index#[Figure] 4
Also add the following if there are routines that reference the target table:
+ number of routines that reference the target table[Figure] 2 + 1
Also add the following if there are trigger action procedures that reference the target table:
+ number of trigger action procedures that reference the target table + 1
Also add the following if there are routines that become invalid:
+ number of routines that become invalid[Figure] 2 + 1
+ number of resources held by a routine that becomes invalid[Figure] number of routines that become invalid
Also add the following if there are triggers that become invalid:
+ number of triggers that become invalid + 1
+ number of resources referenced in the trigger action conditions that become invalid + 1
+ number of parameters in the trigger action procedures of the triggers that become invalid + 1
+ number of trigger event column information items for the triggers that become invalid + 1
Also add the following if index optimization information is collected:
+ 2
Also add the following if the inner replica facility is used:
  • Also add the following if a LOB column or a LOB attribute is defined for the target table:
    + 1 + (number of RDAREAs for LOB column[Figure] number of LOB columns) [Figure] 2
    + (number of RDAREAs for LOB attribute[Figure] number of LOB attribute columns) [Figure] 2
  • Also add the following if indexes are defined for the target table:
    + number of indexes
    + (number of RDAREAs for index[Figure] number of indexes) [Figure] 2
Add the following if the facility for predicting reorganization time is used:
+ number of RDAREAs for index[Figure] 62 + 1
(g) For a HiRDB parallel server configuration (back-end server) (operations other than the addition or deletion of primary keys)

number of routines whose objects become invalid

Add the following if there is a DROP COLUMN:
+ number of triggers defined in the table
Add the following if there is an ADD column name:
Also add the following if adding BLOB columns:
+ 2 + (1 + number of indexes defined in the table + number of BLOB columns defined in the table + number of BLOB attributes of user-defined types defined in the table) [Figure] number of LOB RDAREAs used by the table
Also add the following if adding user-defined type columns that have BLOB attributes:
+ 2 + (1 + number of indexes defined in the table + number of BLOB columns defined in the table + number of BLOB attributes of user-defined types defined in the table) [Figure] number of LOB RDAREAs used by the table
Also add the following if the inner replica facility is used:
  • Also add the following if adding BLOB columns:
    + 2 + (1 + number of indexes defined in the table + number of BLOB columns defined in the table + number of BLOB attributes of user-defined types defined in the table) [Figure] number of LOB RDAREAs used by the table[Figure] (number of generations + 1)
  • Also add the following if adding user-defined type columns that have BLOB attributes:
    + 2 + (1 + number of indexes defined in the table + number of BLOB columns defined in the table + number of BLOB attributes of user-defined types defined in the table) [Figure] number of LOB RDAREAs used by the table[Figure] (number of generations + 1)
Add the following if there is an ADD RDAREA:
+ 4 + number of indexes defined in the table[Figure] 2 + number of BLOB columns defined in the table + number of BLOB attributes of user-defined types defined in the table
Also add the following if the inner replica facility is used:
+ 2 + (number of indexes defined in the table[Figure] 2 + number of BLOB columns defined in the table + 2 + number of BLOB attributes of user-defined types defined in the table) [Figure] (number of RDAREAs used by the table+ 1) [Figure] (number of generations + 1)
Add the following if there is a CHANGE column-name:
Add the following if column recovery restrictions are defined:
  • Also add the following if columns are BLOB columns:
    + 2 + (1 + number of indexes defined in the table + number of BLOB columns defined in the table + number of BLOB attributes of user-defined types defined in the table) [Figure] number of LOB RDAREAs used by the table
  • Also add the following if a column is a user-defined type column that has a BLOB attribute:
    + 2 + (1 + number of indexes defined in the table + number of BLOB columns defined in the table + number of BLOB attributes of user-defined types defined in the table) [Figure] number of LOB RDAREAs used by the table
  • Also add the following if the inner replica facility is used:
    Also add the following if columns are BLOB columns:
    + 2 + (1 + number of indexes defined in the table + number of BLOB columns defined in the table + number of BLOB attributes of user-defined types defined in the table) [Figure] number of LOB RDAREAs used by the table[Figure] (number of generations + 1)
    Also add the following if a column is a user-defined type column that has a BLOB attribute:
    + 2 + (1 + number of indexes defined in the table + number of BLOB columns defined in the table + number of BLOB attributes of user-defined types defined in the table) [Figure] number of LOB RDAREAs used by the table[Figure] (number of generations + 1)
Add the following if there is a CHANGE SEGMENT REUSE:
+ 2 + number of RDAREAs used by the table
Also add the following if the inner replica facility is used:
+ 2 + (1 + number of indexes defined in the table + number of BLOB columns defined in the table + number of BLOB attributes of user-defined types defined in the table) [Figure] number of RDAREAs used by the table[Figure] (number of generations + 1)
Add the following if there is a CHANGE RDAREA:
+ 2 + number of indexes subject to deletion + (2 + number of indexes defined in the table[Figure] 2 + number of BLOB columns defined in the table) [Figure] (number of RDAREAs added to the table+ number of RDAREAs to be deleted from the table)
Also add the following if the inner replica facility is used:
+ 2 + number of indexes subject to deletion + (2 + number of indexes defined in the table[Figure] 2 + number of BLOB columns defined in the table) [Figure] (number of RDAREAs added to the table + number of RDAREAs to be deleted from the table) [Figure] (number of generations + 1)
(h) HiRDB parallel server configuration (back-end server#) (addition and deletion of primary keys)
(i) Addition of primary keys
5 + number of RDAREAs for index[Figure] 2
Also add the following if there are routines that reference the target table:
+ number of routines that reference the target table
Also add the following if the inner replica facility is used:
  • Also add the following if a LOB column or a LOB attribute is defined for the target table:
    + number of RDAREAs for LOB column
    + number of RDAREAs for LOB attribute
(ii) Deletion of primary keys
5 + number of RDAREAs for index[Figure] 4 + number of index segments
Also add the following if there are routines that reference the target table:
+ number of routines that reference the target table
Also add the following if there are routines that become invalid:
+ number of routines that become invalid
Also add the following if the inner replica facility is used:
+ number of RDAREAs for table
  • Also add the following if a LOB column or LOB attribute is defined in the table for which indexes are defined:
    + number of RDAREAs for LOB column
    + number of RDAREAs for LOB attribute
(i) HiRDB parallel server configuration (reference-only back-end server#)

2

#: If the inner replica facility is used, as many resources are required as there are generations.

(6) ALTER TRIGGER

(a) For a HiRDB single server configuration

19

Add the following if the executer is not the owner:
+ 2
Add the following if there is a trigger event column:
+ number of trigger event columns[Figure] 2 + 1
Add the following if a trigger action condition is specified:
+ number of resource information items used in trigger action conditions[Figure] 2 + 1
Add the following if there are resources used by the trigger:
+ number of resources used[Figure] 2 + 1
Add the following if there are tables in the resources used:
+ number of tables used
Add the following if there are view tables in the resources used:
+ number of view tables used + number of utilized resources used in view tables used + 1
Add the following if there are indexes in the resources to be used:
+ number of indexes to be used + 1
Add the following if there are routines in the resources to be used:
+ number of routines used
Add the following if there are user-defined types in the resources to be used:
+ number of user-defined types to be used + 1
Add the following if parameters are specified:
+ number of parameters[Figure] 2 + 1
(b) For a HiRDB parallel server configuration (front-end server)

2

(c) For a HiRDB parallel server configuration (dictionary server)

17

Add the following if the executer is not the owner:
+ 2
Add the following if there is a trigger event column:
+ number of trigger event columns[Figure] 2 + 1
Add the following if a trigger action condition is specified:
+ number of resource information items used in trigger action conditions[Figure] 2 + 1
Add the following if there are resources used by the trigger:
+ number of resources used[Figure] 2 + 1
Add the following if there are tables in the resources used:
+ number of tables used
Add the following if there are view tables in the resources used:
+ number of view tables used + number of utilized resources used in view tables used + 1
Add the following if there are indexes in the resources to be used:
+ number of indexes to be used + 1
Add the following if there are routines in the resources to be used:
+ number of routines used
Add the following if there are user-defined types in the resources to be used:
+ number of user-defined types to be used + 1
Add the following if parameters are specified:
+ number of parameters[Figure] 2 + 1
(d) For a HiRDB parallel server configuration (back-end server)

1

(7) COMMENT

(a) For a HiRDB single server configuration

3

Add the following if the comment is a column:
+ 2
(b) For a HiRDB parallel server configuration (dictionary server)

3

Add the following if the comment is a column:
+ 2

(8) CREATE AUDIT

(a) For a HiRDB single server configuration

7

Add the following if objects are specified:
+ number of definitions of the objects in question
Add the following if objects are not specified:
+ number of definitions with no object specified
(b) For a HiRDB parallel server configuration (dictionary server)

7

Add the following if objects are specified:
+ number of definitions of the objects in question
Add the following if objects are not specified:
+ number of definitions with no object specified

(9) CREATE CONNECTION SECURITY

(a) For a HiRDB single server configuration

7 + number-of-users-registered-in-dictionary-table-SQL_USERS

(b) For a HiRDB parallel server configuration (front-end server)

1

(c) For a HiRDB parallel server configuration (dictionary server)

6 + number-of-users-registered-in-dictionary-table-SQL_USERS

(10) CREATE [PUBLIC] FUNCTION

(a) For a HiRDB single server configuration

number of locked resources in CREATE [PUBLIC]PROCEDURE + number of routines whose objects become invalid

Add the following if there are parameters:
+ number of parameters[Figure] 2
Add the following if a parameter includes a user-defined type:
+ number of user-defined types[Figure] 2
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
Also add the following if a routine that becomes invalid is used by a view table:
+ number of routines used by view tables that become invalid + 1 + number of routines used by view tables that become invalid [Figure]number of parameters + 1
(b) For a HiRDB parallel server configuration (front-end and back-end server)

number of locked resources in CREATE [PUBLIC]PROCEDURE + number of routines whose objects become invalid

(c) For a HiRDB parallel server configuration (dictionary server)

number of locked resources in CREATE [PUBLIC]PROCEDURE + number of routines whose objects become invalid

Add the following if there are parameters:
+ number of parameters[Figure] 2
Add the following if a parameter includes a user-defined type:
+ number of user-defined types[Figure] 2
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
Also add the following if a routine that becomes invalid is used by a view table:
+ number of routines used by view tables that become invalid + 1 + number of routines used by view tables that become invalid [Figure]number of parameters + 1

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

(a) For a HiRDB single server configuration#

20 + number of routines in which indexes become invalid + number of member columns[Figure] 4

Add the following if the indexes are not temporary table indexes:
+ 5 + 2 [Figure] number of RDAREAs for index
+ number of RDAREAs for index[Figure] 4
Add the following if there are routines that reference the table that defines the index:
+ number of routines that reference the table that defines the index[Figure] 4 + 2
Add the following if there are trigger action procedures that reference the table that defines the index:
+ number of trigger action procedures that reference the table that defines the index[Figure] 5
Add the following if there is more than one RDAREA for the index:
+ number of RDAREAs for the index[Figure] 3 + 1
Add the following if the index is a substructure index:
+ number of index member substructure paths[Figure] 3
Add the following if the inner replica facility is used and a LOB column or LOB attribute is defined in the table for which the index is defined:
+ number of RDAREAs for LOB columns + number of RDAREAs for LOB attributes
(b) For a HiRDB parallel server configuration (front-end server)

1 + number of routines in which the index becomes invalid

(c) For a HiRDB parallel server configuration (dictionary server)

19 + number of member columns[Figure] 4

Add the following if the indexes are not temporary table indexes:
+ number of RDAREAs for index[Figure] 4
Add the following if there are routines that reference the table that defines the index:
+ number of routines that reference the table that defines the index[Figure] 4 + 2
Add the following if there are trigger action procedures that reference the table that defines the index:
+ number of trigger action procedures that reference the table that defines the index[Figure] 5
Add the following if there is more than one RDAREA for the index:
+ number of RDAREAs for the index[Figure] 3 + 1 + number of routines in which the index becomes invalid
Add the following if the index is a substructure index:
+ number of index member substructure paths[Figure] 3
(d) For a HiRDB parallel server configuration (back-end server#) (non-temporary table indexes)

5 + number of RDAREAs for the index[Figure] 2 + number of routines in which the index becomes invalid

Add the following if the inner replica facility is used and a LOB column or LOB attribute is defined in the table for which the index is defined:
+ number of RDAREAs for LOB columns + number of RDAREAs for LOB attributes
(e) For a HiRDB parallel server configuration (back-end server) (temporary table indexes)

number of routines in which indexes become invalid

(f) For a HiRDB parallel server configuration (reference-only back-end server#)

2

#: If the inner replica facility is used, a number of lock requests equaling the number of generations is required.

(12) CREATE INDEX (plug-in index)

(a) For a HiRDB single server configuration#

21 + 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

Add the following if the inner replica facility is used and a LOB column or LOB attribute is defined in the table for which indexes are defined:
+ number of RDAREAs for LOB column + number of RDAREAs for LOB attribute
(b) For a HiRDB parallel server configuration (front-end server)

1 + number of routines in which indexes become invalid

(c) For a HiRDB parallel server configuration (dictionary server)

15 + 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

(d) For a HiRDB parallel server configuration (back-end server#)

5 + number of RDAREAs for index[Figure] 2 + number of routines in which indexes become invalid

Add the following if the inner replica facility is used and a LOB column or LOB attribute is defined in the table for which indexes are defined:
+ number of RDAREAs for LOB column + number of RDAREAs for LOB attribute

#: If the inner replica facility is used, a number of lock requests equaling the number of generations is required.

(13) CREATE [PUBLIC] PROCEDURE

(a) For a HiRDB single server configuration

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[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
(b) For a HiRDB parallel server configuration (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

(c) For a HiRDB parallel server configuration (dictionary server)

15

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

(14) CREATE SCHEMA

(a) For a HiRDB single server configuration

5

(b) For a HiRDB parallel server configuration (dictionary server)

5

(15) CREATE SEQUENCE

(a) For a HiRDB single server configuration
9 + 2
(b) For a HiRDB parallel server configuration (dictionary server)
9
(c) For a HiRDB parallel server configuration (back-end server)
2

(16) CREATE TABLE

(a) For a HiRDB single server configuration# (RDAREA for table is omitted and the table is not row-partitioned (including temporary tables))

20 + number of columns[Figure] 3

Add the following if the table is not a temporary table:
+ 9
+ number of public user RDAREAs[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:
+ 8
+ number of member columns[Figure] 3
Add the following if the table is not a temporary table:
+ 5
+ number of RDAREAs for index[Figure] 2
+ number of partitioned RDAREAs[Figure] 6
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
(b) For a HiRDB single server configuration# (RDAREA for table is specified and the table is not row-partitioned)

28 + 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 type 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
(c) For a HiRDB single server configuration# (row-partitioned table)

29 + 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 type 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
(d) For a HiRDB parallel server configuration (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
(e) For a HiRDB parallel server configuration (dictionary server) (RDAREA for table is omitted and the table is not row-partitioned (including temporary tables))

20 + number of columns[Figure] 3

Add the following if the table is not a temporary table:
+ number of public user RDAREAs[Figure] 3
+ number of LOB columns[Figure] number of partitioned RDAREAs[Figure] 4
Add the following if user-defined types are used:
+ number of user-defined types[Figure] 6
+ number of LOB attributes[Figure] number of partitioned RDAREAs[Figure] 4
+ number of user-defined type attributes[Figure] 2
+ 5
Add the following if cluster keys are defined:
+ 8 + number of member columns[Figure] 3
Add the following if the table is not a temporary table:
+ number of partitioned RDAREAs[Figure] 6
Add the following if referential constraint is defined:
+ number of foreign keys[Figure] 10
Add the following if CASCADE is defined for the referential constraint operation:
+ number of CASCADEs[Figure] 17
+ number of referenced tables specified by CASCADE[Figure] 4
Add the following if the specification of the 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
(f) For a HiRDB parallel server configuration (dictionary server, RDAREA for table is specified and the table is not row-partitioned)

25 + 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 type 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
(g) For a HiRDB parallel server configuration (dictionary server, row-partitioned table)
Add the following if 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 if 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
(h) For a HiRDB parallel server configuration (back-end server#) (non-temporary table)

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
(i) For a HiRDB parallel server configuration (back-end server) (temporary table)

0

(j) For a HiRDB parallel server configuration (reference-only back-end server)#

2

Add the following if a cluster key is defined:
+ 1

#: If the inner replica facility is used, a number of lock requests equaling the number of generations is required.

(17) CREATE TRIGGER

(a) For a HiRDB single server configuration

21 + 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
(b) For a HiRDB parallel server configuration (front-end server)

3 + number of routines in which objects become invalid

(c) For a HiRDB parallel server configuration (dictionary server)

18 + 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
(d) For a HiRDB parallel server configuration (back-end server)

number of routines in which objects become invalid

(18) CREATE TYPE

(a) For a HiRDB single server configuration

22 + number of routines that become invalid + number of attributes[Figure] 3

Add the following if there are user-defined types in the attributes:
+ (number of user-defined types[Figure] 6 + 2)
Add the following for subtype definitions:
+ 11
Add the following if there are routines that become invalid:
+ (number of routines that become invalid[Figure] 4 + 2 + number of resources of the routines that become invalid[Figure] 5 + 1)
Also add the following if a routine that becomes invalid is used by a view table:
+ number of routines used by view tables that become invalid + 1 + number of routines used by view tables that become invalid [Figure]number of parameters + 1
Add the following if a function or procedure is defined:
+ number of locked resources for function/procedure definitions#
(b) For a HiRDB parallel server configuration (front-end server)

1 + number of routines that become invalid

Add the following if a function or procedure is defined:
+ number of locked resources for function/procedure definitions #
(c) For a HiRDB parallel server configuration (dictionary server)

21 + number of attributes[Figure] 3

Add the following if there are user-defined types in the attributes:
+ (number of user-defined types[Figure] 6 + 2)
Add the following for subtype definitions:
+ 11
Add the following if there are routines that become invalid:
+ (number of routines that become invalid[Figure] 4 + 2 + number of resources of the routines that become invalid[Figure] 5 + 1)
Also add the following if a routine that becomes invalid is used by a view table:
+ number of routines used by view tables that become invalid + 1 + number of routines used by view tables that become invalid [Figure]number of parameters + 1
Add the following if a function or procedure is defined:
+ number of locked resources for function/procedure definitions #
(d) For a HiRDB parallel server configuration (back-end server)

number of routines that become invalid

#: Reference the lock request count of the function definition or the procedure definition.

(19) CREATE [PUBLIC] VIEW

(a) For a HiRDB single server configuration

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[Figure] 4 + number of tables that are the basis of the view table[Figure] 4 + number of SELECT statements preprocessing

Add the following if the table is a public view table:
+ 2
+ number of tables having the same name as the public view table[Figure] 2
+ number of view tables having the same name as the public view table[Figure] 2
(b) For a HiRDB parallel server configuration (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

(c) For a HiRDB parallel server configuration (dictionary server)

28 + number of columns[Figure] 4 + number of tables that are the basis of the view table[Figure] 4 + number of SELECT statements preprocessing

Add the following if the table is a public view table:
+ 2
+ number of tables having the same name as the public view table[Figure] 2
+ number of view tables having the same name as the public view table[Figure] 2

(20) DEALLOCATE MEMORY TABLE

For DEALLOCATE MEMORY TABLE, determine the value if you will be using a memory-resident database.

(a) For a HiRDB single server configuration

4 + number of indexes defined for the table

(b) For a HiRDB parallel server configuration (dictionary server)

4 + number of indexes defined for the table

(21) DROP AUDIT

(a) For a HiRDB single server configuration

7

Add the following if objects are specified:
+ number of definitions of the objects in question
Add the following if objects are not specified:
+ number of definitions with no object specified
(b) For a HiRDB parallel server configuration (dictionary server)

7

Add the following if objects are specified:
+ number of definitions of the objects in question
Add the following if objects are not specified:
+ number of definitions with no object specified

(22) DROP CONNECTION SECURITY

(a) For a HiRDB single server configuration

7 + number-of-users-registered-in-dictionary-table-SQL_USERS

(b) For a HiRDB parallel server configuration (front-end server)

1

(c) For a HiRDB parallel server configuration (dictionary server)

6 + number-of-users-registered-in-dictionary-table-SQL_USERS

(23) DROP DATA TYPE

(a) For a HiRDB single server configuration

26 + 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 the routines that become invalid[Figure] 5 + 1
Also add the following if a routine that becomes invalid is used by a view table:
+ number of routines used by view tables that become invalid + 1 + number of routines used by view tables that become invalid [Figure]number of parameters + 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 + 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
(b) For a HiRDB parallel server configuration (front-end server)
1 + number of routines that become invalid
(c) For a HiRDB parallel server configuration (dictionary server)

23 + number of attributes[Figure] 3 + number of routines whose 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 the routines that become invalid[Figure] 5 + 1
Also add the following if a routine that becomes invalid is used by a view table:
+ number of routines used by view tables that become invalid + 1 + number of routines used by view tables that become invalid [Figure]number of parameters + 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
(d) For a HiRDB parallel server configuration (back-end server)

number of routines whose objects become invalid

(24) DROP [PUBLIC] FUNCTION

(a) For a HiRDB single server configuration

Number of DROP [PUBLIC ]PROCEDURE locked resources

Add the following if there are parameters:
+ number of parameters[Figure] 2
Add the following if a parameter includes a user-defined type:
+ number of user-defined types[Figure] 2
Add the following if a trigger action condition is specified:
+ 15
Add the following if a routine that becomes invalid is used by a view table.
+ number of routines used by view tables that become invalid + 1 + number of routines used by view tables that become invalid [Figure]number of parameters + 1
(b) For a HiRDB parallel server configuration (front-end and back-end servers)

same as DROP [PUBLIC ]PROCEDURE

(c) For a HiRDB parallel server configuration (dictionary server)

number of locked resources in DROP [PUBLIC ]PROCEDURE

Add the following if there are parameters:
+ number of parameters[Figure] 2
Add the following if a parameter includes a user-defined type:
+ number of user-defined types[Figure] 2
Add the following if a trigger action condition is specified:
+ 15
Add the following if a routine that becomes invalid is used by a view table.
+ number of routines used by view tables that become invalid + 1 + number of routines used by view tables that become invalid [Figure]number of parameters + 1

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

(a) For a HiRDB single server configuration#

22 + number of routines in which objects or indexes become invalid + number of member columns[Figure] 3

Add the following if the indexes are not temporary table indexes:
+ number of RDAREAs for index[Figure] 7
+ number of index segments
Add the following if the indexes are temporary table indexes:
+ 3
Add the following if there are routines that become invalid:
+ number of routines that become invalid[Figure] 7 + 1
Add the following if there are trigger action procedures that reference the table that defines the index:
+ number of trigger action procedures that reference the table that defines the index[Figure] 5
Add the following if acquiring index optimization information:
+ 4
Add the following if the index is a substructure index:
+ number of index member substructure paths[Figure] 3
Add the following if the inner replica facility is used and LOB columns or LOB attributes are defined in the table for which the index is defined:
+ number of RDAREAs for LOB columns + number of RDAREAs for LOB attributes
Add the following if using the facility for predicting reorganization time:
+ number of RDAREAs for the index[Figure] 62 + 1
(b) For a HiRDB parallel server configuration (front-end server)

1 + number of routines in which objects or the index become invalid

(c) For a HiRDB parallel server configuration (dictionary server)

16 + number of member columns[Figure] 3 + number of routines in which objects or indexes become invalid

Add the following if the indexes are not temporary table indexes:
+ number of RDAREAs for index[Figure] 3
Add the following if there are routines that become invalid:
number of routines that become invalid[Figure] 7 + 1
Add the following if there are trigger action procedures that reference the table that defines the index:
+ number of trigger action procedures that reference the table that defines the index[Figure] 5
Add the following if acquiring index optimization information:
+ 4
Add the following if the index is a substructure index:
+ number of index member substructure paths[Figure] 3
Add the following if using the facility for predicting reorganization time:
+ number of RDAREAs for the index[Figure] 62 + 1
(d) For a HiRDB parallel server configuration (back-end server#) (non-temporary table indexes)

5 + number of RDAREAs for the index[Figure] 4 + number of index segments + number of routines in which objects or the index become invalid

Add the following if the inner replica facility is used and LOB columns or LOB attributes are defined in the table for which the index is defined:
+ number of RDAREAs for LOB columns + number of RDAREAs for LOB attributes
(e) For a HiRDB parallel server configuration (back-end server) (temporary table indexes)

number of routines in which objects or indexes become invalid

(f) For a HiRDB parallel server configuration (reference-only back-end server#)

2

#: If the inner replica facility is used, a number of lock requests equaling the number of generations is required.

(26) DROP INDEX (plug-in index)

(a) For a HiRDB single server configuration#

15 + 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 inner replica facility is used and a LOB column or LOB attribute is defined in the table for which indexes are defined:
+ number of RDAREAs for LOB column + number of RDAREAs for LOB attribute
Add the following if the facility for predicting reorganization time is used:
+ number of RDAREAs for index[Figure] 62 + 1
(b) For a HiRDB parallel server configuration (front-end server)

1 + number of routines in which objects or indexes become invalid

(c) For a HiRDB parallel server configuration (dictionary server)

9 + 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
(d) For a HiRDB parallel server configuration (back-end server#)

5 + number of RDAREAs storing the index[Figure] 4 + number of index segments + number of routines in which objects or indexes become invalid

Add the following if the inner replica facility is used and a LOB column or LOB attribute is defined in the table for which indexes are defined:
+ number of RDAREAs for LOB column + number of RDAREAs for LOB attribute

#: If the inner replica facility is used, a number of lock requests equaling the number of generations is required.

(27) DROP [PUBLIC] PROCEDURE

(a) For a HiRDB single server configuration#

19 + number of parameters[Figure] 5 + number of resources[Figure] 10 + number of routines in which objects become invalid

Add the following value if there are routines that become invalid:
+ number of routines that become invalid[Figure] 4 + 2 + number of resources for the routines that become invalid[Figure] 5 + 1
Add the following value if there are trigger action procedures in the routines that become invalid:
+ number of trigger action procedures[Figure] 5
(b) For a HiRDB parallel server configuration (front-end server)

1 + number of routines in which objects become invalid

(c) For a HiRDB parallel server configuration (dictionary server)

18 + number of parameters[Figure] 3 + number of resources[Figure] 10 + number of routines in which objects become invalid

Add the following value if there are routines that become invalid:
+ number of routines that become invalid[Figure] 4 + 2 + number of resources for the routines that become invalid[Figure] 5 + 1
Add the following if there are trigger action procedures in the routines that become invalid:
+ number of trigger action procedures[Figure] 5
(d) For a HiRDB parallel server configuration (back-end server)

number of routines in which objects become invalid

(28) DROP SCHEMA

(a) For a HiRDB single server configuration#1

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

Add the number of tables inside the schema that are to be deleted (when they are not matrix-partitioned tables).
+ [Figure] {number of RDAREAs storing the tables[Figure] 3 + number of specified partitioning conditions[Figure] 9 + number of columns[Figure] 4 + (number of LOB columns[Figure] 4) [Figure] number of RDAREAs storing the tables + 1 + 8} + 2
+ [Figure] (number of RDAREAs for table[Figure] 10
+ 10
+ number of table data segments being used)
Add the number of tables inside the schema that are to be deleted (when they are matrix-partitioned tables).
+ [Figure] {number of RDAREAs storing the tables[Figure] 3 + number of specified RDAREAs storing the tables (including overlapped ones)[Figure] 12 + number of columns[Figure] 4 + (number of LOB columns[Figure] 4) [Figure] number of RDAREAs storing the tables + 1 + 8 + number of privilege definitions for the tables to be deleted + number of partitioning keys[Figure] 2 + (number of specified storage conditions + 2) [Figure] 2 + 2} + 3
+ [Figure] (number of RDAREAs for table[Figure] 10
+ 10
+ number of table data segments being used)
Add the number of indexes inside the schema that are to be deleted.
+ 3 + [Figure] (number of RDAREAs for indexes[Figure] 7 + number of member columns[Figure] 3 + number of index member substructure paths[Figure] 3#2) + [Figure] (number of RDAREAs for the indexes[Figure] 8 + 10 + number of index segments being used) + 8
Add the following if 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 view tables[Figure] 4 + number of columns[Figure] 4)
Add the number of routines that use tables, view tables, routines, or data types inside the schema:
+ 3 + [Figure] (5 + number of resources in procedures[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 data types defined inside the schema#3
Add the following if there are trigger action procedures that reference tables to be deleted:
+ number of trigger action procedures that reference tables to be deleted[Figure] 5
Add the following if there are tables for which triggers are defined:
+ number of triggers defined inside the schema[Figure] 8 + total number of columns specified in the UPDATE trigger definition inside the schema[Figure] 3 + number of triggers that have trigger action conditions inside the schema[Figure] 3 + number of resource types referenced in the trigger action conditions inside 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 using the facility for predicting reorganization time:
+ [Figure] {(number of RDAREAs storing the tables + (number of LOB columns + number of LOB attributes) [Figure] number of table-storage RDAREAs) [Figure] 62} + [Figure] {(number of RDAREAs for indexes + (number of LOB columns + number of LOB attributes) [Figure] number of table-storage RDAREAs) [Figure] 62} + 1
Add the following if there are sequence generators inside the schema:
+ 2 + number of sequence generators inside the schema[Figure] 3 + number of sequence generators inside the schema[Figure] 2
(b) For a HiRDB parallel server configuration (front-end server)

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

(c) For a HiRDB parallel server configuration (dictionary server)

11 + number of indexes in other schemas

Add the number of tables inside the schema that are to be deleted (when they are not matrix-partitioned tables).
+ [Figure] {number of RDAREAs storing the tables[Figure] 3 + number of specified partitioning conditions[Figure] 9 + number of columns[Figure] 4 + (number of LOB columns[Figure] 4) [Figure] number of RDAREAs storing the tables + number of privilege definitions for the tables to be deleted[Figure] 3 + 6} + 11
Add the number of tables inside the schema that are to be deleted (when they are matrix-partitioned tables).
+ [Figure] {number of RDAREAs storing the tables[Figure] 3 + number of specified RDAREAs storing the tables (including overlapped ones)[Figure] 12 + number of columns[Figure] 4 + (number of LOB columns[Figure] 4) [Figure] number of RDAREAs storing the tables + number of privilege definitions for the tables 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 indexes inside the schema that are to be deleted.
+ 4 + [Figure] (number of RDAREAs for the indexes[Figure] 7 + number of member columns[Figure] 7 + number of index member substructure paths[Figure] 3#2) + number of indexes[Figure] 5
Add the following if optimization information is collected:
+ number of tables for which optimization information is collected[Figure] 2 + number of columns for which table 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] (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 number of routines that use tables, view tables, routines, or data types inside the schema:
+ 3 + [Figure] (5 + number of resources inside the procedure[Figure] 10 + number of defined parameters[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 for data types defined inside the schema#3
Add the following if there are trigger action procedures that reference tables to be deleted:
+ number of trigger action procedures that reference tables to be deleted[Figure] 5
Add the following if there are tables for which triggers are defined:
+ number of triggers defined inside the schema[Figure] 8 + total number of columns specified in the UPDATE trigger definition inside the schema[Figure] 3 + number of triggers that have trigger action conditions inside the schema[Figure] 3 + number of resource types referenced in the trigger action conditions inside 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 using the facility for predicting reorganization time:
+ [Figure] ((number of RDAREAs storing the tables + (number of LOB columns + number of LOB attributes) [Figure] number of table-storage RDAREAs) [Figure] 62) + [Figure] ((number of RDAREAs for indexes + (number of LOB columns + number of LOB attributes) [Figure] number of table-storage RDAREAs) [Figure] 62) + 1
Add the following if there are sequence generators inside the schema:
+ 2 + number of sequence generators inside the schema[Figure] 2
(d) For a HiRDB parallel server configuration (back-end server#1)

8 + number of routines whose objects or index objects become invalid

Add the following for non-temporary tables or non-temporary table indexes:
+ [Figure] (number of RDAREAs storing tables[Figure] 10 + 10 + number of table data segments being used)
+ [Figure] (number of RDAREAs for indexes[Figure] 8 + 10 + number of index segments being used)
Add the following if there is a sequence generator inside the schema:
+ number of sequence generators inside the schema[Figure] 2
(e) For a HiRDB parallel server configuration (reference-only back-end server#1)

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.

(29) DROP SEQUENCE

(a) For a HiRDB single server configuration

9 + 2

Add the following if there are routines that become invalid:
+ number of routines whose objects become invalid[Figure] 3 + 2
Add the following if triggers are defined:
+ number of trigger definitions[Figure] 2 + 2 + number of defined trigger event columns + 1 + number of parameters used by defined triggers + 1
(b) For a HiRDB parallel server configuration (front-end server)

1

Add the following if there are routines that become invalid:
+ number of routines whose objects become invalid
(c) For a HiRDB parallel server configuration (dictionary server)

8

Add the following if there are routines that become invalid:
+ number of routines whose objects become invalid[Figure] 2 + 2
Add the following if triggers are defined:
+ number of trigger definitions[Figure] 2 + 2 + number of defined trigger event columns + 1 + number of parameters used by defined triggers + 1
(d) For a HiRDB parallel server configuration (back-end server)

2

(30) DROP TABLE

(a) For a HiRDB single server configuration#1
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 columns[Figure] 4
Add the following if the table is not a temporary table:
+ 5
+ number of RDAREAs for table[Figure] 4
+ number of table data segments being used
+ number of RDAREAs for table[Figure] 3
+ number of specified partitioning conditions[Figure] 9
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 tables to be deleted + number of RDAREAs storing the table[Figure] 3 + number of RDAREAs storing the table (including overlapped ones)[Figure] 8 + number of columns[Figure] 4 + 5 + number of RDAREAs storing the 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 member columns[Figure] 3) + 3
Add the following if the indexes are not temporary table indexes:
+ [Figure] (number of RDAREAs for index[Figure] 2)
+ number of index segments being used
+ [Figure] {(number of RDAREAs for index[Figure] 7) + (number of paths making up the index component[Figure] 3)#2}
Add the following if LOB columns are defined:
+ (number of LOB columns[Figure] 4) [Figure] number of RDAREAs storing the table + 1
Add the following if 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 the view tables) + number of columns[Figure] 4} + 2
Add the following if there are routines that become invalid:
+ number of routines whose 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 table to be deleted:
+ number of trigger action procedures that reference the table to be deleted[Figure] 5
Add the following if user-defined type columns are defined:
+ number of user-defined type 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 trigger definitions[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] 64,000[Figure] + 1)#3
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 constraints
Also add the following if CASCADE is defined for the referential constraint operation:
+ number of CASCADEs[Figure] 17 + number of referenced tables specified by CASCADE[Figure] 4
Also add the following if the specification of the referential constraint operation is UPDATE ON CASCADE:
+ total number of primary key member columns of a 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 using the facility for predicting reorganization time:
+ {number of table-storage RDAREAs + number of RDAREAs for indexes + (number of LOB columns + number of LOB attributes) [Figure] number of table-storage RDAREAs} [Figure] 62 + 1
(b) For a HiRDB parallel server configuration (front-end server)

3 + number of view tables defined based on the table + number of routines that reference the table or view tables 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 constraints
(c) For a HiRDB parallel server configuration (dictionary server)
Add the following if the table is not a matrix-partitioned table:
21 + number of columns[Figure] 4
+ number of routines in which objects become invalid
Add the following if the table is not a temporary table:
+ number of RDAREAs for table[Figure] 3
+ number of specified partitioning conditions[Figure] 9
Add the following if the table is a matrix-partitioned table:
19 + number of RDAREAs storing the table[Figure] 3 + number of specified partitioning conditions[Figure] 9 + number of columns[Figure] 4 + number of routines whose objects become invalid
Add the following if indexes are defined:
+ [Figure] (number of member columns[Figure] 3) + 3
Add the following if the table is not a temporary table:
+ [Figure] {(number of RDAREAs for index[Figure] 7) + (number of paths making up the index component[Figure] 3#2)}
Add the following if LOB columns are defined:
+ (number of LOB columns[Figure] 4) [Figure] number of RDAREAs storing the table + 1
Add the following if 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 the 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 table to be deleted:
+ number of trigger action procedures that reference the table to be deleted[Figure] 5
Add the following if user-defined type columns are defined:
+ number of user-defined type 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 trigger definitions[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
Also add the following if CASCADE is defined for the referential constraint operation:
+ number of CASCADEs[Figure] 17 + number of referenced tables specified by CASCADE[Figure] 4
Also add the following if the specification of the referential constraint operation is UPDATE ON CASCADE:
+ total number of primary key member columns of the referenced tables 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 using the facility for predicting reorganization time:
+ {number of table-storage RDAREAs + number of RDAREAs for indexes + (number of LOB columns + number of LOB attributes) [Figure] number of table-storage RDAREAs} [Figure] 62 + 1
(d) For a HiRDB parallel server configuration (back-end server#1) (non-temporary table)

5 + number of RDAREAs storing the table[Figure] 4 + number of table data segments being used + number of routines whose objects become invalid

Add the following if indexes are defined:
+ [Figure] (number of RDAREAs for indexes[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] 64,000[Figure] + 1)#3
(e) For a HiRDB parallel server configuration (back-end server) (temporary table)

number of routines in which objects or indexes become invalid

(f) For a HiRDB parallel server configuration (reference-only back-end server#1)

2

Add the following if shared indexes are defined:
+ 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: Repeat and add this for the number of LOB RDAREAs.

(31) DROP TRIGGER

(a) For a HiRDB single server configuration

19 + 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
(b) For a HiRDB parallel server configuration (front-end server)

3 + number of routines in which objects become invalid

(c) For a HiRDB parallel server configuration (dictionary server)

16 + 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
(d) For a HiRDB parallel server configuration (back-end server)

number of routines in which objects become invalid

(32) DROP [PUBLIC] VIEW

(a) For a HiRDB single server configuration

10 + 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
Add the following if the table is a public view table:
+ 1
+ number of tables having the same name as the public view table
+ number of view tables having the same name as the public view table
(b) For a HiRDB parallel server configuration (front-end server)

number of view tables to be deleted + number of procedures that become invalid

(c) For a HiRDB parallel server configuration (dictionary server)

10 + [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
Add the following if the table is a public view table:
+ 1
+ number of tables having the same name as the public view table
+ number of view tables having the same name as the public view table
(d) For a HiRDB parallel server configuration (back-end server)

number of routines in which objects become invalid

(33) GRANT AUDIT

(a) For a HiRDB single server configuration

3

Add the following if using the password character restriction facility:
+ 2
(b) For a HiRDB parallel server configuration (dictionary server)
3
Add the following if using the password character restriction facility:
+ 2

(34) GRANT CONNECT

(a) For a HiRDB single server configuration

3 + number of specified users

Add the following if using the password character restriction facility:
+ 2
(b) For a HiRDB parallel server configuration (dictionary server)

3 + number of specified users

Add the following if using the password character restriction facility:
+ 2

(35) GRANT DBA

(a) For a HiRDB single server configuration

3 + number of specified users

Add the following if using the password character restriction facility:
+ 2
(b) For a HiRDB parallel server configuration (dictionary server)

3 + number of specified users

Add the following if using the password character restriction facility:
+ 2

(36) GRANT RDAREA

(a) For a HiRDB single server configuration

5 + number of specified users

Add the following if PUBLIC is specified:
+ number of specified RDAREAs
Add the following if there is a user specification:
+ number of specified RDAREAs[Figure] number of specified users
(b) For a HiRDB parallel server configuration (dictionary server)

5 + number of specified users

Add the following if PUBLIC is specified:
+ number of specified RDAREAs
Add the following if there is a user specification:
+ number of specified RDAREAs[Figure] number of specified users

(37) GRANT SCHEMA

(a) For a HiRDB single server configuration

3 + number of specified users

(b) For a HiRDB parallel server configuration (dictionary server)

3 + number of specified users

(38) GRANT access privileges

(a) For a HiRDB single server configuration

4 + number of specified users

(b) For a HiRDB parallel server configuration (dictionary server)

4 + number of specified users

(39) REVOKE CONNECT

(a) For a HiRDB single server configuration

3 + number of specified users

(b) For a HiRDB parallel server configuration (dictionary server)

3 + number of specified users

(40) REVOKE DBA

(a) For a HiRDB single server configuration

3 + number of specified users

(b) For a HiRDB parallel server configuration (dictionary server)

3 + number of specified users

(41) REVOKE RDAREA

(a) For a HiRDB single server configuration

10

Add the following if PUBLIC is specified:
+ number of specified RDAREAs
Add the following if there is a user specification:
+ number of specified RDAREAs[Figure] number of specified users
(b) For a HiRDB parallel server configuration (dictionary server)

10

Add the following if PUBLIC is specified:
+ number of specified RDAREAs
Add the following if there is a user specification:
+ number of specified RDAREAs[Figure] number of specified users

(42) REVOKE SCHEMA

(a) For a HiRDB single server configuration

5 + number of specified users

(b) For a HiRDB parallel server configuration (dictionary server)

5 + number of specified users

(43) REVOKE access privileges

(a) For a HiRDB single server configuration

7 + number of specified users

Add the following if there are routines that become invalid:
+ number of routines that become invalid[Figure] 2 + 1
Add the following if there are view tables defined based on tables:
+ number of single server locked resources of DROP [PUBLIC ]VIEW
(b) For a HiRDB parallel server configuration (front-end server)

1

Add the following if there are routines that become invalid:
+ number of routines that become invalid
Add the following if there are view tables defined based on tables:
+ number of front-end server locked resources of DROP [PUBLIC ]VIEW
(c) For a HiRDB parallel server configuration (dictionary server)

6 + number of specified users

Add the following if there are routines that become invalid:
+ number of routines that become invalid[Figure] 2 + 1
Add the following if there are view tables defined based on tables:
+ number of dictionary server locked resources of DROP [PUBLIC ]VIEW
(d) For a HiRDB parallel server configuration (back-end server)

0

Add the following if there are routines that become invalid:
+ number of routines that become invalid
Add the following if there are view tables defined based on tables:
+ number of back-end server locked resources of DROP [PUBLIC ]VIEW