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 ... 23
MP Server / Re: ArcDBP_SegSQL:Unable to exec direct sql db
« on: December 06, 2019, 01:41:56 PM »
Anything in db2diag?

I did some experiments with running ARSMAINT on library server and then on object server (servers are separated - LS is one host and OS is another) and I have following conclusion:
- ARSMAINT is maintaining cache on server on which script is run
So, If You run ARSMAINT on library server then it will maintenance cache on library server and cache on object server will not be maintained
Is that correct?

I had a PMR like this years ago. If I remember correctly, Starting in 8.5, you have to run arsmaint on your library server.

We had a one libserver, 2 object server environment, I was running arsmaint on my object server and nothing was happening. This came directly from IBM support. Unfortunately I don't have a tech document or anything like that. However, I am sure if you open up a PMR with IBM they can guide you in the right direction.

MP Server / Re: arsdoc retrieve too slow AIX 7.1 CMOD 9.5 DB10.5
« on: November 22, 2019, 08:43:58 AM »
Are the PDF's that are taking forever older loads?

MP Server / Re: arsdoc retrieve too slow
« on: November 21, 2019, 01:35:12 PM »
Are there funky fonts in the slow retrievals?

If I recall correctly, there's a standard set of fonts that's always available with PDFs.

If you use other than those standard fonts then they have to be archived as resources, recalled, mapped, converted, sliced and diced so that they can be displayed.


That is where I was going. :)

MP Server / Re: arsdoc retrieve too slow
« on: November 21, 2019, 09:36:25 AM »
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.

Could be dependent on the generating system, pdf version, etc. I've seen that happen before.

MP Server / Re: arsdoc retrieve too slow
« on: November 20, 2019, 01:29:53 PM »
I figured.

Are all of the PDF input files exactly structured the same? Here's possible scenario I am thinking

Application ABC with app group XYZ retrieves fast, because its a simple pdf, no colors, images, not a lot of resources
Application DEF with app group LMO retrieves slow, because they are complex pdfs with lots of colors, possibly lots of resources.

Here's a good start-

Retrieve a "Fast aka normal" retrieval via ars doc, and a "Slow one"...Note the times. Then, use the system log to find the original load time and see if they were also quick to load or slow to load.

I would imagine there would be some kind of correlation.

MP Server / Re: arsdoc retrieve too slow
« on: November 20, 2019, 11:12:47 AM »
What kind of data is it? PDF? AFP?

MP Server / Re: arssockd -T -I <<Instance Name>> will not stop CMOD
« on: November 11, 2019, 08:33:55 AM »
I'm trying to shutdown CMOD before an offline backup using the command arssockd -T -v -I archive. The command completes with no output and does not stop the arssockd process.

Anyone have this issue on RedHat Linux V7.6 and CMOD V10.1.0.4

Yes. I've seen this intermittently not work. I end up killing it manually.

I have to export reports from particular application group,  do you know the syntax for arsxml.  I also need to export the meta data, I was hoping you might have the syntax to do both. Thanks.

arsdoc get is what you want to use here..there are a bunch of examples in the documentation. arsxml is used for batch administration.

MP Server / Re: Need help with a query, DB2.
« on: October 14, 2019, 10:54:43 AM »
The CMOD Wiki to the rescue:

And you want to do a "select distinct doc_name on <table>" to get a list of objects.  But this might not be a good way to reconcile your old vs. new loads.



Second query is perfect Thanks!

MP Server / Need help with a query, DB2.
« on: October 14, 2019, 09:26:40 AM »
This is probably a very simple query, but not sure of the best way to approach it. anyways instead of just asking for someone to DO it for me, here's my scenario.

I need to query datatables for two things

1) row count for total docs loaded
2) total number of doc names

Concern of course is for when there's tables that go above our 25,000,000 row limit, or whatever we have it setup in prod as.

I am thinking for this the arsseg table is a good way to start. I can query-

select, b.table_name from arsag a, arsseg b where a.agid=b.agid

Why am I doing this?

Writing a little script so my ops team can see, "where an extraction process is at"

thanks in advance, as always I am open to any other approaches

MP Server / Re: Determining metrics for specific application?
« on: October 09, 2019, 07:34:37 AM »
By AG, this is relatively straightforward.  By Application...  This is a nightmare.  :D


If this was AG, it would have already been done.

I'm probably going to take a dump of ALL 87's from the system log for a particular application load, throw it into excel...

Then look at log entries for "deletes", throw them into excel...

I've found it quite easy to gather metrics and info this way. It sure beats having to have my operations team run queries in prod, especially since I'm the only one that knows the relationships of the tables.

MP Server / Determining metrics for specific application?
« on: October 08, 2019, 07:55:17 AM »
got a requirement from our application team to figure out-

Application XYZ, which is part of AG 123, takes up XXX GB in TSM.

Does anyone have a query handy, or something to determine this. I have a feeling it will require some fancy footwork behind the scenes to do this.

MP Server / Re: License count + arsdoc
« on: October 02, 2019, 01:15:56 PM »
Very strange coincidence that the license count was creeping up slowly as my script ran, but this happened because I was using my own useraccount on my server to run my extract, instead of a process account.

The ulimit's weren't high enough on my own account for stack. I upped it to unlimited, and the script didn't core anymore.

Always the SIMPLE little things!

MP Server / Re: License count + arsdoc
« on: October 01, 2019, 06:44:32 AM »
Coredump = crash.  Whatever you're running is crashing, the server isn't cutting you off.  :)


Yeah strange, the lic. count climbs, then it stops..making me wonder. Will do a trace.. Thanks

Pages: [1] 2 3 4 5 6 ... 23