Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > IBM DB2 > IDENTITY PK-FK ...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 12 Topic 8892 of 9520
Post > Topic >>

IDENTITY PK-FK corruption of data

by stegze <stegze@[EMAIL PROTECTED] > May 19, 2008 at 05:08 AM

Hi All,

I have a problem with a DB2 server of my customer. It is a Debian
Linux running DB2 Express-C. I have an IDENTITY field as PK in a table
and I use this value as FK in another table. Two weeks ago the FK
values got corrupted or mixed up somehow. I also got some warnings
about system tem****ary table spaces so I created a 16K page size
system tem****ary table space to be sure. All seemed to be okay until
today. Something happened an hour ago and the FK field now holds
corrupt data. The guys at the local IBM sup****t say that it is most
likely that the client program connecting to DB2 has something to do
with it. I think it doesn't fit the situation becasue the client
program has been shut down for the weekend and it still is besides it
never updates key fields at all. Has anyone seen something like this
before? What can I do?

Thanks,
Sandor
 




 12 Posts in Topic:
IDENTITY PK-FK corruption of data
stegze <stegze@[EMAIL   2008-05-19 05:08:01 
Re: IDENTITY PK-FK corruption of data
Serge Rielau <srielau@  2008-05-19 09:35:29 
Re: IDENTITY PK-FK corruption of data
stegze <stegze@[EMAIL   2008-05-19 06:52:48 
Re: IDENTITY PK-FK corruption of data
Serge Rielau <srielau@  2008-05-19 11:19:54 
Re: IDENTITY PK-FK corruption of data
stegze <stegze@[EMAIL   2008-05-19 10:42:41 
Re: IDENTITY PK-FK corruption of data
Serge Rielau <srielau@  2008-05-19 14:59:49 
Re: IDENTITY PK-FK corruption of data
"juraj.hrapko@[EMAIL  2008-05-19 11:11:51 
Re: IDENTITY PK-FK corruption of data
stegze <stegze@[EMAIL   2008-05-20 01:53:36 
Re: IDENTITY PK-FK corruption of data
Serge Rielau <srielau@  2008-05-20 07:14:10 
Re: IDENTITY PK-FK corruption of data
"Mark A" <no  2008-05-20 07:29:31 
Re: IDENTITY PK-FK corruption of data
stegze <stegze@[EMAIL   2008-05-27 07:33:12 
Re: IDENTITY PK-FK corruption of data
--CELKO-- <jcelko212@[  2008-05-28 13:12:50 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Tue Dec 2 20:37:09 CST 2008.