Topics

1

MP Server / arsmaint has stopped working post CMOD upgrade from 8.5 to CMOD 10.5

« on: February 17, 2024, 11:59:52 PM »

Hello,

We have observed that since we have gone live with CMOD 10.5.0.5 which was an upgrade from CMOD 8.5 the arsmaint utility is not working. As the cache storage size has increased exponentially, we have TSM client node registered as our archive storage solution however we are also maintaining one copy of the documents inside cache folder as well that is for 90 days only. We tried opening documents which have been stored in CMOD for more than 90 days but still see them coming from cache node instead of TSM client node. are there any changes in the utility command parameters in new version?  prior to upgrade it was working fine

checked the permission and ownership of arscache/cache1 folder and everything seems correct as per IBM documentation.

parameters used in arsmaint command -cdrs

documents are not getting flushed from cache folder.

Thanks,
Mayank

2

MP Server / Can we perform both AND and OR operator operation in a single query using REST

« on: January 25, 2024, 06:23:59 AM »

Hello Members,

is there any possibility to allow AND and OR at the same time in the search ?

One way of doing it using SQL API in IBM CMOD REST but it is being blocked by the server firewalls as it contains where OR and AND keywords hence checking if someone has achieved it already through IBM CMOD REST search API

Warm Regards,
Mayank

3

MP Server / AFP2PDF conversion possibility using IBM CMOD REST APIs

« on: August 09, 2023, 11:39:21 AM »

Hi Team,

We are integrating CMOD 10.5 REST APIs into a custom application to retrieve AFP documents from CMOD and we want to transform these APF documents into PDFs before sending it to the caller of the document.

Has anyone tried anything like this before with REST APIs if you can suggest the possible options that will be great.
 I understand that this is possible with ODWEK APIs with generic transform interface which allows us to leverage RICOH afp2pdf to transform it but I am not sure how to achieve the same with CMOD REST APIs

Any suggestions will be greatly appreciated.

Thanks,
Mayank 

4

MP Server / CMOD 8.5.0.1 performance issues post machine restart

« on: August 02, 2023, 10:11:53 AM »

Hello Everyone,

I have come across a very wired situation where in CMOD 8.5 has started responding very slowly post AIX LPAR reboot.
Document retrieval is taking 3-4 minutes to open the document.

I understand that it is out of support version but it seems customer is not in the mood of upgrade. Any suggestions would be greatly appreciated.

Can anyone suggest things to be checked in this case ?
 
Thanks,
Mayank

5

MP Server / arsdoc query is failing with SQL0420N Invalid character found in a character st

« on: March 31, 2023, 10:59:03 PM »

Hi Team,
We are currently facing issue with one of our scripts. The primary area in which we are seeing this issue is the "arsdoc" query when it gets/extracts the documents from disk.
The snippet goes like below:

 

    /opt/IBM/ondemand/V10.5/bin/arsdoc \
      get -h $HOSTNAME \
          -f "$FOLDER" \
          -i "WHERE tstcrt_number||cast_number in (select tstcrt_number||min(cast_number) from root.$TABLE group by tstcrt_number) AND ARCHIVE_DATE = '$PREVMAXEXT' AND BS_CSI_No = '$CSI'" \
          -a \
          -d $WORK_DIR \
          -o ctbodctc.afp \
          -u dsgrep \
          -p /opt/IBM/ondemand/V10.5/config/ars.stash \
          -v >> $LOG 2>&1

 

Note : This arsdoc function gets/extracts data based on a filter criteria that takes customer_number into consideration.

 

Please note that the sql query in above arsdoc function is using "concat" or "||". The exact same query is running perfectly fine on AIX in our current production system.
However, when running this in Linux system in our new production machine



Error in Linux :
2023-03-31 20:19:04.331935: ARS6117I Querying database with SQL string 'WHERE concat(tstcrt_number,cast_number) in (select concat(tstcrt_number,cast_number) from root.RQD1) AND ARCHIVE_DATE = '03/30/2023' AND BS_CSI_No = '3147843''

 

2023-03-31 20:19:04.354335: ARS6085E Search unsuccessful

 

2023-03-31 20:19:04.354406: ARS6034W No hits were found that matched search criteria.

 

2023-03-31 20:19:04.354406: ARS6011E The error occurred on line number 1.

 

2023-03-31 20:19:04.354971: ARS6026I arsdoc completed.
---------------------------------------------------------------------------------------------------
Error in ondemand client :
2023-03-31 23:49:04.238311    DSGREP      130835221    Error    No        13    DB Error: [IBM][CLI Driver][DB2/LINUXX8664] SQL0420N  Invalid character found in a character string argument of the function "DECFLOAT".  SQLSTATE=22018  -- SQLSTATE=22018, SQLCODE=-420, File=arsdoc.c, Line=3563    system

6

MP Server / does IBM CMOD 10.5 support OCI as its archive storage solution

« on: January 06, 2023, 05:41:09 AM »

Hello,

Did anyone try to use OCI with IBM CMOD 10.5 as its archive storage solution ? I checked in the documentation but did not see it as an option.

Mayank

7

MP Server / TSM Upgrade from TSM 7.1.1.100 AIX to Spectrum Protect 8.1.12 RHEL 8.6

« on: December 19, 2022, 04:14:47 PM »

What will be the best approach to upgrade CMOD archive storage from TSM 7.1.1.100 AIX 7.1.1.100 to Spectrum Protect 8.1.12 RHEL 8.6 ?

We are upgrading CMOD 8.5 to 10.5 , any suggestions for TSM upgrade as mentioned above will be appreciated 

8

MP Server / AFP2PDF Plus Transform for CMOD 10.5 License type

« on: November 15, 2022, 04:12:23 AM »

Hello,

We are in the process of upgrading our CMOD 8.5 to CMOD 10.5 and we are using afp2pdf software to transform afp documents to pdf and looks like IBM has stopped selling the license for it and have directed to us to connect with RICHO to buy the license. Does anyone has any contact details of RICHO if you can share that will be helpful. Also if anyone can share the experience of this tool with Navigator as plugin ?

Thanks
Mayank