2571333 - Disk mirror blocks the sysdevices table - SAP ASE

• 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

• 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

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