Hi Everyone,

I may not original forum owner, but I was founded same issue. (Error 408: No availble connections to pool odpool)
Unfortunely, I have no issue on firewall/connectivity. (WAS/CMODREST/CMODSERVER on same server!)

================
My arsrestapi.log:
2025-Apr-11 13:10:58.728 PM [] INFO  SecurityPropertyReader:provideServerPropertiesMap - Number of keys stored: 2
2025-Apr-11 13:10:58.729 PM [] INFO  PoolPropertyReader:provideServerPropertiesMap - Reading pool properties from -> poolConfig.properties
2025-Apr-11 13:10:58.730 PM [] INFO  PropertyMapReader:provideServerPropertiesMap - Reading pools from -> /opt/ibm/ondemand/V10.5/restcfgdir/pools
2025-Apr-11 13:10:58.730 PM [] INFO  PropertyMapReader:provideServerPropertiesMap - Pool configuration: /opt/ibm/ondemand/V10.5/restcfgdir/pools/odpool.conn
2025-Apr-11 13:10:58.733 PM [] INFO  StartupListener:init - Starting pool: odpool
2025-Apr-11 13:10:58.759 PM [] FATAL StartupListener:init - Trace directory does not exist!
2025-Apr-11 13:12:40.619 PM [ad5d072a-8f12-4bc6-b681-77521746bca3] INFO  LogFilter:filter - GET request to path v1/ping has been made wih authorizaion header CMODSharedKey odpool-{access-id}
2025-Apr-11 13:12:40.627 PM [ad5d072a-8f12-4bc6-b681-77521746bca3] INFO  SignatureRequiredFilter:filter - Security is currently disabled. Please note, this is intended for debug/development purposes only. This is not advised for production environements.
2025-Apr-11 13:12:40.651 PM [ad5d072a-8f12-4bc6-b681-77521746bca3] ERROR PingServiceImpl:getpingInfo - Trace directory does not exist!
2025-Apr-11 13:12:40.652 PM [ad5d072a-8f12-4bc6-b681-77521746bca3] ERROR PingService:ping - Server busy... Maximum pool size reached, no available connections!
2025-Apr-11 13:12:40.658 PM [ad5d072a-8f12-4bc6-b681-77521746bca3] INFO  LogFilter:filter - GET response from path v1/ping has been made

===================
My cmodtest.tmpl:
#OD Server Settings
odHost=192.168.40.102
odPort=1445
odUser=admin
odPassword={my-password}
odInstance=archive
transformXML=/opt/ibm/ondemand/V10.5/config/arsxform.xml
secureAPI=False
language=ENU
maxHits=100
tempDir=/tmp
traceDir=/tmp/traceDir
traceLevel=1
odInstallDir=
odCachedFolderList=
odEncryptionKey=
odSetKeyBeforeLogin=
mime-txt=text/plain
mime-pdf=application/pdf
# Pool
minIdlePerPool=3
maxIdlePerPool=10
maxTotalPerPool=10
maxTotal=40
maxWaitMillis=5000

#SSL Settings
USE_SSL=FALSE
SSL_KEYRINGFILE=
SSL_KEYRINGSTASH=
====
/opt/IBM/WebSphere/AppServer/profiles/AppSrv01/installedApps/{MyServer}Node01Cell/cmod-rest_war.ear/cmod-rest.war/WEB-INF/classes/poolConfig.properties :
#Connection Pool Settings

# minIdlePerPool:
#
# The target for the minimum number of idle connections to maintain in each of the Pooled sub-pools
# Also used when instantiating the number of server connections created at startup for a given pool
minIdlePerPool=3

# maxIdlePerPool:
#
# The cap on the number of "idle" server connections per Pool
maxIdlePerPool=10

# maxTotalPerPool:
#
# The limit on the number of connections allocated by the pool (checked out or idle), per Pool
maxTotalPerPool=10

# maxTotal:
#
# The cap on the total number of connections managed by the pool. Negative values mean that
# there is no limit to the number of connections allocated by the pool
maxTotal=100

# maxWaitMillis:
#
# The maximum amount of time (in milliseconds) the borrowObject() method should block before
# throwing an exception when the pool is exhausted and getBlockWhenExhausted() is true. When
# less than 0, the borrowObject() method may block indefinitely.
maxWaitMillis=5000

===
Related Files/Folders:

# pwd
/opt/ibm/ondemand/V10.5/restcfgdir
# find .
.
./keys
./keys/MyAccessID.ksf
./cmodtest.tmpl
./pools
./pools/odpool.conn



Can anyone found same issue?

I am using ARSMAINT to expire documents that have reached the aging criteria as defined in the Application Group in CMOD 10.1.0.3.


Command:
arsmaint -c -d -u admin -p xxxx -n 0 -x 0 -g MY-APPGROUP

However, it seems that there is a limit to the number of load IDs that can be expired at one time.

For example, if 1,000 documents meet the aging criteria for expiration in CMOD, the first execution of ARSMAINT will expire only the first 100 load IDs. The next execution will expire load IDs 101–200, and so on, until all 1,000 load IDs are expired.

I'm unsure whether this behavior has been previously observed or if IBM has issued any notice regarding this change in the ARSMAINT program. Additionally, I haven't found any new parameters that would allow an increase in the limit for the number of load IDs expired per execution.

# arsmaint
ARS1201I Usage: arsmaint [-c [-n <min>] [-x <max>]] [-d] [-D <pct>] [-e] [-f <full>] [-g <name>] [-i] [-I <od_inst>] [-L] [-m] [-o] [-r] [-R] [-t <yyyy-mm-dd> [-u <userid>] [-p <passwd>]]
        Version:  10.1.0.3
        -c Expire Cache
        -d Expire Database
        -D <pct> Threshold of load being held before reloading
                 (defaults to 0% - not reloaded)
        -e Migrate Database Tables
        -f <full> Cache Full - When to send alert message (defaults to 95%)
        -g <name> Application Group Name (Defaults to all)
        -h <od_inst> OnDemand Instance Name (same as -I)
        -i Expire Migrated Imported Database Tables
        -I <od_inst> OnDemand Instance Name (same as -h)
        -L Update load id table with application id
        -m Migrate Cache
        -n <min> Min cache threshold percentage (Only for -c, Defaults to 80%)
        -o Expire OnDemand Distribution Facility
        -p <passwd> OnDemand Passwd Stash File (Only for -t)
        -r Database Statistics
        -R Reload Resources
        -s Cache Filesystem statistics
        -t <yyyy-mm-dd> Date To Expire/Migrate (Defaults to Today)
        -u <userid> OnDemand Userid (Only for -t)
        -v Verify/Validate Cache Filesystems
        -x <max> Max cache threshold percentage (Only for -c, Defaults to 80%)

Does your arscache filesystems utilization is relies to your parameter?
-n 60 -x 70 : meant if threshold over 70%, expire until it has been reduced to 60%.

Old topic but need to re-confirm, do you have any impact from move CMOD AIX to Linux?
I found some concern about big endian (AIX) vs little endian (Linux) for cache filesystems

But, DB2 should be fine to use DB2MOVE

Based on your license types. (e.g. AUVU, PVU, ...)

AUVU (Authorized User Value Unit): This counts the number of unique users added to the IBM CMOD system. The number of AUVUs purchased must not be exceeded by the number of users in the system.

PVU: Processor Value Unit - IBM has reference table to calculate brand/number-of-core to PVUs.
Intel core will use less PVU than POWER-core half-by-half as I remembered.
(ex. Intel 4-cores=70PVU, POWER 4-cores=140PVU ..this may not actual values just example)

This licensing model requires the use of ILMT (IBM License Metric Tool) to track and report the number of CPU cores in your LPAR/VM, ensuring compliance with the number of PVUs purchased.

Also, they have some more license model -- RVU, Employee VU, ..

However, double check with IBM sale representative for your license usage.

Does IBM CMOD product has some document or certificate that passed security scan for product?
(e.g. Passed OWASP top 10, secure coding, penetration test, or VA scan)

In case of software packages, banking customer need this documentation/certification to approve go-live.
(In case of app development, they need to have source code scan, VA Scan, penetration test processes.)

Hi Justin,

Thank you.
It seem arspdoci used for managed pdf indexer for CMOD loading (Like a pdf indexer that use in Admin Client to setup index position from PDF document)
But what I find out is how to cut PDF by offset/lenght specified in .ind file from arsdoc get.

Thank you

Hi Justin,

Thank you for your reply.
Yes, I quite okay with generic index file because I often to use for loading PDF and other types to CMOD.

The generic index file that I have ever used as below format. (Offset=0, Length=0)
...
GROUP_OFFSET:0
GROUP_LENGTH:0
GROUP_FILENAME:File1.pdf
               
...
GROUP_OFFSET:0
GROUP_LENGTH:0
GROUP_FILENAME:File2
...



But I mentioned about PDF merge files that got from arsdoc_get, they're not append file2, file3, ... to page 2, page 3, ...
But it append/build something like a layers or binary combined.

Indexer has reference to same file but changed on offset and length

...
GROUP_OFFSET:0
GROUP_LENGTH:102187
GROUP_FILENAME:PDF-TIV2.pdf.0.PDF-TIV2.PDF-TIV2.out
               
...
GROUP_OFFSET:102187
GROUP_LENGTH:681891
GROUP_FILENAME:PDF-TIV2.pdf.0.PDF-TIV2.PDF-TIV2.out
...


Do you know or can share document that explain about this PDF's specification or utllity to split it back to original?

You may use DB2HADR for sync CMOD database, but you need another technic to managed arscache, one thing is storage replicate

But I never use DB2 HADR with CMOD, only storage replication for all (Both DB2, arscache)
I have some customer install CMOD, DB2 on 2 sites, and put data to SAN Storage.
In normal case, this storage will mounted on production, replicate to DR, and mount to DR on disaster case. (Then start services)

One issue that cannot prevent in this scenario is data corruption, destination will got same data from source storage.
Another point is RPO, since DB replicate by storage, so some last transaction that's incomplete may lost in rollforward/recover when start DB at DR site.

I have requirement to export all data from CMOD to original pdf with indexes of them. (To use on another system)

So, I try to used 'arsdoc get' command. But output of PDF will be merged in very strange format cannot use to another system,
that is when open by normal PDF viewer will show only first file that exported from CMOD but I exported about 10 pdf files from CMOD.
When inspect filesize of PDF merged, I see filesize come from 10 pdf combined. (Ex. each file is 100K, merged file is 1000K)
In index file will show offset/lenght of each PDF. I think it managed as layers of PDF.


arsdoc get -hlocalhost -uadmin -ppassword -f "PDF-TIV" -g  -N -c -i "where doc_no like '%'" -o PDF-TIV.pdf
Note:
- When arsload back to CMOD, it will spilit to 10 PDF file correctly
- Option -g -N -c needed to used together.

Screenshot: https://u.pcloud.link/publink/show?code=XZCVdJ0ZotyT0txuaOYVyljCldfCzSOyuzd7

Thank you very much everyone. I will convince end customer to go 10.5.

Since CMOD 10.5 release since 2020, I'm not sure when is roadmaps to release newer version.
(Average aging for version will be 5 years, that 10.5 may EOS in 2025, or 10.5 will be version that extend life time to 7-8 years)

This is inquiry from customer. Bcause they decision for upgrade project, and inform that if we go 10.5 and EOS in next year, this will not worth to upgrade it.

Quote from: spond on December 23, 2019, 12:33:40 PM
Also, I forgot to mention (although L2 support will mention this when you contact them), as always, you must be at the latest V10.1.0.5 fix pack to apply the HTML5 Viewer fix.

I'm not sure that does overlapping content is meant each lines are too close like my screenshot? (This may has censor on data)

Greeting on Y2020.

After I tried with ICN CMOD with LineDataHTML5Viewer on Y2018, we decision to use other solution to view LineData (Maintain LineDataApplet) because I have no time to open PMR with IBM Support.

Good news, in this year I have some more progress on setup this.
After I extract ...\www\viewers\LineDataHTML5Viewer.zip into ICN deployed path ...\WebSphere\AppServer\profiles\AppSrv01\installedApps\mynode\navigator.ear\navigator.war\viewers\LineDataViewer\js and rename Folder to "LineDataViewer"

Configure ICN's viewermaps to use LineDataHTMLViewer.

The viewer has been launched successful but has only black square picture on that. Very funny  ::) :o

Do you have anyone success to deploy LineDataHTML5Viewer? Please share with us, what am I wrong?

As I have ever used CMOD 8.5 and Later. After enable LDAP authentication, we still can authenticated by local user/password by using this parameter  ARS_OD_AUTHORITY_FALLBACK=TRUE

But on CMOD 10.1, it seems this parameter has been gone, and as my tried local user/password will logon failed.
https://www.ibm.com/support/knowledgecenter/en/SSEPCD_10.1.0/com.ibm.ondemand.installmp.doc/dodax005.htm

How can I implement AD/Local authenticate as CMOD 8.5 way?

Thanks,