E
dit
A
ttach
P
rintable
r5 - 2017-12-11 - 20:03:01 - Main.ktessier
You are here:
TWiki
>
Deployment Web
>
DeploymentInstallingUpgradingAndMigrating
>
IBMQuickDeployer
>
IBMQuickDeployerSetupAndRun
>
IBMQuickDeployerChangeDefaultSQLServerParameters
<div id="header-title" style="padding: 10px 15px; border-width:1px; border-style:solid; border-color:#FFD28C; background-image: url(<nop>https://jazz.net/wiki/pub/Deployment/WebPreferences/TLASE.jpg); background-size: cover; font-size:120%"> ---+!! IBM Quick Deployer change default SQL Server database parameters <img src="https://jazz.net/wiki/pub/Deployment/WebPreferences/updated.png" alt="updated.png" width="50" height="50" align="right"> %DKGRAY% %INCLUDE{"IBMQuickDeployerInsertAuthorBuildBasis"}% %ENDCOLOR%</div></sticky> <!-- Page contents top of page on right hand side in box --> <sticky><div style="float:right; border-width:1px; border-style:solid; border-color:#DFDFDF; background-color:#F6F6F6; margin:0 0 15px 15px; padding: 0 15px 0 15px;"> %TOC{title="Page contents"}% </div></sticky> <sticky><div style="margin:15px;"></sticky> The values contained in the default database parameters are used to configure the connections between the installed CLM applications and their individual databases. If you are going to use the Quick Deployer-installed SQL Server database then there is no need to change them prior to running the UCD application *Install Applications* process. However, you should have your database administrator review the configuration to make sure it conforms to internal security and reliability policies. <br/><br/> If you are going to use an existing SQL Server database instance then you need to ensure that the default database parameters are updated to match the configuration used by your database instance. To do this follow the instructions in this topic. ---++Change default database parameters 1. Open application *Rational_QD_60x*, click *Environments*, then click the *Request Process* icon for the target environment. <br/><br/><img src="%ATTACHURLPATH%/change-db-parametersV20.png" alt="run process"><br/><br/> 1. In the Process field, select *Change Default SQLServer Parameters*. <br/><br/><img src="%ATTACHURLPATH%/change-sqlserver-parameters.png" alt="change parameters"><br/><br/> 1. If you fixed the component versions on the process you will not be prompted to choose versions. If offered to choose the component versions, then select Latest Available. <br/><br/><img src="%ATTACHURLPATH%/CDDP2V20.png" alt="choose version"><br/><br/> 1. Modify the process property default values to match your database. <br/><br/> The SQL Server databases are created using this command *CREATE DATABASE ${app}DBName GO* which is populated using these property values: <br/><br/> For example: *CREATE DATABASE $jtsDBName GO*. <br/><br/> The SQL Server user and password are created and change the ownership of the database by using this command *CREATE LOGIN ${app}DBuser WITH PASSWORD = '${app}DBpswd'; USE ${app}DBName; exec sp_changedbowner '${app}DBuser' GO*. <br/><br/> For example: *CREATE LOGIN $jtsDBuser WITH PASSWORD = '$jtsDBpswd'; USE $jtsDBName; exec sp_changedbowner '$jtsDBuser' GO* <br/><br/> The SQL Server collation is changed using this command *ALTER DATABASE ${app}DBName COLLATE $sqlserverCollation GO*. <br/><br/> For example: *ALTER DATABASE $jtsDBName COLLATE $sqlserverCollation GO* <br/><br/> The SQL Server row version system for the JTS, CCM, QM, RM, DCC, LQE, LDX, !RELM, DM, GC, and DW databases is changed by using this command *ALTER DATABASE ${app}DBName SET READ_COMMITTED_SNAPSHOT ON GO*. <br/><br/> For example: *ALTER DATABASE $jtsDBName SET READ_COMMITTED_SNAPSHOT ON GO*. <br/><br/> The properties are as follows: * *sqlserverInstanceName* : SQLServer instance name <br/> Default: "CLMINST" * *sqlserverCollation* : SQL Collation. CLM databases require case-sensitivity, and the default for SQL Server is case-insensitive collation. Note that SQL_Latin1_General_CP437_CS_AS is an example; any CS_AS collation can be used. <br/> Default : SQL_Latin1_General_CP437_CS_AS * *jtsDBName* : name of the jts database <br/> Default: "jts" * *jtsDBuser* : jts user name <br/> Default : jtsDBuser * *ccmDBName* : name of the ccm database <br/> Default: "ccm" * *ccmDBuser* : ccm user name <br/> Default : ccmDBuser * *qmDBName* : name of the qm database <br/> Default: "qm" * *qmDBuser* : qm user name <br/> Default : qmDBuser * *rmDBName* : name of the rm database <br/> Default : rm * *rmDBuser* : rm user name <br/> Default: "rmDBuser" * *dccDBName* : name of the dcc database <br/> Default : dcc * *dccDBuser* : dcc user name <br/> Default: "dccDBuser" * *lqeDBName* : name of the lqe database <br/> Default : lqe * *lqeDBuser* : lqe user name <br/> Default: "lqeDBuser" * *ldxDBName* : name of the ldx database <br/> Default : ldx * *ldxDBuser* : ldx user name <br/> Default: "ldxDBuser" * *lqeDBName* : name of the lqe database <br/> Default : lqeDB * *relmDBName* : name of the relm database <br/> Default on: "relm" * *relmDBuser* : relm user name <br/> Default : relmDBuser * *dmDBName* : name of the dm database <br/> Default on: "dm" * *dmDBuser* : dm user name <br/> Default : dmDBuser * *gcDBName* : name of the gc database <br/> Default : gc * *gcDBuser* : gc user name <br/> Default : gcDBuser * *dwDBName* : name of the datawarehouse database <br/> Default : dw * *dwDBuser* : datawarehouse user name <br/> Default : dwDBuser * *sqlserverPort* : database connection port <br/> Default : 1433 * *amDBName* : name of the am database <br/> Default : am * *amDBuser* : am user name <br/> Default : amDBuser <br/><br/> 1. Click on *Submit* and wait for the process to run to completion <br/><br/><img src="%ATTACHURLPATH%/CDDP3V20.png" alt="wait for completion"><br/><br/> %INCLUDE{"IBMQuickDeployerInsertMiscellaneous"}% <sticky></div></sticky>
E
dit
|
A
ttach
|
P
rintable
|
V
iew topic
|
Backlinks:
We
b
,
A
l
l Webs
|
H
istory
: r5
<
r4
<
r3
<
r2
<
r1
|
M
ore topic actions
Deployment
Deployment web
Planning and design
Installing and upgrading
Migrating and evolving
Integrating
Administering
Monitoring
Troubleshooting
Community information and contribution guidelines
Create new topic
Topic list
Search
Advanced search
Notify
RSS
Atom
Changes
Statistics
Web preferences
NOTE: Please use the Sandbox web for testing
Status icon key:
To do
Under construction
New
Updated
Constant change
None - stable page
Smaller versions of status icons for inline text:
Copyright © by IBM and non-IBM contributing authors. All material on this collaboration platform is the property of the contributing authors.
Contributions are governed by our
Terms of Use.
Please read the following
disclaimer
.
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more
here
.