Topics

1

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

2

z/OS Server / Performance arsdoc delete / arsadmin unload

« on: November 13, 2013, 04:19:06 AM »

Hi,
we use 'arsdoc delete' to delete documents and 'arsadmin unload' to delete complete loads. This works fine. If a lot of index entries have to be deleted the performance is very slow. A delete of 1000 documents ('arsdoc delete') was done in 10 minutes.
A PMR was opened for 'arsdoc delete' and 'arsadmin unload'. The 'arsadmin unload' PMR is closed, the 'arsdoc delete'  PMR is still open. When closing the 'arsadmin unload' PMR an enhancement request was opened, which is rejected.

Does anybody has similar Problems with  'arsdoc delete' and 'arsadmin unload' in case of many rows in the Application group data table
or does nobody is deleting many rows?

regards

Egon

3

z/OS Server / how to delete documents with acvtivated enhanced retention management

« on: January 31, 2012, 08:11:59 AM »

Hello,
I'm doing some tests to activate enhanced retention management in CMOD. I was able to load douments with a predefined hold IMPLIED_HOLD and addd additional holds and I was able to drop the hold with ARSDOC.

But I don't know, which module can be taken to do the deletes.

I could write a script to do the deletes p.e. with arsadmin. But I expect an utility that does the deletes auomatically using the retention time and the holds.

Regards

Egon

4

z/OS Server / how to delete delete permission in application group using arsxml

« on: January 12, 2012, 02:32:17 AM »

Hello,

does anybody know how to delete permissions in folders and application groups using ARSXML.

regards

Egon

5

z/OS Server / new load with a date for an index table that is already closed

« on: March 04, 2011, 04:20:34 AM »

Hi,

i'm just thinking about segment field usage.

If a business date is used as a segment field, the following could happen:

- a segment is closed for the date intervall between 2007 and 2010
- you have a current segment 2011-2011
- you get a new report in 2011 for 2007 (some correction for the past)

What is the influence of such a load?

Will we have the following segements afterwards?

- 2007-2010
- 2007-2011

If this is true, the segmentation would not help at all for such kind of business segment fields.

Does anybody know the details?

6

z/OS Server / you know a possibility to change the segment field in the application group?

« on: January 19, 2011, 01:26:16 AM »

Hi,
we want to optimze searching in production. Sometimes the segment field is bad. We want to change such a segmentation field. Do you know how to change it. (maybe some tricky SQL)

Egon