View previous topic :: View next topic
|
Author |
Message |
najeeb
New User
Joined: 15 May 2009 Posts: 6 Location: trivandrum
|
|
|
|
Hi
i need to develop a job to delete all the records from a table.
The table has nearly 2 million records.
if i execute delete from table_name in the JCL i doubt whether there will be any time out error due to huge volume of data.
Can any one please suggest a better solution where i can quickly clear the table compleately |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
had you bothered to use correct terminology,
db2 tables have ROWS,
db2 tables DO NOT HAVE RECORDS
you could have found this link by googling. |
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
dummy load as explained in the link
or
truncate if supported |
|
Back to top |
|
|
|