Show TOC

Displaying Configuration and Log FilesLocate this document in the navigation structure

Prerequisites

You are logged on to the database as database system administrator or as a DBM operator with server authorization for accessing database files.

More information: Glossary, Server Permission

Procedure

Displaying Database Files

  1. In the explorer, expand the folders of the logged-on database system administrator or DBM operator.

  2. Open the Diagnosis Files folder.

    The most important database configuration and log files are listed. To show more log files, choose Extended File List in the context menu of the Diagnosis Files folder.

    For more information about configuration and log files, see Database Administration, Configuration Files and Log Files.

  3. To display the content and attributes of a file, choose Open in the context menu of the file.

    Note that you cannot display binary files directly. You can only save them and then open them using a suitable external editor.

Saving the Database Messages Log File (Kernel Log File) to a Local Text File

  1. Display the Database Messages file.

    This is the most important database log files, which contains all database kernel messages (error messages, warnings, and information). The beginning of the file contains information about the software version, important paths and the current values of the database parameters.

    							   
       1:  Thread      0x1DC Task      -  2009-07-28 16:29:17     DIAG           0:  Using dbghlp version 4.0 rev 5
       2:  Thread      0x1DC Task      -  2009-07-28 16:29:17     DIAG           0:  Symbol search path:
       3:  Thread      0x1DC Task      -  2009-07-28 16:29:17     DIAG           0:  C:\ProgramData\sdb\globaldata\DEMODB;C:\Program Files\sdb\Installation_2009-07-21\pgm;C:\Program Files\sdb\Installation_2009-07-21\symbols;C:\Program Files\sdb\Installation_2009-07-21\sap;C:\Program Files\sdb\test\jtest\tests;C:\Windows
       4:  Thread      0x1DC Task      -  2009-07-28 16:29:17     RTE        20233:  Dump of all kernel parameters start
       5:                                 2009-07-28 16:29:17     RunTime       15:   AbortHandlingMode=BacktraceAndNormalMiniDump
       6:                                 2009-07-28 16:29:17     RunTime       15:   AdditionalLogQueueIOLimitation=0
       7:                                 2009-07-28 16:29:17     RunTime       15:   ADMIN=1
    [...]
    						

    The end of the file contains the latest database actions.

    							
    [...]
    1275:  Thread      0xA54 Task      1  2009-07-29 14:36:28     Savepoint      1:  Savepoint (Time) started by T1
    1276:  Thread      0xA48 Task    146  2009-07-29 14:36:28     Pager      20003:  SVP(1) Start Write Data
    1277:  Thread      0xA48 Task    146  2009-07-29 14:36:28     Pager      20004:  SVP(1) Stop Data IO, Pages: 36 IO: 8
    1278:  Thread      0xA48 Task    146  2009-07-29 14:36:28     Pager      20005:  SVP(2) Wait for last synchronizing task: 146
    1279:  Thread      0xA48 Task    146  2009-07-29 14:36:28     Pager      20006:  SVP(2) Stop Wait for last synchronizing task, Pages: 0 IO: 0
    1280:  Thread      0xA48 Task    146  2009-07-29 14:36:28     DataCache      4:  Mark data pages for savepoint (prepare phase)
    1281:  Thread      0xA48 Task    146  2009-07-29 14:36:28     Pager      20007:  SVP(3) Start Write Data
    1282:  Thread      0xA48 Task    146  2009-07-29 14:36:28     Pager      20008:  SVP(3) Stop Data IO, Pages: 2 IO: 2
    1283:  Thread      0xA48 Task    146  2009-07-29 14:36:28     Pager      20009:  SVP(3) Start Write Converter
    1284:  Thread      0xA48 Task    146  2009-07-29 14:36:28     Pager      20011:  SVP(3) Stop Converter IO, Pages: 8 IO: 8
    1285:  Thread      0xA48 Task    146  2009-07-29 14:36:28     DataCache      3:  Savepoint with ID 33 completed
    							
    						
  2. Choose Save

  3. Choose a location.

    Property

    Description

    My Objects

    Objects in the logged-on user's private branch of the repository

    Shared Objects

    Objects in the public branch of the repository

    Local User Folder

    Local, user-specific folder in the file system

    Example

    <user_home>\sdb\My Local Folder

    To change the local user folder, choose Start of the navigation path Window Next navigation step Preferences Next navigation step Database Studio Next navigation step Repository End of the navigation path and enter the new location.

    Packages

    Loader directory, used for exporting and importing data

    More information: Exporting and Importing: Overview

Displaying the Database Studio Log File

To display the content of the current Database Studio log file, choose Start of the navigation path Window Next navigation step Show View Next navigation step Event Log Viewer End of the navigation path.

Table 1: Database Studio Log Files

File Name

Directory

Content

dbstudio.log

<user_home>\sdb\DatabaseStudio\.metadata\.plugins\com.sap.sdb.tools.core

Database Studio log file

The system overwrites this log file each time Database Studio is started and saves the old log file as dbstudio.log.bak.

For information on how to configure logging for Database Studio, see Database Studio Preferences: Logging.

dbstudio.log.bak

<user_home>\sdb\DatabaseStudio\.metadata\.plugins\com.sap.sdb.tools.core

Previous Database Studio log file

More Information