View previous topic :: View next topic
|
Author |
Message |
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
Hi,
Somtimes I feel I'm still a kid and 'am back to the square one, a lot more to learn yet...
Today, I was doing kind of an experiment with VSAM file and got condition code 12 with following message in SYSPRINT:
Code: |
IDC31467I MAXIMUM ERROR LIMIT REACHED.
IDC0005I NUMBER OF RECORDS PROCESSED WAS 14
IDC3003I FUNCTION TERMINATED. CONDITION CODE IS 12 |
After looking into documentation for IDC31467I, it says:
Quote: |
IDC31467I MAXIMUM ERROR LIMIT REACHED
Explanation: The number of errors encountered has reached the error limit value.
System Action: Processing terminates.
Application Programmer Response: If ERRORLIMIT value is too low, set a different value and rerun the job. ERRORLIMIT has a default value (you may wish to allow REPRO to detect more errors than the default value) and rerun the job.
Source: DFSMSdfp
Detecting Module: IDCI001 |
My concerns are:
1. What is this "ERRORLIMIT"?
2. Is this something site-specific and set by system-programmers?
3. If answer to second quesion is yes, can we override this limit? |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
It seems this,
Quote: |
(you may wish to allow REPRO to detect more errors than the default value) |
from the quote from previous post, can be a key to my concerns. But how do I wish that? By asking my system programmers or some thing is available to poor application engineers as well? |
|
Back to top |
|
|
superk
Global Moderator
Joined: 26 Apr 2004 Posts: 4652 Location: Raleigh, NC, USA
|
|
|
|
Anuj, my first question is:
As an "Application Engineer (to use your term )" why would you opt to use IDCAMS? I usually consider it to be best left to the storage engineers, and instead would use a SORT product whenever possible. As a longtime Moderator in these forums I've always been puzzled as to why IDCAMS is usually being pushed over the much more user-friendly SORT products.
Anyway, I see that ERRORLIMIT is a parameter for the REPRO command, and is probably a parameter for others as well. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
Anuj,
you know that I love this.....
5th or 6th item in REPRO syntax is what I think you are looking for.
by the way, why do you want to override this limit instead of correcting your input file? |
|
Back to top |
|
|
Terry Heinze
JCL Moderator
Joined: 14 Jul 2008 Posts: 1249 Location: Richfield, MN, USA
|
|
|
|
Quote: |
...I've always been puzzled as to why IDCAMS is usually being pushed over the much more user-friendly SORT products. |
Just a guess, but could it be because IDCAMS dealt with VSAM files before any of the SORT products did, and some folks still use it out of force of habit? |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
Hi Kevin,
I need to create a brand new VSAM file for one of my application upgrade, so IDCAMS was an obvious choice.
Quote: |
..why IDCAMS is usually being pushed over the much more user-friendly SORT products. |
'am pretty sure by this quote you did not mean "Sort can create a VSAM file" -- but dumb in me is reading that sentence of yours again and again to understand what exactly the indication is... |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
Hi Dick,
Quote: |
why do you want to override this limit instead of correcting your input file? |
Yeah that's what I did as a solution -- corrected the input file. Actually the error which made me raise my eye-brows is
Code: |
IDC0005I NUMBER OF RECORDS PROCESSED WAS 14 |
I was thinking why "14"; why not more or less? |
|
Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8697 Location: Dubuque, Iowa, USA
|
|
|
|
Anuj, probably some of the records were okay and some were not. I believe (but don't quote me) the default is 4 errors allowed (fifth one ends the run), so if records 1 through 9 were copied okay and the next 5 all were duplicates of existing records, you could get 14 processed. |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
Quote: |
Just a guess, but could it be because IDCAMS dealt with VSAM files before any of the SORT products did, and some folks still use it out of force of habit? |
Oh Terry -- I'm still too young, from mainframes perpesctive, to have something as habit... |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
Robert,
Yes that is a different approach; and I would like to look into that. Let me check, Thanks. |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
one reason to use IDCAMS is that it has some logic processing capabilities for command sequences |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
Anuj,
What exactly are you doing with the VSAM file.
All that you have said is that you were doing a kind of experiment.
We're not psychcic you know |
|
Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
Anuj Dhawan wrote: |
'am pretty sure by this quote you did not mean "Sort can create a VSAM file" -- but dumb in me is reading that sentence of yours again and again to understand what exactly the indication is... |
Hi Anuj,
The answer might be: Since the error came up during a REPRO and not during a DEFINE. |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
LOL - I was missing you Expat sir.
This is the full-program, stuff is kinda site-specifc:
1. Need to create a "History file (HF)"; which will have 3-years of data.
2. We need to create weekly report by referring HF file; This HF would be a VSAM.
3. I'm descoping an old Technology (FoxPro), so they (FoxPro perosnnels) will provide me data which I need to put in this VSAM.
4. On first run of my job in production I need this VSAM already available.
5. This VSAM will be "populated" using a file from other source so I used a test-file which was surely not up to the mark as far as the key of the VSAM are concerned. And probably that created the problem and then that "14" made me in deee....eeep thinking...
hff....fff... putting that (garbase) stuff above was a good labor... , see my eyes are just coming out.. |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
Apart from duplicate keys as already suggested, what about the option that the input file to the repro is not in key sequence order. |
|
Back to top |
|
|
|