Lars4
3 Silver

Import BTP files into SPA, Is that possible!

Jump to solution

Is there any way to import old performance data into SPA?

I'm "always" copying all our BTP file to my local drive where I can start Performance Manager and analyze data really quickly, So now when we are starting to use SPA I was thinking if there was anyway to populate SPA with old performance data....

/Lars

0 Kudos
1 Solution

Accepted Solutions
dynamox
7 Thorium

Re: Import BTP files into SPA, Is that possible!

Jump to solution

highly unlikely. SPA uses mySQL database and BTP is a binary file. Maybe you can figure out which tables in the mySQL database correspond to fields in a ttp file and import that data.

View solution in original post

0 Kudos
14 Replies
dynamox
7 Thorium

Re: Import BTP files into SPA, Is that possible!

Jump to solution

highly unlikely. SPA uses mySQL database and BTP is a binary file. Maybe you can figure out which tables in the mySQL database correspond to fields in a ttp file and import that data.

View solution in original post

0 Kudos
Lars4
3 Silver

Re: Import BTP files into SPA, Is that possible!

Jump to solution

I was hoping that some EMC'er would have built a import routine for this 🙂

0 Kudos
jb1980
2 Bronze

Re: Import BTP files into SPA, Is that possible!

Jump to solution

Hi Dynamox, so if btp is mysql binary file it should be decoded into readable format ?

Thanks

0 Kudos
Anonymous
Not applicable

Re: Import BTP files into SPA, Is that possible!

Jump to solution

Lars,  Dynamox is correct.  SPA does not understand .btp files.  I wish it did too or at least provided some files that could be dowloaded and worked offline.

Lars4
3 Silver

Re: Import BTP files into SPA, Is that possible!

Jump to solution

....

I might try to find out the structure of the mySQL DB... and  write an import routine from BTP to the mySQL.... But time and  knowledge might be an issue... 🙂

Is there a standard connection name and password for the SPA DB (a jdbc connection URL 🙂 ?

e.g. .... jdbc:mysql://localhost:3306/database

I use Crystal Reports for Eclipse quite much for reporting from StorageScope, DPA and custom DB's... would like to find out the mySQL DB structure to se if any useful reports might be built 🙂

Any way need to tackle the time issues, there is so many things that are fun and so little time 🙂

0 Kudos
Anonymous
Not applicable

Re: Import BTP files into SPA, Is that possible!

Jump to solution

Sorry Lars, I do not have an answer to your question, and would not even know who to contact for this information.  Hopefully someone else can provide some insight.

0 Kudos
the_san_man
2 Iron

Re: Import BTP files into SPA, Is that possible!

Jump to solution

On page 7 in the Tools section of the Symmetrix Performance Workshop Student Guide, it reads:

"If you add Symmetrix Performance Analyzer to an environment that already contains
Performance Manager, you can import the older Performance Manager to preserve the history of
your existing arrays. The data will be read from Performance Manager’s BTP files into the
Symmetrix Performance Analyzer MySQL database. Once you import the old archives, you
should configure Symmetrix Performance Analyzer to collect its own data on the existing arrays
so that data will be updated automatically.

You can only import archives from arrays that have already been discovered by Symmetrix
Performance Analyzer. In other words, the Symmetrix ID in the BTP file must match an array
already in Symmetrix Performance Analyzer. When read, the large number of Performance
Manager metrics will be reduced to just the key performance indicators that Symmetrix
Performance Analyzer records."

That is the only reference to this that I can find.  I am scheduled for this class on Monday and I will see what the instructor says about it and let you know.

Lars4
3 Silver

Re: Import BTP files into SPA, Is that possible!

Jump to solution

🙂 .... now I'm happy ... need to se if it's still there in 2.x.. than's "the_san_man" for triggering me to look deeper!

From SPA Installation Guide 1.0 pn 300-007-397 ....

--- cut ---

The SPA Metric Import Tool (SMIT) is a Symmetrix Performance
Analyzer CLI application used to extract metric data from ECC
Performance Manager daily files, convert them to Key Performance
Indicators (KPIs) and store them in the SPA database.

The SMIT application is intended as a resource to jump start a new
SPA installation by using pre-existing customer performance data in
BTP format to populate the SPA database using the existing SPA
server functionality.

--- paste ---

/Lars

0 Kudos
Lars4
3 Silver

Re: Import BTP files into SPA, Is that possible!

Jump to solution

Well half way there BUT....

  1. I don't belief that the jar file called smit.jar can handle V-MAX as it "bails out" ~indicating 8G, and as the FA "G" is unique to V-MAX my simple conclusion is that smit.jar is only built for DMX'es
  2. The export workes fine for DMX I used this command:
    C:\WLA>java -Xms256M -Xmx768M -jar smit.jar EXPORT ..\Archive\Symmetrix\000290101917 -symmids 000290101917 -out c:\wla
  3. The import command failed (after a wile), sorry i lost the log of that...:
    X:\000290101917>D:\"Program Files"\EMC\SPA\litewave\jre\bin\java -Xms256M -Xmx768M -jar ..\smit.jar IMPORT -symmids 000290300232 -dir x:\000290101917

The IMPORT did not result in more data showing up in SPA 😞 and I don't known if the IMPORT did any population of the mySQL DB or not ... But during the import both the SPA process and the mySQL DB process consumed much CPU cycles so I assume that some this happened..

Is there any EMC'er that can awnser if the smit.jar file should word in SPA 2.x or not?

/Lars

0 Kudos