1636
MP Server / Re: Unable to allocate enough memory / cannot connect
« on: December 13, 2012, 07:26:38 AM »
Yeah, the issue was resolved for us when we cleaned out our /arstmp directory.
-JD.
-JD.
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.
1637
MP Server / Re: arsdoc delete
« on: December 12, 2012, 09:05:38 AM »
Yes - the -i option allows you to do free-form SQL select statements. JW's example was correct. You can use any field you've defined in the AG, as well as CMOD's internal fields like DOC_NAME and DOC_OFFSET.
I would use something like "where CUST_NUM=12345 and ZIP_CODE=90210".
Just remember to be careful and test your queries. You could cause a lot of damage with a typo.
-JD.
I would use something like "where CUST_NUM=12345 and ZIP_CODE=90210".
Just remember to be careful and test your queries. You could cause a lot of damage with a typo.
-JD.
1638
MP Server / Re: arsdoc delete question
« on: December 12, 2012, 09:01:32 AM »
Actually, no.
arsdoc delete only deletes index entries.
You should be using arsmaint with the expiration options (-c for cache, -d for database). Documents in TSM will expire on the schedule defined in the policies that the documents were stored under. If your expiration type is load, CMOD will send TSM an explicit delete command to remove the load, but if the expire type is Segment or Document, TSM will expire the objects on it's own schedule.
-JD.
arsdoc delete only deletes index entries.
You should be using arsmaint with the expiration options (-c for cache, -d for database). Documents in TSM will expire on the schedule defined in the policies that the documents were stored under. If your expiration type is load, CMOD will send TSM an explicit delete command to remove the load, but if the expire type is Segment or Document, TSM will expire the objects on it's own schedule.
-JD.
1639
MP Server / Re: SQL0964C
« on: December 11, 2012, 11:01:45 AM »
I'd start by bringing down the database, and doing a full offline backup, and making sure your transaction logs are being properly archived.
Then I'd do what the error message recommends... NUM_IOCLEANERS is one of the parameters that the CMOD developers have (in the distant past) recommended increasing. My rule of thumb for increasing database parameters is to go in increments of 50% until the situation is resolved. 4 to 6, 6 to 9, 9 to 15, etc.
-JD.
Then I'd do what the error message recommends... NUM_IOCLEANERS is one of the parameters that the CMOD developers have (in the distant past) recommended increasing. My rule of thumb for increasing database parameters is to go in increments of 50% until the situation is resolved. 4 to 6, 6 to 9, 9 to 15, etc.
-JD.
1640
MP Server / Re: arsdoc delete
« on: December 11, 2012, 10:56:14 AM »
You should be able to use the -i option and use an SQL statement to identify your document to be deleted.
Let us know how it works out!
-JD.
Let us know how it works out!
-JD.
1641
MP Server / Re: problem with upgrading to 8.5
« on: December 10, 2012, 10:17:29 AM »
And just a quick note for others who find this thread... BEFORE you ininstall CMOD 8.4.x, make sure you back up your configuration data:
tar -xvf /tmp/CMODconfig.tar /usr/lpp/ars/config*
When CMOD 8.5 is installed, restore your ars.ini, ars.dbfs, and ars.cache files. Review the contents of your OLD ars.cfg file, and manually add in any changes you've made. This ensures that you have the latest copy of ars.cfg, and get all of the new variables.
-JD.
tar -xvf /tmp/CMODconfig.tar /usr/lpp/ars/config*
When CMOD 8.5 is installed, restore your ars.ini, ars.dbfs, and ars.cache files. Review the contents of your OLD ars.cfg file, and manually add in any changes you've made. This ensures that you have the latest copy of ars.cfg, and get all of the new variables.
-JD.
1642
MP Server / Re: PDF compression optimization in V 8.5
« on: December 10, 2012, 10:06:11 AM »
In my experience, the compression with the PDF Indexer is good -- but still not as good as AFP. In the tests I ran with a customer earlier year, the compression was about 70% with PDFs, and over 90% with AFP. The documents were invoice-style pages.
Let us know what you find!
-JD.
Let us know what you find!
-JD.
1643
Other / Re: Viewing Number of Users Logged into OnDemand
« on: December 06, 2012, 10:26:49 AM »
Depends on the platform and version.
In AIX with CMOD 8.4, you can get the number of active users from the process list:
$ ps -ef |grep license
archive 7536774 7274502 0 Sep 18 - 145:15 arssockd: license (Cur(1), Max(12))
Which platform / version are you using?
-JD.
In AIX with CMOD 8.4, you can get the number of active users from the process list:
$ ps -ef |grep license
archive 7536774 7274502 0 Sep 18 - 145:15 arssockd: license (Cur(1), Max(12))
Which platform / version are you using?
-JD.
1644
MP Server / Re: problem with upgrading to 8.5
« on: December 06, 2012, 10:21:27 AM »
Just a quick note to thank you guys for posting the solution to this. Ran into this error today -- I'm sure you just saved me a week's work!
On AIX, I just ran this immediately before running odaix.bin:
rm /usr/lpp/ars/exits/ars*
Also, you could prevent this entirely by uninstalling your previous version of CMOD before starting the 8.5.0.0 installer. (Something IBM considers 'optional'.)
-JD.
On AIX, I just ran this immediately before running odaix.bin:
rm /usr/lpp/ars/exits/ars*
Also, you could prevent this entirely by uninstalling your previous version of CMOD before starting the 8.5.0.0 installer. (Something IBM considers 'optional'.)
-JD.
1645
MP Server / Re: Upgrade to 8.5.0.6..Notes issue
« on: December 05, 2012, 04:23:11 AM »
Just to clarify -- the Thick Client DOES NOT use ODWEK at all -- it connects directly to the server and communicates with the arssockd process. ODWEK allows you to use Java APIs to make requests to arssockd. ODWEK is optional, and not a required component for CMOD, as long as you only access the server using the thick client or command-line utilities like arsdoc.
-JD.
-JD.
1646
MP Server / Re: Upgrade to 8.5.0.6..Notes issue
« on: December 04, 2012, 04:58:51 AM »
Ick! Can you provide more info? I've got at least three customers on 8.5.0.6 -- two of them using annotations daily.
Do the annotations show up in the arsann table when added? Can you retrieve the doc + annotation using arsdoc (with -A 7 to extract annotations with the document)? Are clients on the 8.5.0.6 Thick Client, or are they using CGI / Java API?
Do the annotations show up in the arsann table when added? Can you retrieve the doc + annotation using arsdoc (with -A 7 to extract annotations with the document)? Are clients on the 8.5.0.6 Thick Client, or are they using CGI / Java API?
1647
MP Server / Re: Password encryption.
« on: December 04, 2012, 04:56:02 AM »
In DB2, the fact that you're logged in as a particular user on the local machine, is authentication to talk to the database (it doesn't hurt that you're likely in the SYSADM group either). It's been years since I worked with Oracle, but I suspect it doesn't have this authentication method, or it's not enabled by default.
This page is from DB2 v8, but I think most of it is still true:
http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/admin/c0005435.htm
This page is from DB2 v8, but I think most of it is still true:
http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/admin/c0005435.htm
1648
z/OS Server / Re: ARS0113E
« on: November 29, 2012, 07:47:27 AM »
Check for other error messages beside this one in your System Log. Also, check the TSM activity log around the same time for failed logins and such. Let us know what you find.
-JD.
-JD.
1649
MP Server / Re: Determining Tier1 Cache Usage
« on: November 29, 2012, 07:46:15 AM »
Hi Russ.
I've got some utilities to calculate that info. We'll run them when I get down there next week.
-JD.
I've got some utilities to calculate that info. We'll run them when I get down there next week.
-JD.
1650
MP Server / Re: Issue with CMOD 9.0 with DB2 V10
« on: November 27, 2012, 06:23:58 AM »
Thanks for keeping up updated Ali!
-JD.
-JD.