MVSFORUMS.com

RajSanj · Beginner Joined: 17 Mar 2006 Posts: 15 Topics: 7

Hi,

Can someone suggests, what are possible reasons for high EXCPS in the system?

Regards,
Raj

Phantom · Posted: Wed Mar 22, 2006 2:38 am Post subject:

Rajsani,

Your question is very vague. High EXCPs could be because of several reasons.
1. Inefficient programming logic.
2. Using Flat file in areas where VSAM could have been better.
3. Using BLSR option in JCL for Random Read of VSAM could reduce EXCPs and elapsed time. Otherwise, EXCPs might be high.

Tell us what your job does. We can see what might have been the problem.

Thanks,
Phantom

Bill Dennis · Posted: Wed Mar 22, 2006 9:22 am Post subject:

Also, too small of BLOCKSIZE on files.
_________________
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.

RajSanj · Beginner Joined: 17 Mar 2006 Posts: 15 Topics: 7

Thanks Phantom & Bill for your inputs,

We are unzipping a file on TAPE & also hitting database of size 70 million rows for every record.

Please suggest.

Regards,
RajSanj