Sounds good to me. It's no worse than a catalog search that returns everything.
Rob Schramm On Fri, Mar 20, 2020, 13:10 Massimo Biancucci <mad4...@gmail.com> wrote: > 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 > ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
