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
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
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
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.
- Create a new file within ARIS Client directory and copy the script into this file.
- Change the passwords for DBADMIN and SITEADMIN if you are using not the default.
- Start the script by calling the batchfile and with the ARIS database name for the database you want to reorganize.
Regards,
Jens
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!
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