Tuesday, March 19, 2013

IID 7.5 install on Windows 7 with domain account

When you install IID (IBM Integration Designer 7.5) on widnows 7 with a domain account, you will encounter an error while creating databases or tables.  This is because DB2 express can not lookup domain user id as a authorized id, even after you add your domain id to local DB2ADMINS.

You have instruct DB2 to pick local id's be running below commands


    db2set DB2_GRP_LOOKUP=LOCAL,TOKENLOCAL         
    db2 update dbm cfg using sysadm_group DB2ADMNS 
    db2stop                                        
    db2start   

authorized  Please see the further details in IBM Tech note SWG21504375