Reputation
2,879
Top tag
Next privilege 3,000 Rep.
Cast close & reopen votes
Badges
3 14 44
Newest
 Revival
Impact
~285k people reached

1d
comment Informatica vs datastage? Wich is better for a beginner?
I would start by reading up on Inmon and Kimball. They talk about those in their books. That also prepares you for both schools of thought and the hybrids that exist between them.
2d
comment Informatica vs datastage? Wich is better for a beginner?
I think you would do better to study warehousing and ETL methodologies. The ETL tool and database platform will vary by shop. Which tools do they use at your company (or the company you wish to work for)? Or which tools tend to be used the most in the area you live? These are the kinds of things I would think about then just "which is better?".
2d
revised What exactly is binding in DB2?
updated link.
2d
answered Check if encrpytion key is valid in DB2
2d
comment RAM utilization
I like to follow the formula I read from Jonathan Kehayias. 1 GB for OS, plus 1 GB for each 4GB for the first 16 GB, and then 1GB for each 8 GB after the first 16 GB). This is what should be reserved for the system. The rest can go to SQL Server if it is a dedicated system.
2d
comment RAM utilization
SQL Server will normally grab a lot of memory. You should generally cap it around 80 - 90% of the systems memory. The system should have at least 4GB of memory comfortably. Or, if memory starved, perhaps 2 GB.
Jun
26
comment check when last backup was taken
In my case (I use Ola Hallengren's scripts), I can check the CommandLog table that those log to. I also get an email every day on success or failures (right now we only back up daily). And I also visit the server and check on the backups and logs, cpu, memory, etc. for a health spot check.
Jun
19
comment Identical query slower when searching for `T` rather than `F`
Brent Ozar's team explains how this happens and some of what you can do to mitigate this: brentozar.com/archive/2013/06/…
Jun
18
awarded  Revival
Jun
18
answered How do I modify a stored procedure in IBM DB2?
Jun
15
comment How to create a Linked Server from SQL Server 2008 to DB2?
Which OS is your DB2 on? Unix, Linux, or Windows? Because ODBC is generally bound by default (given which packages get bound by the admin when creating databases) on Unix and Linux, but must be explicitly bound by the admin on Windows. That might be part of your issue here.
Jun
10
answered DB2 10.5 - When inserting, the database is trying to reuse index keys on GENERATE ALWAYS
Jun
9
awarded  Popular Question
May
29
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
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.