ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

S0c4 archiving SQLSTMT text when 32K is specified for OF/PF length


Article ID: 133600


Updated On:


SYSVIEW Performance Management Option for DB2 for z/OS


Increasing the length of the SQLSTMT from (OF=A4000,PF=A4000) to (OF=A32000,PF=A32000)  causes an AbendS0C4 in the job.  Does IDB2 impose any line length limitation?


A line length limitation of ~30K is imposed.


Release : 19.0

Component : CA Insight Database Performance Monitor for DB for z/OS


There is a limit of 32K on an internal collection buffer. However, this buffer also contains some universally collected data, so in practice the available space is ~30K per report line. 

Additional Information

In r20, there has been added extra internal checks to enforce this limit, thus preventing the S0C4 abend.