thanks for your response. Here's what I don't understand. If I create a dbspace for the DB, the dbspace is actually empty until I load data. Once data is in, then the space is filled up.
Using that idea, when I create dbspace for physical logging, the dbspace is empty, but when I use onparams, it becomes 50% full before I populate the database with data. If its 50% full, what is it full of?
The only thing I can figure is that the onparams utility reserves page-space, and that "fills" up the dbspace, so to speak. Is that true or false?
When you initialize a instance of IDS you need have in your mind 4 thinks: root, logical log, physical log and data...
- root : space to database SYSMASTER
- physical log: space reserved to before-images pages....
- logical log:: space reserved to transactions logs...
- data: your database...
By default on the first initialization the configuration put all together, but this is not recommended... at least you need a dbspace for each one.
some like this:
rootdbs - only to database sysmaster
physdbs - only to physical log (allocated with onparams)
logdbs - only to logical log (allocated with onparams)
data1dbs - only to your database