Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - Ed_Arnold

Pages: [1] 2 3 4 5 6 ... 80
1
z/OS Server / CMOD has surfaced the following Db2 APAR
« on: March 12, 2024, 09:52:30 PM »
PH57851: ABEND0C4 MAY HAPPEN AT DSNXOGP:0AB44 FOR QUERY WITH MULTI-INDEX ACCESS.

Error description
ABEND0C4 may happen at DSNXOGP:0AB44 for query with multi-index
access.
The abend happens during choosing access path for query.

ADDITIONAL SYMPTOMS:
ABEND0C4 MIDX DSNXOGP OFFSET0AB44 OFFSETAB44 0AB44 AB44
Local fix
BYPASS/CIRCUMVENTION:
Please try adding OPTIMIZE FOR 1 ROW to discourage optimizer
from using multi-index.
Problem summary
****************************************************************
* USERS AFFECTED:                                              *
* All users of Db2 12 and Db2 13 for z/OS who                  *
* has queries whose access path contains                       *
* multiple index access.                                       *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* ABEND0C4 at DSNXOGP offset 0AB44 may                         *
* occur for an SQL statement whose                             *
* access path contains multiple index                          *
* access.                                                      *
****************************************************************
* RECOMMENDATION:                                              *
* Apply corrective PTF when available                          *
****************************************************************
ABEND0C4 at DSNXOGP offset 0AB44 may occur for an SQL statement
whose access path contains multiple index access.
The abend is intermittent depending on the availability of
certain storage.
Problem conclusion
Db2 has been modified to correctly process the aforementioned
SQL statement.
Additional Keywords ABEND0C4 SQLEXPLAIN SQLINDEX MIDX
                    SQLACCESSPATH
Modify message

2
z/OS Server / CMOD has surfaced the following Db2 APAR
« on: March 12, 2024, 09:50:11 PM »
PH56940: ABEND0C4 RC10 AT DSNXOD3 OFFSET04726 MAY OCCUR FOR THE QUERY USING SINGLE INDEX ACCESS

Error description
ABEND0C4 RC10 AT DSNXOD3 OFFSET04726 MAY OCCUR when explaining
an SQL statement whose access path contains single index access.

KEYWORDS: ABEND0C4 SQLEXPLAIN SQLACCESSPATH
Local fix
Avoid Explain on the impacted SQL statement.
Problem summary
****************************************************************
* USERS AFFECTED:                                              *
* All users of Db2 12 and Db2 13 for z/OS who                  *
* explain queries whose access path contains                   *
* single index access.                                         *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* ABEND0C4 at DSNXOD3 offset 04726 may                         *
* happen when explaining an SQL                                *
* statement whose access path contains                         *
* single index access.                                         *
* Abend only happens when the accessed                         *
* storage is not available. Otherwise,                         *
* incorrect information may be populated                       *
* into column IBM_SERVICE_DATA of                              *
* PLAN_TABLE.                                                  *
****************************************************************
* RECOMMENDATION:                                              *
* Apply corrective PTF when available                          *
****************************************************************
For example:
EXPLAIN ALL SET QUERYNO = 1 FOR
SELECT C1,C2 FROM T1
WHERE T1.C1 = 100;
Index IX(C1) is chosen to access T1. When populating data into
PLAN_TABLE, an invalid array index zero is used that may result
in ABEND0C4 at DSNXOD3 offset 04726 or incorrect information in
column IBM_SERVICE_DATA of PLAN_TABLE.
Problem conclusion
Db2 has been modified to correctly process the aforementioned
SQL statement.
Additional Keywords ABEND0C4 SQLEXPLAIN SQLINDEX

3
z/OS Server / CMOD has surfaced the following Db2 APAR
« on: March 12, 2024, 09:46:56 PM »
PH57851: ABEND0C4 MAY HAPPEN AT DSNXOGP:0AB44 FOR QUERY WITH MULTI-INDEX ACCESS.

Error description
ABEND0C4 may happen at DSNXOGP:0AB44 for query with multi-index
access.
The abend happens during choosing access path for query.

ADDITIONAL SYMPTOMS:
ABEND0C4 MIDX DSNXOGP OFFSET0AB44 OFFSETAB44 0AB44 AB44
Local fix
BYPASS/CIRCUMVENTION:
Please try adding OPTIMIZE FOR 1 ROW to discourage optimizer
from using multi-index.
Problem summary
****************************************************************
* USERS AFFECTED:                                              *
* All users of Db2 12 and Db2 13 for z/OS who                  *
* has queries whose access path contains                       *
* multiple index access.                                       *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* ABEND0C4 at DSNXOGP offset 0AB44 may                         *
* occur for an SQL statement whose                             *
* access path contains multiple index                          *
* access.                                                      *
****************************************************************
* RECOMMENDATION:                                              *
* Apply corrective PTF when available                          *
****************************************************************
ABEND0C4 at DSNXOGP offset 0AB44 may occur for an SQL statement
whose access path contains multiple index access.
The abend is intermittent depending on the availability of
certain storage.
Problem conclusion
Db2 has been modified to correctly process the aforementioned
SQL statement.
Additional Keywords ABEND0C4 SQLEXPLAIN SQLINDEX MIDX
                    SQLACCESSPATH

4
z/OS Server / `
« on: March 12, 2024, 09:40:15 PM »
PH56940: ABEND0C4 RC10 AT DSNXOD3 OFFSET04726 MAY OCCUR FOR THE QUERY USING SINGLE INDEX ACCESS

Error description
ABEND0C4 RC10 AT DSNXOD3 OFFSET04726 MAY OCCUR when explaining
an SQL statement whose access path contains single index access.

KEYWORDS: ABEND0C4 SQLEXPLAIN SQLACCESSPATH
Local fix
Avoid Explain on the impacted SQL statement.
Problem summary
****************************************************************
* USERS AFFECTED:                                              *
* All users of Db2 12 and Db2 13 for z/OS who                  *
* explain queries whose access path contains                   *
* single index access.                                         *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* ABEND0C4 at DSNXOD3 offset 04726 may                         *
* happen when explaining an SQL                                *
* statement whose access path contains                         *
* single index access.                                         *
* Abend only happens when the accessed                         *
* storage is not available. Otherwise,                         *
* incorrect information may be populated                       *
* into column IBM_SERVICE_DATA of                              *
* PLAN_TABLE.                                                  *
****************************************************************
* RECOMMENDATION:                                              *
* Apply corrective PTF when available                          *
****************************************************************
For example:
EXPLAIN ALL SET QUERYNO = 1 FOR
SELECT C1,C2 FROM T1
WHERE T1.C1 = 100;
Index IX(C1) is chosen to access T1. When populating data into
PLAN_TABLE, an invalid array index zero is used that may result
in ABEND0C4 at DSNXOD3 offset 04726 or incorrect information in
column IBM_SERVICE_DATA of PLAN_TABLE.
Problem conclusion
Db2 has been modified to correctly process the aforementioned
SQL statement.
Additional Keywords ABEND0C4 SQLEXPLAIN SQLINDEX

5
MP Server / Re: Updating retention for historical loads
« on: March 05, 2024, 12:43:49 PM »
I still don't know the answer to your question, but...

I was thinking to do arsxml update.

...that's fine. 

I was concerned that the intention was to use straight SQL to change table values.

Ed Arnold

6
MP Server / Re: Updating retention for historical loads
« on: March 04, 2024, 11:37:57 AM »
ODSA -

I don't know the answer to your question but...

> I am planning to do a direct DB update to change the retention to 7 for all the AGs.

...this sounds very dangerous.

Ed Arnold

7
MP Server / Re: Loading reports online from the AS/400 to CMOD MP
« on: February 29, 2024, 07:21:51 AM »
Olivier - This is how it works on multiplat boxes, I'll assume the same for IBM i:

 "instance" ---- you shouldn't need a full install of CMOD on the IBM i box, just lay down the code.

Then point arsload to the server.

Ed


8
MP Server / Re: arsmaint has stopped working post CMOD upgrade from 8.5 to CMOD 10.5
« on: February 19, 2024, 01:18:32 PM »
mayank - are you good now?

Ed Arnold

9
z/OS Server / Re: CMOD 10.5 Release Notes
« on: February 08, 2024, 02:01:48 PM »
At 10.5.0.7 the default TLS (SSL) level for both clients and the server flips from TLS V1.2 to TLS V1.3.

If implementing TLS for the first time, things might be easier if all of CMOD, clients and servers, are at 10.5.0.7 first.

10
MP Server / Re: CMOD roadmaps after V10.5
« on: February 02, 2024, 08:37:20 AM »
Quote
This is inquiry from customer. Because they decision for upgrade project, and inform that if we go 10.5 and EOS in next year, this will not worth to upgrade it.

Hello Teera - I occasionally get asked about CMOD plans and directions.

First off - nobody tells me anything, and I don't want to know, either.  That way I can maintain plausible deniability about CMOD plans and directions.  :-)

What I do when asked is point people to this official doc:

https://www.ibm.com/support/pages/how-do-ptf-numbers-relate-content-manager-ondemand-product-version-numbers-and-maintenance-fix-packs

It's written for z but the information is true across all platforms.  All service fixpacks, all announcement and end-of-service dates are in lockstep across the CMOD platforms.

You can see that 10.5 is the only currently supported release.

No announcement has been made (yet) about a follow on release.

I believe that an announcement of support has always given a customer two years to upgrade.

No announcement has been made for 10.5 EoS so at a minimum there would most likely be two years to upgrade.

CMOD 10.5 is currently at fixpack 7 (10.5.0.7).  While it really means nothing note that 9.5 and 10.1 put out several more semi-annual fixpacks during their lifecycle.

One thing I can say is that new function lately has been pushed out via fixpack, so read those fixpack announcements thoroughly!  :-)

Anyway, I absolutely recommend upgrading to 10.5.  Get to a supported environment.

Ed Arnold


11
z/OS Server / Don't specify an index two different ways
« on: January 02, 2024, 10:51:41 AM »
Specifying an index parameter two different ways is unsupported.

Specifically, in this instance, the problem was specifying job_name index created from two different sources: (INDEX1= and -b/-B).

After upgrading from 10.1 to 10.5 the symptom was reports that failed to load, despite having loaded successfully at 10.1.

In these cases, the 88-type record simply indicates an error of RC = 6.   

The desire was for -b/-B to win, overriding what ACIF (or any of the indexers) might have found in the report.   

However, that is  not supported. 

Remove one of the specifications.


12
z/OS Server / z/OS V3.1 Release Notes
« on: January 02, 2024, 09:38:37 AM »
Nothing to report yet. 

Just letting everyone know that we've got it up and running and are exercising it.

Ed

13
z/OS Server / Re: z/OS V2.5 Release Notes
« on: December 21, 2023, 09:32:09 AM »
IF you try running an SSL test with CMOD

https://www.ibm.com/docs/en/zos/2.5.0?topic=2-system-ssl-module-verification-setup

AND IF CMOD fails with:
 
CEE3501S The module //GLDCLS64 was not found

CEE3501S The module //GSKC64F was not found

THEN you're missing the following:

FMIDs JRSL441 and JCTP451 which supply those 2 missing ++PROGRAM parts.
 
These are IBM® Tivoli® Directory Server for z/OS® (IBM TDS for z/OS) and SSL System Security Level 3

https://www.ibm.com/docs/en/zos/3.1.0?topic=descriptions-zos-security-level-3

https://www.ibm.com/docs/en/zos/2.5.0?topic=descriptions-tivoli-directory-server-zos-tds-zos


14
MP Server / Re: Unable to ping arssockd / load
« on: December 14, 2023, 11:10:24 AM »
Thanks for posting the resolution

Ed

15
MP Server / Re: PreReq - Installation in a Windows Environment
« on: December 14, 2023, 11:08:31 AM »
For CMOD, you can see the official list of prerequisites here:

https://www.ibm.com/support/pages/node/1170004

Db2 I'll let someone else chime in.

Ed


Pages: [1] 2 3 4 5 6 ... 80