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

  • 0 posts edited
  • 0 helpful flags
  • 3 votes cast
Nov
23
awarded  Famous Question
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