3809611 - Error: 12334, Severity: 21, State: 1 reported with failed due to read failure in prefetch - ASE

• sp_configure shows the following parameter set to the following:

isk i/o structures                 256        9758          32768          32768 number  dynamic
max async i/os per engine            1024           0          32768          32768 number static
max async i/os per server      2147483647           0     2147483647     2147483647 number static

• sp_sysmon sampling     shows "I/Os Delayed by" has non zero values

Disk I/O Structures               n/a           n/a      314774       n/a
Disk I/O Structures               n/a           n/a        2062       n/a

• sp_monitor shows max_outstanding_AIOs_server is set to 32768
• sp_sysmon sampling show Max Outstanding I/Os HWM is also set to 32768

Disk I/O Management
-------------------

  Max Outstanding I/Os            per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ----------
    Server                            n/a           n/a       32768       n/a

• All sp_monitoring sampling show the following for apf_not_issued_lack_of_resource is 0

apf_not_issued_lack_of_resource                                                 buffer_0                       208           0

• The following stack is reported along with the 12334 error

pcstkwalk
ucstkgentrace
ucbacktrace
terminate_process
hdl_default
s_handle
exc__raise
exc_raise
getpage__raise_apffail_error.constprop
getpage_with_validation
dol_qualrow
dol_oamscan_getnext

SAP Adaptive Server Enterprise (ASE) 16.0 SP04

CR 832573, 832573, blkio, APF, prefetch, resource , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Product Enhancement