IBM Db2 - The Ultimate Database for Cloud, Analytics & Mobile
we deleted records from a parent table with reorg - discard and WHEN condition (V12)
and hoped, the records in the dependent table were deleted, too, because there is a foreign key with ON DELETE CASCADE rule.
But DB2 do not delete the records in the dependent table. Dependent Table is in CHKP.
Do you have a hint to tell the reorg to do the deletion on dependent table ?
thanks and best regards
Db2 12 Exploiting new functions and Migration Planning REGISTER NOW Db2 12 for z/OS® takes Db2 to a new level, both extending the core capabilities and empowering the future. Db2 12 extends the…1 Comment 1 Like
Db2 12 Exploiting new functions and Migration Planning PART 2 REGISTER NOW Db2 12 for z/OS® takes Db2 to a new level, both extending the core capabilities and empowering the future. Db2 12 extends…0 Comments 0 Likes
Register Today! Whether you are an existing Db2 Analytics Accelerator user or considering becoming one, you won’t want to miss this webcast! Join Daniel Martin, STSM, IBM Db2 Analytics Accelerator De…0 Comments 0 Likes
Bringing Db2 enthusiasts together virtually. Expert or novice, distributed or mainframe, this is the place for everything DB2.
I would need to know who modified table data on a certain day.I do have my backups and database logs available.DB2audit was however not activated at this point.How would i be able to access this information?Continue
This digital event examines how enterprises can become smarter with a data management system that is developer-inclusive. During this session, participants will get to learn how Db2 integrates with a broad array of programming languages, employs…Continue