Performance Tuning Process Description thru a bat using mxl scripts:
- Process steps of “Name_as_desire.bat”
- The batch will run the “Name_as_desire.mxl” this will export the data of the cube at level 0.
- The batch will run the another batch “Name_as_desire.bat” if the export runs correctly, then this batch will be excecuted.
- The batch will run the “Name_as_desire.mxl” this will defrag the application and import the data, and will execute 3 calcscripts that will......
Code at the first batch
1. Variables configuration that will be used at the rest of the code:
- Server- Server IP.
- Application - Application name.
- Data Base – Database name.
- User – User name to log in.
- Password – User password to log in.
- Export – Path where will be save the export data file.
- Script – Path where will be save the scripts that will be executed by the batch process.
- Log – Path where will be save the log files.
- Temp – Path where will be save the temp files used by the process.
2. Register at log details of last execution :
- Hostname.
- Date.
- Time.
- Time am/pm.
3. Erase temp files and ancient logs:
From the path previously configure at the variables.
4. Set the header log:
- Server.
- Aplication
- Date.
- Start Time.
5. Erase ancient exported files.
From the path previously configure at the variables.
6. Export process.
- Configure start date, hour with meridian nomenclature of the export process that will register in the log file.
- Give the instruction to execute the mxl “LAPnL01DefragExport.mxl”
- Configure ending date, hour with meridian nomenclature of the export process that will register in the log file.
7. Import file creation.
- Configure start date, hour with meridian nomenclature of the import file creation process that will register in the log file.
- Borra el archivo LAPnL01Defrag_Detail.log from the path previously set at the variables.
- Configure ending date, hour with meridian nomenclature of the import file creation process that will register in the log file.
- Configure start date, hour with meridian nomenclature of the import file creation process that will register in the LAPnL01DefragImport.ess file.
- Delete ancient “LAPnL01DefragImport.ess” files from the path previously configure at the variables.
- Instruction to execute the bat process “BuildImportFiles.bat” with the instruction to generate the log file “LAPnL01Defrag_Detail.log” recording on it the start date and hour.
- Configure ending date, hour with meridian nomenclature of the import file creation process that will register in the LAPnL01DefragImport.ess file.
8. Import process.
- Configure start date, hour with meridian nomenclature of the import process that will register in the log file.
- Instructuon to execute the mxl “LAPnL01DefragImport.mxl”
- Configure ending date, hour with meridian nomenclature of the import process that will register in the log file
9. Instruction to record scripts duration and names at the log file.
Instruction to record scripts duration and names at the log file.
10. Record at the end of the log file a resume of the statistics of the process execution.
Instruction to record at the end of the log file, the date, time and duration of the whole batch process execution.
11. Historic file creation.
Is an instruction to create a file to record the dates, time and duration of each time that this batch is executed.
Process requested to be executed by the Batch “LAPnL01Defrag.bat”
The batch process explained before request the execution of these 3 processes:
“LAPnL01DefragExport.mxl”
“BuildImportFiles.bat”
“LAPnL01DefragImport.mxl”
1.- Connects to the application and database, according to the parameters configured at the batch “LAPnL01Degrag.bat”
2.- Creates a log file to record errors and statistics of the execution, specifying the path and name, then log out all the users, and record to insert the statistics of dimensions and data blocks.
3.- Run the instruction to start the application and database and runs an export of the data at level zero to a text file, and set the path where it will be extracted.
4.- Then configures that if the process generates an error gives the instruction to end the process and start the application and database.
5.- I has been set a cleardata thru the mxl command “reset” .
6.- Instruction to execute the calcscript CLRPnL and then logout.
Next Steps
1.- Configures the variables for the accesses and paths for the rest of the code:
- Path.
- Server.
- User.
- Password.
- Application.
- Data Base.
- DirExport – Where will be placed the exported files.
- DirScript – Where are placed the scripts that will run the batch.
- DirLog – Where will be placed the log files.
- DirTemp – Where will be placed the temp files, used by the process.
2.- Mention that the next files should exist at the specified path:
- E:\Scripts\Defrag\LAPnL01\LAPnL01DefragImport.Mxl1.txt
- E:\Scripts\Defrag\LAPnL01\LAPnL01DefragImport.Mxl2.txt
3.- Construction process of the file that will be imported:
Next Steps
1.- Connects to the application and data base according to the parameters set at the batch “LAPnL01Degrag.bat”
2.- Generates a log file to record errors and outputs specifying the name and path.
3.- Instruction to import the local file specifying the path and name, and if fan error occurs, ask to abort the process.
4.- Instruction to execute the next calculation scripts:
PartDF15 Roll Up FY15
PartDF14 Roll Up FY14
PartDF13 Roll Up FY13
PartDF12 Roll Up FY12
PartDF11 Roll Up FY11
PartDF10 Roll Up FY10
5.- Instruction to insert the dimension and data blocks statistics at the log file, then exit the application and start again the application and database in case of error , is requested to insert at the log file “Error”, specifying the path and name, then to logout.
Disclaimer - Views expressed in this blog are author's own and do not necessarily represents the policies of aclnz.com