Profiling and Discovery Sizing Guidelines

Back Next

Relational Data Sources Worksheet

When you run column profiles and scorecards on relational data sources, you need to consider the additional CPU and temporary tablespace requirements on the database. The profile queries require sorting the data that results in further memory requirements for buffer pools.

The following settings determine how effectively the profiling and scorecard tasks run on relational sources:

Maximum DB Connections: The number of database connections. The setting indicates a measure of maximum concurrency for the profile query, which consumes the maximum tablespace.
Maximum Column Size: The maximum size of any column that you can run a profile on. Double the length if the column is Unicode. You cannot run a profile on columns, such as large text columns, CLOBS, and BLOBS.
Maximum Number of Rows: The number of rows in the largest relational table you run the profile on.

Use the following worksheet to record the values:

Metric	Value
Maximum DB Connections
Maximum Column Size
Maximum Number of Rows
Sorting pass*	2
*Sorting pass is the maximum number of passes that the profile queries perform to sort the data.

Calculation

To compute the required relational tablespace that you can use in development deployment, multiply all the values in the Value column.

Rename Saved Search

Table of Contents

Profiling and Discovery Sizing Guidelines

Profiling and Discovery Sizing Guidelines

Relational Data Sources Worksheet

Relational Data Sources Worksheet