Reputation
3,394
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
4 16 46
Newest
 Electorate
Impact
~386k people reached

2d
comment Transaction Log Backups Serial or Parallel?
@MaxVernon - perhaps. But some opinion based questions are valid. I try to ask questions that make sense to ask, rather than just starting flame wars. Plus I have tended to be Accidental/Junior DBA at all of my jobs. First DB2 and now SQL Server. So I don't have a senior to learn from. My only resource is the community. So I think a question like this is fair. It allows myself and other accidental/juniors to learn from it.
2d
asked Transaction Log Backups Serial or Parallel?
Feb
3
comment How to Start DB2 10.5 HADR on the Standby Database
Be aware that LOGRETAIN will retain logs forever. It will not clean them up for you, even if you use AUTO_DEL_REC_OBJ. For this reason, I have avoided LOGRETAIN and gone with DISK. This allows me to specify where I want the archived logs to go to, and to enable auto-pruning through AUTO_DEL_REC_OBJ.
Jan
27
awarded  Electorate
Jan
22
comment DBCC Check DB issue
You could use the WITH ESTIMATEONLY option to see how much space DBCC CHECKDB is attempting to use.
Jan
21
comment Max Degree of Parallelism for SQL Server 2008
I've learned recently from a class that if you have NUMA, to set MAXDOP equal to the number of physical cores in a single processor, but if Non-NUMA, to set no higher than the number of physical cores with a max value of 8.
Jan
20
comment Unable to restore database because it exists, unable to drop because it does not exist
Before dropping it is always a good idea to make sure no one is connected and the database is not activated. Use db2 deactivate db <name> to deactivate the database.
Jan
20
revised DB2 Database Conversion Workbench Issue
edited tags
Jan
20
answered DB2 Database Conversion Workbench Issue
Jan
18
comment Unable to restore database because it exists, unable to drop because it does not exist
See also dba.stackexchange.com/questions/2610/…
Jan
18
revised DB2 doesn't start after change db2 hostname
added 19 characters in body
Jan
18
answered DB2 doesn't start after change db2 hostname
Jan
15
answered DB2 Naming Standards - Similar to OFA
Jan
15
comment DB2 Naming Standards - Similar to OFA
Just FYI db2inst1 is the default name for the first instance of DB2, should you not name your instance otherwise. All databases will create by default there unless you override the default path at the instance level and/or specify (a) new path(s). In our case, we never went with defaults (security reasons). We always created named instances in different locations. And we placed data, system data, logs, archive logs, and backups all on different file paths (we had SAN underneath so I couldn't tell you if the disk was truly different or not).
Jan
12
revised DB2 - Error accessing a table space SQL 57048
edited tags
Jan
11
comment How can I ensure that only one user at a time can call a stored procedure? Can I lock an SP?
Does that require the WLM license? My understanding is the work load manager stuff is a separate license from IBM.
Jan
11
answered How can I ensure that only one user at a time can call a stored procedure? Can I lock an SP?
Jan
11
answered Check if a user exists in a SQL Server database
Jan
8
revised Error in loading data using DB2 load command in DB2 10.5
Added tags to help
Jan
8
revised Two If's And An Else
rolling my answer into the winning answer, as mine explained what was wrong and the accepted answer just provides the code. Will delete my competing answer.