3007584 - Alter table add partition times out - SAP ASE

Alter table to add new partitions runs for over 2hrs and times out
The job is done under one transaction where the last partition is first dropped, new partitions added and the last partition re-added
Using DBArtisan

SAP Adaptive Server Enterprise (ASE) - 15.7 and later

SAP Adaptive Server Enterprise 15.7

alter table, partition, skip_global_index_rebuild , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

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

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