# ADADEF utility ERROR-137

**URL:** <https://techcommunity.softwareag.com/t/adadef-utility-error-137/58078>\
**Category:** Forum\
**Tags:** Adabas-Natural, Adabas, Adabas-on-Mainframes, Adabas-Utilities-on-Mainframes\
**Created:** [July 19, 2006, 3:15pm UTC](https://techcommunity.softwareag.com/t/adadef-utility-error-137/58078 "2006-07-19T15:15:59Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Aylin\_Atasoy](https://avatars.discourse-cdn.com/v4/letter/a/6f9a4e/32.png) [@Aylin\_Atasoy](https://techcommunity.softwareag.com/u/Aylin_Atasoy)\
**Post date:** [July 19, 2006, 3:15pm UTC](https://techcommunity.softwareag.com/t/adadef-utility-error-137/58078/1 "2006-07-19T15:15:59Z")

</div>

Hi,  
I’m getting the error message below when I’m trying to define a database having ASSOSIZE of 120168 cylinder. ASSODEV is 8393.  
Is there a way to pass this limit or do I have to understand that Adabas has some size restrictions on ASSO?

A D A D E F: Error occurred during execution:

ERROR-137, ASSOSIZE too large

```
       The size must not exceed 16777215 blocks. 
                                                 
       Correct the error and rerun the job. 

```

Best regards.

---

<div class="post-metadata">

**Author:** ![Bill\_Leeney](https://avatars.discourse-cdn.com/v4/letter/b/b5e925/32.png) [@Bill\_Leeney](https://techcommunity.softwareag.com/u/Bill_Leeney)\
**Post date:** [July 19, 2006, 5:28pm UTC](https://techcommunity.softwareag.com/t/adadef-utility-error-137/58078/2 "2006-07-19T17:28:10Z")

</div>

Hi,  
From the Adabas DBA Reference/Tasks Manual, Database Maintenance Tasks, Database Space Management, Relative Adabas Block Number:

> [@](#):
>
> The number of RABNs that can be assigned to ASSO and DATA depends on the RABNSIZE parameter, which is specified when the database is defined (by ADADEF). RABNSIZE specifies the length of relative Adabas block numbers in the database (not the length of the block itself).
> 
> If RABNSIZE=3 (block number is 24 bits or three bytes), the maximum number of RABNs is 16,777,215.
> 
> If RABNSIZE=4 (block number is 31 bits or four bytes), the maximum number of RABNs is 2,147,483,646.

So in your case, where you need 21,630,240 Asso blocks, RABNSIZE=4 is needed in your ADADEF job.  
HTH

---

<div class="post-metadata">

**Author:** ![Aylin\_Atasoy](https://avatars.discourse-cdn.com/v4/letter/a/6f9a4e/32.png) [@Aylin\_Atasoy](https://techcommunity.softwareag.com/u/Aylin_Atasoy)\
**Post date:** [July 20, 2006, 9:22pm UTC](https://techcommunity.softwareag.com/t/adadef-utility-error-137/58078/3 "2006-07-20T21:22:23Z")

</div>

Thank you for your help… it worked 🙂

---

<div class="post-metadata">

**Author:** ![Aylin\_Atasoy](https://avatars.discourse-cdn.com/v4/letter/a/6f9a4e/32.png) [@Aylin\_Atasoy](https://techcommunity.softwareag.com/u/Aylin_Atasoy)\
**Post date:** [July 26, 2006, 7:45pm UTC](https://techcommunity.softwareag.com/t/adadef-utility-error-137/58078/4 "2006-07-26T19:45:37Z")

</div>

Hi again,  
as I told you before; using RABNSIZE=4 in define job worked. But,  
I’m now trying to restore data from ADASAV offline backup which I took before this database enlargement operation.  
The restore statement is like “ADASAV RESTORE FMOVE=121”.  
And the ERROR code it gets is as below: 😢  
ERROR-169, Incompatible RABN sizes

```
       An attempt is made to restore one or more files from 
       a database with 3-BYTE RABN's into a database with   
       4-BYTE RABN's.                                       
                                                            
       The requested function cannot be performed.          

```

Do you have any idea about a solution?  
Looking forward from hearing you.  
Best regards.

---

<div class="post-metadata">

**Author:** ![Bill\_Leeney](https://avatars.discourse-cdn.com/v4/letter/b/b5e925/32.png) [@Bill\_Leeney](https://techcommunity.softwareag.com/u/Bill_Leeney)\
**Post date:** [July 26, 2006, 8:05pm UTC](https://techcommunity.softwareag.com/t/adadef-utility-error-137/58078/5 "2006-07-26T20:05:25Z")

</div>

Hi,  
To copy/move a file from a database with RABNSIZE = 3 to a database with RABNSIZE = 4 you could unload the source file (ADAULD) and load it into the target database (ADALOD).  
HTH

---

<div class="post-metadata">

**Author:** ![Aylin\_Atasoy](https://avatars.discourse-cdn.com/v4/letter/a/6f9a4e/32.png) [@Aylin\_Atasoy](https://techcommunity.softwareag.com/u/Aylin_Atasoy)\
**Post date:** [July 26, 2006, 8:21pm UTC](https://techcommunity.softwareag.com/t/adadef-utility-error-137/58078/6 "2006-07-26T20:21:41Z")

</div>

So, it’s not possible to load by ADASAV ☹ Unfortunately all our backups are taken by ADASAV.  
In every restore case; to restore them first into a db defined with rabnsize=3, then unload data and finally load to target db won’t be so efficient I think.

Anyway, thank you for your kindly response…

---

<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:39pm UTC](https://techcommunity.softwareag.com/t/adadef-utility-error-137/58078/7 "2021-04-02T14:39:02Z")

</div>


