Messages

76

MP Server / Re: INPEXIT TO DELETE COLUMNS 1-2-3 OF EACH RECORD

« on: November 06, 2013, 04:58:07 AM »

Hi Litecia,

we have implemented an exit in COBOL. The exit logic works like:

The exit will be called with a pointer to a structure. One of the elements is a pointer to the current record. You can change the record. At the end you have to return to arsload what to do with the changed record (p.e. use it). That's all


regards Egon

77

MP Server / Re: INPEXIT TO DELETE COLUMNS 1-2-3 OF EACH RECORD

« on: October 24, 2013, 11:24:10 PM »

Hi Leticia,

which kind of Indexer do you use?

regards Egon

78

MP Server / Re: INPEXIT TO DELETE COLUMNS 1-2-3 OF EACH RECORD

« on: October 23, 2013, 11:45:28 PM »

Hi Leticia

you can use the input exit but you can also use the preview exit to drop the first columns. (see for coding examples in the documentation)

regards

Egon

79

MP Server / Re: Select Disabled User on Database

« on: October 15, 2013, 05:28:54 AM »

Hi,

at least DB2 Z/OS doesn't have the bitand function.   

Egon

80

MP Server / Re: Select Disabled User on Database

« on: October 14, 2013, 10:54:08 PM »

You can get results by SQL as well. You have just to use an OR to see whether a bit is on:

SELECT HEX(ADMIN),A.* FROM ARSSERVR.ARSUSER A
     WHERE USER LIKE '%'
     AND (SUBSTR(HEX(ADMIN), 2 , 1)='1'    -- 1
       OR SUBSTR(HEX(ADMIN), 2 , 1)='3'    -- 1 + 2
       OR SUBSTR(HEX(ADMIN), 2 , 1)='7'    -- 1 + 2 + 4
       OR SUBSTR(HEX(ADMIN), 2 , 1)='F'    -- 1 + 2 + 4 + 8
       OR SUBSTR(HEX(ADMIN), 2 , 1)='5'    -- 1 + 4
       OR SUBSTR(HEX(ADMIN), 2 , 1)='D'    -- 1 + 4 + 8
       OR SUBSTR(HEX(ADMIN), 2 , 1)='9');; -- 1 + 8

regards

Egon

81

z/OS Server / Re: How can divide functions from Server OnDemand Z/OS??..

« on: October 04, 2013, 08:20:24 AM »

Hi,

I have only used the features in a heavy load server pool (not Ondemand).The configuration itself was not done by myself. But the usage was simple. Different servers are started against the virtual IP and the port configured for port sharing.

regards egon

82

z/OS Server / Re: How to fallback from CMOD 9.0 to 8.4.0

« on: October 02, 2013, 06:50:22 AM »

Hi allessandro,

it may be that the content of the current 'CMOD Customer tables' are never(?) changed. But it is not guaranteed that this is true for documents that are loaded after the migration. Additionally we have a link between the CMOD internal tables and the customer tables that are important. This link exist p.e in system log, LOB header, arsload and of course some special attributes of the customer tables itself. In the first comment of Ed he has stated this implicitly when he says: 'You would somehow have to save copies of the data to be loaded'

regards Egon

83

z/OS Server / Re: How can divide functions from Server OnDemand Z/OS??..

« on: October 02, 2013, 06:29:34 AM »

Hi,
on Z/OS two transparent features can be used.
1) Port sharing two server listen to the same port
2) virtual ip (in sysplex) one logical ip is translated into physical ips

regards

Egon

84

z/OS Server / Re: How to fallback from CMOD 9.0 to 8.4.0

« on: October 01, 2013, 01:52:46 AM »

Hi,

as discussed before: the only possibility is storing of all documents loaded in the new CMOD Version additionally in filesystem or OAM or ....

This ist the base to be able to goback in general after new documents have been loaded.

Of course a solution provided by IBM is the best solution.

It's possible, if you do it in an individual approach. But of course it's expensive and it depends on the decision of business how to deal with risk and costs.

regards

Egon

85

MP Server / Re: Strange Error while loading a file

« on: September 24, 2013, 03:20:07 AM »

Hi,

what is the codepage in the database? Might be you have charcters that are not defined in the database codepage

regards Egon

86

Report Indexing / Re: PDF File names

« on: August 20, 2013, 11:37:26 PM »

Hi,

you have at least two possibilities:

1. running a script that picks the files and does a rename whenever possible (= current file is loaded by arsload).
2. if you are on Z/OS you can send the files p.e. with REXX to spool like Ed has mentioned.

regards

egon

87

OD/WEK & JAVA API / Re: Pagination

« on: August 12, 2013, 03:41:26 AM »

Hi Pankaj,

another option is to use an index exit. You define an additional field p.e. portion and you fill it with a default. The index exit is used to change the default to generate document breaks.

regards

Egon

88

z/OS Server / Re: How to fallback from CMOD 9.0 to 8.4.0

« on: August 07, 2013, 11:05:21 PM »

Hi all,

"I think this is a BIG issue, and I've complained a lot of times on the ODUG-meetings regarding the 'missing piece' of any 'downgrade'-scripts/function WITHOUT restoring an old Image Copy.Which in itself is impossible!!!, because you can't restore an old IC to the ARS-tables... since some of them are dropped/recreated during the process of upgrade"

Of course you have to look for such table changes and prepare some DDL and unloads of individual tables. So it's possible even for a big shop if Application group data tables have not been changed. We used our approach for the migrations 8.4.3 -> 8.4.4 and 8.4.4 -> 8.5.x.x. And it was tested on dev and uat.

"AND !! If you managed to do some restore...What have you done with your System Log  If you restored that, then you can't
do any auditing on who searched/viewed anything under the period that you were running the new release."

You can save the system log in server.sl_save. This should be anough for autiting.

We have supported our approach with a lot of scripting and programming. This will work for nearly all possible migrations. Besides of the table changes we regard Ondemad a black box. But of course IBM could do the work in a better better way because they can use their internal kowledge to optimize a fallback solution. Our management has insisted on a fallback solution So we could not wait for an IBM solution

regards

Egon

89

OD/WEK & JAVA API / Re: Pagination

« on: August 05, 2013, 01:01:18 AM »

Hi Pankaj,
just an idea. If you have something like 'page nnnn' on every page, you could configure another break for instance 'page nn'. By this you will get an additional break every 100 pages. Maybe this helps.

regards Egon

90

z/OS Server / Re: How to fallback from CMOD 9.0 to 8.4.0

« on: July 30, 2013, 01:04:55 AM »

Hi Leo,

we have developped a generalised fallback solution.

a) backup CMOD database
b) we copy all data (our data come via spool) before loading them in the migrated CMOD

In case of fallback we do:
a) restore CMOD database
b) delete oam objects that are loaded from the migrated system
c) load all copied documents
d) adapt date field in the index if needed.

Everything is tricky. For instance you have to look for the table arsseg and arsag to prevent data chaos. But it works

regards

Egon