Monday 3 February 2014

Following Leadership Legacy

Roosevelt used to say “The best executive is the one who has sense enough to pick good men to do what he wants done, and self-restraint to keep from meddling with them while they do it.” I had the honor of working under very good managers and it seemed they used to follow what Roosevelt underlined above in the message. Well, you reciprocate the same as you grow up the ladder making it a better work place for you, your manager and even your subordinates. And that’s where I think people say “I look up to my manager and is a role model for me”.


The comic strip Dilbert's workplace was started to satirize technology, workplace, and company issues. Dilbert portrays corporate culture as a world of bureaucracy issues for its own sake and office politics that stand in the way of productivity, where employees' skills and efforts are not rewarded, and busy work is praised. Much of the humor emerges as the audience sees the characters making obviously ridiculous decisions that are natural reactions to mismanagement. Scott Adams puts across the mismanagement issues in a concise manner in the comic strips portraying what should not be done - but on the bright side people just laugh it off as a good joke not really prodding their own views or behavior.




Jokes apart, wherever the macro trends are headed, the ability to engage and retain talented employees is a critical skill for managers and the firm. Most of us aspire to leave our mark in the world in some way, to be remembered for something. Involuntarily you tend to sow the seeds of the legacy through one of these:

  • Improving skills and capabilities of your peers and subordinates by your actions (coaching, developing or creation of roles)
  • Mentoring people in the breadth of the organization. I wouldn’t term on the quantity but the quality of the people mentored across the breadth of the organization.
  • A better giving and receiving feedback framework.


Friday 10 January 2014

DB2 Replication – Near Real-time

In a world where everything has become real-time, mainframe is fast catching up to the term near real-time. It was not long ago, that customers were asking for real-time information. This did have an impact on mainframe community too, Db2 or Adabas, the word was out to see if a replication mechanism can be developed and if such a replication is a viable option. Software AG (developers of xml & Adabas/natural) was able to size up the opportunity quickly by creating the new tool called Adabas replicator driven on PLOG. Db2 wasn’t far behind either.

The only clich̩ was that Adabas Replicator was yet another tool (well let us say you have to get a licensing cost to it) to be marketed by the software giant, while db2 provided a solution called event publishing for converting committed source changes into messages in an XML format and publishing those messages to applications such as message brokers by leveraging the system files within db2. Before I proceed further, I just want to pause and say this Рin both the instances the replication is only near real-time and it really depends on the target systems, on how fast they can process the messages from the queue.

A simple configuration of event publishing looks like this:





DB2 MQ setup table : SYSIBM.MQSERVICE_TABLE
DB2 ID used by db2 to access MQ = DB2MSTR

Sample DDL Set up as follows:
CREATE TRIGGER “REF_DATA_TRIGGER”
AFTER INSERT ON “REF_DATA”
REFERENCING NEW AS REF_NEW
FOR EACH ROW MODE DB2SQL
BEGIN ATOMIC
SELECT DB2MQ.MQSEND
(
'MYSERVICE',
CAST(‘<REFDATA>’||XML2CLOB(
XMLCONCAT(
XMLELEMENT(NAME “FIELD1”,REF_NEW.FIELD_1),
XMLELEMENT(NAME “FIELD2”, REF_NEW.FIELD_2),
XMLELEMENT(NAME “FIELD3”, REF_NEW.FIELD_3),
XMLELEMENT(NAME “FIELD4”, REF_NEW.FIELD_4),
XMLELEMENT(NAME “FIELD5”, REF_NEW.FIELD_5),
XMLELEMENT(NAME “FIELD6”, REF_NEW.FIELD_6)
))||’<REFDATA>’ AS VARCHAR(2000)))
)  
FROM
SYSIBM.SYSDUMMY1


Special thanks to my colleague Jeegar Doshi who helped me compile the information on DB2 replication.