How to Install IBM Fix Pack for WAS 8.5.5.0 using command line

How to Install IBM Fix Pack for WAS 8.5.5.0 using command line

Purpose – To install IBM Fix Pack for WAS 8.5.5.0 to resolve issue related to APAR – PM85314

Pre-requisites

OS – Windows XP – SP2
WAS – Network deployment trial – 8.5.5.0

Issue – Exception:com.microsoft.sqlserver.jdbc.SQLServerException SourceId:com.ibm.ws.sib.msgstore.persistence.impl.DatasourceController.performFirstAction ProbeId:1:274:1.36 Reporter:com.ibm.ws.sib.msgstore.persistence.impl.DatasourceController@f527ffad
com.microsoft.sqlserver.jdbc.SQLServerException: Column, parameter, or variable #5: Cannot find data type DATETIME2

Procedure

Step1: Download the Fix Pack zip files from the below site.

Download fixpack
http://www-01.ibm.com/support/docview.wss?uid=swg1PM85314

8.5.5-WS-WAS-FP0000001-part1.zip
8.5.5-WS-WAS-FP0000001-part2.zip

The Fix packs can also be searched from the IBM Fix pack central

Step2: Extract the contents of the two zip files into single folder.

Extract Package
D:WebsphereWAS_8.5.5.1_FixPack_DownloadExtract

Step3: Check the Packages and Fixes currently installed on the system

List Installed packages
C:Program FilesIBMInstallation Managereclipsetools>imcl.exe listInstalledPackages
com.ibm.cic.agent_1.5.2000.20120223_0907
com.ibm.websphere.IBMJAVA.v70_7.0.5000.20131010_1516
com.ibm.websphere.NDTRIAL.v85_8.5.5000.20130514_1044
8.5.5.0-WS-WAS-IFPM88937_8.5.5000.20130520_1507
8.5.5.0-WS-WAS-IFPM89206_8.5.5000.20130528_1049
8.5.5.0-WS-WAS-IFPM89365_8.5.5000.20130528_1108
8.5.5.0-WS-WAS-IFPM90588_8.5.5000.20130607_0847
8.5.5.0-WS-WAS-IFPM93496_8.5.5000.20130723_1455
8.5.5.0-WS-WASND-AllOSExceptIBMi-IFPM79754_8.5.5000.20130711_1041
8.5.5.0-WS-WASND-AllOSExceptIBMi-IFPM90681_8.5.5000.20130613_0858
8.5.5.0-WS-WASND-IFPM86173_8.5.5000.20130521_1111
8.5.5.0-WS-WASND-IFPM87004_8.5.5000.20130520_1153
8.5.5.0-WS-WASProd-IFPM84622_8.5.5000.20130707_1755
8.5.5.0-WS-WASProd-IFPM87199_8.5.5000.20130724_1551
8.5.5.0-WS-WASProd-IFPM88003_8.5.5000.20130725_2206
8.5.5.0-WS-WASProd-IFPM88005_8.5.5000.20130725_2310
8.5.5.0-WS-WASProd-IFPM88633_8.5.5000.20130708_1843
8.5.5.0-WS-WASProd-IFPM90932_8.5.5000.20130614_1538
8.5.5.0-WS-WASProd-IFPM90949_8.5.5000.20130919_1136
8.5.5.0-WS-WASProd-IFPM91417_8.5.5000.20130904_0931
8.5.5.0-WS-WASProd-IFPM91501_8.5.5000.20130725_1136
8.5.5.0-WS-WASProd-IFPM93512_8.5.5000.20130811_1550
8.5.5.0-WS-WASProd-IFPM94922_8.5.5000.20130813_1219

Step4: List the Available Packages to be installed from the downloaded Fix pack

List Available packages
C:Program FilesIBMInstallation Managereclipsetools>imcl.exe listAvailablePackages
-repositories D:WebsphereWAS_8.5.5.1_FixPack_DownloadExtract
com.ibm.websphere.BASE.v85_8.5.5001.20131018_2242
com.ibm.websphere.BASETRIAL.v85_8.5.5001.20131018_2242
com.ibm.websphere.DEVELOPERS.v85_8.5.5001.20131018_2242
com.ibm.websphere.DEVELOPERSILAN.v85_8.5.5001.20131018_2242
com.ibm.websphere.EXPRESS.v85_8.5.5001.20131018_2242
com.ibm.websphere.EXPRESSTRIAL.v85_8.5.5001.20131018_2242
com.ibm.websphere.ND.v85_8.5.5001.20131018_2242
com.ibm.websphere.NDDMZ.v85_8.5.5001.20131018_2242
com.ibm.websphere.NDDMZTRIAL.v85_8.5.5001.20131018_2242
com.ibm.websphere.NDTRIAL.v85_8.5.5001.20131018_2242

Step5: Install the Package for Network deployment trial to update the Package from 8.5.5.0 to 8.5.5.1

Intall WAS ND Trial 8.5.5.1
C:Program FilesIBMInstallation Managereclipsetools>imcl.exe install com.ibm.websphere.NDTRIAL.v85_8.5.5001.20131018_2242 -repositories D:WebsphereWAS_8.5
.5.1_FixPack_DownloadExtract -installationDirectory D:WASInstallWAS -acceptLicense
Updated to com.ibm.websphere.NDTRIAL.v85_8.5.5001.20131018_2242 in the D:WASIns
tallWAS directory.
WARNING: One or more fixes will be uninstalled when IBM WebSphere Application Se
rver Network Deployment Trial is updated to 8.5.5.1. The update does not address
 issues that were resolved previously by the maintenance packages. The problems
might return if fixes for the following issues are not reapplied or have new fix
es applied to prevent the problems from returning.
        - PM79754 in the fix package 8.5.5.0-WS-WASND-AllOSExceptIBMi-IFPM79754.
        - PM91417 in the fix package 8.5.5.0-WS-WASProd-IFPM91417.
        - PM94922 in the fix package 8.5.5.0-WS-WASProd-IFPM94922.
        - PM94981 in the fix package 8.5.5.0-WS-WASProd-IFPM91417.

Step6: Verify the Updated Package

Verify Installed Package
C:Program FilesIBMInstallation Managereclipsetools>imcl.exe listInstalledPackages
com.ibm.cic.agent_1.5.2000.20120223_0907
com.ibm.websphere.IBMJAVA.v70_7.0.5000.20131010_1516
com.ibm.websphere.NDTRIAL.v85_8.5.5001.20131018_2242

Step7: Verify the version information for the installed WAS environment by starting the deployment manager

Verify versioninfo
D:WASInstallWASprofilesDmgr01bin>versionInfo.bat
WVER0010I: Copyright (c) IBM Corporation 2002, 2012; All rights reserved.
WVER0012I: VersionInfo reporter version 1.15.1.48, dated 2/8/12

--------------------------------------------------------------------------------

IBM WebSphere Product Installation Status Report
--------------------------------------------------------------------------------

Installed Product
--------------------------------------------------------------------------------

Name                  IBM WebSphere Application Server Network Deployment
Version               8.5.5.1
ID                    NDTRIAL
Build Level           cf011341.03
Build Date            10/18/13
Package               com.ibm.websphere.NDTRIAL.v85_8.5.5001.20131018_2242
Architecture          x86 (32 bit)
Installed Features    IBM 32-bit WebSphere SDK for Java
                      WebSphere Application Server Full Profile
                      EJBDeploy tool for pre-EJB 3.0 modules
                      Embeddable EJB container
                      Sample applications
                      Stand-alone thin clients and resource adapters

--------------------------------------------------------------------------------

Hope you enjoyed reading this article. Thank you.