MVSFORUMS.com

deepa12 · Posted: Tue Jul 05, 2005 4:44 am Post subject: empty a db2 table

What is the optimised way to delete all rows in a db2 table
isntead of using delete from table name
1 method i can think of is load an empty dsn extract
ls help as soon as possible
Thanks & rgs
deepa
_________________
deepa

kolusu · Posted: Tue Jul 05, 2005 6:01 am Post subject:

deepa12,

A LOAD DATA REPLACE LOG NO with a dummy DSN will be more efficient way of emptying a table rather than using an utility.

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

deepa12 · Posted: Tue Jul 05, 2005 7:50 am Post subject:

Thanks a lot
deepa
_________________
deepa

videlord · Beginner Joined: 09 Dec 2004 Posts: 147 Topics: 19

Be careful of using LOAD to empty table.
If more than 1 table in the tablespace, then all tables in the tablaspace would be emptied.

deepa12 · Posted: Thu Jul 07, 2005 12:29 am Post subject:

Hi
Thanks... yes. i will ensure that it is a segmented table space
rgs
deepa
_________________
deepa

videlord · Beginner Joined: 09 Dec 2004 Posts: 147 Topics: 19

Segment tablespace is not 1 table/tablespace,.
1 page of segment tablespace can contain data only from one table.
It's permited to put several tables in one segment tablespace.

deepa12 · Posted: Thu Jul 07, 2005 10:46 pm Post subject:

Hi
Am very sorry... I dont understand
I have always read that simple table space can have many tables
And segmented tablespace can have only 1 table.
So even segmented tablespace can have more than 1 table is it?
_________________
deepa

Manas Biswal · Posted: Fri Jul 08, 2005 1:25 pm Post subject:

deepa12,

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNITH11/1.2.2.5?DT=20010710161352

Regards,
Manas