Messages

1

MP Server / Re: arsdoc retrieve too slow AIX 7.1 CMOD 9.5 DB10.5

« on: March 27, 2020, 01:13:41 PM »

Hi derrick

If apparently it is installed, I attach the images.

It is worth mentioning that we are only using Cache storage.

I have done tests to show with the command "more", the physical files at the operating system level (they obviously appear strange characters because they are PDF) and I have no problems with any.

Regards.

2

MP Server / Re: arsdoc retrieve too slow AIX 7.1 CMOD 9.5 DB10.5

« on: March 26, 2020, 04:28:08 AM »

Hi jsquizz,

Nothing really is observed, only the exaggerated recovery time for the documents for the application group PAN_EstadoCuentaRetail.

I attached the file from SystemLog where "Message" column can be filtered by:
PAN_EstadoCtaTC (fast retrival time)
CRI_EstadoCtaTC (fast retrival time)

PAN_EstadoCuentaRetail (slow retrival time)

thanks in advance!

3

MP Server / Re: arsdoc retrieve too slow AIX 7.1 CMOD 9.5 DB10.5

« on: March 24, 2020, 11:17:09 AM »

Hi,

Sorry for refloating the thread, but we still have the problem.

We have detected that the arsdump program varies too much in the execution times, it does not matter if it is from the ICN, the Windows client or the arsdoc.

Search is fast for all applications, queries in DB apparently respond the same way for all applications. But it takes almost 3 times longer when recovery is invoked with the arsdump program (from ICN, Windows Client, arsdoc).

What can we do to investigate the cause of this? Is there a way to modify the execution parameters of arsdump?

4

MP Server / Re: arsdoc retrieve too slow AIX 7.1 CMOD 9.5 DB10.5

« on: November 29, 2019, 05:10:54 PM »

You mentioned that you are exporting from one environment, and these images (IMG1-3) are from when you load them back into the new environment, correct?

No.  The images (IMG1-3) are from the original loads to the "old" environment

It looks like you are loading them using, hmm, the "Graphical PDF Indexer", correct? Or are you using "Internal indexing" (PPDs)?

Yes, in the original load we used the Graphical PDF Indexer.

The load process spends HUGE amounts of time indexing. Therefore, one way to speed up the load would be to use the -g flag during export (arsdoc get ... -g = Create generic indexer file), and then to use the flags -X G (="Find a generic indexing file") during arsload.

Yes, the files were loaded with pdf indexer originally, but to retrieve them from the original environment we're using the generic indexer (with -g flag). To load on the new environment we're using the flag -X -G.

I don't know if I create a file with the generic indexer it has to do something with the type of compression in the PDF file that originally loaded. Is there a way to change the type of compression once is already loaded? the development team says it's  an OD77 compression

Sorry for the delay

5

MP Server / Re: arsdoc retrieve too slow AIX 7.1 CMOD 9.5 DB10.5

« on: November 22, 2019, 09:11:44 AM »

Are the PDF's that are taking forever older loads?

No. They were loaded at similiar time

6

MP Server / Re: arsdoc retrieve too slow

« on: November 22, 2019, 08:01:45 AM »

You haven't given us any information on your environment - which version of CMOD, your OS & version, and database engine and version.  All versions should include the fixpack level.

Providing this information in your original post is the best way to help us to help you! 

-JD.

Hello Justin,

Here is the information on the environment

• DB2 10.5 fixpack 7
• CMOD 9.5 fixpack 10
• AIX 7.1 TL 4 SP 4

If you need any more information let me know

thank you in advance.

7

MP Server / Re: arsdoc retrieve too slow

« on: November 21, 2019, 06:04:52 PM »

Hello. thanks for the response

All the PDFs use the Standard fonts, none of the funky fonts.

I'll post some images to explain more detailed the problem

Ok, the first image (IMG1) this one uploads fast and the retraival time is fast as well

The second image (IMG2) this one uploaded slow (around 25 seconds) but the retreival time is relative fast

And the last image (IMG3) is the one taking long, uploading (25 seconds) and slow retrieving (25 seconds) (As i mentioned, no funky fonts nor images or colored text.)

Just to clarify, all the documents are already uploaded, so the only thing that matter right now is how to retrieve them.

Thanks for the help

8

MP Server / Re: arsdoc retrieve too slow

« on: November 20, 2019, 02:55:24 PM »

The interesting thing about that is..

The application group ABC and XYZ have even more colors and images in the PDF (the faster one)
And the one that is taking longer, is only text lines.

I'll check the system load like you said.

9

MP Server / Re: arsdoc retrieve too slow

« on: November 20, 2019, 12:22:16 PM »

The 3 application are PDF files

10

MP Server / arsdoc retrieve too slow AIX 7.1 CMOD 9.5 DB10.5

« on: November 19, 2019, 02:41:30 PM »

Hello,

We have 3 identical application groups, same compression ratio, similar structure, only cache storage, similar number of documents and none of them have segment tables.

All of them with one associated application. 2 of the applications takes 5 seconds to retrieve each document and the other application takes 15 seconds (This one is the more noticeable), it doesn’t matter if it’s the web client, thick client or recovery from arsdoc.

Currently we’re extracting the reports from one environment to another, using arsdoc get with the recovery by LoadID.
There’re around 4 millions of documents each application, so you can imagine how long it takes to retrieve the documents.

In the 3 application groups the search fields are set to filter.

What would you recommend to enhance the retrieval time?

Thanks in advance.