Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Appendix A Command Reference : -createTables

-createTables
Synopsis
bcappmanage -createTables
Description
This command is used to create audit, runtime, and non-repudiation schemas in database accounts that are different from the ones in the TIBCO BusinessConnect configuration store. This is accomplished by specifying the category (audit/non-repudiation/runtime) as well as the JDBC connection parameters for TIBCO BusinessConnect configuration store.
This task is optional and is not needed when the audit, non-repudiation, and runtime data will be stored in the database account that is the same as the account of the configuration store.
Options
-category [ audit | nr | runtime ]
Table category to drop and recreate.
{ -jdbcURL [<props_file_url> | <jdbc_url>] }
Optional URL to a property file specifying database tables connection parameters or a standard JDBC URL.
If specifying a property file url the syntax is file://<file location>; for example, file://c:/temp/audit.properties.
(default=file://./commonConfig.properties)
{ -jdbcUser <user> -jdbcPw <password> }
Optional database tables connection user and password. It must be specified if the JDBC URL parameter is a JDBC URL, or if they are not specified in the connection properties file.
{ -configRepoURL [<props_file_url> | <jdbc_url>] }
Optional URL to property file specifying configuration repository connection parameters or a standard JDBC URL
If specifying a property file URL, the syntax is file://<file location>; for example, file://c:/temp/config.properties.
(default=file://./commonConfig.properties)
{ -configRepoUser <user> -configRepoPw <password> }
Optional configuration repository user and password. It must be specified if the configRepoURL parameter is a JDBC URL, or if they are not specified in the connection properties file
{ -overwrite }
Optional flag to enable overwriting if the database account has existing audit, non-repudiation, or runtime data. By default existing data is not overwritten.
Examples
bcappmanage -createTables -category audit -configRepoURL file://c:/temp/config.properties -jdbcURL file://c:/temp/audit.properties
Dependencies
-createInstallation

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved