Paul McWilliams's Blog (26)

IBM Db2 AI for z/OS 1.3 is here!

Announcing IBM Db2 AI for z/OS 1.3 – the evolution continues -- moving enterprise relational databases into the future!


To always get the latest…

Continue

Added by Paul McWilliams on June 23, 2020 at 16:28 — 2 Comments

Db2 11 for z/OS End of Service (EOS) date has changed

The end of service (EOS) for Db2 11 for z/OS is now changed to March 31, 2021. For the details, See Mo's recent News from the Lab blog entry.


To always get the latest news about Db2 for z/OS from the IBM lab, sign in and subscribe at:…

Continue

Added by Paul McWilliams on May 15, 2020 at 22:00 — No Comments

Virtual Db2 for z/OS Advanced Classes are now offered for 2020

By Dorothy Lin and Paul McWilliams.

Db2 for z/OS development is now offering two Db2 for z/OS Advanced Class sessions for 2020—previously scheduled  at IBM Hursely and IBM Silicon Valley Laboratory—as virtual…
Continue

Added by Paul McWilliams on April 21, 2020 at 17:30 — 2 Comments

Db2 for z/OS Advanced Class sessions for 2020 are now scheduled

Update: Due to the global pandemic and resulting travel restrictions, this course is now offered as a virtual online course, and the cost to attend is also reduced to $2000. For more information, see the…
Continue

Added by Paul McWilliams on January 23, 2020 at 19:30 — No Comments

The Db2 for z/OS News from the Lab blog has moved!

Perhaps you've seen news about the sunset of the IBM developerWorks community platform at the end of 2019. I am happy that I can now share how you can continue following the latest news from the IBM experts who design, build, test, and support Db2 for z/OS, here in the new Db2 for z/OS Community.



Don't miss any Db2 for z/OS News from the Lab blog entries. Join the new community and subscribe today! For the full story, see:…

Continue

Added by Paul McWilliams on December 11, 2019 at 23:49 — No Comments

Transferring ownership of Db2 objects in Db2 12

In Db2 12, you can transfer the ownership of database and system objects online if you are the owner of the object or have SECADM authority. You can use TRANSFER OWNERSHIP statements to transfer ownership of an objects to another authorization ID or a role, without any application changes.

For the full story on this new SQL capability, see the new Db2 12 GA feature series post, Transferring ownership of Db2…

Continue

Added by Paul McWilliams on July 12, 2019 at 22:38 — No Comments

Announcing Db2 12 function level 505!

We're proud to announce that Db2 12 for z/OS function level 505 becomes available for activation when you apply…

Continue

Added by Paul McWilliams on June 26, 2019 at 18:41 — No Comments

New blog post: PBR table spaces with relative page numbers - a Db2 12 Greatest hit

Partition-by-range (PBR) table spaces with relative page numbers (RPN) in Db2 12 for z/OS improve the usability, manageability, scalability, and availability for the largest tables in Db2 environments.



Read the full story in the Db2 for z/OS News from the Lab blog:

http://ibm.biz/BdzPr4…


Continue

Added by Paul McWilliams on June 12, 2019 at 19:30 — No Comments

New blog post: Simplified application compatibility for IBM Data Server Drivers and Db2 12 function levels

In Db2 12, APAR PH08482 simplifies the process of activating new function levels without impacting existing JDBC, CLI, and .net applications, and it possibly reduces the coordination effort required between Db2 administrators and application programmers, for activating new application…

Continue

Added by Paul McWilliams on May 9, 2019 at 23:32 — No Comments

Create services for provisioning Db2 susystems (DBaaS) with the sample Db2 software services template

By Sueli Almeida and Paul McWilliams.

We recently published a sample Db2 software services template. As a service provider, you can use it to create services (DBaaS) to rapidly provision from scratch one or multiple standalone Db2…

Continue

Added by Paul McWilliams on April 2, 2019 at 22:32 — No Comments

Announcing Db2 12 function level 504

We're proud to announce Db2 12 function level 504!



Function level 504 (activation enabled by APAR PH07672) introduces the following new capabilities in Db2 12 for…

Continue

Added by Paul McWilliams on March 6, 2019 at 18:26 — No Comments

Video: Introduction to Db2 Utilities for z/OS

Got millennials?

It can be challenging to train a new generation of Db2 for z/OS users whose model of learning no longer includes days of reading long “manuals.” But they have energy, enthusiasm and lots of new ideas that you want to foster. Why not try teaching them with short videos?

Check out this Db2 Utilities video, specifically aimed at orienting someone who is new to Db2 for z/OS and knows little or nothing about Db2 Utilities.…

Continue

Added by Paul McWilliams on March 1, 2019 at 23:13 — No Comments

A reminder to convert pagesets for Db2 for z/OS objects to the 10-byte extended RBA and LRSN format

Db2 for z/OS APAR PH02437 introduces the new DSNB233I message in Db2 12 and Db2 11. The new message reminds you to convert pagesets to the extended 10-byte RBA or LRSN format, to avoid outages that might occur if Db2 reaches the 6-byte logging limit.…

Continue

Added by Paul McWilliams on January 8, 2019 at 19:20 — No Comments

The new SQL Reference for Cross-Platform Development is here!

Version 6 of the…

Continue

Added by Paul McWilliams on October 3, 2018 at 23:56 — No Comments

IBM Db2 AI for z/OS and Db2 12 function level 503 available now!

 



For more about IBM Db2 AI for z/OS and Db2 12 function level 503, check out the blog posts:

Continue

Added by Paul McWilliams on September 21, 2018 at 17:26 — No Comments

Enhanced SQL MERGE—a Db2 12 greatest hit with John Campbell

Back in Version 9, Db2 for z/OS introduced minimal support for MERGE statementst, only providing an upsert capability with limited functionality. Db2 12 for z/OS enhances MERGE statements to be consistent with the SQL 2016 Core standard, as…

Continue

Added by Paul McWilliams on August 1, 2018 at 22:51 — No Comments

Db2 for z/OS Master Classes

The first Db2 for z/OS Master Class to be hosted by IBM Europe was recently held at IBM Hursley. The next invitation-only session at IBM Silicon Valley Laboratory is already full, but future session are planned.  For the full story, see Db2 for z/OS Master Classes.


Always get the latest news about  Db2 for z/OS from the IBM lab!…

Continue

Added by Paul McWilliams on July 18, 2018 at 16:53 — No Comments

New SQL pagination syntax - a Db2 12 greatest hit with John Campbell

Db2 12 for z/OS introduces new SQL syntax that makes the difficult task of coding efficient SQL pagination—returning a portion of a result set based on data position—much easier for application developers. Read more in New SQL pagination syntax - a Db2 12 greatest hit with John…

Continue

Added by Paul McWilliams on May 22, 2018 at 21:25 — No Comments

Fast index traversal - a Db2 12 greatest hit with John Campbell

Fast index traversal is one of the the most important new performance features in Db2 12 for z/OS. It is an in-memory index performance optimization that enables Db2 to do fast index lookup, by avoiding expensive index B-tree traversal.…

Continue

Added by Paul McWilliams on May 8, 2018 at 17:53 — No Comments

Db2 12 function level 502 now available with z/OS data set encryption support and more

We're proud to announce that Db2 for 12 for z/OS function level 502 is now available!

Function level 502 introduces support for new policy controls in Db2 12 for…

Continue

Added by Paul McWilliams on April 30, 2018 at 21:30 — No Comments

Bringing Db2 enthusiasts together virtually. Expert or novice, distributed or mainframe, this is the place for everything DB2.

Forum

Complimentary IDUG EMEA 2020 Expo Pass for World of Db2 Members

Started by Surekha in What's hot ? Nov 18. 0 Replies

Complimentary IDUG EMEA 2020 EXPO Pass We are offering a complimentary IDUG EMEA 2020 Expo Pass for Db2 users to visit the IBM Expo at the IDUG EMEA 2020 Conference. Basically this means that IDUG have opened the IBM Expo for non IDUG registered…Continue

Tags: Db2z, LUW, Db2, IDUG

Replaying past database activities

Started by Shaun Hide in Security and DB2. Last reply by Alexander Dashevsky Nov 17. 1 Reply

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

Tags: #DataAccess

© 2020   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service