Storr Consulting - sc510-ada012


Home	The Company	Publications	Products	Links	Tips

Last update: 12 July 2006

Experiences With ADABAS Upgrade from 6.2.2 to 7.4.2

Report is under development

Read all Release Notes of the versions:
6.2.3
7.1.1
7.1.2
7.1.3 most important, includes prior changes
7.4.1
7.4.2
Read Installation Manual 7.4
Copied all installation datasets from tape/cart to disk
Downloaded 170 ZAPs from ServLine24 into a PDS dataset -- status 23 Jan 2004:
AI742001-014
AN742004-124
AO742001-006
AU742004-046 (no AU742041)
ADABAS ZAP types:
AN - Nucleus
AU - Utility
AH - Dynamic Caching
AI - Operating System Independent
AO - Operating System Dependent (OS/MVS)
AD - Operating System Dependent (DOS=VSE/ESA)
AY - Optional
AW - Early Warnings
Downloaded Early Warnings -- status 14 May 2004:
AN742037 Online index reorder
AN742043 PLOG I/O error
AN742046 wrong result S1/L1 w/ ISL greater than TOPISN
AN742085 invalid ISNQ
AN742089 GCB overwritten
AO742006 OPEN error w/ RGCB flag on / multi volumes!
AU742009 ADASAV Restore w/ more system files
AU742023 ADARES does not copy all PLOG available
AW742027 DA-reposition loses extended SB controls
AW742028 ABM doesn't register when the nucleus is down
Downloaded again all ZAPs from ServLine24 into a PDS dataset and compared manually what is new and what is old. There must be an easier way to do this. Ahhh... "Delta" is the magic word. Here are the new ones -- status 23 May 2004:
AI742016-024
AN742125-190
AO742012-024
AU742047-072
Didn't apply all ZAPs, for example AU742028 is for Delta Save users. ZAP AI742006 also pointed out: OPTIONAL For Fastpath(AFP), Vista(AVI), SAF Gateway(AAF) and Transaction Manager(ATM) user only.
Implemented ADA742 router (SVC).
We are using two different SVC numbers (flip-flop) for ADABAS versions.
Changed SVC in SYSPARM of Com-plete
Changed Com-plete batch node in member ACSTAB
Added new libraries into RACF
APF-authorized new libraries
PROCLIBs
- Added and prepared new PROCLIBs, suffix .A742
- Renamed existing PROCLIBs, suffix .A622
- Renamed new proclibs, w/o suffix
Brought down the database(s) by ADAEND
Made sure that all PLOGs were copied (UEX2)
Backed up the database(s) offline with ADASAV 6.2.2 (PLOGs won't work in ADA742)
Converted (ADACNV) database(s) from ADA622 to ADA742 via ADA71 (see report)
ADABAS Convert Utility performed the following:
- Converted internally version by version, e.g. 6.2.2 to 7.4.2
  GCB, DLOG area, FST, Free-RABN-Chain
- FILEA holds the before images of blocks. FILE A should not be a temp dataset because it must be available for a possible restore.
- Formats WORK and PLOGs automatically if DD-statements are included. RLOG has to be fomatted separately.
Changed some ADARUN parameters
- LCP=0 to LCP=2000 (new min. value)
- LN=0, deleted obsolete or unknown parameter (maybe from version 5)
- REVIEWHUBID=0 (from 6.2.2) needed user exit 5, locked the nucleus during start, nucleus must be cancelled, changed to REVIEW=NO
  ADAN03 00001 ADABAS coming up
  ARVU09 00001 User exit 5 unavailable.
  ADAM99 00001 ADABAS Abend code 40222000 PSW 078D0000 8003D5C8
BUBs are no longer supported
Restarted the database(s) -- (see report)
ADARAI LIST failed with U0034 and DDDRUCK displays
ERROR-099, Internal error at ADARAI+0031AA
IEF450I ADAT1REP ADARAI LIST - ABEND=S000 U0034 REASON=00000000
ADARAI failed at offset X'31AA' when it attempted to list recovery log generations created under ADABAS 6.2.2.
Solution: Must reformat recovery logs (RLOG) and run PREPARE utility. Unfortunately, there is no hint in the Release Notes to convert RLOGs and to run PREPARE. There is only a statement on page 18 about ADARAI compatibility: ....ADABAS version 6 RLOGs are not supported.
Software AG Support Request #553734: To reformat RLOG was OK. Support will ask for a note in the Release Notes.
ADARAI LIST ended with condition code (CC) or response code (RC) 8 when PLCOPY job ran in parallel. This behavior on the part of ADARAI under ADABAS 7.4.2, is different from its behavior under ADABAS 6.2.2, where, in similar circumstances, no error occurs. In my opinion, the ADARAI LIST function should note the discrepancy, but not issue a RC 08 in this situation. (see report)
We don't want that a report ends with CC/RC 8 and the following steps are flushed.
Software AG Support Request #553731: ZAP AU742090 should solve the problem.
After zap implementaion, we now receive CC/RC 4, even if it is "only" a LIST function.(see report) SAG's response: This condition should return a RC 4. The condition in ADA622 is considered a product defect. The same condition under ADA622 should have issued a non-zero RC.
Conclusion: We must change the respose code check of all job steps from RC<1 in RC<5.
Conversion sequence regarding ADARAI:
RLOGFRM / ADACNV / PREPARE leads to
ERROR-159, ADARAI PREPARE not permitted to run.
The RLOG is in an invalid state.
ADACNV / RLOGFRM / PREPARE: this sequence was working OK (it makes more sense)
Tried to format DDRLOGM1 with RLOGFRM, received the error message:
ERROR-051, Error occurred during execution of Open DDRLOGR1:
06 - DA: No DD-Statement; DUMMY; UA, IGN(DOS)
OK, sometimes you're doing stupid things....(smile)
Downloaded again all ZAPs from ServLine24 into a PDS dataset and compared manually what is new and what is old. We also don't apply OPTIONAL ZAPs or ZAPs for products we don't have.
ALLZAPS contains -- status 20 Aug 2004:
AI742001-037
AN742004-212
AO742001-028
AU742004-088
Needed for ADARAI: AU742041, AU742055, AU742059
Applied 266 ADABAS 7.4.2 fixes -- status: 25 August 2004
Restore ADA742 databases with ADA622 backups (ADASAV/SAVE) are not possible.
Restore on file level should be possible, when you read ADA742 Release Notes at page 21:
"For restoring files, it is possible with Adabas 7.4 to restore files from a save dataset created by Adabas 7.2, 7.1, 6.2, 6.1, 5.3,5.2, or 5.1 by using the RESTORE or RESTONL functions with the FILE or FMOVE parameters."
When I tried to restore files from a version 6.2.2 online save into a version 7.4.2 database, I received the error message that the version 6.2.2 PLOG is not compatible to be read by 7.4.2 ADASAV RESTONL
(see report)
V622 ==> V742
RESTORE FMOVE: possible
RESTONL FMOVE: not possible
RESTORE entire database: not possible
SAG: Use RESTONL FMOVE with special zap to avoid PLOG read (Hmmm... dangerous)
Workaround: Create a database with prior version or don't convert at least one database to allow RESTONL FMOVEs
RESTONL FMOVE
Have problems to frequently "refresh" our development and training environments (V742) with production data (V622) until production is converted to V742. Reason: RESTONL FMOVE
ADAPLP V742: Read PLOG V622
Could read the first part and then, ADAPLP looped -- job was canceled.
(see report)
ADACSH V742 -- ADABAS Dynamic Caching
Copied all modules (ADACSH, ADACS1, ADACS6) from
ADABAS.ACF742.LOAD to
ADABAS.ADA742.LOAD
Didn't find any zaps for ACF742 on ServLine24
Started ADABAS with ADACSH = OK
(see report)
Corrupted Checkpoint File
ADAACK ACCHECK FILE=019 -- yes, nucleus was down
ERROR-131, ISN found in DS-Record is greater or equal to the
first unused ISN in the file
ERROR-129, Wrong value for fist unused ISN found in FCB
ERROR-126, Duplicate ISN in Checkpoint File
ADAICK ICHECK FILE-019 -- yes, nucleus was down
ERROR-134, ISN 000005EB NOT LT FCB+45 000005C3 (1ST UNUSED ISN)
Reason:
I believe that ADAORD was the reason because this was the only program running before the corruption. Unfortunately, we cannot repeat the error. SAG is still investigating the problem.
Solution or work around was to delete all checkpoints. And we didn't use, fortunately, ET data on the CP file.
SYSAOS / Checkpoint Maintenance / Delete Checkpoints
If using ET data, run an ADAORD REORFILE FILE=xxx SORTSEQ=ISN on the checkpoint file.

(see report)

ADARES REGENERATE displayed wrong TOCP value

       (snip)
       -- Function Executed --
       File 138 excluded from ADARES processing

       Utility Checkpoint detected during processing:
       * CPTYPE=30 - Load File 138
       * CPNAME=SYNP, CPBLK=36248, Session=939, Jobname=ADAP3P8A

       This is the batch utility that needs to be rerun. The messages:

       ADARES REGENERATE FILE=138
       ADARES FROMPLOG=939,TOPLOG=939
       ADARES FROMBLK=36248,FROMCP=SYNP
       ADARES TOBLK=36313,TOCP=3319186496  <<<===== ??
       (snip)

ADASAV SAVE DB to VTS -- ABEND A78-18
SYTEM COMPLETION CODE=A78 REASON CODE=00000018
44 tapes/carts were already written, when the CLOSE command failed.
Explanation: An error occurred when the system tried to process an RU or RC form of the FREEMAIN macro or the STORAGE RELEASE macro. A reason code in the SDWACRC field of the system diagnostic work area (SDWA) explains the error: 18 = Part of the private area to be freed is fixed.
This problem is VTS related and IBM has the following solution.
OW44314 ABENDA78-18 ENCOUNTERED WHEN FREEMAIN FROM IGG0201Y IS ISSUED FOR BUFFERS THAT WERE PAGE FIXED WITHOUT A PAGE FREE.
Please also see: http://www-1.ibm.com/support/docview.wss?uid=isg1OW44314
See also document with possible solutions as well as SAG and IBM statements (status: 11 July 2006). Click here to read document

ADACNV Output

The following parameters are in use for this run :                   
                                                                     
ADARUN DBID=001,SVC=254,DEVICE=9990,LP=65535                         
ADARUN PRO=ADACNV                                                    
ADARUN MODE=MULTI                                                    
ADARUN IGNDIB=NO                                                     
                                                                     
The following programs are in use for this run :                     
                                                                     
ADARUN   RUNMVS   Date 2002-10-18, Version 7.4, SM 2, Base AO742000  
         RUNIND   Date 2002-11-06, Version 7.4, SM 2, Base AI742000  
                  Zaps AI742003                                      
ADAMSG            Date 2002-10-23, Version 7.4, SM 2, Base AU742000  
ADAIOR            Date 2002-10-15, Version 7.4, SM 2, Base AO742000  
ADAIOS   IOSMVS   Date 2002-10-15, Version 7.4, SM 2, Base AO742000  
                  Zaps AO742006                                      
         IOSIND   Date 2002-10-15, Version 7.4, SM 2, Base AI742000  
                  Zaps AI742010 AI742011                             
ADACNV            Date 2002-10-18, Version 7.4, SM 2, Base AU742000  
                  Zaps AU742005 AU742035                             
ADAMG0            Date 2002-07-30, Version 7.4, SM 2, Base AU742000  
ADAMGE            Date 2002-07-30, Version 7.4, SM 2, Base AU742000  
ADAMGI            Date 2002-07-30, Version 7.4, SM 2, Base AU742000  
                                                                              
Mode     = MULTI                                                              
DBID     = 00001                                                              
Device   = 9990                                                               
SVC      = 254                                                                
AMODE    = 31                                                                 
                                                                              
17:53:01 ADAI65  EXCPVR is being used for this run                            
17:53:01 ADAI64  File DDASSOR1 is being opened in ECKD mode - RABN size 03768 
17:53:01 ADAI64  File DDWORKR1 is being opened in ECKD mode - RABN size 27990 
17:53:01 ADAI64  File DDPLOGR1 is being opened in ECKD mode - RABN size 27990 
17:53:01 ADAI64  File DDPLOGR2 is being opened in ECKD mode - RABN size 27990 
ADAI01 DDFILEA         42 writes                                              
ADAI01 DDFILEA         42 reads                                               
ADAI01 DDFILEA         42 reads                                               
ADAI03 DDASSOR1       268 reads        45 writes                             
ADAI03 DDWORKR1         1 reads     32769 writes                             
ADAI03 DDPLOGR1         1 reads      6725 writes                             
ADAI03 DDPLOGR2         1 reads      6725 writes                             
                                                                             
A D A C N V   V7.4  SM2   DBID = 00001  Started           2004-08-09  17:53:0
Parameters:                                                                  
-----------                                                                  
ADACNV CONVERT TOVERS=74 
Conversion from version 61/62 to version 71 started **********        
Conversion to version 71 feasible                                     
Conversion from version 71 to version 74 started **********           
Conversion to version 74 feasible                                     
********************* Point of no return reached *********************
Conversion completed                                                  
A D A C N V  Terminated normally                          2004-08-09  17:56:01

ADA742 Report -- DDPRINT

ADAN21 00001 Protection log PLOGR1 started                                 
ADAN02 00001 Nucleus run with protection log 01329                         
ADAL02 00001 2004-08-12 17:44:51 CLOGRS is active                          
ADAN03 00001 ADABAS coming up                                              
ADAN8Y 00001 File-Level Caching initialized                                
ADAN80 00001 ADABAS Dynamic Caching environment established.               
ADA800 00001 User exit 8 active.                                           
ADA801 00001 ADAT1X8S submitted.                                           
ADAN19 00001 Buffer flush is  a s y n c h r o n o u s                      
ADAN01 00001 A D A B A S  V7.4.2  is active                                
ADAN01 00001 MODE = MULTI                                                  
ADAN01 00001 Running without recovery log                                  
DBG98001I 2004-08-12 17:45:05 CA-APAS USER EXIT FOUR IS ACTIVE IN ADABAS   
DBG98002I 2004-08-12 17:45:05 CA-APAS DATA COLLECTOR IS ATTACHED           
ADAN8W 00001 FNR 00007 (ASSO) Synchronised                                 
ADAN8W 00001 FNR 00009 (ASSO) Synchronised                                 
ADAN8W 00001 FNR 00106 (ASSO) Synchronised                                    
ADAN8W 00001 FNR 00108 (ASSO) Synchronised                                    
ADAN8D 00001 ESP (ASSO) Cache active                                          
ADAN8L 00001 FNR 00106 (ASSO) range active, RABNS 20,725 thru 21,207          
ADAN8L 00001 FNR 00007 (ASSO) range active, RABNS 1,492 thru 1,660            
ADAN17 00001 2004-08-12 18:00:04 Read I/Os A=1284,D=238,W=3                   
ADAN17 00001 2004-08-12 18:00:04 Write I/O A=26,D=7,W=33                      
ADAN17 00001 2004-08-12 18:00:04 Nr. of commands=1997,Buffer efficiency=4.3   
ADAN17 00001 2004-08-12 18:00:04 Nr. of Fmt-Tran.=60,Nr. of Fmt-Ovwr.=0       
ADAN17 00001 2004-08-12 18:00:04 Thread001=1997 commands                      
ADAN41 00001 2004-08-12 18:00:04 Function completed                           
(snip)
--- FRIDAY,    13 AUG 2004 ----                                                
ADAN8K 00001 ESP (ASSO) Released after exceeding non-activity time limit.      
ADAN8P 00001 FNR 00007 (ASSO) Disabled after exceeding non-activity time limit.
ADAN8P 00001 FNR 00009 (ASSO) Disabled after exceeding non-activity time limit.
ADAN8P 00001 FNR 00106 (ASSO) Disabled after exceeding non-activity time limit.
ADAN8P 00001 FNR 00108 (ASSO) Disabled after exceeding non-activity time limit.
ADAN8U 00001 FNR 00007 (ASSO)  Enabled on demand.                              
ADAN8U 00001 FNR 00009 (ASSO)  Enabled on demand.                              
ADAN8U 00001 FNR 00106 (ASSO)  Enabled on demand.                               
ADAN8U 00001 FNR 00108 (ASSO)  Enabled on demand.                               
(snip)
ADAN17 00001 2004-08-13 10:55:18 Read I/Os A=2210,D=3150,W=3                   
ADAN17 00001 2004-08-13 10:55:18 Write I/O A=98,D=129,W=284                    
ADAN17 00001 2004-08-13 10:55:18 Nr. of commands=485440,Buffer efficiency=185.7
ADAN17 00001 2004-08-13 10:55:18 Nr. of Fmt-Tran.=172,Nr. of Fmt-Ovwr.=0       
ADAN17 00001 2004-08-13 10:55:18 Thread001=485436 commands                     
ADAN17 00001 2004-08-13 10:55:18 Thread002=4 commands                          
ADAN41 00001 2004-08-13 10:55:18 Function completed                            
ADAN8L 00001 FNR 00108 (ASSO) range active, RABNS 21,463 thru 24,149           
ADAN17 00001 2004-08-13 11:20:37 Read I/Os A=2734,D=3202,W=3                   
ADAN17 00001 2004-08-13 11:20:37 Write I/O A=118,D=137,W=306                   
ADAN17 00001 2004-08-13 11:20:37 Nr. of commands=497059,Buffer efficiency=172.0
ADAN17 00001 2004-08-13 11:20:37 Nr. of Fmt-Tran.=190,Nr. of Fmt-Ovwr.=0       
ADAN17 00001 2004-08-13 11:20:37 Thread001=497055 commands                            
(snip)

ADARAI V742 LIST Function -- Cond.Code 8 -- Report -- DDPRINT

(snip)
*** The following utility step was started                     
           but not complete indicating that information        
           for the step is missing from the RLOG and thus      
           a recovery step for this utility execution          
           may only be partially built.                        
                                                               
*** 2004-08-15  21:04:06                                       
*** Copy Dual Protection Log Dataset for PLOG 1334             
      ADARUN DBID=001,SVC=254,DEVICE=9990,LP=65535             
      ADARUN PROGRAM=ADARES                                    
      ADARES PLCOPY                                            

    //DDSIAUS1 DD DSN=ADABAS.DB1.PLOG.COPY.G2402V00,               
    //            UNIT=3390,SPACE=(TRK,(495,495),RLSE),DISP=NEW,        
    //            DCB=(RECFM=VB,BLKSIZE=27998,LRECL=27994),             
    //            VOL=SER=(WRK011)                                      
                                                                        
    DDSIAUS1   VOLSER=WRK011    From Block=11                           
                                To   Block=23                           
                                From Date =2004-08-15  03:29:08         
                                To   Date =2004-08-15  21:03:44         
              Volume is associated with PLOG No. 1334    

A D A R A I  Terminated                                   2004-08-15  21:04:08

ADARAI V742 LIST Function -- with ZAP AU742090 -- Cond.Code 4 -- Report -- DDPRINT

(snip) *** The following utility step was started but not complete indicating that information for the step is missing from the RLOG and thus a recovery step for this utility execution may only be partially built. *** 2004-08-28 20:09:54 *** Copy Dual Protection Log Dataset for PLOG 1351 ADARUN DBID=001,SVC=254,DEVICE=9990,LP=65535 ADARUN PROGRAM=ADARES ADARES PLCOPY //DDSIAUS1 DD DSN=ADABAS.DB1.PLOG.COPY.G2420V00(+1), // UNIT=3390,SPACE=(TRK,(495,495),RLSE),DISP=NEW, // DCB=(RECFM=VB,BLKSIZE=27998,LRECL=27994), // VOL=SER=(WRK015) DDSIAUS1 VOLSER=WRK015 From Block=11 To Block=25 From Date =2004-08-28 00:34:32 To Date =2004-08-28 20:09:41 Volume is associated with PLOG No. 1351 A D A R A I Terminated with warning 2004-08-28 20:09:55

ADASAV V742 RESTONL Function with V622 back-up and PLOG V622 -- DDDRUCK

JCL:
//RESTONLF EXEC ADASAVRF  /* ADASAV 742 Restore File Procedure                
//DDREST1 DD DISP=SHR,BUFNO=30,DSN=ADA622.BACKUP.FULL.G0225V00 
//DDPLOG  DD DISP=SHR,BUFNO=30,DSN=ADA622.PLOG.COPY.G0626V00   
//DDKARTE DD *                                                          
ADASAV RESTONL BUFNO=2                                                  
ADASAV         FMOVE=024,111                                            
ADASAV         OVERWRITE        

DDDRUCK from ADA742:
ADASAV --- Function = RESTONL                             2004-08-25  21:06:21

The save tape has been successfully restored.
Now the Protection Log input will be processed.

Supplied parameters are:  PLOGNUM = 534
                           SYN1/4  = 4418


A D A S A V:  Error occurred during execution:


ERROR-122, SYN1/SYN4-Checkpoint not found

            1) The SYN1/SYN4-Checkpoint is not contained in
               Protection Log block 4418, or
            2) the SYN2/SYN5-Checkpoint is not present anywhere
               on the Protection Log, or
            3) another SYN1/SYN4-Checkpoint was encountered
               before the expected SYN2/SYN5-Checkpoint.

            The wrong Protection Log has been mounted, or the
            wrong SYN1/SYN4-Checkpoint has been specified.

            Supply the correct Protection Log and parameters.
            For case 1 or 2, continue with the RESTPLOG-Function.
            For case 3, repeat the RESTONL-Function.


A D A S A V  Terminated                                   2004-08-25  21:06:31


DDDRUCK from ADA622 -- just to compare:
ADASAV --- FUNCTION = RESTONL                             2004-08-26  18:35:51
                                                                              
THE SAVE TAPE HAS BEEN SUCCESSFULLY RESTORED.                                 
NOW THE PROTECTION LOG INPUT WILL BE PROCESSED.                               
                                                                              
SUPPLIED PARAMETERS ARE:  PLOGNUM = 534                                       
                          SYN1/4  = 4418                                      
                                                                              
SYN2-CHECKPOINT FOUND IN PLOG BLOCK 4420                                      
                                                                              
                                                                              
ADAU64 STARTING POINT FOR ADARES REGENERATE:                                  
       FROMPLOG=534, FROMCP=SYN2, FROMBLK=4420                                
(snip)

ADAPLP V742 SPLOGPRI PRINT -- Report -- DDDRUCK

A D A P L P   V7.4  SM2   DBID = 00001  Started           2004-08-26  14:59:02  
                                                                                
Parameters:                                                                     
-----------                                                                     
                                                                                
ADAPLP SPLOGPRI PRINT                                                           
                                                                                
PLOGNUM=534, DBID=001

1. (Block header)                                                            
Len       Block-#  Sess V  Size     DBID Timestamp        Fl ID              
0096 0000 00000001 0216 00 0000FFFF 0001 BBAB39F2F3F3F400 00 007C 00000001   
                                                                             
Len  BEFZ     In Ty RABN     Fnr                                             
8004 00000000 00 00 00000000 0000 FFFFFF00                                   
                                                                             
Len  BEFZ     In Ty User-ID          Fnr  RABN/ISN Vz Cl WR-Chain Trn-Seq#   
                    Communication-ID                                         
6C60 404DE76C E7 F4 5D0100A600C5D9D9 8740 85A78583 A4 A3 89969540 968640E6   
                    D6D960F0F4F06B40C59999969940968383A4999985844084A4998995 
                                                                             
     *rite WORK:. . ER*  9989A38540E6D6D9D27A01003B00C5D9   0000             
     *ROR-041, Error o*  D9D6D960F0F4F16B40C5999996994096   0010             
     *ccurred during e*  8383A4999985844084A4998995874085   0020             
     *xecution of Clos*  A78583A4A389969540968640C39396A2   0030             
     *e WORK:. . ERROR*  8540E6D6D9D27A01003A00C5D9D9D6D9   0040             
     *-042, Error occu*  60F0F4F26B40C59999969940968383A4   0050   
(snip)

ADACSH V742 ADABAS Dynamic Caching -- Report -- DDPRINT

(snip)
ADAN03 00001 ADABAS coming up                                                 
ADAN8Y 00001 File-Level Caching initialized                                   
ADAN80 00001 ADABAS Dynamic Caching environment established.                  
ADAN19 00001 Buffer flush is  a s y n c h r o n o u s                         
ADAN01 00001 A D A B A S  V7.4.2  is active                                   
ADAN01 00001 MODE = MULTI                                                     
ADAN01 00001 Running with recovery log                                        
ADAN8W 00001 FNR 00013 (ASSO) Synchronised                                    
ADAN8W 00001 FNR 00018 (ASSO) Synchronised                                    
ADAN8W 00001 FNR 00022 (ASSO) Synchronised                                    
ADAN8W 00001 FNR 00024 (ASSO) Synchronised                                    
ADAN8W 00001 FNR 00036 (ASSO) Synchronised                                    
ADAN8W 00001 FNR 00206 (ASSO) Synchronised                                    
ADAN8D 00001 ESP (ASSO) Cache active                                          
ADAN8L 00001 FNR 00013 (ASSO) range active, RABNS 3,129,509 thru 3,445,992    
ADAN8L 00001 FNR 00022 (ASSO) range active, RABNS 524,834 thru 577,474        
ADAN8L 00001 FNR 00024 (ASSO) range active, RABNS 2,050 thru 239,840          
ADAN8L 00001 FNR 00036 (ASSO) range active, RABNS 3,640,082 thru 3,795,309    
ADAN8L 00001 FNR 00018 (ASSO) range active, RABNS 239,934 thru 458,228        
ADAN8L 00001 FNR 00013 (ASSO) range active, RABNS 887,323 thru 889,366      
ADAN8L 00001 FNR 00206 (ASSO) range active, RABNS 834,930 thru 836,755      
ADAN8L 00001 FNR 00206 (ASSO) range active, RABNS 577,475 thru 801,808      
ADAN8L 00001 FNR 00206 (ASSO) range active, RABNS 3,834,601 thru 3,846,806  
ADAN8L 00001 FNR 00018 (ASSO) range active, RABNS 1,020,308 thru 3,129,508  
ADAN8L 00001 FNR 00018 (ASSO) range active, RABNS 3,877,118 thru 3,890,475  
ADAN8L 00001 FNR 00013 (ASSO) range active, RABNS 807,002 thru 809,978      
ADAN8L 00001 FNR 00036 (ASSO) range active, RABNS 1,013,934 thru 1,015,175  
ADAN8L 00001 FNR 00036 (ASSO) range active, RABNS 823,358 thru 834,929      
ADAN8L 00001 FNR 00024 (ASSO) range active, RABNS 486,358 thru 499,385      
ADAN8L 00001 FNR 00018 (ASSO) range active, RABNS 499,386 thru 524,134      
ADAN8L 00001 FNR 00022 (ASSO) range active, RABNS 1,019,997 thru 1,020,288  
ADAN8L 00001 FNR 00022 (ASSO) range active, RABNS 844,987 thru 855,288      
ADAN8L 00001 FNR 00024 (ASSO) range active, RABNS 817,979 thru 819,608      
ADAN8D 00001 ESP (WRK2) Cache active                                        
ADAN8L 00001 ESP 64001 (WRK2) range active, RABNS 65,537 thru 65,651        
ADAN8D 00001 ESP (WRK3) Cache active                                        
ADAN8L 00001 ESP 64002 (WRK3) range active, RABNS 77,030 thru 100,048       
ADAN8L 00001 FNR 00018 (ASSO) range active, RABNS 3,445,993 thru 3,631,691  
ADAN8K 00001 ESP (WRK3) Released after exceeding non-activity time limit.      
ADAN8P 00001 ESP 64002 (WRK3) Disabled after exceeding non-activity time limit.
(snip)

ADAICK and ADAACK -- Reports -- DDDRUCK

A D A I C K   	V7.4 	 SM2   DBID = 00001  Started           2004-12-04  23:14:21
SARPAGE 7                                                                     
ADAICK                                                                        
DB 00001  VERSION 7.2/7.4 DATA BASE                                           
DB 00001       FIRST     LAST                                                 
               RABN      RABN                                                 
DB 00001  ASSO 00000001  0009EC48                                             
DB 00001  DATA 00000001  000AAFB7                                             
DB 00001  WORK 00000001  000186D0                                             
DB 00001  DSST 0000051A  000005D3
Parameters: 	              
-----------               
                          
ADAICK ICHECK FILE=019    
(snip)
********  AC BLOCK 000005F5 AT OFFSET 030C                               
******** ERROR-134, ISN 000005EB NOT LT FCB+45 000005C3 (1ST UNUSED ISN) 
         NUMBER OF ERRORS DETECTED = 1                                   
(snip)
********  AC BLOCK 000005F5 AT OFFSET 0486                                    
******** ERROR-134, ISN 00000669 NOT LT FCB+45 000005C3 (1ST UNUSED ISN)      
         NUMBER OF ERRORS DETECTED = 2                                        
FILE 019 000004E8-000009CF 000005F5 00000002 00000004           436 2,511     
******** NUMBER OF ERRORS DETECTED = 2                                        
                                                                              
                                                                              
A D A I C K  Terminated                                   2004-12-04  23:14:22

    = = = = = = = = = = = = = = = 

A D A A C K   	V7.4 	 SM2   DBID = 00001  Started           2004-12-05  03:16:08 
                                                                               
Parameters:                                                                    
-----------                                                                    
                                                                               
ADAACK ACCHECK FILE=019                                                        
                                                                               
     ------------------------------------------------------------------------  
                                                                               
 *********************************************                                 
 * Check AC for File 19 (CHECKPOINT      )   *                                 
 *********************************************                                 
                                                                               
    Reusable ISNS (Hexadecimal):                                               
      00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000  
(snip)
7 DS Blocks to process                                          
                                                                
 File 19: thru DS Block 00000001, 1 Block processed, 6 left     
 File 19: thru DS Block 00000002, 2 Blocks processed, 5 left    
 File 19: thru DS Block 00000003, 3 Blocks processed, 4 left    
                                                                
ERROR-131, ISN found in DS-Record is greater or equal to the    
           first unused ISN in the file.                        
                                                                
           ISN = 000005EC (1516), DS-RABN = 00000004 (4)        
           First unused ISN = 000005C9 (1481)                   
 File 19: thru DS Block 00000004, 4 Blocks processed, 3 left    
                                                                
ERROR-131, ISN found in DS-Record is greater or equal to the    
           first unused ISN in the file. 
           ISN = 0000066A (1642), DS-RABN = 00000005 (5)                
           First unused ISN = 000005C9 (1481)                           
 File 19: thru DS Block 00000005, 5 Blocks processed, 2 left            
 File 19: thru DS Block 00000006, 6 Blocks processed, 1 left            
 File 19: thru DS Block 00000007, 7 blocks processed, 2 Empty DS blocks.
                                                                        
Lowest  ISN             = 00000411 (1041)                               
Highest ISN             = 0000066A (1642)                               
ERROR-129, Wrong value for first unused ISN found in FCB                
                                                                        
           FCB+ISNU (Offset X'45') contains 000005C9 (1481)             
           Actual First Unused ISN = 0000066B (1643)                    
Number of records in DS = 000001BA (442)                                
                                                                               
 Pass  3 - Check for ISNS in AC but not in DS.                                
 ---------------------------------------------                                
                                                                              
                                                                              
000005C8 (1480) AC Elements to process.                                       
                                                                              
                                                                              
000005C8 (1480) AC Elements processed.                                        
                                                                              
A D A A C K  Terminated                                   2004-12-05  03:16:08

Top Page

Back to ADABAS Tips, Tricks, Techniques -- Overview