Direct links to fixes
8.5.1-TIV-TDWC-WINDOWS-X86-64-FP0006
8.5.1-TIV-TDWC-WINDOWS-FP0006
8.5.1-TIV-TDWC-LINUXS390-FP0006
8.5.1-TIV-TDWC-LINUX-I386-FP0006
8.5.1-TIV-TDWC-LINUX-X86-64-FP0006
8.5.1-TIV-TDWC-LINUXPPC-FP0006
8.5.1-TIV-TDWC-SOLARIS-FP0006
8.5.1-TIV-TDWC-AIX-FP0006
8.5.1-TIV-TDWC-SOLARIS-I386-FP0006
8.5.1-TIV-TDWC-HPUX-FP0006
8.5.1-TIV-TDWC-HPUXIA64-FP0006
8.5.1-TIV-TWS-AIX-FP0006.TAR
8.5.1-TIV-TWS-HPIA64-FP0006.TAR
8.5.1-TIV-TWS-HPUX-FP0006.TAR
8.5.1-TIV-TWS-LINUX_I386-FP0006.TAR
8.5.1-TIV-TWS-LINUX_PPC-FP0006.TAR
8.5.1-TIV-TWS-LINUX_S390-FP0006.TAR
8.5.1-TIV-TWS-LINUX_X86_64-FP0006.TAR
8.5.1-TIV-TWS-SOLARIS_I386-FP0006.TAR
8.5.1-TIV-TWS-SOLARIS-FP0006.TAR
8.5.1-TIV-TWS-WIN_X86_64-FP0006
8.5.1-TIV-TWS-WIN-FP0006
APAR status
Closed as documentation error.
Error description
The documented procedure to switch TWS's database vendor from DB2 to Oracle is missing information that causes the Dynamic Workload Broker application to fail to start. Following the procedure results in missing DWB tables in Oracle. Also, the configuration file <TWA dir>/TDWB/config/DAOCommonProperties is not updated with the oracle specifics. Repeat connection attempts exhausts the maxConnections parameter for the datasource and results in thread hangs that make the WebSphere instance unusable.
Local fix
Use the documented procedure "Creating or upgrading the database tables if you are using Oracle" to create the correct set of tables. Also, manually update the file <TWA dir>/TDWB/config/DAOCommonProperties so that rdbmsName=oracle rather than db2 and all three *Schema= values are set to the oracle schema name for the TWS database.
Problem summary
The documentaion does not write accurately that also the TWS Broker schema must be migrated, and the update of the DAOCommon.properties file See LOCAL FIX for further details.
Problem conclusion
The TWS manuals will be changed to correctly fix the issue in the next Info ceter update for 8.6, 9.1, 9.2 and 9.3
Temporary fix
Comments
APAR Information
APAR number
IV78318
Reported component name
TIV WKLD SCHDL
Reported component ID
5698WKB86
Reported release
8L6
Status
CLOSED DOC
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2015-10-23
Closed date
2016-01-14
Last modified date
2016-01-14
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
Document Information
Modified date:
14 January 2016