Comments for DB2 LUW DBA HowTo

Comment on International Relocation: In Defense of IBM and Project Match by Jeffrey

Jeffrey — Tue, 30 Mar 2010 02:09:34 +0000

@Cassie – My job has been outsourced twice. Every time I immediately found a better job that was more appropriate to a senior DBA. If your job can be offshored that easily, you may think about changing your skillset.

Once a DBA position becomes so routine that any junior DBA can handle it, it’s ripe to be offshored. I pride myself in not staying in positions that are beneath my capabilities.

Comment on International Relocation: In Defense of IBM and Project Match by Cassie

Cassie — Mon, 29 Mar 2010 23:40:00 +0000

Jeffrey is clearly an IBM lap dog (for now). When his job gets offshored, I’m sure he’ll change his tune.

Comment on UPDATE: DB2 Health Monitor Problems by Jeffrey

Jeffrey — Sat, 16 Jan 2010 17:12:53 +0000

Devendra,

All i can suggest is the IBM recommendation: “Set the registry variable for the instance once.

db2set DB2ENVLIST=DB2_HMON_DFT_STACK_SZ

And set the environment variable before db2start every time.

export DB2_HMON_DFT_STACK_SZ=655360
db2start”

Comment on UPDATE: DB2 Health Monitor Problems by Devendra

Devendra — Sat, 16 Jan 2010 08:00:18 +0000

Jeffrey,
I cannot perform the above operations suggested by IBM since DB2 server is a production server.I can only suggest to Customer the above solution,but I cannot suggest it currently since in your case HEALTH_MON is set to ON value, whereas in my case it is OFF.
We have suggested them to keep DB2_HMON_DFT_STACK_SZ = 0, since on our production server HEATLH_MON is usulally set to OFF always and we do not want errors due to db2acd process which runs after every two hours even if HEALTH_MON is set to zero.

Comment on UPDATE: DB2 Health Monitor Problems by Jeffrey

Jeffrey — Sat, 16 Jan 2010 05:42:41 +0000

Davendra,

Please read to end of article: “Update February 17, 2009 from IBM” which gives detailed advice. Please implement and tell me if this corrects your issue.

Comment on UPDATE: DB2 Health Monitor Problems by Devendra

Devendra — Sat, 16 Jan 2010 04:19:03 +0000

In your case u said u found the above error when HEALTH_MON=ON was set, but in my case I found the same error when HEALTH_MON=OFF,Please suggset