PBS Quick Check for SAP ERP

SAP data archiving projects need to be prepared accurately. For optimal results you need to learn about the data volume, grouped by SAP archiving objects respectively BW InfoProviders:

  • How large is the SAP database?
  • How is the data distribution by SAP archiving objects resp. InfoProviders?
  • Which are the largest modules?
  • Which are my largest (z) tables?
  • How much – and which – data have already been archived?

PBS offers to support you gathering this information, combined with recommendations to benefit from best matching PBS archive add ons / NLS solutions for complete and integrated SAP (archive) data retrieval and query access.  

We will compile a brief database analysis free of charge and with no obligations. For this, we just ask you to have your DB admin provide some technical database details: Extracts of table ARCH_DEF (resp. RSDCUBE, …), ADMI_FILES and information from the table and index monitor (transaction DB02). We will not ask for any business related details/confidential information.   

We would be pleased to send you our short guide how to achieve and provide the necessary details. An evaluation containing the database occupation of the SAP tables grouped by archiving objects and further information will be returned very quickly.

Save all files from parts A) and B) and send them compressed (zip or similar compression) directly to quickcheckpbs-software.com or your local contact.

 

 

Instruction:

A) Extract data archiving admin information

Table ARCH_DEF

(Hints for all database systems)

  1. Start transaction SE16 for table ARCH_DEF.
  2. Set the maximum hits to "9.999.999" and start in dialog mode (F8).
  3. Export the results list:
    System -> List -> Save ->  Local File (unconverted):

Table ADMIN_FILES

(Optional details for archive data analysis. Hints for all database systems)

1. Start transaction SE16 for table ADMIN_FILES.
2. Set the maximum hits to “9.999.999” and start in dialog mode (F8).
3. Export the results list:System -> List -> Save -> Local File (unconverted):

B) Extraction of the table information

SAP HANA database (here for SAP ECC 6.7)

  1. Start SAP transaction DB02
  2. In the left section, branch to menu option SAP HANA Database -> System Information- -> Large Tables (double click). Enter at least “1.000” in field “Max. No. of Hits” as marked in the below screenshot. Hit “Apply Selection” and order the result by “Memory Size in Total”.
  3. Results appear after a short runtime. Save the data in an unconverted text file via "Export":

Oracle database (here for SAP ECC 6.0)

  1. start SAP transaction DB02
  2. Branch to menu section Space -> Segments -> Detailed Analysis (double-click). In the pop-up window, enter the "Owner" (when known). Select all segments for the analysis using the asterisk (*) in field “Segments” (see screenshot).
  3. Results appear after a while (depending on data volume and system resources). Save the data in an unconverted local file via button "Export".

IBM DB2 database (here for SAP ECC 6.0)

  1. Start SAP transaction DB02
  2. Branch to menu section Space -> Tables and Indexes (double-click). In the pop-up window, select all data/tables via the asterisk (*) and start the analysis (F8).
  3. Results appear after a while (depending on data volume and system resources). Save the data in an unconverted text file via button "Export".
    (Unfortunately, we can’t provide screenshots for illustration. Process is very similar to chapter B – Oracle database).

MAXDB database (here for SAP ECC 6.0)

  1. Start SAP transaction DB02
  2. Select button “Table Size Statistics”. Branch to tab “Largest Tables”. Leave field “Total Number of Tables” empty to ensure selection of all available tables. If this would lead to an unacceptable runtime, please limit with an appropriate value. Start in dialog with F8.
  3.  Save the results in an unconverted text file:

Table details from AS400 system (here for SAP ECC 6.0)

Extract table details from AS400 (here for SAP ECC 6.0)

  1. Start transaction SE16 for table DB4TABLE_STAT
  2. Call menu option: Settings -> List Format -> Choose Fields
  3. Select fields TABNAME_LONG and TABSIZE
  4. Set maximum hits to “9.999.999“ and start the selection (F8).
  5. Export the results list in a text file: System -> List -> Save -> Local File (unconverted):

C) Collocate all files and transfer to PBS Software

Save all files from parts A) and B) and send them compressed (zip or similar compression) directly to quickcheckpbs-software.com or your local contact.

Kindly ensure that all data were saved as unconverted text files. Large data files should to be compressed properly. We will return the complete analysis results ASAP!