Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Fastload abended with S222

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CA Products
View previous topic :: :: View next topic  
Author Message
chetanambi

New User


Joined: 21 Jan 2012
Posts: 53
Location: India

PostPosted: Sun Jun 14, 2015 10:02 am    Post subject: Fastload abended with S222
Reply with quote

Hi,

We are using FASTLOAD 17.0 utility to for load. Getting below error message and job is getting abended with S222 finally. Can someone please help me to resolve this.

below message is from PTIMSG:
PFL4018W - Errors causing rows to be discarded exceeded 1,000
PFL4018W - Errors causing rows to be discarded exceeded 2,000
PFL4018W - Errors causing rows to be discarded exceeded 3,000
and so on... after reaching a 12,262,000 job seems to be not executing and being cancelled by the operator.
Back to top
View user's profile Send private message

chetanambi

New User


Joined: 21 Jan 2012
Posts: 53
Location: India

PostPosted: Sun Jun 14, 2015 10:06 am    Post subject:
Reply with quote

I got below information :

Errors causing rows to be discarded exceeded nnn

Reason:
The number of errors that are causing rows to be discarded exceeds the value specified by the DISCARD-WARN option. Every time the utility encounters and exceeds the specified number of errors, or a multiple of that number, this warning message appears. When the total number of errors reaches the limits of memory, the utility terminates abnormally with condition code S106.

Action:
Consider stopping the utility before the memory limit is reached.

but not getting how to resolve the issue. Can someone guide me.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7904
Location: Bellevue, IA

PostPosted: Sun Jun 14, 2015 5:43 pm    Post subject:
Reply with quote

What you are describing is a symptom of the problem. The real issue is whatever is causing the rows to be discarded. Once you resolve that problem, the PFL4018W messages will stop and the load will work.

You need to work with your site support group to figure out what error is causing the rows to be discarded. If your site support group cannot help you, you need to contact the vendor and work with the vendor's support. Since you have not provided anything for us to help you, there's not much more we on this forum can tell you, except don't confuse the symptom with the problem.
Back to top
View user's profile Send private message
chetanambi

New User


Joined: 21 Jan 2012
Posts: 53
Location: India

PostPosted: Sun Jun 14, 2015 10:05 pm    Post subject:
Reply with quote

Dear Robert,

Please let me know what details I can provide you. Meanwhile i am trying to get help from site support
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10201
Location: italy

PostPosted: Sun Jun 14, 2015 11:52 pm    Post subject: Reply to: Fastload issue
Reply with quote

Quote:
Please let me know what details I can provide you.



for what reason should Robert do the work for which Your support is getting paid for ???

remember
we reply on OUR OWN time and for FREE !
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7904
Location: Bellevue, IA

PostPosted: Mon Jun 15, 2015 6:10 am    Post subject:
Reply with quote

Presumably error messages are being generated -- somewhere (it is possible that the DD name they are written to is being routed to DUMMY or commented out, in which case your first step would be to make sure those messages are being captured). The messages could be with the FASTLOAD product or they could be with the database itself -- you need to find those messages, interpret their meaning, and use them to resolve the issue. If you are getting the error on every record, for example, you could have a conflict in attributes between the database column definitions and the source data file for FASTLOAD. As I said before, you did not provide any of these error messages and hence there's nothing we can do on this forum to help you resolve the problem. Without something to indicate what error(s) are being generated, we could only guess at the issue and that's not a good way to resolve problems.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CA Products All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts How to identify which DSN has an aben... dineshjyrm JCL & VSAM 14 Fri May 08, 2015 6:13 pm
No new posts Need some help in resolving job abend... tuvi_kp JCL & VSAM 2 Wed Nov 20, 2013 5:37 am
No new posts EXECUTION ABENDED, REASON=X'00E40347'... Jimy Carol DB2 2 Sat Sep 07, 2013 6:35 pm
No new posts Display user error message in SPOOL w... V S Amarendra Reddy DFSORT/ICETOOL 4 Wed Aug 21, 2013 3:11 am
No new posts ABENDED S000 U0016 CN(INTERNAL) narendrabade JCL & VSAM 3 Tue Apr 23, 2013 8:52 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us