I have all my essbase application in D: drive. I need to copy some ASO applications to E: Drive under (essbase\AnalyticServices\APP) with diffent name and provision some users to the copied backup databse databse. Since our D drive is full it is just like creating a copy of the existing app with some other location. Refresh needs to happened every night. please suggest how to copy entire application to diiferent drive?
As far as I know (please correct me if I'm wrong) you cannot specify an alternate path where to store the application when copying the cube.
But what you could do is specify another location for the data files. For that you could use the alter tablespace statement of MaxL.
For details (11.1.1.x) see:
I have tried the table space option too. But, I after restarting the application it is just creating a folder with application name in the alternate path with inside empty folder default. I didn't under stand clearly how could it work. Can i push the database inside to this newly created folder?
I have tried the option alter system set eas_loc 'alternatepath'; also. this statement is executing successfully but after that also copy application is creating in regular folder only. I think some needs to change the application storage settings.
The folder structure and certain files will always exist on the drive where Essbase was installed for both ASO and BSO. For example, the database directory that contains the outline and load rules. If you change the tablespaces for the data and the temp space, it means the new location will be used for those. If you do an application copy from EAS, there is no way to specify the new location for those files during the copy. IT would copy them to the Essbase path, you would then need to change them and reload the data
I think this will not work.
Changing the tablespace would mean that you would have to add new one and remove current one. Than as stated by Glenn already you have to completely reload the data.
However what you could try is a filesystem copy of the old tablespace files on the drive to the new one - may be this will work as well so you wouldn't have to completely reload all data.
So I would try:
- Copy application using MaxL
- Add tablespace for new drive
- copy files of old tablespace to new one
- delete old tablespace
- reload app and test if data is still there
As I don't know if it will work, please don't test this on a productive system.
I hope copy table space files will not work. Since, I need the entire process to be automated. We can't copy files trough Maxl. I have tried changing the table space and loading the data in copy application. It is storying dat files in copy application.
I think there is no option to copy entire database to newlocation with all the scripts and databse folder. any way I am proceed with changing table space. Hope so client will accept this.
in your batch or shell script look for the existance of the application directory in the under the app directory in the arborpath. If it exists don't run the MaxL.
If it is windows look for the if exists command