SAP Note 13170 - Deleting ABAP/4 load modules (changed hardware)

Symptom:

ABAP/4 load modules are to be deleted.
Typical situation: The R/3-System is to be migrated to other hardware.

Reason and Prerequisites

ABAP/4 load modules are hardware-specific.

Solution

The ABAP/4 load modules must be deleted before exporting the database (Tables D010L, D010Q, D010Y, D010LINF).

• During and after the action no one may be logged on to the R/3 System. You should shut down the R/3 System and not restart it before the export has been completed.

• The database must be active (status "open")

• Deleting the Loads:

• Option 1:
  For Oracle database: login as user ora sqldba lmode=y
  connect internal
  truncate table sapr3.d010l reuse storage;
  truncate table sapr3.d010q reuse storage;
  truncate table sapr3.d010y reuse storage;
  truncate table sapr3.d010linf reuse storage;
  exit
  
  For DB2 common server database login as user db2 db2 connect to
  
  On UNIX operating systems:
  db2 import from /dev/null of DEL replace into sapr3.d010l
  db2 import from /dev/null of DEL replace into sapr3.d010q
  db2 import from /dev/null of DEL replace into sapr3.d010y
  db2 import from /dev/null of DEL replace into sapr3.d010linf
  On Windows operating systems:
  db2 import from NUL of DEL replace into sapr3.d010l
  db2 import from NUL of DEL replace into sapr3.d010q
  db2 import from NUL of DEL replace into sapr3.d010y
  db2 import from NUL of DEL replace into sapr3.d010linf
  
  db2 terminate
  

• Option 2 (general, but Release 2.* only): login as user adm cd /usr/sap/trans/bin
  ./tp touchall
  
  This does not delete the loads but initializes the time stamps.

• After transporting the database to the new hardware platform, the ABAP/4 load modules are generated new when the program concerned is called up. The system will therefore be very slow at the beginning. You can use the program RSGENLDS (start as background job) to generate all ABAP/4 load modules.
  

• Note (1):
  The TRUNCATE command is no standard SQL command. Without this command the procedure would be as follows:
  - structure export for the four tables (without data)
  - dropping the tables
  - importing the empty tables

• Note (2):
  The Dynpro loads in Table D020L and D020LINF are not hardwarespecific and therefore do not need to be deleted.