SAPLIB

1. The Cost of Logging
Some of you may already know that you can’t turn off [transaction] logging in db2 for z/os. Turning off transaction logging is an important part of the ECC upgrade process, and for good reason, since the upgrade process eats up a huge number of logs, and you seldom need to perform any kind of point in time recovery since the upgrade program can rerun each step.

In the SAP SERVICE MARKETPLACE you can find some information on the upgrade procedure’s requirements from the various servers and databases. Note 815203 will even tell you how much free space you require. But I haven’t found an official document that addresses the logins issue, so I guess there isn’t one. Anyway, what I’m trying to say is that my recent experience shows that upgrade from ECC5 to ECC6 generates around 500MB of transaction log data, and if you use dual logging it will add up to 1TB of data, so be prepared.

2. Profile Parameter Issues
a. Save your [old] instance and default profiles before the upgrade.
b. Save your [old] instance and default profiles before the upgrade.
c. Save your [old] instance and default profiles before the upgrade.
d. Save your [old] instance and default profiles before the upgrade.
e. Review the new profiles, make sure you haven’t lost important non-standard parameters, also note that some of the memory related parameters have changed, they are given default values , and this is probably not optimal for your system.
f. Review the shadow instance profile before the upgrade. At the very least consider adding the following parameters to it :
dbs/db2/use_wlm=1
dbs/db2/use_accounting = 1
(more…)

Popularity: 26% [?]

The following sections provide simple step-by-step instructions for executing many of the reporting processes just discussed. Use the following sections as a quick reference to speed you through each respective reporting process. And remember, if you need more information, refer to each process’s respective detailed sections provided earlier in this hour.

Quick Reference for Exporting Lists to Microsoft Excel
Quick Reference for Exporting SAP Query Reports to Excel
Quick Reference for Creating Form Letters with Microsoft Word
Quick Reference for Exporting Lists to Microsoft Access
Quick Reference for Exporting SAP Query Reports to Access

Quick Reference for Exporting Lists to Microsoft Excel

The following is a recap of the steps required to use the System List function to export SAP lists to Microsoft Excel.

1. Navigate to the SAP screen containing the list you want to output.
2. Follow the menu path System, List, Save, Local File.

(more…)

Popularity: 20% [?]

Creating reports in Microsoft Access is easy using a tool called the Microsoft Access Report Wizard. The use of reports wizards simplifies the layout process of your fields by visually stepping you through a series of questions about the type of report that you want to create. The wizard walks you through the step-bystep creation of a report, while behind the scenes Access is formatting, grouping, and sorting your report based on selections you make.

Instead of having to create a report from scratch, Microsoft Access provides a number of standard report formats. Some of these, like tabular and columnar reports, mail-merge reports, and mailing label formats, lend themselves to meeting basic reporting requirements. Reports created using the Microsoft Access Report Wizard can also be customized to fit your needs. To use the Report Wizard, perform the following steps: (more…)

Popularity: 16% [?]

After the XLS file resides on your local system or an accessible file share, you need to import this file into Microsoft Access (the following steps assume Access has been installed on your system; given that Access is not included with all versions of Microsoft Office, this might not be the case by default):

1. Launch Microsoft Access on your system.
2. From this initial window, select the Blank Database option, and then click OK. You are prompted to create a name and to select a location for your database. In this example, I selected the C:\My Documents directory and named the database MySAP.mdb
3. Click the Create button; you then see the main Microsoft Access window
4. To bring the SAP data into Microsoft Access, use the Microsoft Access menu path File, Get External Data, Import. You are then prompted with a window similar to the one shown in Figure 22.10. This is where you have to input the location and filename of the output file you saved earlier. By default, the Files of Type box lists Microsoft Access (*.mdb). You have to change this to Microsoft Excel (*.xls). (more…)

Popularity: 18% [?]

As you have seen, exporting SAP data to Microsoft Excel and Word is useful when it comes to performing further offline manipulation of your data, for creating reports and graphs, or for drafting form letters. Exporting data to a Microsoft Access database is quite useful, too, when it comes to general reporting.

The initial steps to export data into Microsoft Access are the same as the steps to download a file into Microsoft Excelthe idea is to get the data into the Excel XLS format. Verify this is the case before proceeding. (more…)

Popularity: 15% [?]