Instance Creation in WebSphere Commerce 7 (DB2 9.5)

Updated 6/21/2012 to provide complete syntax for db2iupdt.

So sometimes in Commerce 7 instance creation, we get this error:

SQL30082N Security processing failed with reason “42” (“ROOT CAPABILITY REQUIRED”). SQLSTATE=08001

It doesn’t happen every time, but significantly often. On our most recent build it occured on 1 out of 3 instances created.

The solution is not to run Commerce instance creation as root (please, don’t!). Instead, a db2iupdt is what you need. This does require a DB2 instance outage so be careful if you have other databases on the same DB2 instance.

After instance creation has failed:

  1. Stop the DB2 instance on the database server:
    • (as DB2 instance owner) db2stop
    • (as DB2 instance owner) ipclean
    • IF AIX (as root) /usr/lib/slibclean
  2. Run db2iupdt on the database server:
  3. Start the DB2 instance on the database server:
    • (as DB2 instance owner) db2start

Then re-do Commerce Instance creation, and you won’t get the SQL30082N RC 42 error message.

db2iupdt is usually only required for fixpacks. I’ve also seen it resove various issues including persistent SQL1042C errors. It basically goes out to sqllib and refreshes both copies and links between there and the base db2 code. I’m not entirely sure as to why it is required in this case. We do the DB2 installation and instance creation manually ourselves – perhaps the Commerce instance creation is attempting to do some of that work?

You may also like...

4 Responses

  1. Max says:

    Ahhh yes…
    Also, it’s good to try to ssh to DB server with WAS admin user to make sure it’s password is set correctly. Not to mention, the actuall ID exists on the DB server!

    • ecrooks says:

      Says the guy who actually encountered this error the last time it happened! Yep, I should write up my list of “check first” stuff too at some point.

  2. Charles says:

    In 9.7, it appears that ./db2iupdt requires a -e (for every instance)

Leave a Reply

Your email address will not be published. Required fields are marked *