SAP Knowledge Base Article - Preview

2533361 - Empties partitions remain after selective deletion - SAP BW on ASE

Symptom

  • Selective deletion was run for an infocube, however when you check the partitions using ABAP report RSSYBPARTMON the partitions are there, with 0 rows, ie:

DB table = /BIC/E<table>
Partition type = RANGE
Number of partitions = 122
Estimate number of rows = 345477536
Data change = 4 %
Partition key(s) = SID_0CALMONTH

Partition Name Est. # of rows Condition Data change %
/BIC/E<table>_0000200612 0 VALUES <= (200612) 0  
/BIC/E<table>_0000200701 0 VALUES <= (200701) 0
/BIC/E<table>_0000200702 0 VALUES <= (200702) 0
/BIC/E<table>_0000200703 0 VALUES <= (200703) 0
/BIC/E<table>_0000200704 0 VALUES <= (200704) 0
/BIC/E<table>_0000200705 0 VALUES <= (200705) 0
/BIC/E<table>_0000200706 0 VALUES <= (200706) 0
/BIC/E<table>_0000200707 0 VALUES <= (200707) 0
/BIC/E<table>_0000200708 0 VALUES <= (200708) 0
/BIC/E<table>_0000200709 0 VALUES <= (200709) 0
/BIC/E<table>_0000200710 0 VALUES <= (200710) 0
/BIC/E<table>_0000200711 0 VALUES <= (200711) 0
/BIC/E<table>_0000200712 0 VALUES <= (200712) 0
/BIC/E<table>_0000200801 2774125 VALUES <= (200801) 0      <<<< all partitions with data older than 200801 are empties

  • You would like to know how to completely surpress unnecessary empties partitions from E table.

Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP Business Warehouse - All versions 

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP Business Warehouse all versions

Keywords

merge, deletion, archived, partitions , KBA , BW-SYS-DB-SYB , BW on Sybase ASE Database Platform , 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.