LinkedIn
Copied!

Table of Contents

Viewing column BLOB size

Version:

Only available versions of this content are shown in the dropdown

You can view the size of columns that use a binary large object (BLOB) on your internal PegaRULES and PegaDATA databases on Pega Cloud using Schema Tools.

You need the PegaRULES:DatabaseAdministrator role to access Schema Tools. For more information, see Adding a role to an access group.

Pega Platform uses Query Runner, Query Inspector, and Schema Tools for Pega Cloud clients to interface with their database. These database tools are not available for on-premises clients.

This operation might be time consuming and should not be performed during peak production hours. The operation continues in the background if you leave the Schema Tools landing page. The retrieved values are displayed the next time you view the column details.

  1. In the header of Dev Studio, click Configure System Database Schema Tools .

  2. Expand the database schema tree and select the column you want to view.

  3. Click Get BLOB sizes to get initial sizing of BLOB columns.

  4. Click Refresh BLOB sizes to refresh sizing of BLOB columns after initial sizing.

Did you find this content helpful?

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.