Messages

16

MP Server / Active / Passive setup - Who's doing what?

« on: January 24, 2024, 02:56:31 PM »

Hi Folks,

I saw some posts around here regarding HADR + CMOD, which were very old. I am wondering - Is anyone using HADR with the product?

My thought was-2 servers, \arscache mounted to both - then a primary and standby node. Data center 1 goes down, takeover on data center 2, and the data will be right there too.

I'm not a db2 dba and unfortunately i dont have access to one for this project.

I think that this might be a viable solution as long as replication is done properly, and only one arssockd is touching the database at the a time.

Dual loading is also an option I've seen many of the customers I've worked with do. My only concern is inconsistencies between data centers. Data center 1 goes down, docs queue, there's no recon process, things get messy - etc. I've usually seen custom coding put around it. I think overall the best solution probably is dual loading - especially since they mentioned their daily backups of the database, OS images, and cache

Unfortunately - zookeeper/purescale is not an option.

wondering what everyone thinks. Thanks in advance

17

Announcements & News / Re: UPDATE: Single Sign On ("SSO") on CMOD with ICN

« on: January 24, 2024, 02:25:11 PM »

Hey JD, qq-

Do you know if SSO works with the thick client?

18

MP Server / Re: How Can I Optimize ARSDOC GET

« on: January 24, 2024, 06:18:03 AM »

I had a ticket open with IBM and they've pretty much said it's TSM causing the lag. I'd like to bypass looking in CACHE first only because I know for a fact that all the documents are in TSM only. I'm waiting on my TSM guy to be available so I can get him to open another ticket for TSM to see if it can be tuned to work faster. The external entity may need the pdf's individually because they definitely don't use CMOD so I don't see the value of generating a generic index file. But what do I know.

That is a very valid point. Unfortunately, I've seen that also. Perhaps checkout ARSADMIN - I'm not very familiar with it but you can essentially retrieve documents as a "bunch" for lack of a better term

19

MP Server / Re: How Can I Optimize ARSDOC GET

« on: January 23, 2024, 11:21:01 AM »

Hm, strange.

I did a full system extraction using arsdoc get with -X, no issues. Perhaps your DB is not tweaked right or there's a setting off in the the RHEL (Based on your reply to my post..) server.

Maybe give it "more juice"

But as far as arsdoc goes, just as a force of habit I usually do-

arsdoc get -u <user> -p <stash> -agcNv -G <ag> -X loadID -o <AgName>

or

Query the data tables, grab the DOC_NAME

Lets say theres 100 tables, maybe do three lists, of the doc_names do

List1:
FAA1
FAA2
FAA3
FAA4

List2:
FAA5.. etc

I think when I did the extract in 2021 I did something like:

Code: [Select]

#!/usr/bin/bash
#script1.bash
<DefineVariables or config file..>
while read DOC_NAME; do
   arsdoc get -u ${USER} -p ${PASS} -h ${HOST} -agcNv -i "where doc_name like '%${DOCNAME}%': -o ${AGNAME}
done < list1.list

nohup ./script1.bash > round1.out 2>&1 &


there's a few ways to do this. I know you can use arsadmin as well, but I have never taken that leap.

20

MP Server / I need a sample file + overlay

« on: January 23, 2024, 08:35:31 AM »

Hi Gang, Let me preface with this is new to me and came out of the blue.

I have a requirement to load a line data file - with an overlay.

At some point in the process, the file will get converted to afp, followed by - afp2pdf via ICN

Does anyone have a sample overlay that I can use, as well as a corresponding line-data file?

I would appreciate it and owe ya one!

21

MP Server / Re: CMOD 10.5 License Type

« on: January 17, 2024, 02:02:13 PM »

So next question is, do anyone have experience changing license type by installing same fixpack version that is already installed?

I cannot imagine that will work.

I think your best case is to re-install, backup your config/registry files - and go from there. Should be straight forward i'd imagine

22

MP Server / Wintel : Moving Data - OnPrem SAN > AWS

« on: December 21, 2023, 08:04:04 AM »

I am working on a migration from windows 2012 to windows 2022.

I've successfully implemented V9.5 + DB2 V11.5 on a new server. I've taken a full offline database backup from the windows 2012 server, via the OnDemand scheduler.

I then successfully restored the database:

Code: [Select]

db2 "deactivate db archive"
db2 "restore db archive from e:\ replace existing"
db2 "activate db archive"
I used robocopy within windows to move around 10GB of test data.

I restarted the application via configurator, and the database looks good, metadata/objects/etc - All seem perfect and as expected.

when I go to retrieve a document.. I get

Code: [Select]

OnDemand is unable to determine the link for the file >f:\arscache1\retr\CBA\2FAAI<. The error number is 22
I ran arsmaint -rsv thinking that could tidy things up - and that did not work so far either.

Anyone have any thoughts/ideas/suggestions?

23

MP Server / Re: Unable to ping arssockd / load

« on: December 15, 2023, 09:25:25 AM »

Thanks for posting the resolution

Ed

One lesson learned. We are using the S3 API's to connect to EMC.

We had that working. Then we implemented LDAP/SSL.

Our LDAP/SSL changes, unfortunately broke something with the EMC connection. Lesson learned, do LDAP/SSL first. ALWAYS

24

MP Server / PreReq - Installation in a Windows Environment

« on: December 14, 2023, 09:02:07 AM »

Hi All,

I'm beginning an installation of CMOD on a Windows environment. It has been 10+ years since I have done this in a production environment, so it has been quite some time.

I am used to doing RHEL implementations - and I always install packages such libstdc, libaio, libpam - Things that are a pre-req to db2. Is there anything else that is specific to DB2/CMOD that I have to install?

25

MP Server / Re: Unable to ping arssockd / load

« on: December 14, 2023, 08:43:17 AM »

So, we did resolve this.

IBM support was fantastic in helping us with this. Lots of troubleshooting.

We had to recreate the key database.

gsk8capicmd_64 -cert -create -db "ondemand.kdb" -stashed -label "cmodcert" -dn "CN=some11.domain.here" -size 2048 -sigalg SHA256_WITH_RSA

Within ars.cfg - We set ARS_LDAP_PORT=636, and bam. Resolved. We took said keys and moved them to the respective clients and that resolved our issues.

I am no security expert but if I understand what we were told, there were some changes to the algorithm with the hash made in 10.5.0.7

26

MP Server / Re: Unable to ping arssockd / load

« on: December 08, 2023, 11:53:05 AM »

1) With SSL Turned OFF, and LDAP turned ON -> Works as expected
2) With SSL Turned ON, and LDAP with SSL turned ON -> Connection cannot be established to <Instance>
3) With SSL Turned ON, and LDAP turned OFF -> Connection cannot be established to <Instance>
4) With SSL and LDAP OFF -> Works as expected
5) With SSL Turned ON, and LDAP Turned OFF -> Connection cannot be established to <Instance>

Based on this, the correct settings will be scenario 2, LDAP with SSL.

The error message in the trace for scenario 2 is:

ERROR arsgskod.c(3567)ArcGSKOD_Connect:socket_init ssl_rc=403 ssl_str=GSK_ERROR_NO_CERTIFICATE

I can connect to CMOD via ICN with SSL turned on.

27

MP Server / Unable to ping arssockd / load

« on: December 07, 2023, 09:21:33 AM »

Hi Gang,

We're using CMOD V10.5/Redhat/Oracle. We are having issues issuing :

Code: [Select]

arssockd -I instanceName -P
arssload -I instanceName -g AppGroup -u user -p password -g AppGroup -nvf fileName
Its failing with connection cannot be established.

We're able to successfully ping arssockd via -I serverName / localhost -P. We can also load via the same. Also - ICN is configured to hit this library server with SSL, and I see a successful login using SSL.

When I turn off SSL, we can issue arssockd -P -I instanceName, as well as load fine, client, etc.

Has anyone ever seen this? We're on 10.5.0.7 with the latest GSK.

Thanks all!

28

MP Server / Re: Issue Loading to S3 (EMC)

« on: November 27, 2023, 01:32:29 PM »

After back and forth with the client - And getting IBM on the line with EMC - This was an authentication issue.

29

MP Server / Re: Windows: Migrating Data

« on: November 27, 2023, 01:31:55 PM »

Jeff - I think you're going to need to mount the data at F:

Ed

I am not sure if thats going to work. The current data sits on the F: drive locally. They are moving to AWS. I'm sure that they have some kind of file transfer utility to seamlessly do it, but my own testing didnt work right - I will try your approach in my sandbox environment.

Thank you!

30

MP Server / Windows: Migrating Data

« on: November 26, 2023, 08:05:48 PM »

Hello All,

Working with a client that is running:

Windows 2016
CMOD V9.5
DB2 V10.5

End goal, is everything running on 2022 Server + Latest versions of everything.

On the target server, I setup a CMOD environment that mimics that of the existing one (config settings, db2, etc..). I then took a backup of the database and restored it to the new CMOD instance running on 22 Server. Looks like that part worked.

Data on the old server is stored on F:/arscache1. I copied the data across the network and I am getting link errors, unable to retrieve the object.

Is this the best approach as far as the objects? Or, should I just mount the drive as F:/ ? Something I am missing?