fileprop utility

The fileprop utility sends all new and changed files to the administration node of the federated WebSphere Application Server environment, which later pushes them into the managed nodes, which include the production server. The staging server must be federated using the same deployment manager as the production server. Otherwise, the managed files are not propagated into the production EAR because the deployment manager is not aware of the production node.

The fileprop utility determines whether the environment is federated or not. If the environment is federated, it propagates the files to the production server. However, if the environment is not federated, fileprop puts the names of new and changed files into the log file, and instructs you to manually copy the files from the staging server to the production server. The fileprop utility assumes that the manual copy is carried out, and will not handle those files the next time the utility is called.

The function of the fileprop utility can be performed by the stagingprop utility if you specify the required parameters. The stagingprop utility publishes production-ready data then publishes managed files. If you only want to publish managed files to the production server, use the fileprop utility.

The fileprop utility runs as a single transaction and is committed only after propagation is successful. If the propagation fails, the transaction rolls back returning your production database to the state before the fileprop utility began.

To run the fileprop utility, issue the following command from a command line on a system that can connect to both the staging or authoring server database and the production server database.

fileprop utility syntax diagram

For IBM i OS operating systemTo run shell scripts:
  1. Log on as a user profile that has a CCSID other than 65535.
  2. Start a Qshell session.
  3. The utility format is:
    • WC_installdir/bin/stagingProp.sh (parameters...)
    Note: The user parameters must always be specified.

Utility command

The fileprop utility has the following file name:

  • For IBM i OS operating systemSolarisLinuxAIXfileprop.sh
  • Windowsfileprop.bat

Parameter values

All parameters are required unless indicated.

dbtype
  • SolarisDB2LinuxAIXWindowsOptional: Specify DB2. This value is the default database type and you can omit the dbtype parameter from the command.
  • For IBM i OS operating systemDB2Required: Specify one of the following values:
    DB2/OS400
    Specify DB2/OS400 when you use the Native JDBC driver.
    DB2/OS400ToolBox
    Specify DB2/OS400ToolBox when you use the IBM Toolbox for Java JDBC driver.
  • OracleRequired: Specify Oracle.
sourcedb
Required: The name of the database on the staging server. For IBM i OS operating system
  • If the dbtype parameter is DB2/OS400, specify the name of the database on the staging server, as displayed in the relational database directory.
  • If the dbtype parameter is DB2/OS400ToolBox, specify the host name of the server on which the production-ready data resides.
DB2Note: For DB2 UDB databases, the DB2 Type 4 JDBC driver is used, where the Type 4 database name is prefixed with the database server and port. For example, db_server:db_port/db_name.
Deprecated featureThe Type 2 database name is deprecated, where the database names do not contain a prefix. For more information, see:
sourcedb_user
Required: The logon ID of the database administrator who created the source database schema. If not specified, the ID of the user currently invoking the utility is used.

For IBM i OS operating system The user profile that is associated with the commerce instance. This profile is the same as the source database schema.

sourcedb_passwd
Required: The password of the logon ID that is specified by the sourcedb_user parameter.
destdb
Required: The name of the database on the production server. For IBM i OS operating system
  • If the dbtype parameter is DB2/OS400, specify the name of the database on the production server, as displayed in the relational database directory.
  • If the dbtype parameter is DB2/OS400ToolBox, specify the host name of the server on which the production database resides.
destdb_user
Required: The logon ID of the database administrator who created the production database schema. If not specified, the ID of the user that starts the utility is used. This parameter is mandatory when you use a remote database.

For IBM i OS operating system The user profile that is associated with the commerce instance. This profile is the same as the production database schema.

destdb_passwd
Required: The password of the logon ID that is specified by the destdb_user parameter. If not specified, the system prompts you to enter the password. This parameter is mandatory when you use a remote database.
destdb_locktimeout
Optional: Specifies the number of seconds the fileprop utility connection to the production database waits to obtain a lock on the database it is updating. If the fileprop utility cannot obtain a lock within the specified number of seconds, the database transaction is rolled back.
wsadmin_user
Optional: A WebSphere Application Server administrative user ID.

This parameter is required if WebSphere Application Server global security is enabled. For more information, see the Administrative security topic.

wsadmin_passwd
Optional: The password for the user ID specified by the wsadmin_user parameter.

This parameter is required if WebSphere Application Server global security is enabled. For more information, see the Administrative security topic.

waspath
The full path to the location of the WebSphere Commerce profile. This path is used to locate the wsadmin.sh or wsadmin.bat file on staging WebSphere Commerce EnterpriseWebSphere Commerce Professionalor authoring server.
profilename
The name of the WebSphere Application Server profile on the staging server that contains WebSphere Commerce. By default, the profile name is the same as the WebSphere Commerce instance name. Ensure that the staging server and the production server are in the same federated environment.
appname
The value of the enterprise archive (EAR) that you are propagating files within on the production server. For instance, the WebSphere Commerce EAR.
Feature Pack 7 or laterNote: If the store web archive (WAR) for your site is separated from the WebSphere Commerce enterprise archive (EAR), set the parameter value to be the store EAR. By default the value of this parameter for a separated store EAR is WCStores_instanceName.ear. When the fileprop utility runs, the value of the appname parameter must be correctly passed in before the utility can call the WebSphere Application Server wcsadmin command.
modulename
The name of the application module to which managed files are copied. This name is typically Stores.war.
log
The path and name of the file in which the fileprop utility records its activities and errors. The timestamp is appended to the file name, for example, myLog_ yyyy.mm.dd_hh.mm.ss.zzz.log. If this parameter is not specified, a log file that is called fileprop_ yyyy.mm.dd_hh.mm.ss.zzz.log is created in the following log directory.
  • SolarisLinuxAIXWC_installdir/logs
  • For IBM i OS operating systemWC_userdir/instances
  • WindowsWC_installdir\logs
paramfile
Optional. Specifies the path to the parameter file that includes command-line arguments and values. Each argument and value needs to be in the format argument=value with a single argument and value on each line in the file. Any passwords within this parameter file must be encrypted.