468,321 Members | 1,734 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,321 developers. It's quick & easy.

Reorg Tablespace

Hi,

I use REORG TABLESPACE with DISCARD option to delete selected records from a table and to write them in a file.
But the process create a file SYSREC with the entire table records.
For a table with a sizeable volume, the cost is important.
Then I want to optimize the process in not writting those records.
I tried NOSYSREC option, but it didn't work.
I tried to code DDname with DUMMY but it didn't work better.
The SYSIN of the DSNUPROC command is :

REORG TABLESPACE Bxxxxxx.Sxxxxxx LOG NO
SHRLEVEL NONE DISCARD
FROM TABLE TEST.Txxxxx WHEN (Txxx_xxxxxxx = '000000')
/*

Can someone help me ?

Thank you.

Jérôme.
Oct 12 '07 #1
0 1254

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

27 posts views Thread by Raquel | last post: by
3 posts views Thread by datapro01 | last post: by
9 posts views Thread by mike_dba | last post: by
9 posts views Thread by Mikael | last post: by
reply views Thread by bwmiller16 | last post: by
3 posts views Thread by jane | last post: by
reply views Thread by NPC403 | last post: by
1 post views Thread by howard w | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.