capManExtract -utility for extracting data from Capacity Manager. CA Technologies Engineering Services @ 2014
Version tested with: Java(TM) SE Runtime Environment (build 1.7.0_55-b13) 64-bit
1. Extract Extractor.zip to any folder
3. There are three files, capManExtract.jar and capManExtract.bat, and the queries.xml
4. Open the capManExtract.bat for edit, and modify the connect information in double quotes
java -Xms54m -Xmx128m -jar capManExtract.jar "DB IP Address" "DB Username" "DB Password" "DB Instance name" "DB Port" "DB Type"
Supported DB Types are "SQL Server" and "Oracle". Note that this is case sensitive.
5. Open command prompt and rum 'capManExtract.bat'
C:\AASoftware\CapMan\Extractor>capManExtract.bat
C:\AASoftware\CapMan\Extractor>java -Xms54m -Xmx128m -jar capManExtract.jar "ITCAPA1" usr" "pwd" "SQLVSphere5" "1433" "SQL Server"
6. Any errors are displayed in the command line. If you wish a separate output.log -file for the errors, modify the capManExtract.bat to contain the following
java -Xms54m -Xmx128m -jar capManExtract.jar "MSSQL IP Address" "MSSQL Username" "MSSQL Password" "SQLVSphere5" "1433" > output.log
7. The command will print output for each query in c:\cap -folder.
8. Queries in the 'queries.xml' can be modified