DB2 v2.1 introduced RI, there were enhancements later starting in 2.2. This is on MVS, likely different on VM. I was working at STL at the time, there were some interesting discussions on how to implement it.
On Sat, Aug 30, 2025 at 10:05 AM René Jansen < [email protected]> wrote: > Before RI and primary keys we defined our own unique indexes. I have RI in > my memories as in somewhere in 2.x but I will have a look later. > > best regards, > > René. > > > On 29 Aug 2025, at 19:16, Mike Schwab < > [email protected]> wrote: > > > > Since RI depends on indexes, releasing index locks might have been a > > co-implementation or pre-requisite, V4 1994-96.. > > > https://www.dbta.com/Columns/DBA-Corner/A-Short-History-of-DB2-for-z-OS-99183.aspx > > > > > > On Fri, Aug 29, 2025 at 5:34 PM Mark S Waterbury < > > [email protected]> wrote: > > > >> Hello, all, > >> > >> Does anyone remember or know: > >> > >> 1. when was "referential integrity" constraints between tables was added > >> to DB2 for MVS and SQL/DS for VM and VSE? What release(s) and/or what > >> year(s)? > >> > >> 2. when were "triggers" added to DB2 for MVS and SQL/DS for VM and VSE? > >> What release(s) and/or what year(s)? > >> > >> Thanks in advance. > >> > >> Mark S. Waterbury > >> > >> ---------------------------------------------------------------------- > >> For IBM-MAIN subscribe / signoff / archive access instructions, > >> send email to [email protected] with the message: INFO IBM-MAIN > >> > > > > > > -- > > Mike A Schwab, Springfield IL USA > > Where do Forest Rangers go to get away from it all? > > > > ---------------------------------------------------------------------- > > For IBM-MAIN subscribe / signoff / archive access instructions, > > send email to [email protected] with the message: INFO IBM-MAIN > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to [email protected] with the message: INFO IBM-MAIN > ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
