Table ARSAPP and ARSAG2FOL mapping

[dakun]

we are running CMOD v9.0.0.5 in zOS. I tried to pull out mappings between applications and folders by ARSAPP and ARSAG2FOL table.   
however I found the AID column in ARSAG2FOL table is not reliable and mapped to the AID in the ARSAPP table. 

is there any one had experience on how to get application and folder mapping?

[Nolan]

Do you have actual corrupt mappings?  We query the table all the time for the mapping with a clist.

"SELECT B.NAME,b.aid,C.NAME,c.fid,C.DESCRIPTION"
"FROM ARSAG2FOL A, ",                   
     "ARSAPP B, ",                     
     "ARSFOL C ",                       
"WHERE B.NAME = 'xxxxxx' " ,                                     
"AND A.AID=B.AID  AND A.FID=C.FID" 

The 0 AID columns are used for other mappings.           
                                               

[Alessandro Perucchi]

Did you try with the command "ARSXML" ?? that way, you will have exactly the mapping.
Of course, you can look into the database, but since the "exact" data model is not public, you might miss some key information that might explains some edge situations.