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.

Topics - mayank81089

Pages: [1]
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.


MP Server / CMOD 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 ?

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


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.


What will be the best approach to upgrade CMOD archive storage from TSM AIX 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 

MP Server / AFP2PDF Plus Transform for CMOD 10.5 License type
« on: November 15, 2022, 04:12:23 AM »

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 ?


Pages: [1]