Symptom
- After reorg defrag command runs on a partition, defrag_status() returns information of defragmentation operation on the partition.
select defrag_status(db_id(), object_id('test_partition1'), partition_id('test_partition1', 'part09'))
go
---------------------------------------------------------------------------------------------------------
frag index=0.00, pct defrag=100, pages defrag=17, pages gen=17, pages tbd=0, last run=Sep 30 20XX 8:47:48:476PM, executing=0, elapsed mins=0
- However, when alter table split partition command runs on another partition of the same table, information of defragmentation operation from defrag_status() on that partition is deleted.
alter table test_partition1
split partition partnew into (part10 VALUES <= ('2022-10-31'), partnew VALUES <=(MAX))
go
(22 rows affected)
select defrag_status(db_id(), object_id('test_partition1'), partition_id('test_partition1', 'part09'))
go
---------------------------------------------------------------------------------------------------------
frag index=0.00, pct defrag=0, pages defrag=0, pages gen=0, pages tbd=24, last run=, executing=0, elapsed mins=0
Read more...
Environment
- 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
Keywords
827223, CR#827223, CR827223, pages to be defragmented , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Known Error
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview