Monitor access to SQL batch text is turned off by default when Adaptive Server is installed, so you must configure Adaptive Server to allocate memory for this feature. Consider the following to help you determine how much memory to allocate per user:
SQL batches exceeding the allocated amount of memory are truncated without warning. Therefore, if you do not allocate enough memory for the batch statements, the text you want to view might be the section of the batch that is truncated.
The more memory you allocate for SQL text from shared memory, the less chance there is that the problem statement will be truncated from the batch copied to shared memory. However, the memory you allocate for SQL text reduces the amount of memory for data and procedure caches.
