Dev_disp in yellow state
Installing a SAP NetWeaver ABAP system is easy, keeping it up and running demands a little bit more. Don’t expect a NetWeaver ABAP system to just work, be prepared to do some additional configuration.
After starting the SAP NetWeaver ABAP instance, you are not able to connect to it. SAPGui tries to connect, but never finishes. This indicates that the message server accepts connections, but cannot process them. At the server, the startsap command executed successfully, it shows that ASCS and DI were started. But still, no connection is possible. What happened?
Taking a look into the dev_disp log reveals that really a problem is going on.
Log file: dev_disp
It is always a good idea to check the connection to the database (here: MaxDB).
The program hangs and never terminates. Also, no trans.log file is created. This indicates a DB problem. Check if the DB is up and running.
- DB GWD is up and running.
More information about DBMCLI
To get more information about MaxDB database, dbmcli offers the info command: dmbcli info
Command: dbmcli -d GWD -u control,<password> info LOG
The above command reveals what is causing the problem. The log area is full:
Used size is 100%. MaxDB cannot write anything anoymore to the log area. The solution is to archive the log area so MaxDB gains more space for the log area and is able to save new entires to it. Another command that can be used to find out if the log area is full is:
Command: dbmcli -d GWD -u control,<password> show active
The solution is to create a backup medium that MaxDB uses to archive its log area to.
Best approach is to ensure that a backup medium for DB and for log area are available for MaxDB to use.
Create backup mediums
- Log on to MaxDB with dbmcli.
Command: dbmcli –d <DBSID> -u control,<password>
Create medium for data backup
Command: backup_template_create backup_data_1 to FILE /sap/sapdb/<DBSID>/backup/DAT0001 CONTENT DATA
- Create medium for log area backup
Command:backup_template_create backup_log_1 to FILE /sap/sapdb/GWD/backup/LOG CONTENT LOG
- Start backup. For this, an open db connection must be established. If you are not already logged on to MaxDB via dbmcli, connect!
- Command: db_connect
Backup of data
Command: backup_start backup_data_1
Backup log area
Command: backup_start backup_log_1
*You do the data backup first because this for the log area backup to be executed, a data backup must be run at least once before.
After these steps, a backup for the data content and for the log area was created.
To ensure that the log area is automatically backed up and is not reaching its limit again, activate auto backup.
To get a list of configured mediums available in MaxDB, issue the command medium_getall