Still mixing terms I'm afraid.
DATABASE=LPAR or iASP=collection of schemas and associated objects
SCHEMA=COLLECTION=LIBRARY
TABLE=PHYSICAL FILE
VIEW=NON-KEYED LOGICAL FILE
INDEX=KEYED LOGICAL FILE
...
Note that for several releases System i has supported installing multiple
databases on the same system/LPAR by leveraging the iASP support. Run
WRKRDBDIRE to see what he's talking about. If you have iASPs installed, run
WRKCFGSTS *DEV *ASP to see corresponding iASP information.
I don't know what the original poster's background is, but if he came from
another platform, he really means database when he says database. On a
number of other platforms database is simply a stream file (with complicated
internal structure of course), install into a file system and a server can
have many databases installed simultaneously on it.
So, if OP is talking DB2 for i database, it's clear - either default LPAR or
iASP library.
If OP is talking a different database (i.e. mySQL), then IFS is a valid
option.
Then again, the OP may indeed simply mean schemas, in which case you're
correct of course.
Elvis
Celebrating 11-Years of SQL Performance Excellence on IBM i, i5/OS and
OS/400
www.centerfieldtechnology.com
-----Original Message-----
Subject: Re: Application Database Objects
Mixing terms here. Are you talking about tables or collections? Collections
(databases) are libraries, and they're always in QSYS. Tables can be in any
library. The IFS wouldn't have anything to do with this. The IFS is for
non-traditional objects, specifically non-library based objects like stream
files and such. The traditional file system is very flat - all objects exist
in a library, all libraries exist in QSYS.
On Fri, Aug 21, 2009 at 12:11 PM, Laine, Rogers
<rlaine@xxxxxxxxxxxxxxx>wrote:
We would like to start creating application databases on our Power6.
When i create a sample database it gets placed in the QSYS.LIB.
Is this the recommended library to create these databases. I think of
QSYS as a System Type library.
I would think it would be better to create these databases under a new
IFS library called QAPPL.
So what is the command to create QAPPL under IFS, if this is the
approved method?
Rogers
midrange.com
