Messages

211

MP Server / Re: Need help with a query, DB2.

« on: October 14, 2019, 10:54:43 AM »

The CMOD Wiki to the rescue:  https://cmod.wiki/index.php?title=Useful_SQL_Queries_for_Content_Manager_OnDemand#How_many_documents_are_in_CMOD_Application_Groups.3F

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.

-JD.

YES

Second query is perfect Thanks!

212

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 a.name, 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

213

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. 

-JD.

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.

214

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.

215

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!

216

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. 

-JD.

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

217

MP Server / Re: License count + arsdoc

« on: October 01, 2019, 04:45:24 AM »

Tried this again last night. I'm expecting around 750 retrievals

While I was the only person on the system running my script-

09/30/2019 22:30:56   ARSSOCKD             0   Error   No      185   OnDemand license limit has been exceeded, currently 18 running only 10 are entitled.  Please contact an IBM Service Representative.
09/30/2019 22:30:52   ARSSOCKD             0   Error   No      185   OnDemand license limit has been exceeded, currently 18 running only 10 are entitled.  Please contact an IBM Service Representative.
09/30/2019 22:30:49   ARSSOCKD             0   Error   No      185   OnDemand license limit has been exceeded, currently 18 running only 10 are entitled.  Please contact an IBM Service Representative.
09/30/2019 22:30:44   ARSSOCKD             0   Error   No      185   OnDemand license limit has been exceeded, currently 18 running only 10 are entitled.  Please contact an IBM Service Representative.
09/30/2019 22:30:40   ARSSOCKD             0   Error   No      185   OnDemand license limit has been exceeded, currently 18 running only 10 are entitled.  Please contact an IBM Service Representative.
09/30/2019 22:30:37   ARSSOCKD             0   Error   No      185   OnDemand license limit has been exceeded, currently 18 running only 10 are entitled.  Please contact an IBM Service Representative.

The script then stopped at 713 retrievals. I only see 713 "90's" in the log.  I also see a lovely core file in the directory where I executed the script.

218

MP Server / Re: License count + arsdoc

« on: September 30, 2019, 01:53:14 PM »

Exceeding the license limits shouldn't stop you from completing a request.  It's just a notification / warning to buy more licenses.

Also, double-check with your IBM Rep -- that license limit may no longer be valid -- since you're unlikely to be paying for support for v8.5.x anyway.

-JD.

thanks, I'll see whats going on then. I could have sworn that once the license count was exceeded- that we fell flat on our face. HA!

219

MP Server / License count + arsdoc

« on: September 30, 2019, 10:14:13 AM »

I have a script that runs arsdoc to retrieve files. The script runs with no problems against most application groups. It runs to about 80% and then I've noticed that the licence count spikes-

OnDemand license limit has been exceeded, currently 13 running only 10 are entitled.  Please contact an IBM Service Representative.

    root 20971548        1   0   Sep 29      -  3:29 arssockd: license (Cur(13), Max(10))
    root 25165968 20971548   0   Sep 29      -  0:03 arssockd: cmd

This is our QA system, not much activity going on. Here's a question. Never seen this before, but could the retrieval of a certain file, maybe a large one, or a file with a certain file structure be causing this? I've also tried slowing down how fast the script runs. This application group is loaded with tons of resources from exstream. Once the license is exceeded, obviously my retrievals stop. Has anyone seen something similar? Btw, 8.5.0.6

220

MP Server / Re: XMl+PDf archive CMOD

« on: September 20, 2019, 06:27:59 AM »

In the past, I've setup the application to use the generic indexer and then used some kind of java program/script to convert the incoming xml to standard generic indexer format that arsload can read.

221

MP Server / Re: tmp filling up quickly with retrieval

« on: September 10, 2019, 08:25:18 AM »

Do you happen to also get a .ind, .out and .res in the output directory of your arsdoc get command?

Yes. both

Also, I'll try adding -d to my scripts and go from there. Thanks much RR!

222

MP Server / Re: tmp filling up quickly with retrieval

« on: September 10, 2019, 05:50:06 AM »

It could be a byproduct of exstreams method for generating afp and its associated resources (fonts, pdef, fdef, etc). Ultimately, you need the space you need.  Not much you can really do about that.

I guess my best action here is to just modify ARS_TMP to point to something with much much more space, other than /tmp, which in itself is a bad practice.

So I modified ARS_TMP to point to a file system with a much larger amount of space. my ARSDOC process is still failing-

09/09/19 19:44:58 : 12 document(s) have been queried. Retrieving 12 document(s).
09/09/19 19:45:00 : The command is unable to write to the file: /tmp/21692582.5622.5623.599.ARSRESGRP  (ERRNO = 28)
09/09/19 19:45:00 : arsdoc completed.

223

MP Server / Re: tmp filling up quickly with retrieval

« on: September 05, 2019, 06:11:41 AM »

arsdoc get -u admin -h archive -acgNv -G APPGROUP -i "where doc_name = 'FAA1'" -o OUTPUT

224

MP Server / Re: tmp filling up quickly with retrieval

« on: September 05, 2019, 05:54:26 AM »

It could be a byproduct of exstreams method for generating afp and its associated resources (fonts, pdef, fdef, etc). Ultimately, you need the space you need.  Not much you can really do about that.

I guess my best action here is to just modify ARS_TMP to point to something with much much more space, other than /tmp, which in itself is a bad practice.

225

MP Server / Re: Move CMOD 9.5 to new windows server, remote db not changing

« on: September 04, 2019, 10:47:26 AM »

Whats the exact error message you are getting in the system log 88 message?

What's the other error message associated with the 88, assuming it's probably storage related..?