OnDemand User Group

Support Forums => z/OS Server => Topic started by: ibmarthin on December 21, 2017, 11:44:57 PM

Title: Ready for DB2 v12
Post by: ibmarthin on December 21, 2017, 11:44:57 PM

Hello out there

Planning to upgrade DB2 to v12, I am asked if OnDemand 8.5 and 9.5 have any issues.
I traveled across the Internet and could only find info referring to DB2 V11.1
Does anyone have plans with DB2 v12?

Title: Re: Ready for DB2 v12
Post by: Justin Derrick on December 23, 2017, 02:39:41 PM

You can check the release notes (readme.txt) for the version of CMOD you're using, and towards the end of the document, it'll show you which versions CMOD was tested with.  As long as you're using a version of DB2 newer than what was tested with, it's presumed to work -- and of course, it will be supported.

In the absence of any specific advice from IBM (you could open a PMR with IBM and report back) you could just do a test install to see if you run into any issues.

Having said all that, CMOD doesn't make use of any of the new / advanced features of DB2 -- so newer versions should be fine as long as there aren't major changes in the DB2 database configuration parameter names.  (This happened in an older version of CMOD where the DB2 9.x changed the names of logging parameters, breaking the arsdb -c command.)

-JD.

Title: Re: Ready for DB2 v12
Post by: Ed_Arnold on December 26, 2017, 08:45:41 AM

We've been running DB2 V12 internally since it first came out.  Haven't found any issues at all so far.

> CMOD doesn't make use of any of the new / advanced features of DB2

Justin is right on this one.  Just follow good DB2 practices and you should be good to go.

I'll add this:

1. Make sure you have the corresponding APARs applied for any issues found in DB2 V11:

http://www.odusergroup.org/forums/index.php?topic=1525.0 (http://www.odusergroup.org/forums/index.php?topic=1525.0)

2. While you're in test, try to exploit as many things as possible from here:

http://www.odusergroup.org/forums/index.php?topic=1682.0 (http://www.odusergroup.org/forums/index.php?topic=1682.0)


Here's where we are on my test system:

-DSNC DISPLAY GROUP                                                   
DSN7100I  -DSNC DSN7GCMD 742                                         
*** BEGIN DISPLAY OF GROUP(........) CATALOG LEVEL(V12R1M500)         
                  CURRENT FUNCTION LEVEL(V12R1M501)                   
                  HIGHEST ACTIVATED FUNCTION LEVEL(V12R1M501)         
                  HIGHEST POSSIBLE FUNCTION LEVEL(V12R1M501)         
                  PROTOCOL LEVEL(2)                                   
                  GROUP ATTACH NAME(....)                             
---------------------------------------------------------------------
DB2          SUB                     DB2    SYSTEM    IRLM           
MEMBER   ID  SYS  CMDPREF   STATUS   LVL    NAME      SUBSYS IRLMPROC
-------- --- ---- --------  -------- ------ --------  ----   --------
........   0 DSNC -DSNC     ACTIVE   121501 MVS222    ID12   IR12PROC
---------------------------------------------------------------------
SPT01 INLINE LENGTH:        32138                                     
*** END DISPLAY OF GROUP(........)                                   
DSN9022I  -DSNC DSN7GCMD 'DISPLAY GROUP ' NORMAL COMPLETION           

Ed

Title: Re: Ready for DB2 v12
Post by: ibmarthin on January 03, 2018, 02:21:32 AM

Thank you both  :)

Title: Re: Ready for DB2 v12
Post by: Ed_Arnold on June 05, 2018, 07:06:49 AM

A Db2 V12 service thread for CMOD is been created here:

Recommended DB2 on z/OS Service, V12

http://www.odusergroup.org/forums/index.php?topic=2412.0 (http://www.odusergroup.org/forums/index.php?topic=2412.0)

Ed