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
 

 

Error 0226 while trying to Erase

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IDMS/ADSO
View previous topic :: :: View next topic  
Author Message
satinspace

New User


Joined: 28 Sep 2005
Posts: 3

PostPosted: Tue Dec 16, 2008 7:18 pm    Post subject: Error 0226 while trying to Erase
Reply with quote

Hi all,

I am encountering an error status 0226 while executing an ERASE statement. The record which is being erased is present in the database and it is obtained making it current before executing the ERASE. The OBTAIN statement was successful but I am getting an 0226 error for the ERASE. Below is the ERASE statement used in the code.

ERASE <Record name> PERMANENT MEMBERS

Please provide me any possible reasons for this error.
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 Dec 17, 2008 12:30 am    Post subject:
Reply with quote

Hello and welcome to the forum,

I don't "do" idms, but does this not point to the problem (the bold is mine)?
Quote:
26 Either no duplicates exist for the named record or the record name or SPF index entry cannot be found.
Back to top
View user's profile Send private message
Uday Kumar R

New User


Joined: 07 Nov 2007
Posts: 25
Location: Mumbai

PostPosted: Fri Dec 19, 2008 12:35 am    Post subject:
Reply with quote

Hi,

Probably an broken chain issue. Try to use the command

Erase <Record name> members all

Please let me know if i am wrong.
Back to top
View user's profile Send private message
satinspace

New User


Joined: 28 Sep 2005
Posts: 3

PostPosted: Fri Dec 19, 2008 3:50 pm    Post subject:
Reply with quote

Hi Uday,

Thanks for the reply. Can you explain more about the broken chain issue you were talking about?..
Back to top
View user's profile Send private message
sudharsan.soundararajan
Warnings : 1

New User


Joined: 15 Oct 2008
Posts: 17
Location: Chennai

PostPosted: Fri Dec 19, 2008 6:18 pm    Post subject: Reply to: Error 0226 while trying to Erase
Reply with quote

Hi All,

I too want to Know about the BROKEN-CHAIN.

Satinspace,

Is this abort coming for the first record itself or when trying a series of data.

Please forgive me if i am wrong.
Back to top
View user's profile Send private message
Uday Kumar R

New User


Joined: 07 Nov 2007
Posts: 25
Location: Mumbai

PostPosted: Sat Dec 20, 2008 1:29 am    Post subject:
Reply with quote

Hi Santosh and Sudarsan,

I am not aware in details the reason behind why the issue exactly happens. As per my knowledge - A bad db key has get extracted from a record's , while it was moving in the record set.

Another version is say suppose when a update job running in local mode and after completeion of this job all the areas to be recovered once completion of the run unit, if they are not recovered properly then issue may happens.

One more version is if a retreval job try to retreive a record while an update job using the same record for updating purpose, at that time there is possibly of loosing the currency it is also called as Broken chain.

Usually if this happens in any job, we hold for a couple of minutes and run the job from abending step which executes properly in the next run.

Please let me know if i am going wrong.

Regards,
Uday
Back to top
View user's profile Send private message
satinspace

New User


Joined: 28 Sep 2005
Posts: 3

PostPosted: Mon Dec 29, 2008 7:50 pm    Post subject: Issue resolved
Reply with quote

Thanks everyone for your help.

This issue has been resolved finally. The record which I was trying to erase was a part of a set which was corrupted. This was discovered by our DBA. This corruption was patched out using the IDMSPFIX (fix page) utility. Then the record was successfully erased from DB.
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: Mon Dec 29, 2008 9:55 pm    Post subject: Reply to: Error 0226 while trying to Erase
Reply with quote

Good to hear it is now working - thank you for letting us know icon_smile.gif

d
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 -> IDMS/ADSO All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Getting error while opening a variabl... apandey1 COBOL Programming 5 Fri May 05, 2017 12:22 pm
No new posts IDC2902I Error tzeche ABENDS & Debugging 2 Tue Mar 28, 2017 11:39 am
No new posts Need help with below DB2 error ashek15 DB2 3 Sat Mar 18, 2017 5:56 am
No new posts FINDREP Syntax Error seahawk789 DFSORT/ICETOOL 4 Thu Mar 09, 2017 10:11 pm
No new posts INVOKE WEBSERVICE error danik56 CICS 11 Thu Mar 09, 2017 11:52 am


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