Friday, October 5, 2018

Admin Task -1. Memory management for logging error messages


  •  SAP ASE writes start-up information to a local error log file. Each time it starts, the installation program automatically sets the error log location when you configure a new SAP ASE. 
what the error logging messages consist of :

Many error messages from SAP ASE are written only to the user’s terminal. However, fatal error messages (severity levels 19 and above), kernel error messages, and informational messages from SAP ASE are recorded in the error log file.

Note:
  • SAP ASE keeps the error log file open until you stop the server process.
Admin Task-1:
  • Before deleting old messages to reduce the size of the error log, stop the SAP ASE process.
  • Use sp_errorlog to dynamically change its path. Once the older error log is not being used by SAP ASE, you can move it, and make space available.



location of logging error messages at OS level:


 Note: On some platforms, such as Windows, SAP ASE also records error messages in the operating system event log. See the installation guide and configuration guide for your platform.


Additionals references:

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc35823.1600/doc/html/san1334282798251.html


https://itsiti.com/where-to-locate-sybase-ase-error-log-file-location


https://help.sap.com/viewer/99a215e70bf64c4b8cc8794dc700e767/16.0.3.4/en-US/a72b5487bc2b101482e99b08b54a23e4.html

No comments:

Post a Comment

how to check DB version using isql in sybase DB

hostname /sybase/PL6% isql -U sapsa -Ppassword -Spl6 -X CT-LIBRARY error:         ct_connect(): directory service layer: internal directo...