DATABASE ADMINISTRATION

DB01-ANALYZE EXCLUSIVE LOCK WAITS
DB02-ANALYZE TABLES AND INDEXES
DB12-DB BACKUP MONITOR
DB13-DBA PLANNING CALENDAR
DB15-DATA ARCHIVING DATABASE TABLES

CONFIGURATION T CODE

Configuration

FILE-CROSS CLIENT FILE NAMES/PATHS

RZ04-MAITAIN OPERATION MODES AND INSTANCES

RZ11-PROFILE PARAMETER MAITENACE

SE93-MAITAIN TRANSACTION CODES

SM63-DISPLAY/MAITIN OPERATING MODE SETS

SPRO-CUSTOMIZING INITIAL SCREEN     

SWU3-CONSISTENCY CHECK CUSTOMIZING

SAP Tcode for monitoring

Alert Monitoring

AL01- SAP ALERT MONITOR

AL02-DATA BASE ALERT MONITOR

AL04-MONITOR CALL DISTRIBUTION

AL05-MONITOR CURRENT WORK LOAD

AL16-LOCAL ALERT MONITOR FOR OPERAT. SYST.

AL18-LOCAL FILE SYSTEM MONITOR

RZ10-CCMS MONITORING

How to create a job in SAP basis--A step by step guide

In this post i will tell the how to create a job in SAP BASIS. This is the step by step guide for creating the job in sap basis.
1. login with your master password and username

2. Execute the sm36 t code for creating the job

3. Continue with that dialogue box. Click continue for create.

4. Then it will show the general job information and put our requirement i.e Job name, Job class- (high, low, medium) job status, Target server.

5. Defining a job step by three option a)ABAB program step b) External command as a step
      c) External program as a step. For my convenience i choose ABAB program step

6. Define an ABAP program job step. In this step three option asking ABAP program name, Variant, Execution language.

7. Multi-step jobs shown if you want means choose otherwise not choose.

8.Jon definition:Start conditions. i.e Immediately, date/time, after job, after event, at operation mode switch, start on workday, do not release job.

9. Start the job immediately list the nob name, job class, target server, steps defined, start condition.

10. Bottom of the page shown the job name VRK saved with status released
11. Job has been created and view our job in sm37 tcode.

Contact me

V.Rajeshkumar M.E Department of ECE
Melmalayanur village and post  
Gingee T.k
Villupuram Dist
Tamil Nadu 606611                                      
Cell : +919566937635 or +919092398775
Email id : rajeshkumarece73@gmail.com

ST22 ABAP dump analysis

You can view the ABAP run time errors that have occurred in an ABAP system as well as relevant dumps in client.
This error can save in local file and also print for user reference

.

sm13 monitoring update statistics

In sm13 you can monitor the update statistics if unwanted updated in particular user means you can delete or cancel that update and check critical update and non critical update here. list the update activity by date and time.

sm12 lock entry list

sm12 lock entry types

Lock types ---> there are three types of entries are available first one is (S) Shared lock which any one can access the users even in locked and another one is (E) exclusive lock mode this only for perticular user can entry for unlock option same user go to unlock.

sm04 list of local users

sm04 gives the list of local users and it shows the client numbers, users names, terminal, transaction, dialog time, external session, type, megabyte something like that snap.

AL08 Current active users

In this post we will discuss the about users. In SAP servers how many members are logged in and how to find out that, answers is al08 t code. to excute the al08 t code it shown the list of all users logged on.

1. Active users
2. Active instance
3. Interactive users
4. RFC users
5. Mand ---means client number
6.users
8. t-code
9.time
10.External session
11. Internal session

Ref: http://wiki.scn.sap.com/wiki/display/Basis/AL08+-+List+of+All+Users+Logged+On

sm51 and sm50

To find out the SAP system server by using the tcode as sm51. The only one application server is in this system showing something like that.

This server is active or passive it showing in the particular space. Goto edit---> change stste----> Activate pr deactivate.
Sm50 ----> Process overview

r either clicking double on the server it showing the process overview this process can view in details and many options are available.

Detailed overview of work process:-

Profile in R/3 system

In R/3 System profile display is very easy. There are three types of profile is there.

1. Default
2. Instance
3. Start up profile

Each and every profile consists of three parameters basic, simple, extended. We can display all parameters in this post.

RZ11 profile generation snap

]

How do assign roles in sap basis

               In SAP BASIS assigning of roles is very important  step to the employees. This is the small guide to how assign roles in the sap basis. the step by step procedure to guide assigning of single and composite roles in the sap basis.
step 1: Login the master user name and password as per our requirement

step 2: Execute the t code su01 and create the user name as per our requirement.

step 3 : After creation of user then you have to login with master user name and password.

step 4 : then execute the t code pfcg, then you will see the below dialog box.

Step 5: Role maintenance dialog box will open create the role name start with X, Y, Z only as seen below image.

Step 6: for example create the single role then click role button,

              ----> click the menu button, then add the description.

             ------>click the transaction button then add the tcode for authorization, then add assignment.

             ---------->click save button, then click the authorization menu, then find the change                                                authorization data

             ---------------->then click the generate button then it showing the profile has been created. During creation of this profile profile wizard showing and edit as per our requirement.

            -------------------->then click the user button then you have to enter the required user name , click the user comparison.

Step 7: Then you will see the role and profile automatically created in the user...