Re: [sqr-users] PeopleSoft and Tablespaces

["Edwin Hommes" <hommes@bluewin.ch>]

Jim, not entirely correct. A tablespace is a physsical amount of hard disk
you assign in your database. the next step is to write particular records
into that tablespace. When making your database design you must consider how
much physsical storage some records will take. PS_JOB for example will be
your largest table, therefor require a lot of hard disk space. Some
databases tend to lock an entire tablespace (and thus all records in that
tablespace) when altering data in one of the records. Some systems do not
allow you to automatically extend the seize of your tablespace. It is much
more than just a logical group of tables. You have to find a balance between
all records in one tablespace and each record it's own tablespace.

Edwin


----- Original Message ----- 
From: "Jim Engebretson" <jengebretson@Cerritos.edu>
To: <sqr-users@sqrug.org>; "peoplesoft-hr-l" <peoplesoft-hr-l@OpenITx.com>;
<peoplesoft-other-l@OpenITx.com>
Sent: Monday, July 28, 2003 9:08 PM
Subject: [sqr-users] PeopleSoft and Tablespaces


> It is my understanding that a tablespace is a logical group of
> records/tables. What is the purpose of tablespaces within PeopleSoft?
>
>
>
> Jim Engebretson
>
>
>
>


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.504 / Virus Database: 302 - Release Date: 24/07/2003

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users