IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

ABEND S04E when loading table
IBM Mainframe Forums -> DB2
Post new topic   Reply to topic Quick References
View previous topic :: View next topic  
Author Message
anjankumar_r

New User


Joined: 22 May 2008
Posts: 7
Location: India
PostPosted: Thu Apr 09, 2009 7:47 pm
 Reply with quote
Friends,

ABEND S04E when loading table
I'm getting exactly the same problem while DB2 loading. When i was searching for a solution, i came to here and couldn't find any solutions.
Can somebody help me?

Pls ask if you require any more information.

I use the below JCL for loading.
Code:

//D1OFF1NA JOB (2992),'LOAD-CIFDFB',NOTIFY=D1OFF1N,   
//         CLASS=2,MSGCLASS=X,MSGLEVEL=(1,1)         
//LOAD11  EXEC DSNUPROC,PARM='BSRV,LOADAA',REGION=0M 
//SORTOUT  DD UNIT=DISK,SPACE=(CYL,(200,100),,,ROUND)
//SORTWK01 DD UNIT=DISK,SPACE=(CYL,(200,100),,,ROUND)
//SORTWK02 DD UNIT=DISK,SPACE=(CYL,(200,100),,,ROUND)
//SORTWK03 DD UNIT=DISK,SPACE=(CYL,(200,100),,,ROUND)
//SORTWK04 DD UNIT=DISK,SPACE=(CYL,(200,100),,,ROUND)
//SYSMAP   DD UNIT=DISK,SPACE=(CYL,(200,100),,,ROUND)
//DSNTRACE DD SYSOUT=*                               
//SYSUT1   DD UNIT=DISK,SPACE=(CYL,(200,100),,,ROUND)
//SYSREC00 DD DSN=D1DPP.DMACP200.PMACFMAD,DISP=SHR   
//SYSIN    DD DSN=D1DPP.TB2000.PUNCH,DISP=SHR         
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy
PostPosted: Thu Apr 09, 2009 7:53 pm
 Reply with quote
Quote:
Can somebody help me?


did You ask Your support ???

the input jcl is pretty useless for problem etermination
what is needed is the job output

but the fastest approach would be, as I said, to contact Your support
Back to top
View user's profile Send private message
Terry Heinze

JCL Moderator


Joined: 14 Jul 2008
Posts: 1249
Location: Richfield, MN, USA
PostPosted: Fri Apr 10, 2009 2:34 am
 Reply with quote
Did you check what MVS System Codes says about an S04E?
Back to top
View user's profile Send private message
anandinmainframe

Active User


Joined: 31 May 2007
Posts: 171
Location: India
PostPosted: Fri Apr 10, 2009 9:33 am
 Reply with quote
anjankumar,
Its a Data Connectivity problem. Once you Save, Refresh the dataset it will work.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
PostPosted: Fri Apr 10, 2009 9:49 am
 Reply with quote
Hello,

Quote:
Once you Save, Refresh the dataset it will work
Save what?

Which dataset would you "refresh"?
Back to top
View user's profile Send private message
anandinmainframe

Active User


Joined: 31 May 2007
Posts: 171
Location: India
PostPosted: Fri Apr 10, 2009 10:08 am
 Reply with quote
Hi Dick,
The datasets in the JCL
D1DPP.DMACP200.PMACFMAD,DISP=SHR
DSN=D1DPP.TB2000.PUNCH,DISP=SHR
can be saved before loading

Correct me if i am wrong.[/quote]
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
PostPosted: Fri Apr 10, 2009 10:26 am
 Reply with quote
Hi Anand,

I am still conmfused about which datasets might be save and/or refreshed. When my systems refresh anm input file it is because the input file was corrupt and needed to be re-created by whatever pocess initially created the data.

Possibly, there is something i do not yet understand. . . icon_confused.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 

Similar Topics
Topic Forum Replies
No new posts Load new table with Old unload - DB2 DB2 6
No new posts Pulling a fixed number of records fro... DB2 2
No new posts ISAM and abend S03B JCL & VSAM 10
No new posts Multiple table unload using INZUTILB DB2 2
No new posts Check data with Exception Table DB2 0
Search our Forums:

Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us