10 Commerce Tables you should be familiar with

You may also like...

25 Responses

  1. Margarethe says:

    Where exactly is the facebook like link ?

  2. Hiram says:

    Really good content, We are checking back regularly looking for refreshes.

  3. very nice submit, i certainly love this web site, carry on it

  4. sidhant says:

    how could i describe a table in websphere commerce .AS i already used describe command but it shows nothing but a error messge ie:
    Query: describe users
    SQL Exception: Syntax error: Encountered “describe” at line 1, column 1.

    • Ember Crooks says:

      You may simply be forgetting the keyword “table. In db2 it’s “describe table schema.tablename”. If that doesn’t work, your tool may not support the describe command where you’re issuing it. From a command line on the database server, I would do:

      $ db2 connect to dbname

      Database Connection Information

      Database server = DB2/LINUXX8664 9.7.4
      SQL authorization ID = DB2INST1
      Local database alias = DBNAME

      $ db2 “describe table schema.USERS”

      Data type Column
      Column name schema Data type name Length Scale Nulls
      ——————————- ——— ——————- ———- —– ——
      USERS_ID SYSIBM BIGINT 8 0 No
      DN SYSIBM VARCHAR 1000 0 Yes
      REGISTERTYPE SYSIBM CHARACTER 4 0 No
      PROFILETYPE SYSIBM CHARACTER 2 0 Yes
      LANGUAGE_ID SYSIBM INTEGER 4 0 Yes
      FIELD1 SYSIBM VARCHAR 254 0 Yes
      SETCCURR SYSIBM CHARACTER 3 0 Yes
      FIELD3 SYSIBM VARCHAR 254 0 Yes
      FIELD2 SYSIBM VARCHAR 254 0 Yes
      LASTORDER SYSIBM TIMESTAMP 10 6 Yes
      REGISTRATION SYSIBM TIMESTAMP 10 6 Yes
      LASTSESSION SYSIBM TIMESTAMP 10 6 Yes
      REGISTRATIONUPDATE SYSIBM TIMESTAMP 10 6 Yes
      REGISTRATIONCANCEL SYSIBM TIMESTAMP 10 6 Yes
      PREVLASTSESSION SYSIBM TIMESTAMP 10 6 Yes
      OPTCOUNTER SYSIBM SMALLINT 2 0 Yes
      PERSONALIZATIONID SYSIBM VARCHAR 30 0 Yes

      17 record(s) selected.

      $

  5. rohit says:

    In which table do we maintain the relationship between userId and particular storeId, if we have more than one store id???

    • Ember Crooks says:

      I think a member/user can exist across multiple stores. MBRATTRVAL can co-relate a user with a store id for specific member attributes, anyway.

      • rohit says:

        no “member/user can exist across multiple stores” if you create an account in one of the store it will not be available in other store, try it!!!!

        • Ember Crooks says:

          Always welcome corrections from others. The one site I’ve got that uses multiple stores that I support on an ongoing basis also puts store-based prefixes (several upper case letters followed by a |) in front of the users’ logon ids in userreg. I’m not sure if that’s a hack or a normal practice – I’m not on the dev side of things.

          • Raghavan says:

            By default, there is a unique index on LOGONID field in USERS table. This means logonid is unique across stores. If there is a business requirement to localize logonid to a store, developers use hacks such as logonidStoreID, which is a bad approach in my view.. They end up doing unnecessary customization elsewhere to substriing logonid…

          • Ember Crooks says:

            Yes, I’ve seen that too – using a prefix to logonid. Logonid is in the USERREG table.

          • Michael Stack says:

            so I realize I am a bit late to the party, but if the developer hacks mentioned below aren’t the recommended approach, what is the recommended approach for managing requirements that customers be able to re-use login credentials across stores?

          • Ember Crooks says:

            What a wonderful question to ask IBM!

  6. baig says:

    This is really very useful information.Can you please provide the different OOB commands which wil be used in ordering flow

  7. Sudha says:

    Nice work 🙂

  8. Sudha says:

    Nice work

  9. Al says:

    How do you usually troubleshoot dbclean as it is not completing successfully?
    I was running dbclean -object catentry -type without-orderitems -insatncexml path..

    Thanks!
    Al

    • Ember Crooks says:

      I do regular audits on my supported databases to ensure dbclean is not failing in some silent way. I take the same SQL that is in the CLEANCONF table, and turn it into a select count statement to ensure that the results are generally low. If I suspect a problem, I also review the dbclean logs.

  1. December 12, 2011

    […] talked about 10 Commerce Tables You Should Be Familiar With, and about making alterations to Commerce objects, and about general observations about Commerce […]

  2. June 5, 2012

    […] of my most popular posts that’s specific to WebSphere Commerce is The 10 Commerce Tables You Should Be Familiar With. This is an updated version of that post, since the preferred method of dealing with attributes has […]

Leave a Reply

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