Messages

1

MP Server / Re: CMOD table space.

« on: June 26, 2014, 04:15:00 PM »

I had the same problem after moving to 8.5.0.6, and we filled up the filesystem that the system logs started writing to which caused OD to stop in the middle of the day. Lovely stuff.

I haven't tried to move either of these (we just added a bunch of space for the system log and monitor it now), but I would be curious as to what your results are if you do try and move them.

2

MP Server / Re: LDAP Setup and Configuration for OnDemand on Windows

« on: June 26, 2014, 04:10:03 PM »

1) How to add active directory user to the system.
I'm guessing there are multiple ways to do it, but I just put the Active directory username as the OnDemand username. Then I configure the BIND attribute to bind based on the username.
2) Can we leverage active directory groups
I haven't figured out how to do this if there is, we've just put a policy in place where user's request access and we add their usernames into OD.
3) The above link talks about trace logs, which helps troubleshoot the LDAP connection. I was able to locate that using the instructions from http://www-01.ibm.com/support/docview.wss?rs=0&uid=swg21330810. But when I open the file, it is not readable. Am I missing something.
I don't know why your trace.settings file would be unreadable. It's just a text file, so you should be able to open it with a text editor (I just opened one on a Windows server to be sure). It may try to open as a DB2 object, but just open it with Notepad or something.
4) Any additional documentation (for windows) would be helpful.
All the documentation I found for it was not helpful, I just had to test and test until I got the settings correct.

Hope that helps a bit.

3

MP Server / Re: PCI Security in OnDemand

« on: June 26, 2014, 03:56:43 PM »

We're undergoing a project for it right now, and essentially each vendor has a bunch of products that they can throw at it and still have gaps, but there seems to be no one button fix.

That being said, I think TSM does have encryption in V6 now, but we're just going to encrypt the source data since TSM doesn't really care what you send it.

4

Documentation / Re: ARSDOC QUERY against the System Log Failing

« on: May 24, 2013, 08:09:51 AM »

This is an example command from one of the system log scripts I use:

/usr/lpp/ars/bin/arsdoc query -h <servername> -u <username> -p <password> -v -o <output file location> -i "WHERE TIME_STAMP BETWEEN <start time> AND <end time> AND MSG_TEXT LIKE '%XYZ%' AND MSG_NUM = 65" -f 'System Log' -G 'System Log' -S '12/30/12,1/25/14'

So for your example, you'd want to use these arsdate values instead of the ones you have listed:

> /usr/lpp/ars/bin/arsdate -z "04/08/13 00:00:01"
04/08/13 00:00:01       ->      1365397201

> /usr/lpp/ars/bin/arsdate -z "05/09/13 00:00:01"
05/09/13 00:00:01       ->      1368075601

Hope that helps.

5

MP Server / Re: CMOD upgrade from 8.4.0.3 to 8.5.0.6 question

« on: May 24, 2013, 07:46:15 AM »

I ran into the same upgrade when I upgraded about a month ago, my solution was to just skip that step and have the DBA manually reorg and do runstats on all of the tables that the process went through.

It went much quicker that way and I've personally had no side effects from doing it that way.

6

MP Server / Re: The OnDemand PDF feature not installed

« on: May 24, 2013, 07:42:02 AM »

We are running fine in both our test and production environments.  So far, 8.5.0.6 has not had any issues for us.  The biggest 'gotchas' were permissions on the Oracle database for the OD_Instance_Owner and then making sure the database and listener were stopped when I installed the application 8.5.0.0 and its fixpack 8.5.0.6.

The installation script will display 'Congratulations' or 'Installed but with errors, see log.'  When it displayed 'installed but with errors', it usually did not install the current arsoracle file and then we stopped both the db and listener and uninstalled and reinstalled 8.5.0.0 successfully and of course then fixpacked successfully also.

Oracle also has a link record to a timetable issue.

Make sure that the account you use to install the app has the proper database references in its profile, if you have any references at all; such as HOME / SID / LIBPATH.

A bit later than I'm sure is helpful, but I just recently installed 8.5.0.6 at my company and we found out about a defect regarding size limitations for PDF's when the patch notes for FP7 came out a few weeks ago. I'm not sure if your client/company indexes/loads large PDFs, but I believe there's a hot fix for FP6 regarding this and it's supposed to be resolved in FP7 now.