Scripts

The $EDS_HOME/dbUtil on UNIX or the %EDS_HOME%\dbUtil directory on Windows contain these scripts, which enable you to accomplish a variety of database tasks. 

Do not run other scripts present in the preceding directories as they are internal scripts, and is called from other main scripts.

This table describes the purpose of the scripts:

Name

Purpose

add_dashboard_data.sh

Adds Dashboard Author data to an CES database.

add_number_of_notes_ attachments_in_custom_ configs.sql

Adds properties for the number of notes and attachments to custom configurations.

attach_notes_update.sh

Adds notes and attachments icons and properties to classes and items and maintain the count of how many exist.

cascade_evvs.sql

Performs the cascading of enumerated valid values.

cascade_rvvs.sql

Cascades the range valid values to the bottom class.

check_clp_ldd_data.sql

Identifies logical data types that are not defined but are used by Class Properties.

compile_views.sql

Restores the corrupted views in CES.

create_index_on_bottom_class_ id.sql

Creates an index for the Bottom Class ID property for each item in the database.

delete_act_not_classes.sql

Removes Activation, Activation to User Group, Activation to User Link, and Notice classes.

delete_blb_not_dep_classes.sql

Removes the unused classes such as Department, Binary Large Objects, Notice.

delete_cf_evv_rvv.sql

Deletes custom functions from the database that were not implemented in the CES custom function libraries.

delete_duplicate_evvs.sql

Deletes duplicate EVVs from EVV table.

delete_gco_goe_uoe_classes.sql

Removes obsolete classes S_GCO_CLASS, S_GOE_CLASS, S_UOE_CLASS.

delete_orphan_classes.sql

Deletes all orphan classes from the database.

delete_orphan_config_objects.sql

Deletes all orphan configuration objects in Search, Result and Configuration included classes.

delete_orphan_objects.sql

Deletes the orphan objects from all the classes except the Root class which do not have their corresponding objects in the Root class.

delsmon.sql

Deletes items from the License Monitor class for the specified period.

delete_uem_class.sql

Deletes the obsolete class User Extensible Menu, its related configuration and meta-model objects.

estimate_tablesize.sh

Estimates the database size on UNIX.

estimate_tablesize.sql

Estimates the database size on Windows.

increase_email_length.sql

Increases the size of the email address.

initialize_create_date_user.sql

Initializes Create Data and Create User properties in the Root class with input provided by user if Create User is Null.

insert_objects.sql

Populates the classes in the middle hierarchy with obj_id, obj_type, and class_id from objects in each of the bottom classes.

report_child_classes.sql

Identifies and reports child classes under a given class label.

report_orphan_classes.sql

Identifies and reports all orphan classes in the CES system.

rollup_max_objects.sql

Rolls up the value of s_cls_max_objects of bottom classes in their parents.

S_DELETE_DETDEF_CONFIG_ PR.sql

Deletes all DEFAULT and DETAIL configurations in CES.

set_evv_cascade.sql

For the given parent class, sets the EVV class, Cascade Flag property to Yes in all child classes.

upd_all_att_note_count.sh

Updates the S_ROT_CLASS rot_att_count and s_rot_note_count for all the objects.

upd_cls_att_count.sh

Updates the S_CLS_TABLEs cls_att_count to the number of attachments associated with every class.

upd_obj_att_note_count.sh

Updates the S_ROT_TABLEs rot_att_count and s_rot_note_count for a given class.

set_rvv_cascade.sql

Updates the RVV cascade flag from False to True.