Use sp_lock to view partition locks currently held by SAP ASE.
View locked partitions in the partitionid column of the sp_lock report.
sp_lock go fid spid loid locktype table_id partitionid page row dbname class context --- ---- ---- -------- -------- ----------- ---- --- ------ ------ ------- 0 13 26 Ex_intent 420193516 0 0 0 master Non Cursor Lock 0 13 26 Ex_intent_partition 420193516 452193630 0 0 master Non Cursor Lock 0 13 26 Ex_page 420193516 452193630 4993 0 master Non Cursor Lock 0 14 28 Ex_intent 420193516 0 0 0 master Non Cursor Lock 0 14 28 Ex_intent_partition 420193516 468193687 0 0 master Non Cursor Lock 0 14 28 Ex_page 420193516 468193687 5001 0 master Non Cursor Lock 0 16 32 Sh_intent 1006623598 0 0 0 master Non Cursor Lock