ADAFDU problem

, , , ,
1

[b][color=“darkred”]I am trying to create two new files on WinXP (adabas 6.1.9.02) in Batch

here is the output from batch run: [/color][/b]
$SET FDUFDT=C:\File Transfer\WinXP\FDT\DCUFDT_F001.prm
$adafdu.exe 0<“C:\File Transfer\WinXP\FDU\FDU-F001.prm”
%ADAFDU-I-STARTED, 05-NOV-2010 12:03:47, Version 6.1.9.02 (Windows)
%ADAFDU-I-DBOFF, database 201 accessed offline
%ADAFDU-E-NOISNRU, no ISN reusage allowed for checkpoint file

contents of FDU_F001.prm:
db=201
file=1
name=PARAMETERS_FILE
maxisn=200
dssize=2B
nisize=4B
uisize=5B
reuse=(ds,isn)

$SET FDUFDT=C:\File Transfer\WinXP\FDT\DCUFDT_F002.prm
$adafdu.exe 0<“C:\File Transfer\WinXP\FDU\FDU-F002.prm”
%ADAFDU-I-STARTED, 05-NOV-2010 12:03:47, Version 6.1.9.02 (Windows)
%ADAFDU-I-DBOFF, database 201 accessed offline
%ADAFDU-E-INVFDT, invalid FDT for system file

contents of FDU_F002.prm:
db=201
file=2
name=RANK_ANALYSIS
maxisn=300
dssize=4B
nisize=5B
uisize=2B
reuse=(ds,isn)

contents of DCUFDT_F001.prm:
01,AA,8,A,DE,NU
01,AB,8,U,NU
01,AC,7,U,NU
01,AD,8,A,NU,MU
01,AE,1,A,NU
01,AF,1,A,NU
01,AG,1,A,NU
01,AH,4,U,NU
01,AI,1,A,NU
01,AJ,1,U,NU
01,AK,1,U,NU
01,AL,8,A,NU
01,AP,60,A,NU
01,AQ,8,A,DE,NU
01,AR,PE
02,AS,3,U,NU
02,AT,2,U,NU
01,AU,PE
02,AV,6,U,NU
02,AW,5,U,NU,MU
01,AM,3,U,NU
01,AN,3,U,NU

AO=AM(1,3),AN(1,3)
AX=AM(1,3),AN(1,3)

contents of DCUFDT_F002.prm:
01,AA,1,U,NU
01,AB,3,U,NU
01,AC,3,U,NU
01,AD,6,U,NU
01,AE,2,U,NU
01,AF,6,U,NU
01,AG,6,U,NU
01,AH,PE
02,AI,3,U,NU
02,AJ,4,P,NU
02,AK,4,P,NU
02,AL,4,P,NU
02,AM,4,P,NU

AN=AA(1,1),AB(1,3),AF(1,2)
AO=AB(1,3),AC(1,3),AF(1,2)
AP=AB(1,3),AD(1,6),AF(1,2)
AQ=AE(1,6),AF(1,2)

2

By default, Adabas grabs the first three file numbers for system files. You can verify this with an AdaRep.

  • File 1 - Checkpoint
    File 2 - Security
    File 3 - User Data

He thinks you’re trying to modify the Checkpoint and Security files, so try creating files 4 and 5 instead.

3

By default, Adabas grabs the first three file numbers for system files. You can verify this with an AdaRep.

  • File 1 - Checkpoint
    File 2 - Security
    File 3 - User Data

He thinks you’re trying to modify the Checkpoint and Security files, so try creating files 4 and 5 instead.

4

thanks Ralph: you are right, I have been able to load 21 files starting from 4 onwards - no such restriction on Unix by the way. I still have about 15 files to load when I’ve started receiving ADA_77 storage error.
%ADAFDU-I-STARTED, 06-NOV-2010 08:39:38, Version 6.1.9.02 (Windows)
%ADAFDU-I-DBOFF, database 201 accessed offline
%ADAFDU-E-ADA_77, * ASSO/DATA storage exhausted (DATA)
%ADAFDU-I-IOCNT, 2 IOs on dataset WORK
%ADAFDU-I-IOCNT, 7 IOs on dataset ASSO
%ADAFDU-I-IOCNT, 93 IOs on dataset FDUFDT
%ADAFDU-I-ABORTED, 06-NOV-2010 08:39:39

Free Space before Loading Files:
Free space of Database 201 06-NOV-2010 11:19:02

Container Extents in Blocks Number of Block
File from to Blocks Size

ASSO:
1 63 12,800 12,738 4,096
2 12,802 14,400 1,599 32,768

DATA:
1 14 16,000 15,987 32,768

%ADAREP-I-IOCNT, 3 IOs on dataset ASSO

Free Space after Loading 21 Files
Free space of Database 201 06-NOV-2010 14:56:56

Container Extents in Blocks Number of Block
File from to Blocks Size

ASSO:
2 12,860 14,400 1,541 32,768

DATA:
1 1,789 16,000 14,212 32,768

%ADAREP-I-IOCNT, 3 IOs on dataset ASSO
%ADAREP-I-TERMINATED, 06-NOV-2010 14:56:56

5

My Unix databases all have System files defined as 1, 2, and 3. I use DBA Workbench whenever possible, and I expect that System file creation is his default.

To solve your space problem, either reduce the space allocation of the file causing the error, or add another container:

  • invoke DBA Workbench
    select a database
    click Administrate
    click Containers
    click Add
6

Right! File #1 to #4 are system files on Solaris, too.

There are some other ADABAS/NATURAL-Addons grabbing files < 10 by default (e.g. PREDICT). So I would start with file no 10 or so…

7

My next data conversion step ADACMP worked fine except for file F008:

adacmp.exe 0<“CMP_F008.prm”
%ADACMP-I-STARTED, 08-NOV-2010 11:38:36, Version 6.1.9.02 (Windows)
%ADACMP-I-DBOFF, database 201 accessed offline

%ADACMP-W-ERROR, Field = AD, ISN = 2, Offset = 92
%ADACMP-E-UNXEOF, CMPIN - unexpected end of file

%ADACMP-I-CMPINP, Number of records read : 555
%ADACMP-I-CMPERR, Number of incorrect records : 554
%ADACMP-I-CMPREC, Number of compressed records : 1
%ADACMP-I-CMPLCR, Largest compressed record : 78

%ADACMP-I-IOCNT, 3 IOs on dataset CMPDTA
%ADACMP-I-IOCNT, 2 IOs on dataset CMPDVT
%ADACMP-I-IOCNT, 554 IOs on dataset CMPERR
%ADACMP-I-IOCNT, 555 IOs on dataset CMPIN
%ADACMP-I-IOCNT, 2 IOs on dataset WORK
%ADACMP-I-IOCNT, 5 IOs on dataset ASSO
%ADACMP-I-ABORTED, 08-NOV-2010 11:38:37, elapsed time: 00:00:01

adacmp.exe 0<“CMP_F021.prm”
%ADACMP-I-DBOFF, database 201 accessed offline
%ADACMP-E-UNXEOF, CMPIN - unexpected end of file

%ADACMP-I-CMPINP, Number of records read : 3
%ADACMP-I-CMPERR, Number of incorrect records : 0
%ADACMP-I-CMPREC, Number of compressed records : 3
%ADACMP-I-CMPLCR, Largest compressed record : 132

adacmp.exe 0<“CMP_F022.prm”
%ADACMP-I-DBOFF, database 201 accessed offline
%ADACMP-E-UNXEOF, CMPIN - unexpected end of file

%ADACMP-I-CMPINP, Number of records read : 3
%ADACMP-I-CMPERR, Number of incorrect records : 0
%ADACMP-I-CMPREC, Number of compressed records : 3
%ADACMP-I-CMPLCR, Largest compressed record : 74

adacmp.exe 0<“CMP_F028.prm”
%ADACMP-I-DBOFF, database 201 accessed offline
%ADACMP-E-UNXEOF, CMPIN - unexpected end of file

%ADACMP-I-CMPINP, Number of records read : 1
%ADACMP-I-CMPERR, Number of incorrect records : 0
%ADACMP-I-CMPREC, Number of compressed records : 1
%ADACMP-I-CMPLCR, Largest compressed record : 88

%ADACMP-I-TERMINATED, 08-NOV-2010 11:38:37, elapsed time: 00:00:00

contents of CMPIN
record_structure=ilength_prefix

by the way we have 4 files (1-4) in our Unix system since 2004. No System File conflict here.

Solaris 64Bit Ver 3.3.1.08

                          Allocated blocks              Unused blocks

File Filename NI UI AC DS NI UI DS

1 PARAMETERS_FILE 4 14 1 13 0 9 12
2 RANK_ANALYSIS 13 17 3 20 9 12 18
3 MAIL_MASTER_FILE 32 4 5 132 32 3 131
4 M002F04_PERSMOS 55 14 5 132 39 8 129