213 reputation
27
bio website
location Munich, Germany
age 34
visits member for 1 year, 9 months
seen Sep 18 at 14:54

Aug
12
awarded  Yearling
Apr
4
awarded  Notable Question
Dec
4
accepted DB2: Cannot use RUNSTATS/REORG in trigger definitions?
Dec
2
comment DB2: Cannot use RUNSTATS/REORG in trigger definitions?
If I delete rows and do not run REORG/RUNSTATS as you suggest, will the values in SYSIBMADM.ADMINTABINFO update? If not, then this is the reason why I need to run it every time, because otherwise the condition SOMECONDITION would be true too often and too many rows would be deleted.
Dec
2
comment DB2: Cannot use RUNSTATS/REORG in trigger definitions?
@mustaccio: I reduced the sample code to the absolute minimum and it appears, that I built in a bug - you're right that fetch first doesnt work with delete directly, but I fixed that in the example now.
Dec
2
comment DB2: Cannot use RUNSTATS/REORG in trigger definitions?
Thanks for your comments. Please see the edit I made to my original post for some more background info.
Dec
2
revised DB2: Cannot use RUNSTATS/REORG in trigger definitions?
edit to the delete statement
Dec
2
asked DB2: Cannot use RUNSTATS/REORG in trigger definitions?
Oct
3
awarded  Popular Question
Jul
2
awarded  Self-Learner
May
13
awarded  Scholar
May
13
accepted Why doesn't DELETE + REORG free diskspace (DB2)?
May
7
comment Why doesn't DELETE + REORG free diskspace (DB2)?
The databases we're dealing with contain log data from industrial machines. Queries against such databases are not time critical, so if performance drops during a reorg, this is not a problem.
May
7
awarded  Teacher
May
7
awarded  Supporter
May
7
comment Why doesn't DELETE + REORG free diskspace (DB2)?
As I mentioned in my initial post, I already tried most of that and it didn't work out. By now I found the solution my self: Disk space could not be reclaimed because I did not specify the LONGLOBDATA option, which seems to be necessary if you want to reclaim disk space from BLOBs or CLOBs. Please see my answer to my own question here. Anyway I appreciate the effort you put into your answer, +1!
May
7
answered Why doesn't DELETE + REORG free diskspace (DB2)?
May
6
awarded  Editor
May
6
revised Why doesn't DELETE + REORG free diskspace (DB2)?
added more tags in order to hopefully reach a broader audience
May
6
awarded  Student