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.
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.