IBM MAINFRAME HELP & SUPPORT FORUMS

tarun_bhardwaj · Joined: 18 Jul 2003 Posts: 20 Location: delhi

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 !

dick scherrer · Joined: 23 Nov 2006 Posts: 8601 Location: 221 B Baker St

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.

krithikaj · Joined: 10 Aug 2008 Posts: 23 Location: India

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