OnDemand User Group

Support Forums => z/OS Server => Topic started by: dakun on March 29, 2016, 11:54:16 AM

Title: Table ARSAPP and ARSAG2FOL mapping
Post by: dakun on March 29, 2016, 11:54:16 AM

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?

Title: Re: Table ARSAPP and ARSAG2FOL mapping
Post by: Nolan on March 29, 2016, 01:59:10 PM

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.           
                                               

Title: Re: Table ARSAPP and ARSAG2FOL mapping
Post by: Alessandro Perucchi on April 04, 2016, 10:39:36 PM

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.