Wednesday, 20 August 2014

TP Notes

Manually Add Transport To a SAP Import Queue

tp addtobuffer <Transport> <SID> client=<Client no.> pf=<Path to transport profile file .PFL>

Manually Import Transport

tp import <Transport> <SID> client=<Client no.> U<Mode> pf=<Path to transport profile file .PFL>

TP Command Options (Mode)

0 - Overtaker: - Import from the buffer without deleting and set unconditional mode 1 in the buffer to trigger another import.
1 - During export: - Ignore the incorrect status of the command file.
1 - During import: - Ignore the fact that the change request was already imported.
2 - During export: - Do not expand the selection with TADIR brackets.
2 - During import: - Overwrite original objects.
3 - During import: - Overwrite system-dependent objects.
4 - During import: - Ignore invalid component version.
6 - During import: - Overwrite objects in unconfirmed repairs.
8 - During import: - Ignore restrictions based on table classification.
9 - During import: - Ignore the fact that the system is locked for this type of transport.

Thursday, 14 August 2014

Unlock SAP User Account / Delete SAP* user in DB2

At command line:

  • db2
  • connect
  • update sapsr3.usr02 set uflag=0 where mandt='<client>' and bname='<username>'
  • delete from sapsr3.usr02 where mandt='<client>' and bname='SAP*'

Response should be:
DB20000I  The SQL command completed successfully.

Effect is immediate. No 'commit' required.

(* Assumes the schema is sapsr3)