POM_timestamp maintenance

The POM_timestamp table records the time of an object’s most recent modification. The POM_timestamp table holds time stamps until manually cleared. To avoid an overly large POM_timestamp table and any related performance issues, Siemens Digital Industries Software recommends that you provide periodic maintenance of the POM_timestamp table. Do so by running the following command on a periodic basis: Copy install -tidy_timestamps -u=user -p=password -g=group Consider setting up a timed job that executes the previous command from within the Teamcenter environment. Use the following commands to manage the maintenance of the POM_timestamp table. To enable manual mode: Copy install -set_pom_param -u=user -p=password -g=group TC_TIMESTAMP_TIDY_MODE manual To perform manual maintenance on the POM_timestamp table (nightly or as appropriate): Copy install -tidy_timestamps -u=user -p=password -g=group To disable manual mode, remove the manual parameter configuration: Copy install -set_pom_param -u=user -p=password -g=group TC_TIMESTAMP_TIDY_MODE To view the current configuration: Copy install -ask_pom_param -u=user -p=password -g=group TC_TIMESTAMP_TIDY_MODE Note If a configuration is not displayed then the default configuration (automatic mode) is in effect. To adjust the time stamp threshold value: Copy install -set_pom_param -u=user -p=password -g=group TC_TIMESTAMP_THRESHOLD hours hours must be an integer.