SAP Knowledge Base Article - Preview

1941891 - Reorg rebuild with text columns slows down performance and consume more space in syslogs - SAP ASE


Reorg rebuild with text columns slower post ASE 15.7 SP100 with spike in log usage because a 'MODIFY' entry will be logged for every text row:

MODIFY        (27330,22)     sessionid=27252,8
attcnt=1 rno=22 op=9 padlen=4 sessionid=27252,8 len=72
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objid=640002280  ptnid=640002280 pageno=2943 offset=1998 status=0x00 (0x0000)
cid=0 indid=255
old ts=0x0000 0x00007f40  new ts=0x0000 0x000087d4



SAP Adaptive Server Enterprise (ASE) 15.7 SP100 and later


SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0


CR749632, 749632, CR#749632, CR750324, 750324, CR#750324, log, image, unitext, FTP, first text page, link pointer, perf, degradation , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Bug Filed

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.