The posts here represent my personal views and not those of my employer. Any technical advice or instructions are based on my own personal knowledge and experience, and should only be followed by an expert after a careful analysis or consultation with IBM support. Please test any actions before performing them in a critical or nonrecoverable environment. Any actions taken based on my experiences should be done with extreme caution. I am not responsible for any adverse results. DB2 is a trademark of IBM. I am not an employee or representative of IBM.

Commerce Data Model

Example of Indexing for a Problem Delete

An Example of Changing the Data Type of a DB2 Column

Example of Troubleshooting a Locking Problem

How to Tell if a Table is a Part of Stagingprop

STGMENBR and Stagingprop Failure

Updated: The 10 WebSphere Commerce Tables You Should Be Familiar With

NEVER drop a WebSphere Commerce base index

VARCHAR: Friend or Foe

Categories of tables in E-commerce databases

Naming Standards in WebSphere Commerce Databases

Tweets:

Recent Posts

DB2 Education Resources

WebSphere Commerce Reference and Education

Disclaimer

Categories