Object type | Exclude tables during archive | Exclude tables during restore | Exclude tables during copy |
---|---|---|---|
Table | yes | yes | yes |
CP Table | yes | yes | yes |
PPI Table | yes | yes | yes |
NOPI Table | yes | yes | yes |
Journal Table | no | no | no |
Queue Table | yes | yes | yes |
View | no | yes | yes |
Macro | no | yes | yes |
Trigger | no | yes | yes |
User-Defined Type (UDT) | no | no a | no b |
Glop | no | yes | yes |
Stored Procedures | yes | yes | yes |
External Stored Procedures | yes | yes | yes |
Java (JAR) procedure | yes | yes | yes |
Join Index | yes b | yes a | yes a |
Hash Index | yes a | yes a | yes a |
Authorization Function | no | yes | yes |
Standard (Scalar) Function (with data) | yes | yes | yes |
Standard (Scalar) Function (without data) | no | yes | yes |
Aggregate Function (with data) | yes | yes | yes |
Aggregate Function (without data) | no | yes | yes |
Statistical Function (with data) | yes | yes | yes |
Statistical Function (without data) | no | yes | yes |
AggrStat Function (with data) | yes | yes | yes |
AggrStat Function (without data) | no | yes | yes |
Table Function (with data) | yes | yes | yes |
Table Function (without data) | no | yes | yes |
Instant or Constructor Method (with data) | yes | no b | no b |
Instant or Constructor Method (without data) | no | no b | no b |
Parser Contract Function (with data) | yes | yes | yes |
Parser Contract Function (without data) | no | yes | yes |
Table Function (Operator) (with data) | yes | yes | yes |
Table Function (Operator) (without data) | no | yes | yes |
User Installed File (UIF) | yes | yes | yes |
Remote Server (without data) | no | yes | yes |
Schema (without data) | no | yes | yes |
Function Alias (without data) | no | yes | yes |
a. The EXCLUDE TABLES clause can not be applied to SYSUDTLIB nor UDTs/UDMs. This is because UDTs/UDMs are stored in the SYSUDTLIB database and a restore/copy of SYSUDTLIB is not allowed b. Do not specify these objects in the exclusion list, use SKIP JOIN INDEX instead. |