View previous topic :: View next topic
|
Author |
Message |
priyabrata mohanty
New User
Joined: 04 Mar 2005 Posts: 8 Location: bangalore
|
|
|
|
hi,
i am reading from a ps having 800000 records. the job usually takes 4 hrs to complete. but today it abended with S0C7. from sysdump, i found that it abended while reading a record. now i want to find out , which record caused the abend and that too as quickly as possible (say, within 30 min). can anybody suggest me how to do without using FILE-AID?
thanx in advance.
regards,
Priyabrata. |
|
Back to top |
|
|
mdtendulkar
Active User
Joined: 29 Jul 2003 Posts: 237 Location: USA
|
|
|
|
priyabrata mohanty,
Theres no easy way to find out on which record the program got abended if you do not have checkpoints, counters, displays in your programs.
You will need to analyze the flow of the program, identify the field at which the program gave S0C7 and then identify the valid data for that field and use file-aid to filter and see if any data mismatch is there for that field.
This is a crude way of analysis, see the DUMP for more details. You will need to analyze that only
Regards
Mayuresh |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
One common cause of an 0C7 involves decimal operations on invalid decimal data (PD or ZD format). If that's the problem and you know which PD or ZD fields are being accessed, you could use the VERIFY or DISPLAY operator of DFSORT's ICETOOL to identify the invalid values and the records in which they're located. If you want to know more about this technique, let me know. |
|
Back to top |
|
|
priyabrata mohanty
New User
Joined: 04 Mar 2005 Posts: 8 Location: bangalore
|
|
|
|
hi yeager,
thankx for your reply. i am really interested in the way in which DFSORT can be used to track the problem of finding the record causing soc7 abend. please let me know about it.
is it possible to split the large ps(say,having 800000 recs) to smaller files(say, having 200000 recs each) and find the problem record in less time?
thankx.
priyabrata. |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
You can use a DFSORT/ICETOOL job to identify invalid values in ZD or PD fields. You can either use the VERIFY operator, or the DISPLAY operator (or both). Here's a DFSORT/ICETOOL job that will identify invalid values in a ZD field in positions 21-28 and invalid values in a PD field in positions 41-45.
Code: |
//S1 EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//IN DD DSN=... input file
//TOOLIN DD *
VERIFY FROM(IN) ON(21,8,ZD) ON(41,5,PD)
/*
|
It will only take DFSORT/ICETOOL at most a few minutes (and probably a lot less) to verify 800000 records. DFSORT is generally much, much faster than FileAid.
For more information on using the VERIFY and DISPLAY operators of DFSORT's ICETOOL to identify invalid ZD and PD values, see:
publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA10/6.7.5.9?SHELF=&DT=20050222160456
Quote: |
is it possible to split the large ps(say,having 800000 recs) to smaller files(say, having 200000 recs each) and find the problem record in less time? |
No. It takes less time to just read the file and identify the records with invalid values then to read the file, split it and then read the individual files to identify the records with invalid values. In the first case, you're reading the records once. In the second case, you're reading the records twice. |
|
Back to top |
|
|
yoyowjd
New User
Joined: 07 Mar 2005 Posts: 1
|
|
|
|
Hi Frank
Good Tools~
Thanks for your share~
Regards,
Ever |
|
Back to top |
|
|
lnvrn
New User
Joined: 24 Feb 2005 Posts: 8 Location: Mumbai
|
|
|
|
Hi,
Can u please explain by using File-aid how can we achieve this.
Thanks & Regards |
|
Back to top |
|
|
sekhar_ibm
New User
Joined: 21 Feb 2005 Posts: 5 Location: hyd
|
|
|
|
hai,
can i know,
If any variabe or feald need to change(lenth,datatype) in any program,table or map then how can we find which programes,database tables are effected.tell me if any spufi option is there or any tool.
thanku |
|
Back to top |
|
|
mcmillan
Site Admin
Joined: 18 May 2003 Posts: 1210 Location: India
|
|
|
|
That's the reason why we are maintaining doccuments. You have to review your doccuments for that. |
|
Back to top |
|
|
|