Jump to content
Main menu
Main menu
move to sidebar
hide
Navigation
Main page
Recent changes
Random page
Help about MediaWiki
Special pages
Niidae Wiki
Search
Search
Appearance
Create account
Log in
Personal tools
Create account
Log in
Pages for logged out editors
learn more
Contributions
Talk
Editing
IBM Db2
(section)
Page
Discussion
English
Read
Edit
View history
Tools
Tools
move to sidebar
hide
Actions
Read
Edit
View history
General
What links here
Related changes
Page information
Appearance
move to sidebar
hide
Warning:
You are not logged in. Your IP address will be publicly visible if you make any edits. If you
log in
or
create an account
, your edits will be attributed to your username, along with other benefits.
Anti-spam check. Do
not
fill this in!
=== Db2 for z/OS - evolution === In 1995, GA (general availability) of V4. It introduced "data sharing": several DB2 engines access the same data. Advantages: performance and availability (if one DB2 engine fails or is migrated to the next version). In 1997, GA of V5. It added, e.g., online reorganization of tablespaces. In 1999, GA of V6. It added object-relational support. "Objects" here mean data items longer than 32K (up to then the maximal length of a table row, more precisely a table record), such as images, videos, or text. DB2 could now store and handle such objects. Furthermore, it added trigger support. In 2001, GA of V7. It added, e.g., dynamic allocation of data sets (~files on z/OS), and the ability to let utilities run on lists of tablespaces. Furthermore, real-time statistics, scrollable cursors, and initial Unicode support. In 2004, GA of V8. It added, e.g., 64-bit support. New index types (notably DPSI), recursive SQL. Internal catalog is converted to Unicode. In 2007, GA of V9. It added, e.g., Trusted Context (a security feature), and "native XML" support. In 2010, GA of V10. It added, e.g., Temporal Tables (e.g., row history), security features like separation of system and security administrators, and RCAC (row column access control). In 2013, GA of V11. It added, e.g., JSON support. In 2016, GA of V12. It added, e.g., RESTful services; and usage of AI to optimize the selection of the access path to the data, thus enhancing performance. On May 31, 2022, IBM released Db2 13 for z/OS.<ref>{{Cite web |date=2022-04-05 |title=IBM Db2 13 for z/OS delivers leading-edge AI innovations and enhancements, reinforcing it as the foundation for enterprise computing within the hybrid cloud and digital world |url=https://www.ibm.com/common/ssi/ShowDoc.wss?docURL=/common/ssi/rep_ca/3/897/ENUS222-003/index.html |url-status=live |archive-url=https://web.archive.org/web/20220817000108/https://www.ibm.com/common/ssi/ShowDoc.wss?docURL=/common/ssi/rep_ca/3/897/ENUS222-003/index.html |archive-date=2022-08-17 |access-date=2022-06-21 |website=www.ibm.com |language=en-US}}</ref>
Summary:
Please note that all contributions to Niidae Wiki may be edited, altered, or removed by other contributors. If you do not want your writing to be edited mercilessly, then do not submit it here.
You are also promising us that you wrote this yourself, or copied it from a public domain or similar free resource (see
Encyclopedia:Copyrights
for details).
Do not submit copyrighted work without permission!
Cancel
Editing help
(opens in new window)
Search
Search
Editing
IBM Db2
(section)
Add topic