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
 
DSNHLI2- DB2 ABEND code 04E

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

New User


Joined: 18 Jul 2003
Posts: 39
Location: delhi

PostPosted: Wed Aug 20, 2008 3:21 am    Post subject: DSNHLI2- DB2 ABEND code 04E
Reply with quote

Hi,

When I try to delete a row from a table using FileMan for DB2, I get an error message saying
Code:
FM/DB2 has encountered a DB2 ABEND while accessing
DSNHLI2- DB2 ABEND code 04E, reason code 0101.   


I tried to look at the possible solution on the IBM website but could not get any fix for it. Can someone please help me with this ?

Thanks in advance !
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: Wed Aug 20, 2008 5:04 am    Post subject:
Reply with quote

Hello,

Where do you see this error? Online or in some batch execution?

Have you done this successfully before for the same volume of data (or does this happen for only a single row delete)?

If you are online, you might try to do this in batch - it may be that your signon does not have enough memory allocated to your session.

You might also talk with your dba and see of others have had the same abend.
Back to top
View user's profile Send private message
krithikaj

New User


Joined: 10 Aug 2008
Posts: 45
Location: India

PostPosted: Fri Aug 22, 2008 11:15 am    Post subject: DSNHLI2- DB2 ABEND code 04E
Reply with quote

Hi,

First check if there is any utility run on this table with your ID. To do this, go to DB2 Commands and type -DISPLAY UTILTY(*). If you find any, terminate that utility. -TERM UTILITY(*). Then execute RUNSTATS on the table and try running any SQL.

Even if this does not solve your problem, then the table might be out of space.

Thanks,
Krithika J
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 Getting GG return code abdulrafi IMS DB/DC 2 Tue Apr 10, 2018 12:31 pm
No new posts Need help with 002-030 ABEND in TSO R... Terry Tallian TSO/ISPF 0 Sat Mar 17, 2018 1:13 am
No new posts Need help with ABEND RC=S806 RSN=4 an... chong.zhou All Other Mainframe Topics 3 Fri Feb 09, 2018 12:17 am
No new posts IMS error U4038 while executing my PL... abdulrafi IMS DB/DC 2 Thu Feb 08, 2018 1:05 pm
No new posts Conditional setting of return-code af... sanvan COBOL Programming 9 Wed Jan 31, 2018 11:05 pm

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