Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Bulk Insert to table - Abend S04E, REASON=X'00E40345'

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
rexx77

New User


Joined: 14 Apr 2008
Posts: 78
Location: Mysore

PostPosted: Wed Jun 10, 2009 3:38 pm    Post subject: Bulk Insert to table - Abend S04E, REASON=X'00E40345'
Reply with quote

Greetings.

I am trying to load a file which has over 65 million records to test region table using DSNUPROC procedure.

Job failed with S04E abend. I googled for that and there was mention in some forum to create SORT WORK FILES in TAPE to overcome this issue.

i gone through the manuals for what should be the DD statement for TAPE datasets, but i am not able to get any useful information.( I dont know the VOL, SER,Label parameters for my shop mainframe tapes)

Can anyone here help me in giving any idea in Bulk Loading data to DB2 tables and/or help me in creating the datasets in TAPE (Temporary SORT work files).

Thanks in advance.
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10308
Location: italy

PostPosted: Wed Jun 10, 2009 3:49 pm    Post subject: Reply to: Bulk Insert to table - Abend S04E, REASON=X'00E403
Reply with quote

we do not know anything about Your environment,
any suggestion might be wrong

speak to Your support, the should know
Back to top
View user's profile Send private message
rexx77

New User


Joined: 14 Apr 2008
Posts: 78
Location: Mysore

PostPosted: Wed Jun 10, 2009 3:57 pm    Post subject:
Reply with quote

Thanks for your quick reply. Do you have any idea of how to insert bulk data to tables......
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Wed Jun 10, 2009 4:05 pm    Post subject:
Reply with quote

Quote:
over 65 million records
Just for an experiment, if you try with less number of records, what happens?
Back to top
View user's profile Send private message
rexx77

New User


Joined: 14 Apr 2008
Posts: 78
Location: Mysore

PostPosted: Wed Jun 10, 2009 4:13 pm    Post subject:
Reply with quote

Actually before loading to table i am sorting the Input file. When i speify Stopafter 999999 records in sorting and if i load the sorted file to table then it is successfully loaded.

But my testing team is not finding records which match their conditions.
That is the reason i would like to insert all the records available in the file

Any inputs?
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Wed Jun 10, 2009 5:04 pm    Post subject:
Reply with quote

Quote:
But my testing team is not finding records which match their conditions.


sounds as if you need to isolate those records which will satisfy your test-teams requirements,
and then load those,
if you can not solve your 'total' file load.
Back to top
View user's profile Send private message
rexx77

New User


Joined: 14 Apr 2008
Posts: 78
Location: Mysore

PostPosted: Wed Jun 10, 2009 6:30 pm    Post subject:
Reply with quote

Not like that.

The 1 million records which i have loaded is belongs to some other partition data which is present in the file. They need to test with the other partitions data which is also available in the same file.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Jun 11, 2009 5:57 am    Post subject:
Reply with quote

Hello,

Quote:
They need to test with the other partitions data which is also available in the same file.
Yes, we understand this. . .

What reason is there preventing selectively copying some records they do need from the file to load, rather than just using the first million. . .?
Back to top
View user's profile Send private message
shyamkumarnagabandi

New User


Joined: 12 May 2009
Posts: 7
Location: hyderabad

PostPosted: Fri Jun 19, 2009 12:39 pm    Post subject:
Reply with quote

i think its better to run the 'COPY TABLESPACE DATABASE_TABLENAME'
before loading the data to the table...
please let me know if it is wrong...
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Jun 19, 2009 8:13 pm    Post subject:
Reply with quote

Hello,

How does this help the s04e abend?
Back to top
View user's profile Send private message
shyamkumarnagabandi

New User


Joined: 12 May 2009
Posts: 7
Location: hyderabad

PostPosted: Mon Jun 22, 2009 3:42 pm    Post subject:
Reply with quote

sorry...Actually i got the abend as S04E, but after again submitting the Job it has run succesfully
with out any changes..but i dont why it was happened like that....

Reasons for getting the Abend S04E is:
--Resource unavailable
--A decimal packed field contained non-numeric data when an INSERT or an UPDATE SQL statement was executed
--An SQL WHERE clause in a cursor contains a packed numeric working storage field that contains non-numeric data when the OPEN CURSOR statement is executed. Initialize the field or remove it from the SQL statement if not used.
Back to top
View user's profile Send private message
suresh1624

New User


Joined: 21 Nov 2007
Posts: 28
Location: chennai

PostPosted: Mon Jun 29, 2009 10:04 pm    Post subject:
Reply with quote

Quote:
The 1 million records which i have loaded is belongs to some other partition data which is present in the file. They need to test with the other partitions data which is also available in the same file.



looks like you are loading a partition table. split the file based on your patition key and try to load independently each partition. also can u please post the table definition you are loading and the o/p messages you got while loading.
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 -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Insert a Row_number into table useit DB2 2 Tue Sep 19, 2017 1:07 pm
No new posts how to see when the last read access ... Mike 1304 DB2 1 Tue Sep 12, 2017 7:52 pm
No new posts PC (UTF-8) -> z/OS (EBCDIC) -> ... prino All Other Mainframe Topics 4 Fri Sep 01, 2017 1:47 am
No new posts Adding a userid to SMTP Security table Yolanda Harvey JCL & VSAM 1 Sun Aug 13, 2017 6:16 pm
No new posts Loading data to table gives wrong for... Raghu navaikulam DB2 19 Thu Jul 13, 2017 2:11 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us