IC61914: THE DOCUMENTATION OF CREATING ESB COMMONDB IN ORACLE IS NOT CORRECT.

APAR status

• Closed as documentation error.

Error description

• The following is the URL is incorrect:
  http://publib.boulder.ibm.com/infocenter/dmndhelp/v6r2mx/index.j
  sp?topic=/com.ibm.websphere.wesb620.doc/doc/tins_edit_oracle_scr
  ipts.html
  
  1.  Remove the createTable.sql in the CommonDB directory.
  2.  Correct the doc steps: step 4 should be a pre-req for step
  3.  In current step 4, the createSchema_CommonDB.sql is
  incorrect.  It should be changed to createSchema.sql.
  

Local fix

• 1.  Inform customer to do step 4 before step 3.
  2.  Inform customer to use the script of createSchema.sql.
  3.  Inform customer to ignore the createTable.sql script.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of WebSphere Enterprise Service Bus    *
  *                 and WebSphere Process Server V6.2 who are    *
  *                 attempting to use Oracle as the Common       *
  *                 Database                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: The documentation in the infocentre     *
  *                      is incorrect:                           *
  *                                                              *
  *                      http://publib.boulder.ibm.com/          *
  *                      infocenter/dmndhelp/v6r2mx/index.jsp?   *
  *                      topic=/com.ibm.websphere.wesb620.doc/   *
  *                      doc/tins_edit_oracle_scripts.html       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The documentation in the info centre is targeted to be
  changed to indicate the following:
  
  1. Make sure that you are using a user ID with sufficient
  authority to update the database schema.
  2. Locate the directory where the database scripts are located:
  media_root/dbscripts/CommonDB/oracle or
  <extract_directory>/dbscripts/CommonDB/oracle
  media_root\dbscripts\CommonDB\oracle or
  <extract_directory>\dbscripts\CommonDB\oracle
  
  3. Locate the createSchema_CommonDB.sql file which is a
  template used to create required schemas. To create a database
  schema:
  a. Replace the DBUSER variable with the database schema name.
  For example, orauser.
  b. Replace the DBPASS variable with the database schema
  password. For example, youNameIt.
  c. Repeat the above steps for each additional schema.
  
  4.     Locate the configCommonDB.bat or configCommonDB.sh file
  and
  perform following subtasks:
  a. Replace the DB_NAME variable with the Oracle Database name
  [SID], for example ORCL.
  b. Replace the DB_USER variable with Oracle user, for example
  orauser.
  
  5.     Locate the insertTable_CommonDB.sql file and replace
  the  following variables with the WebSphere ESB version you are
  installing. For example, if the WebSphere ESB version is
  6.2.0.0 then:
  a. Replace the MajorVersion variable with the first digit of
  the product version number, for example 6.
  b. Replace the MinorVersion variable with the second digit of
  the product version number, for example 2.
  c. Replace the RefreshPackLevel variable with the third digit
  of the product version number, for example 0.
  d. Replace the FixpackLevel variable with the fourth digit of
  the product version number, for example 0.
  
  6. Copy all of the scripts from the
  extract_directory\dbscripts\CommonDB directory to the Oracle
  workstation and run the configCommonDB.bat or
  configCommonDB.sh script.
  Note: Make sure the common database schema or user is created
  (in Step 3)  before running this script because it uses common
  database user to connect the database for creating tables.
  

Problem conclusion

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels