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
 

 

-803 related questions

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
pch1982cn

New User


Joined: 02 Apr 2006
Posts: 10
Location: Dalian.China

PostPosted: Mon Apr 03, 2006 8:36 pm    Post subject: -803 related questions
Reply with quote

DSNT408I SQLCODE = -803, ERROR: AN INSERTED OR UPDATED VALUE IS INVALID BECAUSE INDEX IN INDEX SPACE FMSXCCO1
CONSTRAINS COLUMNS OF THE TABLE SO NO TWO ROWS CAN CONTAIN DUPLICATE VALUES IN THOSE COLUMNS. RID OF EXISTING
ROW IS X'000064CA20
DSNT418I SQLSTATE = 23505 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXRUID SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = -110 13172739 0 13817814 -490143744 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'FFFFFF92' X'00C90003' X'00000000' X'00D2D7D6' X'E2C90000' X'00000000' SQL DIAGNOSTIC
INFORMATION

For this error message, could we identify which record is duplicated using the row ID '000064CA20'? or only used by utilities?
Does the row ID assign to each row dynamically? for example, if some rows were deleted, will their ID be released and assign to other new rows?
Back to top
View user's profile Send private message

martin9

Active User


Joined: 01 Mar 2006
Posts: 288
Location: Basel, Switzerland

PostPosted: Mon Apr 03, 2006 9:15 pm    Post subject:
Reply with quote

hy pch1982cn,

note: sql -803 you get on the index part, not on the data part.
therefore code in your program some displays, whenever
sql -803 occurs, write out the keys...
this will help you immediately....

martin9
Back to top
View user's profile Send private message
pch1982cn

New User


Joined: 02 Apr 2006
Posts: 10
Location: Dalian.China

PostPosted: Mon Apr 03, 2006 10:14 pm    Post subject:
Reply with quote

Thanks martin9.

Yes, this is a good way to trace problem icon_smile.gif

But the row ID is just for index information? cannot associate to the data part manually? i.e. we cannot know which row is it by the row ID .. ?
Back to top
View user's profile Send private message
Jag

New User


Joined: 07 Dec 2005
Posts: 30
Location: India

PostPosted: Tue Apr 04, 2006 8:11 am    Post subject: Hi friends
Reply with quote

Hi ,

The -803 as all of you know it comes due to the voilation of the primary key.When a row is insteredor updated where the primary key data of the row is equal to the primary key data if the row (Which already exists)..


Then come to the ROWID part..Its a memory refernce of the rows which you used to get the rows at the time of the data retirevl etc...The Row Id's are stored in the statistics of the DB2..When a row of table is deleted the corresponding ROW ID may be used by another row (AS another row inserted may be stored in that particular memeroy location)..


I hope i gave some useful information to you ... :-)


Cheers,
Jag,
Email: ***EMail ID REMOVED... Read Forum Rules***
Back to top
View user's profile Send private message
pch1982cn

New User


Joined: 02 Apr 2006
Posts: 10
Location: Dalian.China

PostPosted: Tue Apr 04, 2006 12:31 pm    Post subject:
Reply with quote

thanks Jag!
Back to top
View user's profile Send private message
Jag

New User


Joined: 07 Dec 2005
Posts: 30
Location: India

PostPosted: Wed Apr 05, 2006 7:29 am    Post subject: One more point
Reply with quote

I forgot to add one imprtant point..

As i said the ROW ID can be resued but only after the REORG..is done..Till then the refernce will be deleted from the DB2 catalog. The deleted record will be there in the specified memory location physically...When the REORG is done the system will rearragne the rows and catalog the info once again..when the Row id can be used again..

Cheers,
Jag,
Email: ***EMail ID REMOVED... Read Forum Rules***
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 -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Mainframe Interview Questions CICS,CO... akshathan Mainframe Interview Questions 6 Thu Feb 09, 2017 6:38 pm
No new posts Viewing executing process in NDM .. q... Debb.Brant IBM Tools 0 Wed Dec 14, 2016 10:55 pm
No new posts INCLUDE condition questions van bui DFSORT/ICETOOL 1 Thu Jun 30, 2016 9:52 am
No new posts SAS Programming - Basic Questions Techelm All Other Mainframe Topics 3 Fri Mar 18, 2016 10:53 pm
No new posts SQL Order By related question Joseph K Thomas DB2 8 Fri Mar 18, 2016 12:53 pm


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