Messages

46

General / Re: storing multiple versions of the document and retrieve the latest version

« on: May 17, 2015, 11:51:15 PM »

Hi,
one possibility is to use an index exit. Using a status field you can mark all loads loaded before as invalid within the index exit. The assumption is that the different loads have the same database content besides the status field and that these database fields identify the different versions of the document completly.

regards Egon

47

Report Indexing / Re: Multiple reports inside a single file...

« on: March 31, 2015, 11:02:40 PM »

Hi Alessandro,
as far as I remeber enhanced retention management needs the configuration on load level. By programm holds and releasing them you can install some processes on document level.
Because of special deletion rules like 10 years counting from the end of the year and different retention periods for different reports in the same application, we have done our own retention management.

regards


Egon

48

Report Indexing / Re: Multiple reports inside a single file...

« on: March 29, 2015, 10:59:38 PM »

Hi Justin,
if you take the report from the indexes you have a new level in in your architecture: application group, application and report. This is OK but you have to look for possible problems p.e. regarding retention management.

regards

Egon

49

MP Server / Re: user reporting from CMOD

« on: March 25, 2015, 03:58:05 AM »

Hi Bruce,
if you activate the needed messages you can get the needed info from syslog. We have structured copy of system log from which logins, searches, retention needs .. can be derived.

regards

Egon

50

MP Server / Re: Matching Lower Case and Upper Case data in Search

« on: January 16, 2015, 01:26:28 AM »

Hi Russel,
beginning with DB2 V10 you can create an index like:
CREATE INDEX qual.tablex1
  ON qual.table
  (lower(attr,' ') asc );

Of course this has to be done within DB2. Ondemand does not support this

regards

Egon

51

MP Server / Re: Variable retention requirement

« on: January 08, 2015, 12:32:41 AM »

Hi Pankaj,

we have done some researches two years ago. With enhanced retention management you cannot do that requirement without additional programming. You have to set / release holds for customers in all involved application groups. This is not very efficient.

So we have developed an individual solution using the possibilities of the standard product. Our solution was an own retention database that controls the delete process in CMOD.

regards

Egon

52

Report Indexing / Re: empty field in PDF form

« on: January 07, 2015, 05:45:17 AM »

Hi Michel,

your solution might be a problem for sorting and doing a between search. This can only be avoided if the date strings look like 'yyyymmdd'

regards

Egon

53

Tips and Tricks / Re: Validating Cache Storage

« on: September 18, 2014, 12:18:32 AM »

Hi to all,
I have forgotten the details. But as far as I remember the permission bits are used for the technical process itself. Thex were used to store informations. So  it's not anough that the user has the right to see the files.

regards


Egon

54

Report Indexing / Re: Report not being broken into multiple documents

« on: July 16, 2014, 12:16:40 AM »

Hi daodug,

it might be that the indexer does not detect any page breaks. So a document split would not be possible.

regards

Egon

55

MP Server / Re: PCI Security in OnDemand

« on: June 30, 2014, 12:17:07 AM »

Hi Mike,
for PCI it's not required to encrypt everything. It's anough mask the creditcard numbers with tokens in your docunments. Additionally you need an encrypted table, which allows you to get the creditcard number for a given token and the token for a given creditcard number. By this technique you can do nesarly everything with your documents without doing any encription / decription. Only if you need the original card number you need to decrypt the token. This technique is a general approach that works as well in IT in general.

regards

Egon

56

Report Indexing / Re: Alternate of arsload

« on: June 11, 2014, 10:45:49 PM »

Hi Kasim,
just a remark. ARSLOADS calls OAM or TSM. Most of the work during storing the document is done by OAM or TSM. If you only look for the load phase, I don't see any chance to be faster. But if you look for the indexing phase you will be much faster if you are able to use a generic indexer.

regards Egon

57

z/OS Server / Re: arsload -keep original creation date during the ingest

« on: May 04, 2014, 11:43:39 PM »

Hi,
we have done a similar migration (different kind of archives)  by generating generic indexer files and generate arsload jobs that do the load using the generated generic indexer files.

regards

Egon

58

Report Indexing / Re: Report Indexing / Field Mapping between two application groups.

« on: April 27, 2014, 10:59:26 PM »

Hi Jeff,

you can change such wrong values to a special date (p.e. lowest or highest possible date) by using an index exit. So you will always have a valid date expression.

regards

egon

59

OD/WEK & JAVA API / SQL Codes from the backend

« on: March 06, 2014, 06:18:04 AM »

Hi,
does anybody know whether it is possible to get the sqlcode / sqlstate that is launched by DB2 when processing a query to get a result set.

Backgorund of the question is that we have implemented a sql extension in arsuperm, which lead to a call of a DB2 user defined function. We want to show the result of the udf in a readable manner. The results are transported by special sqlstates and messages.

Without changes in the frontend we get the error:

At least one search criteria was invalid: com.ibm.mm.beans.CMBInvalidQueryException: DGL2013A: Nicht unterst?tzte Suchkriterien. "". (DK_OD_MSG_NO_MESSAGE) [RC=9(DK_OD_RC_MISC_ERROR),ExtRC=9(DK_OD_MSG_SERVER_FAILED_SEARCH)]

regards

Egon

60

z/OS Server / Re: RACF sercurity

« on: February 28, 2014, 01:36:02 AM »

Hi Dave,
a batch could be implemented that reads all CMOD user. For all user the racf configuration could be checked. If a user deletion is needed, the user can be deactivated or dropped using ARSXML. I know this would work. Of course this idea does not substitute a detailed design.

regards

Egon