Re: When to Create Database vs Schema only !!!
Date: 1996/01/31
Message-ID: <4eorad$jcu_at_gopher.state.az.us>#1/1
Bill, Thankyou for replying to my question. To followup...schema and
DB2 Database appear to be equivalent ( grouping of objects defined by a
high-level identifier ).
1. DB2...Start and Stop can be issued against the database. Is this
true with at the schema level, or only the instance level?
2. DB2...Tablespaces are defined as Simple, Segmented, or Partitioned.
Many issues relate to this choice. Is an ORA tablespace with mulitple
datafiles equivalent to a DB2 partitioned tablespace? Is there an
equivalent Segmented tablespace?
3. If you define one big tablespace for several schemas how would one
recover just one or part of one schema? Is lowest level of
backup/recovery at the tablespace level?
Thanks for any help, AZ Dept of Environmental Quality (ADEQ). Received on Wed Jan 31 1996 - 00:00:00 CET