useful transaction

8

Click here to load reader

Upload: ofrq

Post on 05-Apr-2018

214 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: Useful Transaction

7/31/2019 Useful Transaction

http://slidepdf.com/reader/full/useful-transaction 1/8

 

System Administration Made Easy A –1

$SSHQGL[$8VHIXO7UDQVDFWLRQV

&RQWHQWV

Useful Transactions............................................................................................... A –2

Page 2: Useful Transaction

7/31/2019 Useful Transaction

http://slidepdf.com/reader/full/useful-transaction 2/8

Appendix A: Useful Transactions

Useful Transactions

Release 4.6A/BA –2 

8VHIXO7UDQVDFWLRQV

System ad ministrators may find the following transactions useful. Although man y of the

transactions are n ot discussed in this guid ebook, we are listing them for your convenience.

Many of these transactions are for more “ad vanced” fun ctions than targeted in the scope of 

this guidebook.

7UDQVDFWLRQ&RGH6ZLWFKHV

/n<trans code> /nspad Exit the current transaction and

start the new tr ansaction

/o<trans code> /ospad Open a new session (window) and

start the new tr ansaction

7UDQVDFWLRQ&RGH7DEOHThe following are d efinitions of two of the column headers.

< Dangerous

These transactions are p otentially dam aging or fatal to the system if executed

incorrectly.

As a general ru le, most of the Basis transactions are potentially dam aging. Access to

these transactions shou ld be restricted in a ll systems. Access to some of these

transactions should be even further restricted in the produ ction system.

< Performance Impact

These transactions could h ave a p otentially adverse imp act to system p erformance if 

executed . Traces and table display are th e transactions of concern here.

The problem with a table display occurs wh en the qu ery does a “full table scan” for d ata.

When d one on a large table, this query h as serious imp act on performan ce because the

system searches every record in the table to find th ose that meet th e search criteria.

Page 3: Useful Transaction

7/31/2019 Useful Transaction

http://slidepdf.com/reader/full/useful-transaction 3/8

Appendix A: Useful Transactions

Useful Transactions

System Administration Made EasyA –3 

Transaction Description Dangerous Performanceimpact

AL02 Database Alert Monitor

(not supp orted for MS SQL Svr 7.0)

AL03 Operating System Alert Monitor

AL05 Workload Alert Monitor

AL08 Curren t active user s (in system)

AL11 Display operating system file from CCMS

AL12 Display table buffer (buffer synchronization )

BALE ALE adm inistration and mon itoring

DB01 Exclusive waits in Oracle database

DB02 Database performan ce; tables and index

DB03 Param eter changes in database

DB05 Ana lysis of table with resp ect to ind exed fields

DB12 Backu p logs

DB13 DBA plan ning calendar

DB14 DBA logs

DB20 Generate table statistics

OSS1 Online Service System logon

RZ01 Graph ical background job sched uling mon itor

RZ02 Netw ork grap hical display of instance

RZ03 Server status, alerts, maintain operations mod e

RZ04 Maintain operations mod e and instance

RZ06 Mainta in alert threshold

RZ08 CCMS Alert Monitor

RZ10 Mainta in system profiles X

RZ11 Display profile parameter attributes

RZ20 Alert Monitor 4.0

RZ21 Mainta in settings for Alert Monitor 4.0

SA38 ABAP reporting

SCAM CATT man agement

Page 4: Useful Transaction

7/31/2019 Useful Transaction

http://slidepdf.com/reader/full/useful-transaction 4/8

Appendix A: Useful Transactions

Useful Transactions

Release 4.6A/BA –4 

Transaction Description Dangerous Performanceimpact

SCAT Comp uter Aided Test Tool

SCC1 Client copy tran spor t X

SCC3 Client copy log

SCC4 Client copy adm inistration X

SCC5 Delete clients X

SCC6 Client imp ort X

SCC7 Client imp ort – post processing

SCC8 Client export

SCC9 Remote client copy X

SCCL Local client copy X

SCMP Table comp arison

SCU3 Table history

SE01 Transp ort organ izer

SE03 Workbench organ izer: tools

SE06 Set up workben ch organ izer

SE09 Workbench organ izer

SE10 Customizing organ izerSE11 Data Dictionary maintenance X

SE12 Data Dictionary d isplay

SE14 Utilities for ABAP Dictionary tables X

SE15 Repository Info System

SE16 Display table content X X

SE17 Genera l table disp lay X

SE38 ABAP ed itor X

SECR Audit Information System

SEU R/ 3 Repository Browser

SFT2 Mainta in pu blic holiday calendar

SFT3 Mainta in factory calenda r

SICK Installation check 

Page 5: Useful Transaction

7/31/2019 Useful Transaction

http://slidepdf.com/reader/full/useful-transaction 5/8

Appendix A: Useful Transactions

Useful Transactions

System Administration Made EasyA –5 

Transaction Description Dangerous Performanceimpact

SM01 Lock tran sactions X

SM02 System messages

SM04 Overview of users

SM12 Database locks X

SM13 Upd ate terminates X

SM18 Secur ity Audit: Delete Old Audit Logs

SM19 Secur ity Audit: Ad minister Audit Profile (for

SM20)

SM20 System (Security) Audit Log

SM21 System log

SM30 Mainta in tables (not all tables can use SM30) X

SM31 Maintain tables X

SM35 Batch input mon itoring

SM36 Sched ule backgrou nd jobs

SM37 Overview of background jobs

SM39 Job analysis

SM49 External operating system comman ds, execute

(see related SM69)

SM50 Work process overv iew

SM51 Instance overv iew

SM56 Reset or check nu mber ran ge buffer X

SM58 Error log for asynchronou s RFC

SM59 RFC connection, ma intain

SM63 Opera tions mod e, maintain

SM64 Event trigger

SM65 Backgrou nd processing analysis tool

SM66 Global work process overv iew

SM69 External operating system comman ds, maintain

(see related SM49)

SMLG Maintain logon group s

Page 6: Useful Transaction

7/31/2019 Useful Transaction

http://slidepdf.com/reader/full/useful-transaction 6/8

Appendix A: Useful Transactions

Useful Transactions

Release 4.6A/BA –6 

Transaction Description Dangerous Performanceimpact

SMX Display own jobs

SNRO Maintain nu mber range objects X

SP00 Spool

SP01 Spool control

SP02 Display outp ut requests

SP11 TemSe (temp orary sequential objects) contents

SP12 TemSe ad min istration

SPAD Spool ad ministration (printer setup)

SPAM SAP Patch Manager

SPAU Intersection SAP transp ort/ customer

modifications

SPCC Spool; consistency check 

SPDD Intersection SAP transp ort/ customer

mod ifications, DDIC

SPIC Spool; installation check 

ST01 SAP system trace X

ST02 Buffer stat istics

ST03 Workload analysis

ST04 Database per formance ana lysis

ST05 SQL trace X

ST06 Op erating system mon itor

ST07 Ap plication mon itor

ST08 Network mon itor

ST09 Network Alert mon itor

ST10 Table call stat istics – statistics on table accesses

ST11 Display dev eloper trace X

ST12 Ap plication mon itor

ST14 Application ana lysis – statistics related to business

document volum e

ST22 ABAP dum p ana lysis

Page 7: Useful Transaction

7/31/2019 Useful Transaction

http://slidepdf.com/reader/full/useful-transaction 7/8

Appendix A: Useful Transactions

Useful Transactions

System Administration Made EasyA –7 

Transaction Description Dangerous Performanceimpact

ST4A Oracle: analyze the shared cursor cache

STAT Local tran saction statistics

STMS Transport Managem ent System X

STUN Performance monitoring men u

STZAC Customizing Time Zones

SU01 User ma intenance X

SU01D Display users

SU02 Mainta in au thor ization profiles X

SU03 Maintain auth orizations X

SU10 Mass chang e to user record s X

SU12 Delete ALL Users X

SU2 Maintain user parameters

SU22 Au thor ization object check in tran sactions

SU3 Maintain own user parameters

SU53 Display auth orization checked values

TU02 Param eter changes – display active pa rameters

and history of changes

Page 8: Useful Transaction

7/31/2019 Useful Transaction

http://slidepdf.com/reader/full/useful-transaction 8/8

Appendix A: Useful Transactions

Useful Transactions

Release 4.6A/BA –8