DB2 SQL Error: SQLCODE=-554, SQLSTATE=42502 when you try to load database schema

When you are preparing a database for HCL Commerce Version 9, you need to run the initdb_db2_sample utility. During execution, you might encounter a message similar to the following error.

Dec 04, 2017 7:41:44 PM com.ibm.commerce.utilities.RunSQLFile runSql()
INFO: Running file C:\v9\WCDE_V9\\schema\9.0.0.0\db2\Create_Workspaces_For_WCS.sql
Dec 04, 2017 7:41:44 PM com.ibm.commerce.utilities.RunSQLFile runScript()
SEVERE: Error executing: GRANT CREATEIN, ALTERIN, DROPIN ON SCHEMA WCW101 TO USER DB2INST1
Dec 04, 2017 7:41:44 PM com.ibm.commerce.utilities.RunSQLFile runSql()
SEVERE: SQLException information
Dec 04, 2017 7:41:44 PM com.ibm.commerce.utilities.RunSQLFile runSql()
SEVERE: Error msg: DB2 SQL Error: SQLCODE=-554, SQLSTATE=42502, SQLERRMC=null, DRIVER=3.69.24

Problem

You might have specified the dbuser field with a database administrator username.

Solution

Ensure that you do not use an administrator username in the dbuser field.
  1. Restore the database.
  2. Rerun the initdb_db2_sample utility.For example, in the following command, the dbauser is db2inst1 and the dbuser is wcs.
    .\initdb_db2_sample.bat staging mall mydb.ibm.com 50000 db2inst1 db2instpassword wcs wcs1 aaaa1aaaa1aaaa12aaaa1aaaa1aaaa12 wcsadminSalt1 wcsadminPwd1 spiuserSalt1 passw0rd sampleData