SAP Library - Find your answers

You can use this monitor to monitor your database system. The monitor provides, among other things, information and alerts for the following areas:

· Backing up and restoring data

· Database system check: consistency and profile

· Possible storage space problems

· Database performance

· Security of the database system

Features

For more information, choose the appropriate link from the table below, in accordance with the database that you are using:

Activities

To start the monitor, follow the procedure below:

...

1. Start the Alert Monitor using transaction RZ20 or choose CCMS ®Control/Monitoring ®Alert Monitor.

2. On the CCMS Monitor Sets screen, expand the SAP CCMS Monitor Templates set.

3. Start the Database monitor by double clicking it.

Edit, create, delete or adjust your database table

The database utility is the interface between the ABAP Dictionary and the relational database underlying the R/3 System.

This tools allows you to delete all the data in the tables.

You can call the database utility from the initial screen of the ABAP Dictionary with

Utilities -> Database utility (Transaction SE14).

You can use the database utility to edit all the database objects that are generated from objects of the ABAP Dictionary.

These are database tables that are generated from transparent tables or physical table pools or table clusters, indexes, database views and matchcode pooled tables or matchcode views.

If you want to use the database utility, you need authorization for authorization object

I need some basic information on SAP: What database platforms are supported? What operating systems are supported? And what kind of support is there for a mobile environment?

Have a look at http://service.sap.com/platforms*. All database and operating system platforms supported by SAP are listed there.

* Authorization required to access the SAP service marketplace.

To find out the status of connectivity, you can use the R3TRANS.EXE program. From the command prompt, execute "R3Trans –d".

If you see a return code “000”, it means that the database connection for the application is good.

R3trans will create an output file called trans.log which can help to diagnose if the return code is any other value than 000.

Login to the system database..then run a query to update the USR02 table.

To lock an user.

SQL> UPDATE USR02 SET UFLAG = '64' where BNAME='USERID' AND MANDT='CLIENT'
SQL> COMMIT

To unlock an user use

SQL> UPDATE USR02 SET UFLAG = '0' where BNAME='USERID' AND MANDT='CLIENT'
SQL> COMMIT

Here the different values of uflag have different meaning
UFLAG value

0 ------ Not locked

16 ------ Mystery values

32 ------ Locked by CUA admin

64 ------ Locked by system Administrator

128 ------ Locked due to incorrect logon attempts or too many failed attempts

192 ------ A combination of both. The user is locked by admin and user tries to logon with incorrect passwords and gets locked ( 192 = 64+128)

SAP Workload Analysis: Average Database Time per Dialog Step (ms)

A large portion of the "dispatched" time in a dialog is due to the reading and changing of data in the database, This field stores the time required for processing logical database calls (calls to the SAP database interface).

Various factors influence the logical database access time. Read requests can be responded to either by the database buffer or the fast local SAP buffer. The buffer efficiency, the number of the required accesses, and a high number of DB change accesses influence the total access time.

The database access time is measured in the database interface in the application server. This is why this also includes part of the application server CPU time and the network transfer time.

Client-Dependent and Client-Independent.

A table is client-dependent if the first table field type is of type CLNT. The length will always be 3. And this field is always named ‘MANDT’.

If the first is not of type CLNT the table is Client-Independent

Goto SE14

In the field "Obj.name" mention the table name and select "Tables", click on EDIT.

Select the "Delete Data" radio button and click on "Activate and Adjust Database"

To find out the status of connectivity, you can use the R3TRANS.EXE program. From the command prompt, execute "R3Trans –d".

If you see a return code “000”, it means that the database connection for the application is good.

R3trans will create an output file called trans.log which can help to diagnose if the return code is any other value than 000.

Upgrading SAP Kernel, Hotpatches and Database Startup

Kernel upgrade is an easy process.

Go to the SAP OSS Site :-

http://service.sap.com/SWCenter-Main
SAP R/3
SAP R/3 4.6C
Binary Patches
SAP KERNEL 4.6D

Download the kernel programs in a temporary folder.

Create a folder and copy the executables /exe/run/ then uncar the downloaded files and replace the executables.

It is recommended to shutdown the R/3 database and all services including saposcol.

Then restart your system.


A couple of important points to remember are :-.

a) Always make a copy of the files you're going to replace. For e.g. Create a directory (oldkern) and copy all the old files
before replacing them (this helps when sometimes the new Kernel has problems, and you can revert it)

b) You have to shutdown SAP and the Database using the OLD kernel file. Again it is good practice to shutdown everything
first.


Refer to this OSS note which is pretty useful :-

102461 - Installation of 4.0B/40B_COM kernel with 4.0A/40B


How do I find out the current patch level in SAP R/3 4.7

You can use either of these two methods:

1: Follow the path

System --> Status --> Component Information (The Magnifying glass button in the SAP System Data section)

2: Use the Transaction code ---- spam

spam(Support package manager) --> package level


Steps to Start Your Database After Kernel Upgrade

Do these steps to start your database:

1. Open command prompt

2. Give command: SQLPLUS "/as sysdba"
If its giving message connected to idle instance then proceed:

3. Give command: startup open
If its giving error that database is already open, shut it down first. Then first check what database process is up and running.

4. Try stopping the database: shutdown immediate.

5. Follow step 3 again after shut down the database.

6. Exit from SQLPLUS

7. Run command on command prompt: R3trans -d
Check the results whether its still giving error or if it completed with 000 return code, then try starting SAP.

Follow the above steps.

SAP Workload Analysis: Data Requested from Database (KB)

Amount (KB) of database data transferred


A number of interfaces are used to provide data for various uses by the SAP application. The requested data is differentiated according to the following interfaces and data types:


Screen sources

Screen load

ABAP sources

ABAP load

CUA sources

CUA load

Nametab interface

CPIC interface

DDIC interface

DSQL interface (user data from the database)

"Roundtrips" is used to display the number of communication steps.

Keyword: BASIS
Title : Database Tables contaning Transport Requests

A “SAP lock” is named “enqueue lock”, the enqueue is on a much higher level, e. g. a complete sales document is locked there whereas in the datbase usually only row locks exist.

Kernel upgrade is an easy process.

Go to the SAP OSS Site :-

http://service.sap.com/SWCenter-Main
SAP R/3
SAP R/3 4.6C
Binary Patches
SAP KERNEL 4.6D

Download the kernel programs in a temporary folder.

Create a folder and copy the executables /exe/run/ then uncar the downloaded files and replace the executables.

It is recommended to shutdown the R/3 database and all services including saposcol.

Then restart your system.

A couple of important points to remember are :-.

a) Always make a copy of the files you're going to replace. For e.g. Create a directory (oldkern) and copy all the old files
before replacing them (this helps when sometimes the new Kernel has problems, and you can revert it)

b) You have to shutdown SAP and the Database using the OLD kernel file. Again it is good practice to shutdown everything
first.

Refer to this OSS note which is pretty useful :-

102461 - Installation of 4.0B/40B_COM kernel with 4.0A/40B

How do I find out the current patch level in SAP R/3 4.7

You can use either of these two methods:

1: Follow the path

System --> Status --> Component Information (The Magnifying glass button in the SAP System Data section)

2: Use the Transaction code ---- spam

spam(Support package manager) --> package level

Steps to Start Your Database After Kernel Upgrade

Do these steps to start your database:

1. Open command prompt

2. Give command: SQLPLUS "/as sysdba"
If its giving message connected to idle instance then proceed:

3. Give command: startup open
If its giving error that database is already open, shut it down first. Then first check what database process is up and running.

4. Try stopping the database: shutdown immediate.

5. Follow step 3 again after shut down the database.

6. Exit from SQLPLUS

7. Run command on command prompt: R3trans -d
Check the results whether its still giving error or if it completed with 000 return code, then try starting SAP.

Follow the above steps.

Keyword: BASIS
Title : Changing SAP MaxDB Database Properties

Keyword: BASIS
Title : Database Backups

Keyword: BASIS
Title : Database Administration