You can include database objects for any backup, restore, or analyze_validate job by specifying an object under objectlist in the XML file containing the job definition.
- Open the XML file containing the job definition information.
- Under objectlist, specify:
Option Description objectinfo Contains the information on all objects for the job. object_name The name of the object. The name can have a maximum of 128 characters. object_type The type of object. The accepted values are: - AGGREGATE_FUNCTION
- AUTHORIZATION
- COMBINED_AGGREGATE_FUNCTIONS
- CONTRACT_FUNCTION
- DATABASE
- EXTERNAL_PROCEDURE
- FUNCTION_ALIAS [Analytics Database 16.20 Feature Update 1]
- GLOP_SET
- HASH_INDEX
- INSTANCE_OR_CONSTRUCTOR_METHOD
- JAR
- JOIN_INDEX
- MACRO
- NO_PI_TABLE
- ORDERED_ANALYTICAL_FUNCTION
- QUEUE_TABLE
- SERVER_OBJECT
- STANDARD_FUNCTION
- STATISTICAL_FUNCTION
- STORED_PROCEDURE
- TABLE
- TABLE_FUNCTION
- TABLE_OPERATOR
- TRIGGER
- USER
- USER_DEFINED_METHOD
- USER_DEFINED_DATA_TYPE
- USER_INSTALLED_FILE
- VIEW
parent_name The name of the object parent. The name can have a maximum of 128 characters. All objects other than databases and users are required to have a parent name.parent_type [Optional] The type of parent. The accepted values are: - DATABASE
- USER
The following XML sample file excerpt shows how to include the VIEW1 object in the DB1 database.<objectlist> <objectinfo> <object_name>VIEW1</object_name> <object_type>VIEW</object_type> <parent_name>DB1</parent_name> <parent_type>DATABASE</parent_type> </objectinfo>