hi,
Currently I am doing some 2010 year extractions from our CMOD on z/OS - version 9.0.0.6 (DB2 + data in OAM files).
Document type - AFP.
I have issue while arsdoc get - error is "ARS2089E Information has been modified on the server. Please logoff, logon, and retry the operation."
Some log details:
2021-07-14 13:57:10.868179: ARS6063I Searching for documents in 'NLPDK-PENSOVER' ...
2021-07-14 13:57:10.868200: ARS6117I Querying database with SQL string '5;DATO,DATO,DOC_NAME,DOC_NAME,DOC_NAME;'2010-08-09','2010-08-09','','','';WHERE (DATO BETWEEN ? AND ?) AND DOC_NAME NOT IN (?,?,?) '
2021-07-14 13:57:17.757775: ARS6084I Search successful
2021-07-14 13:57:17.757879: ARS6107I 331 document(s) have been queried. Retrieving 331 document(s).
2021-07-14 13:57:17.950935: ARS2089E Information has been modified on the server. Please logoff, logon, and retry the operation.
2021-07-14 13:57:17.954641: ARS6026I arsdoc completed.
I was able to find problematic objects by reducing search period and then adding more conditions to SQL query to have less hit ratio.
But it is time consuming way to find problematic objects.
Q: Is there a faster way to find documents which has this issue?
While trying to open this document in CMOD Client we also have message: "Information has been modified on the server. Please logoff, logon, and retry the operation."
Offcourse logoff and logon does not help
.
I checked logs while loading these documents and this issue is connected with following db2 error:
03-06-2010 17:28:52 US00600 661504 Error No 13 DB Error: äDB2 FOR OS/390åäODBC DRIVERåäDSN08015å DSNT408I SQLCODE = -911, ERROR: THE CURRENT UNIT OF WORK HAS BEEN ROLLED BACK DUE TO DEADLOCK OR TIMEOUT. REASON 00C9008E, TYPE OF RESOURCE 00000302, AND RESOURCE NAME ARS
This error is occuring at the same moment while loading problematic documents.
Q: Can we somehow "rescue" this documents?
Regards
Rafal