John, it seems a nice idea anyway I tend to be cautious in interfacing catalog. In my experience there's something that can go wrong.
Years ago we experienced some random delay in DB2 subsystem without having (after tenth of calls to IBM and dump and so on) the ability to diagnose the problem. After long time we discovered how a single TSO user with ISPF 3.4 asking something like first qualifier "*" could heavily impact the system. This drove us to block such a request (no generic on first qualifier). What's interesting is that if you ask for "*.**" no delay at all, but if you ask for "*.*.some.not.exist.*" problems arise. The query will analyze (potentially for a long time) all the catalog entries keeping a SHR enqueue. If anybody would need to define a dataset (EXCL enqueue) will wait for a while. And because of the EXCL enqueue waiting, potentially all the new SHR requests will wait. That time we opened an issue to IBM to describe the problem and ask for something like "Catalog, do the needed but please after every unsuccessfully N fetch close the ENQ and restart". The answer was: "It works as designed". It's been long time ago and maybe now it's different, new zOS, new zMachine .... Hope this helps. Max Il giorno ven 20 mar 2020 alle ore 14:14 John McKown < john.archie.mck...@gmail.com> ha scritto: > I do tend to come up with weird ideas. But I really like query languages, > especially SQL. So I got to wondering if anyone else would like a query > language, perhaps based on SQL, which uses the z/OS catalog structure as a > data source? It would most likely use IGGCSI00 as its base driver code. Or > is there a product that does this sort of thing already? Or am I just > getting weirder? > > -- > People in sleeping bags are the soft tacos of the bear world. > Maranatha! <>< > John McKown > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
