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
 

 

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 JCL to Set Return code based on DB2 S... vinu78 DB2 17 Mon Mar 13, 2017 9:47 pm
No new posts IMS region inactive - User abend code... gthmrj IMS DB/DC 5 Tue Mar 07, 2017 12:29 pm
No new posts CA Workload Automation event code help vinu78 CA Products 10 Wed Mar 01, 2017 10:05 am
No new posts MAX-RC 88 and Return code 606 in DFH0... lind sh CICS 2 Tue Jan 24, 2017 1:23 pm
No new posts How to Capture the Max return code of... anilkumar922 All Other Mainframe Topics 2 Thu Jan 12, 2017 12:02 pm


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