ARSLOAD extreme slow

[teeraw]

Okay, that's truly bizarre.  It's taking almost a full minute to return to CMOD after the load says it's complete.

I'm going to throw out a guess, and suggest that it's related to DB2.  The only step left after a successful completion of a load is to write messages to the System Log.  It seems like there's a 60+ second timeout happening somewhere.  Check the db2diag log for errors/messages happening around the time of this load.

Given that you're on a drastically unsupported version of CMOD, you're not likely to get much help from IBM.

It's been two weeks since this thread was started -- are you still having the issue?

-JD.

Yes, JD. I still have this problem.
But we tried to relief it by advise customer to perform multiple loading tasks.
For some application group, I have copied it to new one and it work fine. (Faster than old one)

And, customer used CMOD 8.3 that end-of-support, we are during push they to upgrade.

[teeraw]

Okay, that's truly bizarre.  It's taking almost a full minute to return to CMOD after the load says it's complete.

I'm going to throw out a guess, and suggest that it's related to DB2.  The only step left after a successful completion of a load is to write messages to the System Log.  It seems like there's a 60+ second timeout happening somewhere.  Check the db2diag log for errors/messages happening around the time of this load.

Given that you're on a drastically unsupported version of CMOD, you're not likely to get much help from IBM.

It's been two weeks since this thread was started -- are you still having the issue?

-JD.

Yes, JD. I still have this problem.
But we tried to relief it by advise customer to perform multiple loading tasks.
For some application group, I have copied it to new one and it work fine. (Faster than old one)

And, customer used CMOD 8.3 that end-of-support, we are during push they to upgrade.

Do you have documentation for IBM CMOD that describe to internal process of CMOD loading process has access which tables/paths/files on the server?

[Alessandro Perucchi]

I have no idea why it behaves like that in your case

There is no detailed description of the actual ingestion process... I know from experience what it does, but that's not the official description, it would be own :-) with its flaws!

That said, do you know if the customer is using the command "arslog" to do things? As you probably know the "arslog" can be modified, since this is a shell script. And maybe this one is doing more than what it should do.
And maybe because the application group are "old", it takes time for it to process it, since there are some backlogs. And when you have a new application group, there are no backlog, and therefore it goes quick.

Do you know if they are using some user exits?? From what you've shown us, I have the impression that no... but I might be wrong.

[krcd]

I have the same symptom, in a cmod 9.5, DB2 10.5. SO AIX 7.1. I have reviewed the DB and there are no hints of problems, any suggestions?

Okay, that's truly bizarre.  It's taking almost a full minute to return to CMOD after the load says it's complete.

I'm going to throw out a guess, and suggest that it's related to DB2.  The only step left after a successful completion of a load is to write messages to the System Log.  It seems like there's a 60+ second timeout happening somewhere.  Check the db2diag log for errors/messages happening around the time of this load.

Given that you're on a drastically unsupported version of CMOD, you're not likely to get much help from IBM.

It's been two weeks since this thread was started -- are you still having the issue?

-JD.

[Justin Derrick]

Check the troubleshooting article on the Wiki:  https://cmod.wiki/index.php?title=Troubleshooting_Content_Manager_OnDemand

Then report back with anything you think is suspicious.

From one of your other posts, I believe your system needs some re-design in order to keep growing while still performing well.

-JD.