2505797 - Information about logs and trace files for SAP ASE for Business Suite

April 07, 2024

2505797 - Information about logs and trace files for SAP ASE for Business Suite

Symptom

This document explains you which information you should check and collect when SAP ASE for Business Suite has any troubles.

Environment

SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite

SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite

SAP Enterprise Resource Planning (ERP) 6.0

SAP Customer Relationship Management (CRM) 7.0

SAP Supplier Relationship Management (SRM) 7.0

SAP Supply Chain Management (SCM) 7.0

SAP Solution Manager (SOLMAN) 7.1

SAP Solution Manager (SOLMAN) 7.2

SAP NetWeaver (NW) - All versions

Resolution

These are SAP ASE permanent logs, trace files and optional shared memory dump file:

File Type File Name Number Optional Location

SAP ASE errorlog <SID>.log 1 No

Windows: %SYBASE%\%SYBASE_ASE%\install

UNIX/Linux: $SYBASE/$SYBASE_ASE/install

Backup Server errorlog <SID>_BS.log 1 No Windows: %SYBASE%\%SYBASE_ASE%\install

UNIX/Linux: $SYBASE/$SYBASE_ASE/install

Job Scheduler errorlog <SID>_JSAGENT.log 1 No Windows: %SYBASE%\%SYBASE_ASE%\install

UNIX/Linux: $SYBASE/$SYBASE_ASE/install

Connection information for servers Windows: sql.ini

UNIX/Linux: interfaces 1 No Windows: %SYBASE%\ini

UNIX/Linux: $SYBASE

Configuration file <SID>.cfg 1 No Windows: %SYBASE%

UNIX/Linux: $SYBASE/$SYBASE_ASE

Developer trace files dev_* many No Windows: <drive>:\usr\sap\<SID>\<Instance>\work

UNIX/Linux: /usr/sap/<SID>/<Instance>/work

Shared Memory Dump <SID>.dmp.YYYYMMDDhhmmssxxxx 1 or many Yes Specified location by sp_shmdumpconfig

SAP ASE errorlog

SAP ASE reports startup, stopping messages and any SAP ASE errors in this log file. You have to check and collect this file.

On Windows environment, usually SAP ASE keeps recording to only 1 file. On UNIX/Linux environment, <SID>.log file is renamed every startup timing when you start SAP ASE by using startdb or startsap.

Backup Server errorlog

Backup Server is used when DUMP DATABASE / TRANSACTION or LOAD DATABASE / TRANSACTION commands are executed via DBA Planning Calendar or any scripts.

Backup Server reports startup, stopping messages and any backup errors in this log file. You need to check and collect this file if backup or restore perform unexpectedly.

Job Scheduler errorlog

Job Scheduler is used for the management of ASE by providing the ability to define and schedule database administration and maintenance tasks. On Business Suite environment, Automatic Table Maintenance (ATM) and Data Collection Framework (DCF) are performed by Job Scheduler.

You need to check and collect this file if scheduled jobs perform unexpectedly.

Connection information for servers

Connection information (Host Name or IP Address and Server Port) is stored in this file.

Configuration file

Configuration parameters and settings for SAP ASE are stored in this file. You can know the current setting by checking <SID>.cfg file.

When configuration settings are changed by sp_configure or DBACOCKPIT, <SID>.cfg file has been written and the previous version has been renamed to <SID>.nnnnnnnnn.

Developer trace files

Trace files contain information about the system execution. Trace records are usually used by developers and support engineers to record and analyze the occurrence of certain events in programs during runtime.

Shared Memory Dump

Shared Memory Dump is a snap shot of a certain moment. You should configure Shared Memory Dump when support engineer requests to set for further investigation.

The default file name is <SID>.dmp.YYYYMMDDhhmmssxxxx, but you can specify the file name as you like by sp_shmdumpconfig.

Search This Blog

Not all readers are leaders, but all leaders are readers - Harry S. Truman

2505797 - Information about logs and trace files for SAP ASE for Business Suite

Comments

Post a Comment

Popular Posts

N+1 redundancy

Delegating Microsoft DHCP Server Administration in a Windows Domain, “completely”