ME

i need to know the script of  DB reorganisation on windows server platform as i want to schedule a job to automatically run it on daily basis.

thanks,

Mona

by Jens Heylmann
Posted on Fri, 03/01/2013 - 10:58

To automatically start a reorganization of an ARIS Database you can schedule the following windows batch file:

reorg.bat

Set the Database-Admin and Site-Admin password in the script!

@echo off Set DBADMIN=DBADMIN Set SITEADMIN=SITEADMIN ArisAdm72.exe -l reorg.log -s localhost -pa "%SITEADMIN%" -p "%DBADMIN%" reorg "%1"

Call the batch with the database name in the "JavaClient" directory e.g.  

 

Regards,

Jens

0
by Mona Essam Author
Posted on Tue, 03/12/2013 - 17:25

Hi Jens,

thank you for your reply, but i need further assistance please.. i am usually creating my scripts inside ARIS Business Architect for SAP 7.1

In the scripts tab and using cfg and bat file where the bat file just call the cfg file so in this case where should i write your script :

{

@echo off

Set DBADMIN=DBADMIN

Set SITEADMIN=SITEADMIN

ArisAdm72.exe -l reorg.log -s localhost -pa "%SITEADMIN%" -p "%DBADMIN%" reorg "%1"

}

beside that i have a lots of database where am going to mention which database should be re-organized?? and what i should write in the cfg file??

sorry for the tooo many questions :S but am still a beginner and need support.

thanks,

Mona

0
by Jens Heylmann
Posted on Wed, 03/13/2013 - 09:04

Hi Mona,

you can not start a reorg automatically  within ARIS Architect / ARIS script.

You have to call the ARIS Admin Tool via the batch script I've posted before. 

The sceenshot is an example how to call the batch script.

  1. Create a new file within ARIS Client directory and copy the script into this file. 
  2. Change the passwords for DBADMIN and SITEADMIN if you are using not the default.
  3. Start the script by calling the batchfile and with the ARIS database name for the database you want to reorganize.

Regards,

Jens

0
by France Nkoe
Posted on Fri, 03/15/2013 - 12:08

Afternoon all,

Sorry to highjack the topic. I have a crisis and seem to have lost everything.

I was trying to add more modules on my installation and ran the installation file. While it was confirming to remove everything and creating a backup, i cancelled the operation.

Now my databases are no longer visible and I can't seem to get them. I can find the aris.db, aris.props and aris.log which were created duting the operation. The log file has a list of my original databases.

How can i get my databases back? PLEASE HELP!

0
by Mona Essam Author
Posted on Wed, 04/10/2013 - 14:44

Dear jens,

could u please provide an example on how to Call the batch with the database name in the "JavaClient" directory as i can not view the attached screenshot

 

thanks,

Mona

0
by Jens Heylmann
Posted on Fri, 04/12/2013 - 10:24

Hello Mona,

if the batch file is in the ARIS JAVA Client directory e.g. "C:\Programm Files\ARIS7.2\JavaClient" you can call the batch for example like this:

reorg "DemoDB-United motors Group"

This will reorganize the ARIS database "DemoDB-United motors Group"

Hope this helps?

 

Regards,

Jens

0
by Mona Essam Author
Posted on Thu, 04/18/2013 - 14:27

Jens...Thanks a millioooooooooooooooooooon i do really appreciate your help in this issue..i have applied your solution and it worked.

thanks a lot :) i owe u

 

0

Featured achievement

Question Solver
Share your expertise and have your answer accepted as best reply.
Recent Unlocks
  • BZ
  • Profile picture for user TEF_Bernd
  • ПЦ
  • CR
  • BH
  • PacMan

Leaderboard

|
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock