I am facing some problem with SPACE parameter in JCL.
I have job which reads the table and writes into a file. Number of records to be written is quite high almost 1 Million+.
We are using the SPACE parameter for the output file as
Joined: 06 Jun 2008 Posts: 8212 Location: Dubuque, Iowa, USA
It is not very likely that RLSE has much to do with the performance of your job. I've never heard of it having an impact, and a job run time going from one hour to almost 20 hours would be an impact. Something else is going on that is causing the run time difference.
Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
One difference in the 2 runs was probably the traffic on the system when they were run.
To read some data from a database and write a million or so sequential records should take a few minutes - not hours (depending on how the query performs). If the query(ies) are poorly written for the database or the database is not properly defined, run times are more sensitive to additional traffic on the database.