Statement of direction
IBM intends to provide Technotes for the following:

System requirements for Content Manager OnDemand beginning with version 10.5.0.11 is planned for 3Q 2026.

System requirements for Content Manager beginning with version 8.7.0.6 is planned for 4Q 2026.

IBM intends to deprecate the current Full Text Search engine technology in a future Content Manager OnDemand 10.5 fix pack.

Note: The intended replacement search engine technology for Content Manager OnDemand Full Text Search is Elasticsearch and OpenSearch.

Subject: Deprecated DB2 TABLE/TABLESPACES regarding ARS INDEX TABLES

Problem Description:
This week, the DB2 DBA's brought up the topic of old Tablespace constructs being deprecated.  Looks like all of the recently defined Index Data tables are being defined with Supported constructs.  Older Index Data tables were defined with constructs identified as Deprecated. 
Will this Impact Production Support without Upgrading these Objects?  Do they need to be upgraded to be properly supported?  Same with the Indexes associated to these Tables/Tablespaces.

Note:  This answer was provided by Db2 Support.  If you have a question contact Db2 support, not CMOD support.

Note:  This is all unofficial information unless promulgated via an IBM announcement

If you create the objects with APPLCOMPAT  level V13R1M503 or lower then you can create deprecated objects.  If you are using SPUFI or DSNTIAD or DSNTEP2 then you would need to bind those plans with APPLCOMAT(V13R1M503)  or lower.



Note, however,  that Db2 VNext will not support the following:

Simple, segmented or classic partitioned tablespaces;

BRF or basic (6 byte) format pagesets;

hash pagesets;

synonyms;

VTAM connectivity.



You have till approx. 2031 till V13 will be out of support.

_________________________________________________

Follow-on question:

All of the Index tables after 2019 seem to be created ok(partition by growth), but we have 2900+ tables that are Simple tables (TYPE of SPACE).  39 of them are ARS* SYSTEM TABLES.   All need to be converted before 2031, right?  Don't want to wait until the "last minute".
_________________________________________________

Reply from Db2:

>  All need to be converted before 2031, right?

Yes.
 

System requirements for IBM® Content Manager OnDemand beginning with version 10.5.0.11

Ref:  https://www.ibm.com/support/pages/node/7249695

Abstract
This document describes the system requirements for IBM® Content Manager OnDemand beginning with version 10.5.0.11, which is planned for 3Q2026.

Content
Note:  When a product version is specified as 'or later', it refers to later fix packs of the version that is specified, as well as any later versions (and fix packs) that are not specified. In addition, if a product is not listed, that does not mean that the product is no longer supported. Rather, it means that the prerequisite version of the product will not be changed.
 

IBM z/OS
     3.1 or later

AIX
     7.2 TL5 or later, and 7.3 TL3 or later

Linux (Intel and System z)
     RedHat 8 U10 or later, RH 9 U6 or later, and RH 10 or later
     SUSE 15 SP7 or later, and SUSE 16 or later

Microsoft Windows Server
     Windows Server 2025 or later

Microsoft Windows (for Content Manager OnDemand client programs that run on a workstation)
     Windows 11 or later

IBM Db2 for z/OS
     13 or later

IBM Db2 for Linux, UNIX and Windows
     11.5 or later

Microsoft SQL Server
     2022 or later

IBM Storage Protect
     8.1.26 or later

IBM WebSphere Liberty
     25.0.0.9 or later
 

In addition, the following product components are not planned to ship with Content Manager OnDemand version 10.5.0.11 and later. Note that all of these components have supported 64-bit equivalents that will continue to be provided.
               - OnDemand Windows Client (32-bit)
               - OnDemand Windows Administrator (32-bit)
               - OnDemand Windows Monitor (32-bit)
               - Content Manager OnDemand Web Enablement Kit (ODWEK) Java APIs (32-bit)
               - ARSACIF (32-bit; Multiplatforms only)

CMOD V10.5.0.11 will require z/OS V3.1

System requirements for IBM® Content Manager OnDemand beginning with version 10.5.0.11

Ref:  https://www.ibm.com/support/pages/node/7249695

Abstract
This document describes the system requirements for IBM® Content Manager OnDemand beginning with version 10.5.0.11, which is planned for 3Q2026.

Content
Note:  When a product version is specified as 'or later', it refers to later fix packs of the version that is specified, as well as any later versions (and fix packs) that are not specified. In addition, if a product is not listed, that does not mean that the product is no longer supported. Rather, it means that the prerequisite version of the product will not be changed.
 

IBM z/OS
     3.1 or later

AIX
     7.2 TL5 or later, and 7.3 TL3 or later

Linux (Intel and System z)
     RedHat 8 U10 or later, RH 9 U6 or later, and RH 10 or later
     SUSE 15 SP7 or later, and SUSE 16 or later

Microsoft Windows Server
     Windows Server 2025 or later

Microsoft Windows (for Content Manager OnDemand client programs that run on a workstation)
     Windows 11 or later

IBM Db2 for z/OS
     13 or later

IBM Db2 for Linux, UNIX and Windows
     11.5 or later

Microsoft SQL Server
     2022 or later

IBM Storage Protect
     8.1.26 or later

IBM WebSphere Liberty
     25.0.0.9 or later
 

In addition, the following product components are not planned to ship with Content Manager OnDemand version 10.5.0.11 and later. Note that all of these components have supported 64-bit equivalents that will continue to be provided.
               - OnDemand Windows Client (32-bit)
               - OnDemand Windows Administrator (32-bit)
               - OnDemand Windows Monitor (32-bit)
               - Content Manager OnDemand Web Enablement Kit (ODWEK) Java APIs (32-bit)
               - ARSACIF (32-bit; Multiplatforms only)

This thread is current.

No reported z/OS 3.1 issues found by CMOD.

Note:  CMOD 10.5.0.11 will require z/OS 3.1 or later

CMOD has surfaced the follow Db2 defect:


PH68886: Db2 FOR z/OS ODBC TRACED THE BIGINT VALUE INCORRECTLY

Error description
When BIGINT is in use, the Db2 for z/OS ODBC application trace shows an incorrect value.

At the moment there's only one supported level of CMOD and it's quite mature.

When CMOD V.Next comes out I suspect activity will pick up as people start to migrate to the new version.

Ed Arnold

At a minimum I'd like to see this website continue.

I like the ability to publish items that I think are of interest to the CMOD community.

Ed Arnold

Hello teera_aoo -

When I get an unable to connect message here is what I try first:


1. Ping the arssockd server host from Windows.  Does that work?

2. Next try the port:

Powershell - (failure shown first, then I opened up the firewall and retried successfully)

PS C:\Users\ed.arnold> test-netconnection 10.1.203.52 -port 1447
WARNING: TCP connect to (10.1.203.52 : 1447) failed
WARNING: Ping to 10.1.203.52 failed with status: TimedOut


ComputerName           : 10.1.203.52
RemoteAddress          : 10.1.203.52
RemotePort             : 1447
InterfaceAlias         : Wi-Fi
SourceAddress          : 192.168.1.133
PingSucceeded          : False
PingReplyDetails (RTT) : 0 ms
TcpTestSucceeded       : False



PS C:\Users\ed.arnold> test-netconnection 10.1.203.52 -port 1447


ComputerName     : 10.1.203.52
RemoteAddress    : 10.1.203.52
RemotePort       : 1447
InterfaceAlias   : Ethernet 2
SourceAddress    : 10.111.105.47
TcpTestSucceeded : True

3. If both of these fail it's time for a packet trace to see where the packets are going or not going

Ed Arnold

ARS0188E - IBM Content Manager OnDemand server issues the message "ARS0188E Unable to create thread. The return code is X" and exits.

Unfortunately ARSSOCKD ends without enough diagnostic information to tell where the issue was.

Starting at 10.5.0.8 CMOD on z/OS, instead of just terminating, now ends with a dump.

Support can analyze the dump and should be able to localize the root cause.

Ed

// JOBCARD
//*       
//* -----------------------------------------------------------------
//*                                                                   
//*  CHANGE THE OPERANDS ON THE FOLLOWING SET STATEMENTS             
//*  TO REFERENCE THE DATA SET NAMES APPROPRIATE FOR                 
//*  YOUR INSTALLATION.                                               
//*                                                                   
//*     SRCLIB  REFERENCES THE LIBRARY WHICH CONTAINS                 
//*             THE SOURCE CODE PARTS.                               
//*                                                                   
//*     TGTLIB  REFERENCES THE TARGET HFS TO CONTAIN                 
//*             THE LOAD MODULE.                                     
//*                                                                   
//*                                                                   
//PROCESS   OUTPUT  DEFAULT=YES,CLASS=*,JESDS=ALL,OUTDISP=HOLD       
//SRCLIB    SET SRCLIB='ARS.SMPE105.SARSINST'                         
//TGTLIB    SET TGTLIB='/u/some/target/exits'                               
//*                                                                   
//* -----------------------------------------------------------------
//*                                                                   
//COMP     EXEC PGM=CCNDRVR,                                       
// PARM=('/OPTFILE(DD:COPTS)')                                     
//STEPLIB  DD DSN=CEE.SCEERUN,DISP=SHR                             
//         DD DSN=CBC.SCCNCMP,DISP=SHR                             
//COPTS    DD *                                                     
DEFINE(OS390)                                                       
DEFINE(UNIX)                                                       
DEFINE(ARS_COPYRIGHT)                                               
DEFINE(MVS_PRAGMA)                                                 
DEFINE(_THREAD_SAFE)                                               
DEFINE(_OPEN_SYS)                                                   
DEFINE(_XOPEN_SOURCE_EXTENDED)                                     
DEFINE(__OS390__)                                                   
OPT(2)                                                             
GOFF                                                               
XPLINK                                                             
CSECT                                                               
INLRPT                                                             
LIB                                                                 
ARCH(10)                                                           
TUNE(12)
LONGNAME                                                             
RENT                                                                 
SOURCE                                                               
LIST                                                                 
NOSEQ                                                               
NOMAR                                                               
SPILL(512)                                                           
//SYSIN    DD  DSN=&SRCLIB(ARSUPERM),DISP=SHR                       
//USERLIB  DD  DISP=SHR,DSN=ARS.SMPE105.SARSINST                     
//SYSLIB   DD  DISP=SHR,DSN=ARS.SMPE105.SARSINST                     
//         DD  DSNAME=CEE.SCEEH.H,DISP=SHR                           
//         DD  DSNAME=CEE.SCEEH.SYS.H,DISP=SHR                       
//SYSUT1   DD  UNIT=SYSDA,DISP=(NEW,DELETE),                         
//   SPACE=(32000,(30,30)),DCB=(RECFM=FB,LRECL=80,BLKSIZE=3200)     
//SYSUT4   DD  UNIT=SYSDA,DISP=(NEW,DELETE),                         
//   SPACE=(32000,(30,30)),DCB=(RECFM=FB,LRECL=80,BLKSIZE=3200)     
//SYSUT5   DD  UNIT=SYSDA,DISP=(NEW,DELETE),                         
//   SPACE=(32000,(30,30)),DCB=(RECFM=FB,LRECL=3200,BLKSIZE=12800)   
//SYSUT6   DD  UNIT=SYSDA,DISP=(NEW,DELETE),                         
//   SPACE=(32000,(30,30)),DCB=(RECFM=FB,LRECL=3200,BLKSIZE=12800)   
//SYSUT7   DD  UNIT=SYSDA,DISP=(NEW,DELETE),                         
//   SPACE=(32000,(30,30)),DCB=(RECFM=FB,LRECL=3200,BLKSIZE=12800)   
//SYSUT8   DD  UNIT=SYSDA,DISP=(NEW,DELETE),                         
//   SPACE=(32000,(30,30)),DCB=(RECFM=FB,LRECL=3200,BLKSIZE=12800)   
//SYSUT9   DD  UNIT=SYSDA,DISP=(NEW,DELETE),                         
//   SPACE=(32000,(30,30)),DCB=(RECFM=VB,LRECL=137,BLKSIZE=882)     
//SYSUT14  DD  UNIT=SYSDA,SPACE=(32000,(30,30)),                     
//             DCB=(RECFM=FB,LRECL=3200,BLKSIZE=12800)               
//SYSPRINT DD SYSOUT=*                                               
//SYSCPRT  DD SYSOUT=*                                               
//SYSLIN   DD DSN=&&OBJ,                                             
//             DISP=(MOD,PASS),                                     
//             UNIT=SYSALLDA,LRECL=80,RECFM=FB,BLKSIZE=3120,         
//             SPACE=(TRK,(30,30))                                   
//LKED     EXEC PGM=IEWL,COND=(4,LT,COMP),                           
//     PARM='AC=1,CASE=MIXED,OPTIONS=OPTS'                           
//SYSLIB   DD  DISP=SHR,DSN=CEE.SCEEBND2                             
//OPTS     DD  *                                                     
    XREF                                                             
    AMODE=31,MAP                                                     
    RENT,DYNAM(DLL)                                                 
//SYSLMOD  DD PATH='&TGTLIB'                                         
//SYSUT1   DD UNIT=VIO,SPACE=(CYL,(10,2)),DISP=(NEW,DELETE)           
//SARSLOAD DD DISP=SHR,DSN=ARS.SMPE105.SARSLOAD                       
//SCEELIB  DD DISP=SHR,DSN=CEE.SCEELIB                                 
//SYSPRINT DD SYSOUT=*                                                 
//SYSDEFSD DD DUMMY                                                   
//SYSLIN   DD  DSN=*.COMP.SYSLIN,DISP=(OLD,DELETE)                     
//         DD  DDNAME=SYSIN                                           
//SYSIN    DD  *                                                       
   SETOPT PARM(PATHMODE(0,7,5,5),EXTATTR(APF))                         
    INCLUDE SARSLOAD(ARSZUXFX)                                         
    INCLUDE SCEELIB(CELHS003,CELHS001)                                 
    NAME    arsuperm(R)                                               
//*

I learned that new function level is available for Db2.

At this time, there is no plan for CMOD to require any of these new functions.

Db2 13 - What's new - Function level 507 (PH64907 - April 2025)

Function level 507 introduces online conversion of table partitions from PBR to PBG, enhanced concurrency for system temporal tables, LASTUSED support for application plans, more flexibility for temporal and archive-enabled tables, and greater than 64 GB allocation quantities.

As of this writing there is no plan to replace the 10.5.0.9 Admin Client on the download site.

IF your shop is going to be administering ODF

THEN use the 10.5.0.8 Admin Client

OR request a copy of the 10.5.0.9 Admin Client from Level 2 that contains the fix.

Ed

Don't install the 10.5.0.9 admin client if you're going to use it to administer ODF.

Otherwise, it's fine - just ODF administration has an issue.

I'll append here as I find out more.

Ed