tarun_bhardwaj New User Joined: 18 Jul 2003 Posts: 39 Location: delhi
When I try to delete a row from a table using FileMan for DB2, I get an error message saying
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 !
dick scherrer Site Director Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
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.
krithikaj New User Joined: 10 Aug 2008 Posts: 45 Location: India
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.
All times are GMT + 6 Hours