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

SAP Knowledge Base Article - Preview

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

Symptom

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
xvallen=6


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7 SP100 and later

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

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 , SAP Business Suite on Sybase ASE Database Platform , 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.