- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Getting age of tracefiles in SAP HANA database
In SAP HANA database, you have diagnosis files include log and trace files, a mixture of other diagnosis, error, and information files.These files can be checked for diagnosis to find errors in SAP Hana database.
In HANA db, you have trace files stored separated per host, so to get access to the trace files of a multi-node system you have to check for each host individually.
To find the location of trace files in SAP HANA you can run the following SQL statement −
SELECT* FROM M_DISKS WHERE USAGE_TYPE ='TRACE';
To access tracefiles using the command line, you can use cdtrace as below −
You can check details of these files using HANA Studio → Administration tab
You can also try something like this −
SelectFILE_NAME, SECONDS_BETWEEN(FILE_MTIME , CURRENT_TIMESTAMP) AS Age from M_TRACEFILES
- Related Articles
- Getting data in front-end tools from SAP HANA database
- SAP HANA database functions in HANA Cockpit
- Use of _SYS_REPO in SAP HANA database
- Getting statistics details of SAP HANA system
- Understanding a database view in SAP HANA database
- Finding a database view in SAP HANA database
- Using database view in SAP HANA
- Unloading tables in SAP HANA database
- Database objects in SAP HANA Studio
- Changing Ownership of schema in SAP HANA Database
- Comparison of SAP HANA with conventional database
- Benefits of using SAP HANA database views
- Getting License details, hardware key in SAP HANA
- Default table type in SAP HANA database
- Creating column table in SAP HANA database

Advertisements