View Only
  • 1.  SYSCHK1 Usage breakdown

    Posted Jul 24, 2017 12:31 PM



    Does anyone have any code to breakdown GLV and RDF usage so that you can easily see usage by GLV node or table?




  • 2.  Re: SYSCHK1 Usage breakdown

    Posted Jul 26, 2017 07:31 AM

    Hi Andy,

    Not sure exactly what you are doing, but I'll forward a simple pgm that can quickly tell you the number of subnodes for each GLOBALx stem as well as GLVTEMPx stems. It also queries the TABLE table and displays each RDF table and its row count. Use it to clean up GLOBALs and RDF tables when Syschk1 starts filling up. You can of course modify as needed such as using OPSVALUE to get history/update info of each variable as well as last access date/time from the TABLE table for each RDF table. Let me know if you do not receive.