Db2 for z/OS support of z15 and z/OS 2.4


Is maintenance needed in Db2 for z/OS (V11 or V12) for a migration to

- the current hardware z15

- or the current operating system z/OS 2.4 ?

As of today there are no APARs/PTFs needed to tolerate such a migration.


The following key z15 features are exploited by Db2 for z/OS:

- Faster SSL/TLS handshake performance on IBM z15 with Crypto Express7S compared to z14 with Crypto Express6S (no change in Db2 required)

- System Recovery Boost, especially for the transaction/batch backlog of Db2 (no change in Db2 required)

- IBM Z Data Privacy for Diagnostics, which is implemented by OA57570: Db2 exploitation by PH15940.

- Integrated Accelerator for zEDC (LOB compression in Db2 12 for z/OS, no additional change required).

Of course besides the above features, Db2 for z/OS has automatically benefit of improved CPU power and real storage enhancements of the z15.

Db2 12 supports 16TB in total buffer pool size. z15 supports 40 TB maximum per system. z/OS 2.4 supports 4TB per LPAR.

Views: 739

Add a Comment

You need to be a member of The World of DB2 to add comments!

Join The World of DB2

Comment by Peter Hartmann on December 17, 2019 at 6:57


The question is probably not how to go from Db2 V11 NFM to Db2 V12 V12R1M505. This can be done by

a) V11 NFM - CATMAINT to V12R1M100

b) ACTIVATE to V12R1M500 or V12R1M501

c) CATMAINT to V12R1M505

d) ACTIVATE to V12R1M505.

Although you can combine all these steps in one job, I would not recommend it.

Probably the questions are:

a) How many steps should you take? What is your experience with the old migrations, how long have you stayed in CM ? I recommend for your case without knowing your environment, at least 4 weeks in V12R1M100, then 4 weeks in V12R1M500 or V12R1M501 and then go forward to V12R1M505.

b) How can we prevent new functionality of V12R1M50x in production, although test is already converted? The same way as you prevent it in e.g. V10, old SDSNLOAD for applicaton precompile etc. or old driver packages with APPLCOMPAT V11R1

Comment by City Villager on December 17, 2019 at 3:29

With new continuous delivery and Function level, there is confusion about the migration path.. Our target is to migrate from Db1 V11 NFM to DB2 12 FL0505 ..and from our sand box -> to dev Box -> to Production while maintaining full compatibility of DB2 running at different levels. 

Whats the fastest way. We need to d it to exploit DB2 SSC - internal CDC delivered at FL0505.

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


Db2 11.5 External Tables on Line Lab

Started by Phil Downey in What's hot ? Mar 26. 0 Replies

Hi All, George and I built a new hands on Lab for working with Db2 11.5 External tables... takes you through how to define them, query them , dump to them and overall work with them in different scenarios ... takes about 20 minutes. give a try !…Continue

Revoking Sysadm from DB2 Z/os

Started by Chinnapureddy Jaya Prakash in Security and DB2 Mar 4. 0 Replies

Hi, We are having DB2V12 Level 100.  We are looking for best approach for two things1). 'Revoke Sysadm' from existed userids'. 2). Databases are created by userid. so we need to revoke implicitly granted access (like CreateDB, Load, DBADM,..etc).Can…Continue

Tags: (implicit, grants), Database, and, SYSADM

© 2020   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service