SAP Knowledge Base Article - Preview

2244546 - monDeviceSpaceUsage queries fail on NFS devices - SAP ASE

Symptom

SELECT queries accessing the MDA table, monDeviceSpaceUsage,  fail with timeslice errors when:

  • "dump database' is running alongside heavy activity on the system
  • The ASE  database devices, are NFS-mounted

The offending queries are:

SELECT distinct FileSystemName, FileSystemSizeMB, FileSystemFreeMB FROM master..monDeviceSpaceUsage

INSERT #filesystem_metrics SELECT DISTINCT InstanceID, FileSystemName, FileSystemFreeMB, FileSystemSizeMB, getutcdate() AS TIMESTAMP_UTC FROM master..monDeviceSpaceUsage

Timeslice errors are reported in the ASE errorlog for this query execution. 
The accompanying stacktrace references any or all of the functions: __xstat64, __lxstat, mda__get_FileInfo(), mda_populate_monDeviceSpaceUsage()


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Solution Manager 7.1

Keywords

monDeviceSpaceUsage, NFS, dump database, backups, stat, CR 792402, __xstat64, timeslice , KBA , __xstat , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.