I have a huge list of tables for which I am required to find the table-space and index-space files. Currently I am using BMC tool to find this information.
There are SYSIBM.SYSTABLESPACE and SYSIBM.SYSINDEXES tables. I believe there is a pattern for the names of relevant VSAM files. If there is a method I can use these details from these tables and form the file names, it will be great. I wouldn't argue to stick to my assumption if you advise me another efficient way to achieve this.