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
 

 

U0828 Abend - Duplicate Index NI status code

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
View previous topic :: :: View next topic  
Author Message
supreethi.srid

New User


Joined: 15 Oct 2009
Posts: 5
Location: Chennai,India

PostPosted: Thu Mar 04, 2010 6:41 pm    Post subject: U0828 Abend - Duplicate Index NI status code
Reply with quote

Hi,

I am stuck with an abend - U0828 , am here to find a way to get rid of it.

I am trying to run an IMS DLI program that tries to insert / delete / replace segments based on values and validations from the input file. I am using two database clusters - one DB and one its index.

My program is able to process a few records without issues, but few records give me a status code of 'NI' while ISRT call.

I tried to bypass these records by evaluating PSBmask of ISRT call-status(in case of 'NI' status), but still error persists.

Quickref :
"Index Maintenance attempted to insert a new index entry, with index
specified as unique, and encountered a duplicate index entry.
If duplicate secondary index entries occur, the index should be specified
non-unique, and an overflow entry-sequence (EDS) data set should be
provided. If running batch, backout should be executed to resynchronize
data base indexes. "

I dont want to change the index segment as non-unique in the DBD.

Can someone let me know a solution to solve this abend?
Appreciate early response!
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10254
Location: italy

PostPosted: Thu Mar 04, 2010 8:06 pm    Post subject: Reply to: U0828 Abend - Duplicate Index NI status code
Reply with quote

Quote:
I dont want to change the index segment as non-unique in the DBD.
Can someone let me know a solution to solve this abend?
Appreciate early response!


I wonder how You were able to get the NI status code

usually IIRC the abend is scheduled before letting You process the status code


options :
1) the one You do not want to implement
2a) do not insert anything that would cause the issue described ( before the damage )
2b) ugly commit after very succesfull operation
rollback and log the invalid update attempt ( after the damage )
anyway ) review the applications design/requirements/constraints

do not complain about the reply, Your issue was clearly described by the status code itself
nothing reasonable can be done about data/operations that violate the data base specifications/implementation
Back to top
View user's profile Send private message
supreethi.srid

New User


Joined: 15 Oct 2009
Posts: 5
Location: Chennai,India

PostPosted: Thu Mar 04, 2010 10:13 pm    Post subject:
Reply with quote

Quote:
usually IIRC the abend is scheduled before letting You process the status code


Ha! Good Grief, I happened to suspect it !..

2a) seems to be good . Will try that ! Lets c.
Thank You Enrico !
Back to top
View user's profile Send private message
supreethi.srid

New User


Joined: 15 Oct 2009
Posts: 5
Location: Chennai,India

PostPosted: Sun Apr 18, 2010 8:25 am    Post subject: Reply to: U0828 Abend - Duplicate Index NI status code
Reply with quote

Finally it happened to be an issue with my test database - that had 'pointer errors' as reported by DBAs...The DB was corrupted even before i ran my test ! Got the prod image copy extracts and checked - It ran fine !!!!
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 -> IMS DB/DC All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Testing rerad cursor for status with ... John F Dutcher DB2 7 Fri May 19, 2017 9:35 pm
No new posts Job failing with USER = 4093 REASON C... Pradeepa S ABENDS & Debugging 1 Wed May 17, 2017 3:35 pm
No new posts Using ICETOOL, how we can seperate th... bshkris SYNCSORT 5 Tue May 09, 2017 8:33 pm
No new posts COBOL Code Parsers and Lineage Establ... balimanja COBOL Programming 2 Tue May 02, 2017 3:30 am
No new posts Cobol upgrade - source code missing f... gthmrj IBM Tools 1 Wed Apr 26, 2017 6:04 pm


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