View previous topic :: View next topic |
Author |
Message |
Vinodch Beginner
Joined: 23 Dec 2002 Posts: 80 Topics: 32 Location: Chennai, India
|
Posted: Tue Sep 13, 2005 4:16 pm Post subject: USAGE OF REGION PARAMETER |
|
|
Hi
Using the parameter "REGION" on JOB and EXEC statement has any impact on job execution time ?
Thanks,
VInod. _________________ Thanks,
Vinod. |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12375 Topics: 75 Location: San Jose
|
|
Back to top |
|
|
Bill Dennis Advanced
Joined: 03 Dec 2002 Posts: 579 Topics: 1 Location: Iowa, USA
|
Posted: Fri Sep 16, 2005 3:00 pm Post subject: |
|
|
Some specialized programs, such as SORT, can run much faster given enough REGION. Unfortunately, the actual size used by SORT can be limited by internal parameter settings so REGION may have no affect. You can experiment and look at SORT messages.
Most user-written code will not be helped by a larger REGION. _________________ Regards,
Bill Dennis
Disclaimer: My comments on this foorum are my own and do not represent the opinions or suggestions of any other person or business entity. |
|
Back to top |
|
|
|
|