Laine, Rogers wrote:
My background is DB2 on the z-series, that is why I use the term
It sounds like on the I this is called SCHEMA.
Again my concern is should my application schema's be located in the
QSYS library or some where else?
Your schemas will be located in the QSYS.LIB file system. And yet, when viewed from a different perspective, they will each be in a separate library.
QSYS is a library (is one way of saying it). QSYS.LIB is a file system (is another way of saying something similar from a different perspective).
A schema includes having a "library" as a container object; the name of the library will be the same as the name of the schema.
Library 'objects' always exist as objects in QSYS. But those are merely the library "objects" which are basically just entries in a list maintained by QSYS. Each library object also contains a list of objects within the libraries.
A library object can only exist within QSYS itself, not within other libraries. By extension, that implies that libraries may only be a single level deep (except for QSYS which allows that one extra level). Also, since 'library' and 'schema' are somewhat interchangeable as words, it follows that a schema can only exist within QSYS. Stuff created within a schema, or within a library, is not considered to be inside the library named QSYS.
It's kind of irrelevant, though, since you have no choice. When you create a schema, the system will do what it's going do at that level. As far as your application is concerned, it exists in its own library (schema). As far as your application is concerned, it's not in the QSYS library; it's in whatever library has the same name as your schema.
It's like looking at a basic Windows Desktop and seeing 'My Computer' there. Is 'My Computer' _really_ inside your 'Desktop'? If you drill into 'My Computer' to locate your C: drive, is your C: drive then contained within your 'Desktop'?
Well, no, not exactly... It's all based in how symbols are presented for human use.
IOW, don't worry about it. Create schemas and ignore that they apparently get created under QSYS.LIB. Just avoid explicitly specifying QSYS as a library name itself when you create general stuff. Use the library names of your schemas, and things should work out.
Finally, a bunch of what I said isn't completely true. Much depends on perspective and on what operations are being done. It'll all come together for you.