Package binding effects of DEGREE(ANY) & DEGREE(1)

sushanth bobby · Posted: Wed Jan 28, 2009 12:15 pm

Hi,

Can i know, what are the effects of binding a package with DEGREE(ANY) & DEGREE(1). What i found is increase in package avgerage size, when i converted it from degree(1) --> degree(any).

Sushanth

sushanth bobby · Posted: Wed Jan 28, 2009 12:23 pm

Hi again,

I Know DEGREE(1) - means 'No parallel Processing'
DEGREE(ANY) - means 'Allows parallel processing'

Why there is an increase in package avgsize, regards to this ?

Sushanth

Anuj Dhawan · Posted: Wed Jan 28, 2009 4:34 pm

Hi,

A plan or package that is bound with DEGREE(ANY) can require 50 to 70% more storage for the CTs and PTs in the EDM pool than one bound with DEGREE(1). If you change a plan or package to DEGREE(ANY), check the change in the column AVGSIZE in SYSPLAN or SYSPACKAGE to determine the increase required.

sushanth bobby · Posted: Wed Jan 28, 2009 7:13 pm

Yes Anuj,

I check the catalog tables before & after changes from DEGREE(1) --> DEGREE(ANY). There is an increase in the AVGSIZE.

What i wanted to know is WHY ? more storage is required for the package when changing its parallelism(no parallel --> parallel).

Sushanth