A message for Linux.com registered users: We are in the process of making changes to the Linux forums. Starting Monday, 8/13/18 at 6:00 PM PT, you will be unable to access the forums. They will re-launch as soon as possible on Wednesday, 8/15/18 with new features and improved functionality. Thank you for your patience and stay tuned for the new improved forums.

May 21, 2011

Import SAR data to Oracle database

I am looking for a script to convert daily SAR data to a format that can be use by Oracle. I have 1 that works for MySQL but don't want to re-invent the wheel is somebody already has a working script.

Suggestions on how to write this script also welcome

Now, the MySQL data looks like this:

lab12,2011-05-19,00:00:01,CPU,%user,%nice,%system,%iowait,%steal,%idle

To load into the table, the date needs to be in the below format.

lab12|2011-05-19,00:00:01|CPU|%user
lab12|2011-05-19,00:00:01|CPU|%nice
lab12|2011-05-19,00:00:01|CPU|%system
lab12|2011-05-19,00:00:01|CPU|%iowait
lab12|2011-05-19,00:00:01|CPU|%steal
lab12|2011-05-19,00:00:01|CPU| %idle

Click Here!