2571333 - Disk mirror blocks the sysdevices table - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2571333 - Disk mirror blocks the sysdevices table - SAP ASE

Symptom

  • When disk mirror is running on e.g. ASE 15.7, found that the process is blocking sysdevices table.
  • Checking the output of sp_lock when disk mirror is running, below information may display.

1> sp_lock
2> go
The class column will display the cursor name for locks associated with a cursor for the current user and the cursor id for other users.
 fid    spid   loid        locktype                                                                                                                                                                                                                                                        table_id    partitionid page       row    dbname          class                          context                                                                                                                                                                                           
 ------ ------ ----------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------- ----------- ---------- ------ --------------- ------------------------------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
      0     19          38 Ex_table                                                                                                                                                                                                                                                                 35           0          0      0 master          Non Cursor Lock                                                                                                                                                                                                                  

  • However, on ASE 15.0.3, disk mirror does not block sysdevices table. And the output of sp_lock when disk mirror is running would look like below:

1> sp_lock
2> go
The class column will display the cursor name for locks associated with a cursor for the current user and the cursor id for other users.
 fid    spid   loid        locktype                     table_id    page        row    dbname          class                          context
 ------ ------ ----------- ---------------------------- ----------- ----------- ------ --------------- ------------------------------ ----------------------------
      0     15          30 Ex_intent                             35           0      0 master          Non Cursor Lock
      0     15          30 Update_row                            35         177      0 master          Non Cursor Lock


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.5 ESD #1 and higer versions
  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; Sybase Adaptive Server Enterprise 15.5

Keywords

CR613737, CR#613737, 613737, disk mirror, sysdevices, block, EX_TAB, EX_INT , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , Problem

About this page

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

Search for additional results

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