Showing results for 
Search instead for 
Do you mean 
Reply

automating analyze schema in the Technomatix Admin Console

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 

1 REPLY

Re: automating analyze schema in the Technomatix Admin Console

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