# ADAFDU problem

**URL:** <https://techcommunity.softwareag.com/t/adafdu-problem/95243>\
**Category:** Forum\
**Tags:** Adabas-Natural, Adabas, Adabas-on-Windows-UNIX, Adabas-on-Linux, Adabas-Utilities-on-Open-Systems\
**Created:** [November 6, 2010, 2:33am UTC](https://techcommunity.softwareag.com/t/adafdu-problem/95243 "2010-11-06T02:33:50Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Arif](https://avatars.discourse-cdn.com/v4/letter/a/74df32/32.png) [@Arif](https://techcommunity.softwareag.com/u/Arif)\
**Post date:** [November 6, 2010, 2:33am UTC](https://techcommunity.softwareag.com/t/adafdu-problem/95243/1 "2010-11-06T02:33:50Z")

</div>

[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)

---

<div class="post-metadata">

**Author:** ![Ralph\_Zbrog](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/ralph_zbrog/32/78_2.png) [@Ralph\_Zbrog](https://techcommunity.softwareag.com/u/Ralph_Zbrog)\
**Post date:** [November 6, 2010, 6:35am UTC](https://techcommunity.softwareag.com/t/adafdu-problem/95243/2 "2010-11-06T06:35:27Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Ralph\_Zbrog](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/ralph_zbrog/32/78_2.png) [@Ralph\_Zbrog](https://techcommunity.softwareag.com/u/Ralph_Zbrog)\
**Post date:** [November 6, 2010, 6:50am UTC](https://techcommunity.softwareag.com/t/adafdu-problem/95243/3 "2010-11-06T06:50:50Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Arif](https://avatars.discourse-cdn.com/v4/letter/a/74df32/32.png) [@Arif](https://techcommunity.softwareag.com/u/Arif)\
**Post date:** [November 7, 2010, 12:55am UTC](https://techcommunity.softwareag.com/t/adafdu-problem/95243/4 "2010-11-07T00:55:04Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Ralph\_Zbrog](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/ralph_zbrog/32/78_2.png) [@Ralph\_Zbrog](https://techcommunity.softwareag.com/u/Ralph_Zbrog)\
**Post date:** [November 7, 2010, 10:52am UTC](https://techcommunity.softwareag.com/t/adafdu-problem/95243/5 "2010-11-07T10:52:30Z")

</div>

> [@](#):
>
> no such restriction on Unix by the way

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

---

<div class="post-metadata">

**Author:** ![Matthias1](https://avatars.discourse-cdn.com/v4/letter/m/9fc348/32.png) [@Matthias1](https://techcommunity.softwareag.com/u/Matthias1)\
**Post date:** [November 8, 2010, 3:39pm UTC](https://techcommunity.softwareag.com/t/adafdu-problem/95243/6 "2010-11-08T15:39:35Z")

</div>

> [@Ralph Zbrog](#):
>
> > [@](#):
> >
> > no such restriction on Unix by the way
> 
> My Unix databases all have System files defined as 1, 2, and 3.

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…

---

<div class="post-metadata">

**Author:** ![Arif](https://avatars.discourse-cdn.com/v4/letter/a/74df32/32.png) [@Arif](https://techcommunity.softwareag.com/u/Arif)\
**Post date:** [November 9, 2010, 4:45am UTC](https://techcommunity.softwareag.com/t/adafdu-problem/95243/7 "2010-11-09T04:45:49Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\
**Post date:** [April 2, 2021, 2:59pm UTC](https://techcommunity.softwareag.com/t/adafdu-problem/95243/8 "2021-04-02T14:59:20Z")

</div>