The customer's Tecnomatix Database was bounced every Saturday, followed by an Analyze job. They manually run Refresh Schema once a month, or if needed biweekly. They would like to automate the steps, and have the following questions:
1) What is the recommended sequence? Should Refresh Schema be run, followed by Analyze?
2) What's the frequency recommended for Refresh and Analyze schema?
Solution
1. Refresh, followed by Analyze.
2. Use the Frequency described in the Tecnomatix System Maintenance Guide, Chapter 6.
https://support.industrysoftware.automation.siemens.com/docs/tecnomatix_mechanical/planning_simulation/Tecnomatix_System_Maintenance_Guide.pdf
These are the scripts for use on Linux database system:
Refresh schema
--------------
There is a stored procedure which can be created in the DB and later scheduled as a database job.
The stored procedure, as well as examples are located in the following file:
%Program Files%\Tecnomatix\eMPower\DBScripts\refresh_schema_proc.sql
This script also performs Reset Advanced Queue.
It is important to add that in order for the script to perform actual actions there should be no open connections from eMServer and eMSAgent, otherwise the stored procedure will not run.
Analyze schema
--------------
Regarding Analyze Schema, the customer can take a look at the following file:
%Program Files%\Tecnomatix\eMPower\DBScripts\analyze_db.sql
Usually we schedule a database job to execute this gathering stats stored procedure overnight.
Notes and References
Hardware/Software Configuration
Platform: INTL64
OS: suse
OS Version: sles10
Product: TECNOMATIX
Application: EM-SERVER
Version: V_UNKNOWN
Function: DATABASE
Ref: 001-7717795