Step 2 (As-Is) - Download performance history data

An SAP HANA migration assessment requires performance history data from your production system. Performance history data may be obtained in any of the following ways.

• Using the ST03N transaction.
• Using an RFC Destination on your As-Is system that connects directly to your production system.
• Using the performance history data that has been collected for an RFC Destination in LiveCompare.

• Using a remote function called from LiveCompare.

After the performance history data files have been obtained, they must be cleansed before being used in an SAP HANA migration assessment.

Obtain performance history data using the ST03N transaction

To obtain performance history data using the ST03N transaction, follow these steps on your Production system.

1. Run transaction ST03N. The following screen is displayed.

2. Select ‘Expert mode’ from the dropdown list in the top left corner of the screen. The screen changes to the following.

3. In the Workload hierarchy, expand Total, and collapse the Day and Week folders to leave Month open. The screen looks like this:

4. Double-click a month to select it. The screen looks like this:

5. Expand the Transaction Profiles folder in the Analysis Views hierarchy, and double-click Standard. The screen looks like this:

6. Select the All data tab in the main screen.

7. Click (Export) and select ‘Local File’ from the dropdown list. The following dialog is displayed.

8. Select ‘Unconverted’ and click . The following dialog is displayed

9. Save the file to a temporary directory as <SAP System Name>-ST03-<n>.txt. If you are downloading performance history data for more than one month, use <n> to number the files sequentially, for example, <SAP System Name>-ST03-1.txt, <SAP System Name>-ST03-2.txt...
10. The downloaded performance history data should look like this:

11. To download performance history data for additional months, select each month in the Month hierarchy and continue from step 7. Usage counts for duplicated programs and transactions are accumulated in the results generated by the SAP HANA Migration Assessment app.
12. Run the Data Cleanser utility to consolidate the performance history files into a clean file that is compatible with the data extract program.

Obtain performance history data for remote function calls using the ST03N transaction

To obtain performance history data for remote function calls (RFCs) using the ST03N transaction, follow these steps on your Production system.

1. Run transaction ST03N. The following screen is displayed.

2. Select ‘Expert mode’ from the dropdown list in the top left corner of the screen. The screen changes to the following.

3. In the Workload hierarchy, expand Total, and collapse the Day and Week folders to leave Month open. The screen looks like this:

4. Double-click a month to select it. The screen looks like this:

5. Expand the RFC Profiles folder in the Analysis Views hierarchy, and double-click RFC Server Profile. The screen looks like this:

6. Click (Export) and select ‘Local File’ from the dropdown list. The following dialog is displayed.

7. Select ‘unconverted’ and click . The following dialog is displayed.

8. Save the file to a temporary directory as <SAP System Name>-ST03-<n>.txt. If you are downloading performance history data for more than one month, use <n> to number the files sequentially, for example, <SAP System Name>-ST03-1.txt, <SAP System Name>-ST03-2.txt...
9. The downloaded RFC performance history data should look like this:

Obtain performance history data using an RFC Destination

To obtain performance history data using an RFC Destination that connects to your Production system, follow these steps to create the RFC Destination on your As-Is system.

1. Run transaction SM59. The following screen is displayed.

2. Click . The following screen is displayed.

3. Complete the screen fields as follows.

Field	Description
RFC Destination	Enter a name for the RFC Destination.
Connection Type	Enter 3 as the connection type.
Description	Enter a description for the RFC Destination.

4. Select Enter. The screen changes to the following.

5. Complete the following screen fields:

Field	Description
Target Host	Enter the hostname of your Production system.
System Number	Enter the system number of your Production system.

6. Click the Logon & Security tab. The following screen is displayed.

7. Complete the fields in the Logon Procedure section as follows.

Field	Description
Client	The SAP client number to be used for the connection.
Language	The SAP logon language. Use ‘EN’ for English.
User	The SAP user ID to be used for the connection.
Password	The password for the user ID specified above.

8. Click . The following message box is displayed.

9. Click , then select F3 to return to the Configuration of RFC Connections screen.

Obtain performance history data from the data collected in LiveCompare

To obtain performance history data from the data collected for an RFC Destination in LiveCompare, follow these steps.

1. Create a new workflow and add a Read Performance History Data action to it. Create a new RFC Destination parameter and Application Statistics dataset for the action. Link the RFC Destination parameter to the RFC Destination for which performance history data has been collected.
2. Add an Execute SQL action to the workflow. Link its Source1 property to the Application Statistics dataset, and create a new Result dataset. Set the action’s Statements property to the following:

CREATE TABLE Result AS SELECT NAME, '' AS BKGRD, '' AS DESC, [COUNT] FROM Source1

3. Select the Result dataset and choose View Details from the context menu. The following screen is displayed.

4. If necessary, click and set the ‘Maximum number of rows to display’ user preference to a value that allows all the table rows to be displayed.

5. Click to export the table to Excel. Open the Excel spreadsheet.

6. Delete the first column (containing row numbers), and use the ‘Save As’ option to save the spreadsheet in CSV (Comma delimited) format. Choose a meaningful name for the file, for example ST03_<RFC Destination>.csv.

Obtain performance history data using a remote function

To obtain performance history data using a remote function called from LiveCompare, follow these steps.

1. Copy the RFC - Get Perf Data (SAP kernel releases below 700) or RFC - Get Perf Data 700 (SAP kernel releases 700 and above) workflow from the Tools templates folder into your own workspace.
2. Open the copied workflow and set the System 3 parameter to an RFC Destination that contains performance history data.
3. Run the workflow to populate the AppStats External Data Source.
4. Create a new workflow and use the Read External Data Source action to read the AppStats External Data Source into a Table dataset named Application Statistics.
5. Add an Execute SQL action to the workflow. Link its Source1 property to the Application Statistics dataset and create a new Result dataset. Set the action’s Statements property to the following:

CREATE TABLE Result AS SELECT NAME, '' AS BKGRD, '' AS DESC, [COUNT] FROM Source1

6. Select the Result dataset and choose View Details from the context menu. The following screen is displayed.

7. If necessary, click and set the ‘Maximum number of rows to display’ user preference to a value that allows all the table rows to be displayed.
8. Click to export the table to Excel. Open the Excel spreadsheet.

9. Delete the first column (containing row numbers), and use the ‘Save As’ option to save the spreadsheet in CSV (Comma delimited) format to a directory on your machine. Choose a meaningful name for the file, for example ST03_<RFC Destination>.csv.

10. Run the Data Cleanser utility to produce a clean file that is compatible with the data extract program.

Next: Clean the raw performance history data