Erase YES on partitioned Tablespaces

Canvas JHVZ Botha

Erase YES on partitioned Tablespaces
I have been reading through the DB2 manuals (nothing else to do here at the
moment) and stumbled onto the following:

From the DB2 Admin Guide
ERASE. Allows you to specify whether the contents of a data set for the
table space or partition are erased when the table space is dropped.

All good and well. When I looked at the DB2 SQL reference Appendix D I got
the following for ERASERULE
¦ ERASERULE ¦ CHAR(1) ¦ Whether the data sets are to be ¦ G ¦
¦ ¦ NOT NULL ¦ erased when dropped. The value is ¦ ¦
¦ ¦ ¦ meaningless if the table space is ¦ ¦
¦ ¦ ¦ partitioned. ¦ ¦
¦ ¦ ¦ ¦ ¦
¦ ¦ ¦ N No erase ¦ ¦
¦ ¦ ¦ Y Erase ¦

So does this mean that the ERASE RULE is ignored for partitioned tablespace?
Surly the same security requirements must exist for partions as for
non-partitioned tablespaces? I am to lazy to test this at the moment.
Anyone out there with comments? (Any comments)


Cheers

Canvas Botha
DB2 DBA
DataBase Systems
(IT IS) IT Technical Support SBC
Infrastructure Services
27 (0)11 636 4894

Michael Ebert

Re: Erase YES on partitioned Tablespaces
(in response to Canvas JHVZ Botha)
Hi,

what does JHVZ stand for (I wonder)? ERASERULE is in SYSTABLESPACE so it
probably predates partitioned TSs. It should be in SYSTABLEPART because you can
specify the ERASE parm per partition. The true value for the ERASE parm can only
be found in the VSAM Cluster info (e.g. using the CSI program I've put into the
DB2-L-DOCUMENTS site).
Indexes (partitions) can be ERASE YES as well, but I did not find an ERASERULE
associated with them at all - again, it's in the VSAM definition.
Note that the erase operation is done when the VSAM file is deleted... not just
when the TS or Index is dropped, but also in a DELETE/DEFINE e.g. during REORG,
LOAD REPLACE, ADRDSSU COPY... which will significantly increase the time
required for these operations.

Dr. Michael Ebert
DB2 Database Administrator
aMaDEUS Data Processing
Erding / Munich, Germany


From: "Botha, Canvas JHVZ" <[login to unmask email]> on 22/12/2000 08:33 GMT

Please respond to DB2 Data Base Discussion List <[login to unmask email]>





|--------->
| |
|--------->
>--------------------------------------------------------------------------->
| |
>--------------------------------------------------------------------------->
>-------------------------------------------|
| |
>-------------------------------------------|
|--------->
|To: |
|--------->
>--------------------------------------------------------------------------->
|[login to unmask email] |
>--------------------------------------------------------------------------->
>-------------------------------------------|
| |
| |
>-------------------------------------------|
|--------->
|cc: |
|--------->
>--------------------------------------------------------------------------->
| (bcc: Michael Ebert/MUC/AMADEUS) |
>--------------------------------------------------------------------------->
>-------------------------------------------|
| |
| |
>-------------------------------------------|
|--------->
| |
|--------->
>--------------------------------------------------------------------------->
| |
>--------------------------------------------------------------------------->
>-------------------------------------------|
| |
>-------------------------------------------|
|--------->
|Subject: |
|--------->
>--------------------------------------------------------------------------->
|Erase YES on partitioned Tablespaces |
>--------------------------------------------------------------------------->
>-------------------------------------------|
| |
>-------------------------------------------|