# How much an adabas files in megabits? **URL:** \ **Category:** Forum\ **Tags:** Adabas-Natural, Adabas, Adabas-on-Mainframes, Adabas-Basics-on-Mainframes\ **Created:** [December 12, 2018, 9:26pm UTC](https://techcommunity.softwareag.com/t/how-much-an-adabas-files-in-megabits/202090 "2018-12-12T21:26:26Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![Fernando\_Zarazua\_Vilchis1](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/fernando_zarazua_vilchis1/32/852_2.png) [@Fernando\_Zarazua\_Vilchis1](https://techcommunity.softwareag.com/u/Fernando_Zarazua_Vilchis1)\ **Post date:** [December 12, 2018, 9:26pm UTC](https://techcommunity.softwareag.com/t/how-much-an-adabas-files-in-megabits/202090/1 "2018-12-12T21:26:26Z")
There is some utility that gives me a report of the size in magabits of each of the Adabas files, I have tried with ADAREP but there is some other option, since in my databases there are too many files. Thank you. Mainframe Z/OS. ---
**Author:** ![Claudemar\_Martins](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/claudemar_martins/32/322_2.png) [@Claudemar\_Martins](https://techcommunity.softwareag.com/u/Claudemar_Martins)\ **Post date:** [December 26, 2018, 8:50pm UTC](https://techcommunity.softwareag.com/t/how-much-an-adabas-files-in-megabits/202090/2 "2018-12-26T20:50:46Z")
I do not know a utility that does this, here where work i created a natural program that read ADAREP and records the information of the files in e write in file Adabas, size, we have estimates of cylinders, free/used, and a field calculated in MB of the Databases and files. [space.txt](https://techcommunity.softwareag.com/uploads/short-url/dKOBEzvpfmSoJDDHg1vc82S3Cjz.txt) (9.78 KB) ---
**Author:** ![Fernando\_Zarazua\_Vilchis1](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/fernando_zarazua_vilchis1/32/852_2.png) [@Fernando\_Zarazua\_Vilchis1](https://techcommunity.softwareag.com/u/Fernando_Zarazua_Vilchis1)\ **Post date:** [December 26, 2018, 9:40pm UTC](https://techcommunity.softwareag.com/t/how-much-an-adabas-files-in-megabits/202090/3 "2018-12-26T21:40:22Z")
Thanks, Claudemar Martins. I will generate an ADAREP LAYOUT = 1 and the output work file I will extract the data from used cylinders plus free cylinders to obtain the total space occupied by the file, I use the “Power Query” program, you know some other software to extract data from a text file. ?? ---
**Author:** ![Claudemar\_Martins](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/claudemar_martins/32/322_2.png) [@Claudemar\_Martins](https://techcommunity.softwareag.com/u/Claudemar_Martins)\ **Post date:** [December 27, 2018, 3:43pm UTC](https://techcommunity.softwareag.com/t/how-much-an-adabas-files-in-megabits/202090/4 "2018-12-27T15:43:09Z")
The ADAREP output in a dataset, and make an FTP of that dataset to your PC, in my case i created a natural program, I write the ADAREP into a dataset, and run a natural program to do a filter of what I gave the dataset ADAREP and write the information into a database file. Do you use Natural in your Environment? Which version? ---
**Author:** ![Fernando\_Zarazua\_Vilchis1](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/fernando_zarazua_vilchis1/32/852_2.png) [@Fernando\_Zarazua\_Vilchis1](https://techcommunity.softwareag.com/u/Fernando_Zarazua_Vilchis1)\ **Post date:** [December 27, 2018, 4:00pm UTC](https://techcommunity.softwareag.com/t/how-much-an-adabas-files-in-megabits/202090/5 "2018-12-27T16:00:58Z")
We have installed in ADABAS V8.2 and NATURAL v8.2.4.6 in an environment of Manframe Z / OS ---
**Author:** ![Claudemar\_Martins](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/claudemar_martins/32/322_2.png) [@Claudemar\_Martins](https://techcommunity.softwareag.com/u/Claudemar_Martins)\ **Post date:** [December 27, 2018, 4:18pm UTC](https://techcommunity.softwareag.com/t/how-much-an-adabas-files-in-megabits/202090/6 "2018-12-27T16:18:58Z")
What is your email address to send you the natural program, the view, the jcl that we created to monitor the space of the files and databases - it is simple - we run ADAREP and with a natural program it makes a filter of the space database and files ---
**Author:** ![Fernando\_Zarazua\_Vilchis1](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/fernando_zarazua_vilchis1/32/852_2.png) [@Fernando\_Zarazua\_Vilchis1](https://techcommunity.softwareag.com/u/Fernando_Zarazua_Vilchis1)\ **Post date:** [December 27, 2018, 8:11pm UTC](https://techcommunity.softwareag.com/t/how-much-an-adabas-files-in-megabits/202090/7 "2018-12-27T20:11:18Z")
Agradesco your help, I send you my email [fzvzar@gmail.com](mailto:fzvzar@gmail.com) ---
**Author:** ![Claudemar\_Martins](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/claudemar_martins/32/322_2.png) [@Claudemar\_Martins](https://techcommunity.softwareag.com/u/Claudemar_Martins)\ **Post date:** [December 31, 2018, 7:26pm UTC](https://techcommunity.softwareag.com/t/how-much-an-adabas-files-in-megabits/202090/8 "2018-12-31T19:26:55Z")
Email sent; ---
**Author:** ![Douglas\_Kelly](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/douglas_kelly/32/102_2.png) [@Douglas\_Kelly](https://techcommunity.softwareag.com/u/Douglas_Kelly)\ **Post date:** [January 2, 2019, 3:27am UTC](https://techcommunity.softwareag.com/t/how-much-an-adabas-files-in-megabits/202090/9 "2019-01-02T03:27:53Z")
Claude - an option is to share your code by uploading the source code to the tech forums - see [http://techcommunity.softwareag.com/pwiki/-/wiki/Main/Post+code+on+GitHUB](http://techcommunity.softwareag.com/pwiki/-/wiki/Main/Post+code+on+GitHUB) for more information. Once there, the code can be seen and downloaded by any forum members. I think the code you have created will be appreciated by many others. ---
**Author:** ![Claudemar\_Martins](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/claudemar_martins/32/322_2.png) [@Claudemar\_Martins](https://techcommunity.softwareag.com/u/Claudemar_Martins)\ **Post date:** [January 2, 2019, 1:46pm UTC](https://techcommunity.softwareag.com/t/how-much-an-adabas-files-in-megabits/202090/10 "2019-01-02T13:46:24Z")
After Fernando Zarazua Vilchis implement share yes ---
**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, 3:41pm UTC](https://techcommunity.softwareag.com/t/how-much-an-adabas-files-in-megabits/202090/11 "2021-04-02T15:41:58Z")