HCL Workload Automation, Version 9.4

Changing data source properties

You run the changeDataSourceProperties script on the master domain manager to change the data source properties of the RDBMS in use with the master domain manager. You are required to update the data source properties in the following cases:
  • You migrate your data from an Oracle database to DB2® using the reconfiguration method.
  • You change the database name, server, host, or port.
  • You change the path to the JDBC driver of the RDBMS.
The procedure for running the script is described in detail in Application server - using the utilities that change the properties, but in summary you do the following:
  • Run showDataSourceProperties.sh (.bat) > my_file_name to obtain the current properties
  • Edit my_file_name
  • Run changeDataSourceProperties.sh (.bat) my_file_name
Note: my_file_name must be the fully qualified path of the file.

The change utility calls the wsadmin utility by running ChangeDataSourceProperties.jacl with the properties file as input.

Only the WebSphere® Application Server resources.xml are affected by this script. The full path of the file is: 
<WAS_profile_path>/config/cells/TWSNodeCell/nodes/
  TWSNode/servers/server1/resources.xml
where the default value for <WAS_profile_path> is <TWA_home>/WAS/TWSprofile.
The following example shows the properties that can be changed with this utility. Only some of the options listed are currently in use by HCL Workload Automation. 
################################################################
JDBC Path Variables
################################################################
ORACLE_JDBC_DRIVER_PATH=
DB2_JDBC_DRIVER_PATH=c:/hcl/sqllib/java
DB2UNIVERSAL_JDBC_DRIVER_PATH=c:/hcl/sqllib/java


################################################################
DB2 Type2 Resource Properties
################################################################
DB2Type2JndiName=
DB2Type2Description=
DB2Type2ConnectionAttribute=cursorhold=0
DB2Type2EnableMultithreadedAccessDetection=false
DB2Type2Reauthentication=false
DB2Type2JmsOnePhaseOptimization=false
DB2Type2DatabaseName=TWSZ_DB
DB2Type2PreTestSQLString=SELECT 1 FROM SYSIBM.SYSDUMMY1


################################################################
DB2 Type4 Resource Properties
################################################################
DB2Type4JndiName=jdbc/twsdb
DB2Type4DatabaseName=TWSZ
DB2Type4DriverType=4
DB2Type4ServerName=myhost.mydomain.com
DB2Type4PortNumber=50000
DB2Type4SslConnection=false
DB2Type4Description=
DB2Type4TraceLevel=
DB2Type4TraceFile=
DB2Type4FullyMaterializeLobData=true
DB2Type4ResultSetHoldability=2
DB2Type4CurrentPackageSet=
DB2Type4ReadOnly=false
DB2Type4DeferPrepares=true
DB2Type4CurrentSchema=
DB2Type4CliSchema=
DB2Type4RetrieveMessagesFromServerOnGetMessage=true
DB2Type4ClientAccountingInformation=
DB2Type4ClientApplicationInformation=
DB2Type4ClientUser=
DB2Type4ClientWorkstation=
DB2Type4CurrentPackagePath=
DB2Type4CurrentSQLID=
DB2Type4KerberosServerPrincipal=
DB2Type4LoginTimeout=0
DB2Type4SecurityMechanism=
DB2Type4TraceFileAppend=false
DB2Type4CurrentFunctionPath=
DB2Type4CursorSensitivity=
DB2Type4KeepDynamic=
DB2Type4CurrentLockTimeout=
DB2Type4EnableMultithreadedAccessDetection=false
DB2Type4Reauthentication=false
DB2Type4JmsOnePhaseOptimization=false
DB2Type4PreTestSQLString=SELECT 1 FROM SYSIBM.SYSDUMMY1
DB2Type4DbFailOverEnabled=false
DB2Type4ConnRetriesDuringDBFailover=100
DB2Type4ConnRetryIntervalDuringDBFailover=3000
# DB2Type4IsolationLevel can be one of the following: 
#       CURSOR_STABILITY or READ_STABILITY
DB2Type4IsolationLevel=CURSOR_STABILITY


################################################################
Oracle Type2 Resource Properties
################################################################
OracleType2JndiName=
OracleType2DriverType=
OracleType2URL=jdbc:oracle:oci:@ORCL
OracleType2DatabaseName=
OracleType2ServerName=
OracleType2PortNumber=1521
OracleType2OracleLogFileSizeLimit=0
OracleType2OracleLogFileCount=1
OracleType2OracleLogFileName=
OracleType2OracleLogTraceLevel=INFO
OracleType2OracleLogFormat=SimpleFormat
OracleType2OracleLogPackageName=oracle.jdbc.driver
OracleType2TNSEntryName=
OracleType2NetworkProtocol=
OracleType2DataSourceName=
OracleType2LoginTimeout=
OracleType2Description=
OracleType2EnableMultithreadedAccessDetection=false
OracleType2Reauthentication=false
OracleType2JmsOnePhaseOptimization=false
OracleType2PreTestSQLString=SELECT 1 FROM DUAL
OracleType2DbFailOverEnabled=false
OracleType2ConnRetriesDuringDBFailover=100
OracleType2ConnRetryIntervalDuringDBFailover=3000


################################################################
Oracle Type4 Resource Properties
################################################################
OracleType4JndiName=
OracleType4DriverType=
OracleType4URL=jdbc:oracle:thin:@//localhost:1521/ORCL
OracleType4DatabaseName=
OracleType4ServerName=
OracleType4PortNumber=1521
OracleType4OracleLogFileSizeLimit=0
OracleType4OracleLogFileCount=1
OracleType4OracleLogFileName=
OracleType4OracleLogTraceLevel=INFO
OracleType4OracleLogFormat=SimpleFormat
OracleType4OracleLogPackageName=oracle.jdbc.driver
OracleType4TNSEntryName=
OracleType4NetworkProtocol=
OracleType4DataSourceName=
OracleType4LoginTimeout=
OracleType4Description=
OracleType4EnableMultithreadedAccessDetection=false
OracleType4Reauthentication=false
OracleType4JmsOnePhaseOptimization=false
OracleType4PreTestSQLString=SELECT 1 FROM DUAL
OracleType4DbFailOverEnabled=false
OracleType4ConnRetriesDuringDBFailover=100
OracleType4ConnRetryIntervalDuringDBFailover=3000
When you change data source properties, observe the following rules:
  • If a property is not provided in the properties file, the current value is not changed
  • If a property is provided with a non-blank value, the current value is updated.
  • If a property is provided with a blank value, the setting is set to blank if the property is classified as erasable or left unchanged if not.
  • Always use type 4 data sources for DB2 and type 2 data sources for Oracle.
  • Set the appropriate JDBC driver path variable for the RDBMS of your choice.
    • For DB2, the JDBC driver is located in the java subfolder of the sqllib directory. For example: 
      DB2_JDBC_DRIVER_PATH=c:/program files/hcl/sqllib/java
      or 
      DB2UNIVERSAL_JDBC_DRIVER_PATH=c:/program files/hcl/sqllib/java
    • For Oracle, it is located in the jdbc/lib subfolder of the Oracle home directory. For example: 
      ORACLE_JDBC_DRIVER_PATH=C:/Oracle/product/10.2.0/db_1/jdbc/lib
  • Make sure that the data source JNDI name is always set to jdbc/twsdb in the ...JndiName property of the RDBMS you use. If you change the RDBMS, proceed as follows:
    1. Reset to a name of your choice the ...JndiName property of the RDBMS from which you are changing.
    2. Set to jdbc/twsdb the ...JndiName property of the new RDBMS.
  • See that the following properties are set:
    • For DB2: 
      DB2Type4JndiName
DB2Type4DatabaseName
DB2Type4ServerName
DB2Type4PortNumber
    • For Oracle: 
      OracleType2JndiName
OracleType2DatabaseName
OracleType2ServerName
OracleType2PortNumber