If you see the following error after a fail load with the massload command:

SQL0668N Operation not allowed for reason code "1" on table "<table-name>".
SQLSTATE=57016

It means the table is in the Set Integrity Pending No Access state. The integrity of the table is not enforced and the content of the table may be invalid. An operation on a parent table or an underlying table that is not in the Set Integrity Pending No Access state may also receive this error if a dependent table is in the Set Integrity Pending No Access state.

Essentially the table is locked and not accessible to read or write. You can “unlock” the table by issuing the following commands.

From the command line:

db2 connect to wcdbname user user_id using password
db2 set integrity for table_name immediate checked

or issue

set integrity for table_name immediate checked

from control center.

If this does not work you can run the following command:

SET INTEGRITY FOR tablename CHECK, FOREIGN KEY, MATERIALIZED QUERY, STAGING, GENERATED COLUMN IMMEDIATE UNCHECKED;

Which should remove the invalid items from the table and “unlock” it.

Below is an example of how to export catalog data from WebSphere Commerce. You will need to change STOREID to the store id that holds the catalog data. You will need to change CATALOGID to the catalog ID you want to export. If you have sales catalogs you will need to provide those as well.

extract_catalog_filter.xml

Use the following command to extract the data:

massextract.cmd -dbname [DATABASE] -dbuser [DB2USER] -dbpwd [PASSWORD] -filter extract_catalog_filter.xml -outfile catalog.xml

To make certain items tax exempt in your store do this following.

1. Login to Accelerator
2. Click Store -> Change Tax
3. Choose Sales Tax
4. Enter NOTax in “New sales tax code” box and click add
5. Click Category Assignment, make sure the NOTax code does not have a check box
6. Click Merchandise
7. Find the product that should have no tax
8. Select this product
9. Click Actions -> Change on the menu
10. Choose Sales Tax
11. Select NOTax and click Add