Cancel
Showing results for 
Search instead for 
Did you mean: 

automating analyze schema in the Technomatix Admin Console

Experimenter
Experimenter

Hello, I am looking for away for me to automate the analyze schema in the Technomatix Admin Console. I have to run this every day right now I do it maunally during lunchafter getting users out

but i would like to be able to run this at night when no one is here. is there any scripts or command line .bat files?  Your help would be apprciated thanks 

2 REPLIES

Re: automating analyze schema in the Technomatix Admin Console

Siemens Valued Contributor Siemens Valued Contributor
Siemens Valued Contributor

Hi.

 

This information is available as a Solution article in GTAC:

 

These steps in AdminConsole:

1. RUN "REFRESH SCHEMA" UNDER SOFTWARE DEPLOYMENT
2. RUN "RESET ADVANCE QUEUE" UNDER SCHEMA ACTIONS
3. RUN "ANALYZE SCHEMA" UNDER SCHEMA ACTIONS

Can be automated by running the following commands in the following order in batch on the eM-Server:

DbUserAdmin -refreshschema -- -svr XXXXX -usr YYYYY -usrpswd ZZZZZ

DbUserAdmin -initAQ -- -svr XXXXX -schemaOwner YYYYY -schemaOwnerPswd ZZZZZ -aqUsr YYYYY_aq -aqPswd ZZZZZ

DbUserAdmin -refreshAccessUser -- -svr XXXXX -schemaOwner YYYYY -schemaOwnerPswd ZZZZZ -AccessUser YYYYY_EA -AccessUserPswd ZZZZZ

sqlplus YYYYY/ZZZZZ@XXXXXX @analyze_db.sql

(Replace all XXX, YYY, ZZZ with the relevant values)...


All user logins must be disabled during this process.

Disable login-->eMServerCMD.exe administrator n 0 disable_login_all

Enable login-->eMServerCMD.exe administrator n 0 enable_login_all

Re: automating analyze schema in the Technomatix Admin Console

Experimenter
Experimenter

Thanks Ray this will be a great help