Procedure documentationDisplaying Configuration and Log Files Locate 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.

    More information: Database Administration,

  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.

    Syntax Syntax

    1.    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
[...]
    End of the code.

    The end of the file contains the latest database actions.

    Syntax Syntax

    1. [...]
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
    End of the code.

  2. Choose Save (Save)

  3. Choose a location.

    Database Studio: Repositories

    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 Example

    <user_home>\sdb\My Local Folder

    End of the example.

    To change the local user folder, choose   Window   Preferences   Database Studio   Repository   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   Window   Show View   Event Log Viewer  .

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.

dbstudio.log.bak

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

Previous Database Studio log file

More Information

Troubleshooting

Messages (Reference for the database information and error messages)