Replicator and Limited Number of Files in REPLAY Function

, , ,
1

Regarding the problem I described in my previous post "Millions of Messages After Restart’, I deleted the SLOG and tried to REPLAY all updates on 112 files with more than 100 PLOG tapes but it failed with the message

A D A R P L V8.1 SM1 DBID = 00039 Started 2010-04-28 18:16:06

ADARPL REPLAY
ADARPL FILES=006,007,009,010,012,013,016,019,021,023,028,033,034,037
ADARPL FILES=039,040,041,043,047,048,051,058,059,060,061,063,066,066
ADARPL FILES=067,068,071,072,076,077,078,080,081,082,083,084,086,088
ADARPL FILES=090,091,092,093,094,096,097,099,103,104,105,106,109,110
*** ADARPL FILES=111,113,116,119,123,124,125,130,131,133,135,137,138,140
***
ERROR-009, Parameter error, too many values in a list
Check the parameter input.
Supply no more than the maximum number of parameter
values permitted, and rerun the job.
A D A R P L Terminated 2010-04-28 18:16:06

Question:
It stopped with file 123 (***). Why is it limited to 60 files? Adabas knows more than 60 files!
Is this a feature or a bug?

From the manual:
Parameter FILES
Description: Specifies one or more valid Adabas file numbers for which replication was turned on. The PLOG records for these files will be replayed and replicated, based on other settings in the Replay Utility run.
Required? No – although at least one DESTINATION. FILE, or SUBSCRIPTION parameter must be specified.
Default: none

Dieter Storr

ADABAS 8.1.3
ADABAS 6
Replicator ARF 3.2.1
WCP 6.1

2

Hi Dieter,

you are right there is a limit of 60 with regard to files and subscriptions you can specify per ADARPL and this is unfortunately not properly documented.
However, if you work with a token instead (Please check the manual) there should be no limit.

Gruss from good old Germany
Rainer Herrmann

3

Hallo Rainer,

I created a TOKEN by using REPTOR online. The Event Replicator Subsystem initiated the replication replay, displayed the Token=16205 but it seemed that the function failed because of the missing DD-statement DDJCLIN.

Questions:

  1. Do I need additional software from SAG to support DDJCLIN?
  2. Can the TOKEN also be created in batch?
  3. How can we determine a starting point, like a synchronized checkpoint, for 100+ files that failed but don’t want to replay all PLOGs. It can take hours to replay all already done replications. If you support many PLOGs it also can lead to endless error messages like
    add another PLOG
    ERROR-152, Incomplete transaction found on PLOG
    add another PLOG
    ERROR-152, Incomplete transaction found on PLOG
    add another PLOG
    ERROR-152, Incomplete transaction found on PLOG
    etc.

RF00147: Replay process initiated - Token=16205
17:45:38 ***** A D A B A S EVENT REPLICATOR SUBSYSTEM ***** 2010-05-11
Initiate Replication Replay M-RP2010

                              Replay Only                                  
                                                                           
     DBID ........................... ___39                                
     Automated ...................... Y (Y or N)                           
     Timeout ........................ 900_______                           
                                                                           
     From Date/Time ................. 2010-05-06  12:34:18                 
     To Date/Time ................... 2010-05-10  16:11:24                 
     Start Date/Time ................ 2010-05-06  12:34:18                 
                                                                           
     Destination Name List ..... _ + * D191165_  ________  _______        
     Subscription Name List .... _ + * S039165_  ________  ________

17:45:38 ADAF2L 00302 Replication activated for DBID/File 39/ 165
17:45:38 ADAF2L 00302 due to request from ADABAS
17:45:38 ADAF2M 00302 Subscription S039165 activated
17:45:38 ADAF2M 00302 due to begin of replay process
17:45:38 ADAF9J 00302 ADARAG function 24 return code 8
17:45:39 ADAF9J 00302 DDJCLIN failed to open
17:45:39 ADAF9J 00302 Replay jobstream generation failed
17:45:39 ADAFCB 00302 ADARPL Jobstream generation failed for Replay token 16205
17:45:39 ADAFC8 00302 Replay token 16205 initialization canceleddi
17:45:39 ADAF2L 00302 Replication deactivated for DBID/File 39/ 165
17:45:39 ADAF2L 00302 due to end of replay process
17:45:39 ADAF5Q 00302 All transactions from database 39
17:45:39 ADAF5Q 00302 that ended before 2010-05-06 15:57:26
17:45:39 ADAF5Q 00302 have been processed for file 165
17:45:39 ADAF2M 00302 Subscription S039165 deactivated
17:45:39 ADAF2M 00302 due to deactivation of DBID/FNR 39/ 165
17:45:39 ADAF5Q 00302 All transactions from database 39
17:45:39 ADAF5Q 00302 that ended before 2010-05-06 15:57:26
17:45:39 ADAF5Q 00302 have been processed for subscription S039165

Gruss aus Sacramento
Dieter

PS
Sehen wir uns in Prague?