How can I know which descriptor fields are used in an adabas file?

Fernando_Zarazua_Vilchis1 · August 18, 2020, 9:21pm

Mainframe Z/OS 2.2
ADABAS Ver. 8.2. sp 6

I want to know what descriptor fields are used in an adabas file, the purpose is to eliminate descriptor fields, super descriptors, sub-descriptors, as well as periodic fields and multiple fields that are not used, it is worth mentioning that I do not have Predict installed.

I really appreciate your valuable help.

Douglas_Kelly · August 18, 2020, 10:39pm

What tools do you have for monitoring your database at this time? for example, Adabas Review or one of the 3rd party reporting packages?

If not, you may have to enable Adabas Command Logging and specify logging of the search buffers (for descriptor usage) and format buffers (for pe/mu field usage). Check out the sample PRILOG/PRILOGC programs that comes with your Adabas installation, as you can probably adapt that to extract the information you are looking for.

Fernando_Zarazua_Vilchis1 · August 18, 2020, 10:57pm

Thanks Douglas, what I have are the tools that come by default from adabas, I don’t have Adabas Review.
I’m going to activate Adabas Command Logging

wolfgang.winter · August 19, 2020, 6:35am

Please note that command logging will create massive amounts of data on production systems, so make sure the CLOG files are big enough and log switching procedures are in place.

Steve_Robinson · August 19, 2020, 10:22am

How many Natural objects reference this file? If the number is relatively small you can scan the objects looking for the appropriate field names.
If you use external file views you can scan them as a way to limit your task.

Please note that an appearance of field names in views does not mean it will be used at all. Similarly a FIND using a descriptor does not mean that FIND is ever used.

Fernando_Zarazua_Vilchis1 · August 19, 2020, 1:09pm

Hi Wolfgang, We have a very big problem with disk space, that is why we are debugging adabas files, likewise I am debugging descriptor fields, there are natural objects that are already out of use.

Thanks you

Fernando_Zarazua_Vilchis1 · August 19, 2020, 1:15pm

Hi Steve, The problem is that I have more than 30 databases and more than 1,300 adabas files, I have located many files that are no longer active, and programs that have descriptor fields defined in their views but are not used in the logic of the program. but you gave me an idea to make a batch (JCL) and locate those programs that use the descriptor fields.

Thanks you.