![]() ![]() ![]() Whereas today (and ever since V3) there have only been versions. You might notice that IBM delivered “releases” of DB2 back in the 1980s, DB2 V1R3 saw the introduction of DATE data Same thing for Version 1 Release 3, which was announced on May 19,ġ987 and became GA on June 26, 1987. Only a month for a new release of DB2 these days? But that is how it happenedīack then. General availability a month later on March 7, 1986. Version 1 Release 2 was announced on Februand was released for Early releases of DB2 were viewedīy many as an “information center” DBMS, not for production workloads, like IMS was. The basics of making a relational DBMS work. Not released because of April Fool’s Day? Initial DB2 development focused on I wonder if it was ready on April 1st but back to the wild and woolly 1980s! And watch our favorite DBMS,ĭB2 Version 1 Release 1 was announced on June 7, 1983, and it became generallyĪvailable on Tuesday, April 2, 1985. Examine each application program to determine whether changes are required for it to continue functioning appropriately.ĭecades ago.Recreate the security authorizations captured earlier.Recreate any triggers, views, and indexes for the table.Recreate any referential constraints that may have been dropped.Reload the tables, using the unloaded data obtained earlier.Recreate the database object with the new specifications by using the definition obtained from the Db2 Catalog earlier.Drop the database object to be changed, which in turn drops any dependent objects, revokes authorizations, and invalidates any SQL statements against any impacted tables in any application programs.Unload the data from all tables that will be impacted.Obtain a list of all programs that access impacted tables by using the Db2 Catalog, Db2 Directory, and any other program documentation at your disposal.Retrieve all security authorizations that have been granted for all database objects that will be dropped either directly or as a result of cascading drops.Capture all referential constraints for all tables involved in the change (either directly or indirectly).Retrieve the current definition of any dependent objects as well for example, if you drop a table, then triggers, views, and indexes are also dropped.Retrieve the current definition of the database object by querying the appropriate Db2 Catalog tables, which will be different for each type of object. ![]()
0 Comments
Leave a Reply. |