This topic describes changes in Release 9.3 to the following:
- Installation Folders
- Property Files
- Database Tables
Changes to installation folders in Release 9.3
In
Release 9.3 there are no changes made to the installation folders.
Changes to property files in Release 9.3
No
properties are removed or modified in Release 9.3.
In Release 9.3, the following properties were added:
- <enterprise_code>.PromisingServerUpgradeDateTime=yyyy-MM-ddTHH:mm:ss
- yfs.scwc.sdf.integration.providerurl=corbaloc:iiop:server:port
- yfs.scwc.sdf.integration.apis.export.qcf=AGENT_QCF
- yfs.scwc.sdf.integration.apis.import.qcf=AGENT_QCF
- yfs.scwc.sdf.integration.apis.import.queue=FVT.INBOUND
- yfs.scwc.sdf.integration.apis.createorderonsuccess.event.queue=<Queue
Name>
- yfs.scwc.sdf.integration.apis.sendinventorychanges.event.queue<Queue
Name>
- yfs.scwc.sdf.sendinventorychanges.service.url=http://WC_HOSTNAME:8007/webapp/wcs/component/inventory/services/InventoryServices
- yfs.scwc.sdf.sendorderchanges.service.url=http://WC_HOSTNAME:8007/webapp/wcs/component/order/services/OrderServices
- yfs.scwc.sdf.getOrderPrice.service.url=http://WC_HOSTNAME:8007/webapp/wcs/component/order/services/OrderServices
- yfs.scwc.sdf.getItemPrice.service.url=http://WC_HOSTNAME:8007/webapp/wcs/component/price/services/PriceServices
- yfs.scwc.sdf.validateCoupon.service.url=http://WC_HOSTNAME:8007/webapp/wcs/component/promotion/services/PromotionServices
- yfs.scwc.sdf.wc.user=user yfs.scwc.sdf.wc.password=password
- yfs.scwc.sdf.integration.user=WCIntegrationUser
- yfs.scwc.sdf.integration.password=WCIntegrationUser
- yfs.scwc.value.mapping.file=/file_path/ValueMaps.xml
- scwc.server.read.timeout
- scwc.server.connection.timeout
- yfs.enableedgedeployment
- yfs.edgedeployment.id
- yif.apifactory.edgedeployment.protocol
- endpoint.MOTHERSHIP.yif.apifactory.protocol
- endpoint.MOTHERSHIP.yif.httpapi.url
- yfs.api.edgedeployment.<api name>.endpoint
- yfs.api.edgedeployment.<api name>.autoignoreerrorlist
- yfs.api.edgedeployment.autoignoreerrorlist
Locating database table changes due to migration to
Release 9.3
During the upgrade process, several tables and
the data in them may be modified. This section provides information
about the steps to be taken to locate the tables that have incurred
changes.
You can perform the following types of database updates:
- Shard Migration
- Factory Setup Migration
- Custom Data Migration
Shard migration
During
shard migration, alter scripts are generated by comparing the entity
XML files that were shipped with the previous release with the entity
XML files available with the upgrade version.
Run initupgrade to
review the contents of the following directories (including subdirectories)
and files for a list of tables that have been modified during shard
migration:
If you are using Oracle, review the following directories
(including subdirectories) and files:
- <INSTALL_DIR>/Migration/9.2.1/database/scripts/oracle/history
- <INSTALL_DIR>/Migration/9.2.1/database/scripts/oracle/transaction
- <INSTALL_DIR>/Migration/9.2.1/database/scripts/oracle/textsearch
- SQL queries in the "ORACLE_Query" nodes of <INSTALL_DIR>/Migration/9.2.1/transaction/DropColumnOverride.xml
- SQL queries in the "ORACLE_Query" nodes of <INSTALL_DIR>/Migration/9.2.1/history/DropColumnOverride.xml
- <INSTALL_DIR>/Migration/9.2.1/pre-migration-oracle.sql
If you are using DB2®, review the following directories (including
subdirectories) and files:
- <INSTALL_DIR>/Migration/9.2.1/database/scripts/db2/history
- <INSTALL_DIR>/Migration/9.2.1/database/scripts/db2/transaction
- <INSTALL_DIR>/Migration/9.2.1/database/scripts/db2/textsearch
- SQL queries in the "DB2_Query" nodes of <INSTALL_DIR>/Migration/9.2.1/transaction/DropColumnOverride.xml
- SQL queries in the "DB2_Query" nodes of <INSTALL_DIR>/Migration/9.2.1/history/DropColumnOverride.xml
- <INSTALL_DIR>/Migration/9.2.1/pre-migration-db2.sql
Note: If you are performing an upgrade in sharded mode, the directories
listed above contain subdirectories that are defined by tabletype.
Note: These directories will not be created until after the initupgrade
step is completed. These directories will not be created until after
the initupgrade step is completed.
Factory setup migration
For
a list of tables in which factory setup data is being changed, refer
to the following directories:
For tables with additional factory
setup data:
<INSTALL_DIR>/Migration/<version upgrading from>/database/
FactorySetup/XMLs/added
For tables with changed factory
setup data:
<INSTALL_DIR>/Migration/<version upgrading from>/database/
FactorySetup/XMLs/changed
Note: The name of each file in
these directories corresponds to the name of the table that is being
updated, for example, the YCP_YFS_EVENT.xml file corresponds to the
YFS_EVENT table.If you are performing a multihop upgrade, ensure that
you check these directories in each version that is upgraded. For
example, if you are upgrading from Release 8.5 to Release 9.2 and
you want to check the tables with changed factory setup data, refer
to the following directories:
<INSTALL_DIR>/Migration/8.5/database/FactorySetup/XMLs/changed
<INSTALL_DIR>/Migration/9.0/database/FactorySetup/XMLs/changed
<INSTALL_DIR>/Migration/9.1/database/FactorySetup/XMLs/changed
To
locate the files pertaining to IBM Sterling Business Center in these
directories, SBC is added automatically as a prefix to the file names,
for example, SBC_YFS_MENU.xml.
Custom data migration
For
a list of tables that have been changed during the custom data migration
process using SQL updates, refer to the "Important Behavior Changes"
section of the release that is relevant to your upgrade. This section
provides you the following information:
- Changes that have taken place during the migration
- Locations of the SQL scripts that have been run or the tables
affected