Messages

1

z/OS Server / Re: Folder hit limit in case of multiple AG

« on: January 15, 2018, 04:24:38 AM »

Hi Justin,
this does only work if you activate a server based sort. But this implies that it might have a performance impact if the result set is big.

regards

Egon

2

z/OS Server / Re: How to make fallback from upgrade?

« on: April 19, 2017, 01:07:06 AM »

Hi scottnys,
you can avoid duplicate loadids by manipulating arsag. You can avoid segment splits by manipulate arsseg. The needed SQL have been accepted by IBM of course for a special migration.  Being aware of this a DB2 fallback is possible and you can load reports that are lost by this fallback. After the final migration you delete the reports from OAM with arsadmin unload. These unloads are accepted by ARSSOCKD (even if no knowledge them).
It's still true that this is not our task. But it works. The main idea of the technique is to separate the migration / fallback process from the details of the changes between version (a) and (b). Preconditions are
a) the same documents can be loaded / unloaded with version(a) and version (b)
b) going back to the old content of the database. (here the kind of table changes have to be observed for a proper reconstruction)

regards

Egon

3

MP Server / Re: ARSMAINT slowness

« on: April 06, 2017, 12:06:36 AM »

Hi,
this shows that concurrent DB2 work (arsload?) causes a timeout.

13         DB Error: [IBM][CLI Driver][DB2/AIX64] SQL0911N  The current transaction has been rolled back because of a deadlock or timeout.  Reason code "68".  SQLSTATE=40001  -- SQLSTATE=40001, SQLCODE=-911, File=arsseg.c, Line=8246

this could be one of the possible reasons for a bad performance. In our shop a timeout occurs after 15 seconds. You can imagine the impact, if such an error occurs often.

regards

Egon

4

z/OS Server / Re: How to make fallback from upgrade?

« on: March 29, 2017, 11:22:57 PM »

Hi Hakan,
it's my opinon as well, the IBM should provide the solution. To have no dependency between different versions, I think a solution must track the loads to be able to replay the loads after a fallback. Otherwise you have to look for the details of the changes between version 1 and version 2 which is not relevant for this approach.

By the way if you switch to new functions mode after a DB2 migration you cannot do a fallback afterwards. Also with DB2 you have a point of no return.

regards

Egon

5

z/OS Server / Re: How to make fallback from upgrade?

« on: March 29, 2017, 12:49:57 AM »

Hi Hakan,
if you know the loadids from the buggy migration , you can do an unload after the final successful migration. This works fine and we have tested it. CMOD need not to find the loadids in the system log. If you have all reports that have been loaded by the buggy migration, you can load them again. We have worked with a one week window to decide whether we go back or not

Of course Ondemand could / should provide this or another technique as a general solution.

regards

Egon

6

iSeries / Re: OnDemand - Additional Indices

« on: March 28, 2017, 10:36:34 PM »

Hi Bill,
you have to decide / check which searches shall be supported. p.e. you can see the real searches looking for message 226 (if activated). These searches have to be supported with indexes. Sometimes it helps to use compound indexes not only one field. It's a regular task of database optimizing.

regards

Egon

7

z/OS Server / Re: How to suppress carriage control characters in CMOD

« on: March 22, 2017, 03:57:51 AM »

Hi Siva,

in my opinion it's a bug in the report. With my knowledge you can only change it by using an input exit.

regards

Egon

8

z/OS Server / Re: How to make fallback from upgrade?

« on: February 13, 2017, 03:00:36 AM »

Hi,
you will not find a general solution for a fallback, if loads are done and you want to preserve the loads that have been done. To avoid these problems we are doing the loads again after the fallback. After the final migration the unnecessary loads are deleted.

regards

Egon

9

z/OS Server / Re: How to specify storage node using ARSLOAD

« on: January 23, 2017, 06:27:22 AM »

Hi,
you cannot do it directly. But using the archive definition exit you can configure the node that shall be used for the current load.

regards

Egon

10

MP Server / Re: OS390 indexer

« on: January 11, 2017, 11:55:18 PM »

Hi,

it would help to see the JCL of your ARSLOAD instances.

regards

Egon

11

z/OS Server / Re: How to make fallback from upgrade?

« on: November 04, 2016, 04:31:25 AM »

Hi Marthin,

we are loading from spool (Z/OS) p.e. dest1. We change the load process from listening p.e for dest1 to dest12. We have a module that is listening for dest1. This module copies the file in the file system and at end it changes the dest1 to dest12.

regarding

Egon

12

z/OS Server / Re: How to make fallback from upgrade?

« on: October 24, 2016, 11:47:19 PM »

Hi scottnys,
this is right. if you have new loads you have to do much more. If we do a migration p.e. from V1 to V2 we run a script that stores every file before it is loaded in Ondemand.
In case of a fallback the following has to be done after restoring the old database content and preventing the duplicates that you have mentioned by changing arsag.
- loading all files that have been loaded in V2
- deleting all loads that have been loaded with V2 before the fallback (In general this can only be done after the final migration to v2)

regards

Egon

13

z/OS Server / Re: Encrypt/tokenize CMOD Data on the fly.Possible?

« on: September 21, 2016, 10:35:47 PM »

Hi Alessandro,
you are right this is possible. Just an additional information. Only the credit card numbers must be stored encrypted. It depends of the requirements whether it helps to use the CMOD frontend. Depending on your rights you could see no document, a tokenized document or a document with unencrypted card numbers. This could be realized with the preview exit (using ICSF or open SSL depending on the platform).

regards
Egon

14

z/OS Server / Re: Encrypt/tokenize CMOD Data on the fly.Possible?

« on: September 20, 2016, 12:48:23 AM »

Hi PK2016,

it is possible but of course only with exit programming. please look for the PCI discussion in this forum.

regards

Egon

15

General / Re: Add notes/annotation to multiple document list result of one load

« on: August 31, 2016, 10:50:15 PM »

Hi ODSA,
the combination DOC_NAME and DOC_OFF is unique.
17FAAA                 0
17FAAA              4024
.
.

If you can generate a list of DOC_NAME, DOC_OFF from one ore iterative  SQLs than you can write a script to add the annotations.

Regards

Egon