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

1d
revised How to revoke DBADM and clean up any related objects from DB2 LUW
deleted 1 character in body
May
27
revised Which size is correct?
edited body
May
26
comment AUTO_BACKUP not even trying to backup database
You need to use db2 list utilities [show detail] in order to see if there is a backup in progress or not. (The show detail is optional.)
May
26
comment AUTO_BACKUP not even trying to backup database
And both have DB2 installed as root? and appropriate permissions? And both have logging switched to something other than circular? (although personally I'd go with DISK over LOGRETAIN, allows you AUTO_DEL_REC_OBJ to automatically prune logs along with backups then).
May
21
answered DB2 - REPLACE INTO SELECT from table
May
15
answered Getting error while installing log4db2 utility
May
14
comment SSL impementation in DB2 9.7
Yes, please provide in what way has it failed. What error messages are you receiving? Did you look into using the authentication mode of DATA_ENCRYPT (I know its not SSL, but it forces encryption of user name, password, and data being passed back and forth).
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.