IBM Security Z Security

 View Only
  • 1.  DBU2MSXL and DBU2MSAC

    Posted Wed October 12, 2022 05:31 PM
    Hello,

    I have been tasked with finding the best way to parse out RACF unloads into either XML, CSV, or Microsoft Access formats.

    I came across mentions of DBU2MSXL and DBU2MSAC but can't find any working links to these tools.

    Would using CARLa be the better option to get these formats?

    Thank you!

    Joseph Armas

    ------------------------------
    Joseph Armas
    ------------------------------


  • 2.  RE: DBU2MSXL and DBU2MSAC

    IBM Champion
    Posted Thu October 13, 2022 04:02 AM
    Edited by Rob van Hoboken Thu October 13, 2022 04:17 AM
    Hi Joe

    Using this Google query you can find a repository and documentation about DBU2MSXL.  I suppose the same holds for the other tool.  

    With CARLa you can easily create CSV output, using the HEADER=CSV (or better, with column titles using HEADER=CSVT) parameter in the OPTION and NEWLIST commands.  For example:

    newlist type=racf header=csvt
      select class=user segment=base
      sortlist key name ljdate($date,10) revoked

    Personally, I much prefer the TSVT format that uses TAB characters as separator, thus removing need for quotes.  Quotes play havoc with some field types.

    If you want to output dataset and resource profiles, use newlist type=racf_access for easier formatting of the ACL.  For inspiration about field names, for the different profile types and segments, look at the RECREATE application, that is member names CKRXCxxx and CKRXRxxx in SCKRCARL.

    If you need to export several classes of profiles in the same pass (job), you can use the DD=ddname parameter on the NEWLIST command, and allocate said ddnames in your JCL.  Each DD receives its own data WITH a proper title line.  If your output data set in a PDSE, you can even allocate DDs to different members of the same PDSE, but don't try this with a traditional PDS.

    I suggest you stay away from XML, due to the limitations on support in CARLa and necessary work-arounds, unless your application demands it.

    ------------------------------
    Rob van Hoboken
    ------------------------------