Reputation
2,789
Top tag
Next privilege 3,000 Rep.
Cast close & reopen votes
Badges
3 14 42
Newest
 Yearling
Impact
~253k people reached

Apr
24
comment How do I modify a stored procedure in IBM DB2?
I believe you can do so through IBM Data Studio. I would use that tool anyway as that is now the approved IBM tool for interacting with DB2 and Control Center is deprecated.
Apr
10
comment Backup of database X on SQL Server 2008 on server A - restore to SQL Server 2012 database Y on server B
+1 for stop using the GUI. Scripting is always better.
Apr
6
comment DB2 - what happens when SQL archive log file reches its maximum value (S9999999.LOG)
Well done mustaccio. You should post this as an answer.
Apr
6
comment How do I grant all privileges to local db2admin with DB2 9.7 on Windows?
SYSADM always has the ability t to create a database. So does SYSCTRL.
Apr
2
comment DB2 Setting up table access based on LDAP groups
And even if you are using groups....I would highly recommend you go with roles rather than explicitly permission against objects. Going to save you a lot of pain later as you can move groups around within roles, etc.
Apr
2
comment How do I grant all privileges to local db2admin with DB2 9.7 on Windows?
@sunk818 - steps would be the same even for command line. It has more to do with how DB2 functions with regards to security starting in version 9.7.
Mar
29
awarded  Yearling
Mar
24
comment List of open (uncommitted transactions) in DB2 LUW
@Dror - is this for a report? Why would you need the list of uncommitted transactions on a client? Perhaps you would be better off having db2pd run on the server and a report sent out?
Mar
23
comment List of open (uncommitted transactions) in DB2 LUW
If it runs server side only, perhaps you need to use something like PuTTY to remote to the server to run it.
Mar
11
comment List of open (uncommitted transactions) in DB2 LUW
@Dror those were just recommendations. If you take a peek at the views and functions lists that I linked to, you may find the exact one you are looking for.
Mar
11
answered List of open (uncommitted transactions) in DB2 LUW
Mar
5
comment DB2 ROLLFORWARD option “TO END OF LOGS” - does it read archive logs?
Of course I would also comment that you should probably take backups more often than just on Monday. I am hoping what you asked above was a hypothetical question.
Mar
5
comment DB2 ROLLFORWARD option “TO END OF LOGS” - does it read archive logs?
So in your question above #2 seems to be the answer you are looking for.
Mar
5
comment DB2 ROLLFORWARD option “TO END OF LOGS” - does it read archive logs?
And this gets to your next question. Archive logs can be in multiple places. But you control where. If logarchmeth1 was set to LOGRETAIN, then the archive logs are stored in the active log directory (and hence perhaps no need to specifcy the "overflow log path" clause on the rollforward statement. But if you specify "DISK:<some location>", then the archive logs are in another location. At which point if you wish to rollforward through them you would want to specify that in the "overflow log path " clause of the rollforward statement.
Mar
5
comment DB2 ROLLFORWARD option “TO END OF LOGS” - does it read archive logs?
@Dejan - what mustaccio says is true. 1st you need to know where your active logs are. So if you just say db2 rollforward to end of logs, it will restore the database and then search the active logs for transactions to roll forward to. Depending on the last active log, this may or may not be possible. Hence, why you can tell the database where the logs are you wish to rollforward over....
Mar
3
comment DB2 - question regarding RESTORE OFFLINE backup and Archive Logs
@Dejan - Whether or not you have active logs or take an online or offline backup, once you are using archivable logging, you need to rollforward to take the database out of rollforward pending mode.
Feb
26
comment Multiple records and determine if a combination if values exist and write this to a new column
You may be better off going with a view. A table would be hard to maintain with this. Then your app would have to figure this out, or you would need a trigger or stored proc to determine the change in the new column based on inserts, updates, or deletes. So I vote you either go with a view or use a trigger or stored proc if you really want this information in the table.
Feb
25
comment accessing DB2 database connection by squirrel sql client
Is DB2 also on Ubuntu?
Feb
24
comment DB2 PURGE (old Online Backups and Archive logs) - some of the archive logs are not removed
I have encountered issues where the files are not always cleaned up. My experience and what little looking into it I've done lead me to think it is some form of permissions issue. Sometimes taking an offline backup and then cleaning out the entire archive structure has helped. Sometimes it hasn't.
Feb
24
answered DB2 PURGE (old Online Backups and Archive logs) - some of the archive logs are not removed