Alexander Tobias Heinrich
Reputation
250
Top tag
Next privilege 300 Rep.
Create new tags
Badges
2 8
Impact
~9k people reached

  • 0 posts edited
  • 0 helpful flags
  • 3 votes cast
Mar
12
accepted db2pd: Database mydb not activated on partition 0
Mar
12
comment db2pd: Database mydb not activated on partition 0
That did solve my problem, thank you very much. The user under which I was executing db2pd had DBADM privilege which I believed would suffice, but it was not part of the Administrators group of Windows. Adding the user to the Administrators group and starting db2cmd via right click -> Run as Administrator then worked.
Mar
11
asked db2pd: Database mydb not activated on partition 0
Jan
28
awarded  Nice Question
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!