# Defining of SORT or TEMP files for a database

**URL:** <https://techcommunity.softwareag.com/t/defining-of-sort-or-temp-files-for-a-database/57982>\
**Category:** Forum\
**Tags:** Adabas-Natural, Adabas, Adabas-on-Linux, Adabas-Utilities-on-Open-Systems\
**Created:** [May 1, 2006, 5:13pm UTC](https://techcommunity.softwareag.com/t/defining-of-sort-or-temp-files-for-a-database/57982 "2006-05-01T17:13:48Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![sai](https://avatars.discourse-cdn.com/v4/letter/s/ecd19e/32.png) [@sai](https://techcommunity.softwareag.com/u/sai)\
**Post date:** [May 1, 2006, 5:13pm UTC](https://techcommunity.softwareag.com/t/defining-of-sort-or-temp-files-for-a-database/57982/1 "2006-05-01T17:13:48Z")

</div>

I want to add the SORT or TEMP means temporary datasets to increase the work size for a running database without trminating the database. Please let me know how can I define with the online utilities.

---

<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:** [May 1, 2006, 6:03pm UTC](https://techcommunity.softwareag.com/t/defining-of-sort-or-temp-files-for-a-database/57982/2 "2006-05-01T18:03:45Z")

</div>

If by “the database” you are talking about the nucleus - it does not need SORT and/or TEMP, these datasets are utility-only, e.g. ADAMUP or ADAINV.

ADAFRM with the SORTSIZE / TEMPSIZE parameters allocates / formats them.

---

<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:38pm UTC](https://techcommunity.softwareag.com/t/defining-of-sort-or-temp-files-for-a-database/57982/3 "2021-04-02T14:38:58Z")

</div>