Support Article
Passing DB username and password to script for deployment
SA-19872
Summary
User require a script-based deployment in a Unix enviroment (Webphere + DB2 + linux). The db username and password must be passed as parameters. They are currently explicitly defined in prpcUtils.properties which is not required.
Error Messages
Not Applicable.
Steps to Reproduce
Not Applicable.
Root Cause
Not Applicable
Resolution
The prpcUtils.bat has the following usage:
usage:
prpcUtils.bat ( export | exportRAP | import | expose | resave | runagent | runUpdateWizard | scanInvalidRules | manageHotfixes | javaSyntaxUpgrade | indexing | help ) [options...]
Options:
--driverClass Your JDBC driver class (example: oracle.jdbc.OracleDriver)
--driverJAR Location of your JDBC JAR file
--dbType Database vendor type ("mssql" for SQL Server, "udb" for DB/2 UDB, "oracledate" for Oracle)
--dbURL JDBC URL to db to be loaded
--dbUser Database username
--dbPassword Database password
--archivePath Full path to the archive to be imported or exported
--hfixAction If manageHotfixes is selected, sets the hotfix operation. Valid values are commit, rollback, generateDDL, install, and scan.
--udbSchema Sets the schema for UDB
--noFailOnError Set to true or false. When enabled, instances that fail to import are skipped and import continues instead of failing
--U PRPC User Name (Optional. But if provided, will be used only by exportRAP, resave, expose)
--P PRPC User Password (Optional. But if provided, will be used only by exportRAP, resave, expose)
--accessGroup AccessGroup in which the Rule-Declare-Index of the classes being exposed exists.(applicable for expose utility if --U or --P are not provided).
All "--" options are optional and will override options in the properties file
One can skip providing the DB user name and password in the prpcUtils.properties file and can be given as parameters in the command line.
Published February 20, 2016 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.