Recent Posts

Pages: 1 2 3 4 5 [6] 7 8 9 10
51
MP Server / Use of external filesystem for the Archive storage manager
« Last post by obaltus on March 20, 2024, 06:26:26 AM »
Hello,

I am planning an installation, and I'd like to know if external storage basically a NFS mount on the CMOD server can be used as storage for the Archive storage manager?

Thanks for your help
52
MP Server / Re: Manually retrieving a document?
« Last post by Mattbianco on March 15, 2024, 04:21:19 AM »
Quote from: Mattbianco on October 02, 2019, 05:16:37 AM
Still curious about the 2nd and 3rd parameters: 148456,36678.

They are the offset and length of the decompressed document within the compressed document block.
The 4th and 5th parameter (976552,243727) are the offset and length of that compressed block within the 801FAAB object (DOC) file.

So, first decompress the 243727 bytes starting at byte 976552 of 801FAAB, and then take the 36678 bytes starting at 148456 of that decompressed output, for the actual document.
53
OD/WEK & JAVA API / Re: ODWek REST API 10.5.0.4 - response ask me to logoff and log on
« Last post by rjrussel on March 14, 2024, 10:08:38 AM »
Yes
54
OD/WEK & JAVA API / Re: ODWek REST API 10.5.0.4 - response ask me to logoff and log on
« Last post by Andreas Baaserud Hauge on March 14, 2024, 12:50:28 AM »
Thanks for reply rjrussel.

So because it is a connection pool - we need to restart the odwek-rest when we make these admin changes in OnDemand?
55
z/OS Server / CMOD has surfaced the following Db2 APAR
« Last post by Ed_Arnold 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
56
z/OS Server / CMOD has surfaced the following Db2 APAR
« Last post by Ed_Arnold 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
57
z/OS Server / CMOD has surfaced the following Db2 APAR
« Last post by Ed_Arnold 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
58
z/OS Server / `
« Last post by Ed_Arnold 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
59
OD/WEK & JAVA API / Re: ODWek REST API 10.5.0.4 - response ask me to logoff and log on
« Last post by rjrussel on March 12, 2024, 05:44:33 AM »
no - It's a connection pool. Connections are established when the REST services start.
60
OD/WEK & JAVA API / ODWek REST API 10.5.0.4 - response ask me to logoff and log on
« Last post by Andreas Baaserud Hauge on March 12, 2024, 01:58:52 AM »
Hi,

I am working with the ODWek REST API on IBM Content Manager OnDemand version 10.5.0.4
When performing the follow HTTP POST request

URL = http://localhost/cmod-rest/v1/hits/
HTTP Method = POST
Body
Code: [Select]
{
    "query": "where DateField between 230301 and 240301",
    "folder": "MYFOLDER"
}
Response
Code: [Select]
Information has been modified on the server.  Please logoff, logon, and retry the operation.
Bit surprised I get this response as I thought the ODWek REST API would take care of logoff, log on to CMOD right?
Pages: 1 2 3 4 5 [6] 7 8 9 10