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

DSNHLI2- DB2 ABEND code 04E


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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

Moderator Emeritus


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

PostPosted: Wed Aug 20, 2008 5:04 am
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts run rexx code with jcl CLIST & REXX 15
No new posts Compile rexx code with jcl CLIST & REXX 6
No new posts ISAM and abend S03B JCL & VSAM 9
No new posts REXX code to expand copybook in a cob... CLIST & REXX 2
No new posts VSAM return code 23 - for a Random read COBOL Programming 4
Search our Forums:

Back to Top