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.


Messages - jsquizz

Pages: 1 [2] 3 4 5 6 7 ... 37
16
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.

17
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!

18
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

19
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?

20
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

21
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?

22
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

23
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.

24
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!

25
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.

26
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!


27
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?

28
MP Server / Issue Loading to S3 (EMC)
« on: October 27, 2023, 09:29:47 AM »
Hi all,

Working on loading to EMC via S3.

Within ars.s3 - We have defined-

Code: [Select]
ARS_S3_VENDOR=EMC
ARS_S3_REGION=...
ARS_S3_SERVER=...
ARS_S3_SERVICE=S3

The message after trying to load -

Code: [Select]
S3 Interface (AMAZON) Error: Message=Couldn't resolve host name, Resturn Code=6
One thing to note, we can ping the S3_SERVER from our desktops, but not from the server we are trying to load from.

Not sure if this is an S3 configuration issue or a CMOD config issue. The one thing that is wondering me is since its trying to resolve AMAZON, yet EMC is defined as the provider..?

29
MP Server / Re: OnDemand on Linux fails with Higher Version (CMOD 9.5)
« on: September 26, 2023, 02:36:46 PM »
Just a quick note to thank Roberto and Alessandro for this thread...  Almost 10 years later, it helped me upgrade a client from v7 all the way to v10.5...

Another awesome display of the power of the forums.  :)

-JD.

10.5.0.7?

We're having what appears to be install anywhere / java issues with RHEL on that one.

Code: [Select]
[root@server od]# ./odlinux1057.bin -i console -DOD_HIGHER_VERSION_CHECK=false
Preparing to install
Extracting the JRE from the installer archive...
Unpacking the JRE...
Extracting the installation resources from the installer archive...
Configuring the installer for this system's environment...

Launching installer...

Error: Could not find or load main class com.zerog.lax.LAX
Caused by: java.lang.ClassNotFoundException: com.zerog.lax.LAX

Google related to another product said to try this:

Code: [Select]
export JAVA_TOOL_OPTIONS=-Djdk.util.zip.disableZip64ExtraFieldValidation=true
So doing this along side

Code: [Select]
./odlinux1057.bin -i console -DOD_HIGHER_VERSION_CHECK=false
Prompted me to:

Code: [Select]
Please Wait
-----------
------|-------
    1- Yes to All
    2- Yes
    3- No
    4- No to All

A newer file named "commons-text-1.10.0.jar" already exists at
   "/opt/ibm/ondemand/V10.5/jars".

Which led to:

Code: [Select]
Installation Complete
---------------------

Congratulations. IBM OnDemand V10.5 has been successfully installed to:

   /opt/ibm/ondemand/V10.5

PRESS <ENTER> TO EXIT THE INSTALLER:
[root@server od]# /opt/ibm/ondemand/V10.5/bin/arsxml
ARS7700I Usage: arsxml add|update|delete|export|validate [options]
        Version:  10.5.0.7



30
z/OS Server / Re: DSNT408I SQLCODE = -804, ERROR
« on: August 17, 2023, 07:36:50 AM »
Here's some total WAGs:

Check app group definitions to make sure AcctNo has the same definition in all App Groups

If you have database access, something like:
Code: [Select]
select * from arsagfld where name like 'acctNo' will make any differences a little more obvious.

Turn off parameter markers for queries

Ask your DBA to check their diagnostic logs (db2diag.log in the LUW world) for more info.

-JD.

Turning off parameter markers gave us the results I need -> I think. We're able to see the queries and are still investigating.

I've never had to touch that checkbox before. Thanks from myself and my colleagues.

Pages: 1 [2] 3 4 5 6 7 ... 37