View previous topic :: View next topic
|
Author |
Message |
tarun_bhardwaj
New User
Joined: 18 Jul 2003 Posts: 39 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 ! |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
krithikaj
New User
Joined: 10 Aug 2008 Posts: 45 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 |
|
Back to top |
|
|
|