- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- 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
Updated on 13-Feb-2020 12:40:44
- Related Questions & Answers
- Getting data in front-end tools from SAP HANA database
- Getting statistics details of SAP HANA system
- SAP HANA database functions in HANA Cockpit
- Use of _SYS_REPO in SAP HANA database
- Comparison of SAP HANA with conventional database
- Benefits of using SAP HANA database views
- Understanding a database view in SAP HANA database
- Finding a database view in SAP HANA database
- Changing Ownership of schema in SAP HANA Database
- Unloading tables in SAP HANA database
- Database objects in SAP HANA Studio
- Using database view in SAP HANA
- Getting License details, hardware key in SAP HANA
- Meaning/Use of multi-tenant SAP HANA database
- Dropping a SAP HANA database view
Advertisements