Home > Integration Developer > IBM Integration Designer Installation troubleshooting

IBM Integration Designer Installation troubleshooting

Just spent quite a few hours troubleshooting IID V8.0 installation. Troubles started when installing DB2 Express (which comes with IID). I got to the end of installation but none of the server profiles was configured. Errors in the logs pointed to a pretty common SQL error

“SQL1092N “USER” does not have the authority to perform the requested command “

And it reported my domain Windows user account instead of “bpmadmin” user that was configured in the wizard.

Had to dig all the DB2 forums to come up with fixes. Wish IBM would document it somehow.

1. Verify user Domain Account and “bpmadmin” is part of DB2ADMNS and Administrators group

2. Verify  in DB2 SYSADM, SYSCTRL, SYSMON groups are set to DB2ADMNS

   db2 get dbm cfg

3. If they are not update groups:

db2 update dbm cfg using SYSMAINT_GROUP DB2ADMNS

db2 update dbm cfg using SYSCTRL_GROUP DB2ADMNS

db2 update dbm cfg using SYSMON_GROUP DB2ADMNS

db2 update dbm cfg using SYSADM_GROUP DB2ADMNS

4. Check that DB2_GRP_LOOKUP=TOKEN to make sure it works with domain account:

  db2set -all

5. To update this setting run:

db2set DB2_GRP_LOOKUP=TOKEN

6. Restart DB2 instance

7. Reset WAS profile : Open IID, right click on Server -> Manage Profiles -> Reset Profile

8. If Reset did not work delete profile, and all files in profiles directory and re-create the profile with PMT

Advertisements
  1. Michael Lu
    July 18, 2012 at 3:15 pm

    cool, useful information.

  2. Ramu P
    August 31, 2012 at 1:08 am

    Quick Q:
    If I am doing a fresh install on a new machine(windows 7), will the DB2ADMNS group get created the first time I attempt to install IID7.5.1?

    So should I let it fail once, add “bpmadmin” to DB2ADMNS and try to install again?

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: