Instance Creation in WebSphere Commerce 7 (DB2 9.5)

Posted by

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?

Lead Db2 Database Engineer and Service Delivery Manager , XTIVIA
Ember is always curious and thrives on change. Working in IT provides a lot of that change, but after 17 years developing a top-level expertise on Db2 for mid-range servers and more than 7 years blogging about it, Ember is hungry for new challenges and looks to expand her skill set to the Data Engineering role for Data Science. With in-depth SQL and RDBMS knowledge, Ember shares both posts about her core skill set and her journey into Data Science. Ember lives in Denver and work from home for XTIVIA, leading a team of Db2 DBAs.

4 comments

  1. 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!

    1. 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.

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.