Feature Pack 7 or later

Database connection validation results sample

The following sample log output details the information that is retrieved, tested, and validated by the database connection validation utility. This sample output is for a WebSphere Commerce production environment that runs on the Windows operating system with a DB2 database.

The following code is a snippet of a sample updatedb-instance_name.log file that is generated during a fix pack update. For instance, updatedb-demo.log. This sample log file includes database-related information that is used by the fix pack update process to update the WebSphere Commerce database schema.

   Buildfile: C:\WEBSPH~1\COMMER~1\components\Fixpack\xml\configureDatabaseFixpack.xml
   
   PropCheck:
   
   ApplyDBFixpack:
   
   GenerateANTProperties:
   
   setWorkspaceEnabledFlag:
   [echo] workspaceEnabled = true
   
   checkDbaUserForWorkspace:
   [echo] dbaName = db2admin
   [checkDBAPwd] user: db2admin
   [checkDBAPwd] jdbcDriver: com.ibm.db2.jcc.DB2Driver
   [checkDBAPwd] jdbcURL: jdbc:db2://localhost:50000/mall
   [WcsDbValidation]   
   [WcsDbValidation]   
   [WcsDbValidation] ***************************************************************
   [WcsDbValidation] Start time = 2013-06-05 17:16:39.657
   [WcsDbValidation] >>>>>>>>>> System <<<<<<<<<<
1[WcsDbValidation] OS information
   [WcsDbValidation]   OS name = Windows Server 2008
   [WcsDbValidation]   OS version = 6.1 build 7601 Service Pack 1
   [WcsDbValidation]   OS architecture = amd64
   [WcsDbValidation]   
2[WcsDbValidation] Java information
   [WcsDbValidation]   Java vendor = IBM Corporation
   [WcsDbValidation]   Java version = 1.6.0
   [WcsDbValidation]   Java specification version = 1.6
   [WcsDbValidation]   Java home = C:\WEBSPH~1\APPSER~1\java\jre
   [WcsDbValidation]   Java class version = 50.0
   [WcsDbValidation]   Classpath = "C:\WebSphere\AppServer\profiles\AppSrv01\properties;C:\WebSphere\AppServer\properties;C:\WebSphere\AppServer\lib\startup.jar;C:\WebSphere\AppServer\lib\bootstrap.jar;C:\WebSphere\AppServer/lib/lmproxy.jar;C:\WebSphere\AppServer/lib/urlprotocols.jar;C:\WebSphere\AppServer\java\lib\tools.jar;;C:\WEBSPH~1\APPSER~1\optionalLibraries\jython.jar"
   [WcsDbValidation]   
3[WcsDbValidation] User information
   [WcsDbValidation]   User name = Administrator
   [WcsDbValidation]   User home = C:\Users\Administrator
   [WcsDbValidation]   User directory = C:\WebSphere\CommerceServer70\bin
   [WcsDbValidation]   User language = en
   [WcsDbValidation]   User timezone = America/New_York
   [WcsDbValidation]   
4[WcsDbValidation] Memory information
   [WcsDbValidation]   Maximum heap allocation =       1.50 gigabytes
   [WcsDbValidation]   Current heap allocation =      36.07 megabytes
   [WcsDbValidation]   
5[WcsDbValidation] WebSphere Commerce information
   [WcsDbValidation]   wcUserInstallDir = C:\WEBSPH~1\COMMER~1
   [WcsDbValidation]     wcUserInstallDir is readable = true
   [WcsDbValidation]   instanceName = demo
   [WcsDbValidation]   instanceName directory = C:\WEBSPH~1\COMMER~1\instances\demo
   [WcsDbValidation]     instanceName directory is readable = true
   [WcsDbValidation]   loggerconfigfile = C:/WebSphere/CommerceServer70/instances/demo/xml/loader/WCALoggerConfig.xml
   [WcsDbValidation]     loggerconfigfile is readable = true
   [WcsDbValidation]   errordirectory = C:/WebSphere/CommerceServer70/instances/demo/logs
   [WcsDbValidation]     errordirectory is readable = true
   [WcsDbValidation] >>>>>>>>>> System <<<<<<<<<<
   [WcsDbValidation]   
   [WcsDbValidation] Database validation start time = 2013-06-05 17:16:39.657
   [WcsDbValidation]   
   [WcsDbValidation] >>>>>>>>>> Database <<<<<<<<<<
6[WcsDbValidation] Input Parameters
   [WcsDbValidation]   dbType = db2
   [WcsDbValidation]   dbHostname missing.
   [WcsDbValidation]   dbName = mall
   [WcsDbValidation]   portnumber missing.
   [WcsDbValidation]   dbUserName = WCS
   [WcsDbValidation]   dbUserPassword = **************
   [WcsDbValidation]   dbaName = db2admin
   [WcsDbValidation]   dbaPassword = **************
   [WcsDbValidation]   schemaName = WCS
   [WcsDbValidation]   jdbcDriver = com.ibm.db2.jcc.DB2Driver
   [WcsDbValidation]   jdbcURL = jdbc:db2://localhost:50000/mall
   [WcsDbValidation]   
7[WcsDbValidation] Connection Testing
   [WcsDbValidation]   Test with supplied jdbcDriver
   [WcsDbValidation]   jdbcDriver = com.ibm.db2.jcc.DB2Driver found.
   [WcsDbValidation]     Location = file:/C:/WebSphere/SQLLIB/java/db2jcc4.jar!/com/ibm/db2/jcc/DB2Driver.class
   [WcsDbValidation]   
   [WcsDbValidation]   Test connection with supplied jdbcURL using dbUserName and dbUserPassword.
   [WcsDbValidation]   Connection successful with the following parameters :
   [WcsDbValidation]     jdbcURL = jdbc:db2://localhost:50000/mall
   [WcsDbValidation]     dbType = db2; dbUserName = WCS; dbUserPassword = **************
   [WcsDbValidation]       Connection class name = com.ibm.db2.jcc.t4.b
   [WcsDbValidation]       Database product name = DB2/NT64
   [WcsDbValidation]       Database product version = SQL10011
   [WcsDbValidation]       Database major version = 10
   [WcsDbValidation]       Database minor version = 1
   [WcsDbValidation]       Database driver name = IBM Data Server Driver for JDBC and SQLJ
   [WcsDbValidation]       Database driver version = 4.14.111
   [WcsDbValidation]       Database driver major version = 4
   [WcsDbValidation]       Database driver minor version = 14
   [WcsDbValidation]     WebSphere Commerce features:
   [WcsDbValidation]       Feature name = BASE. VRMF = 7.0.0.7
   [WcsDbValidation]       Feature name = foundation. VRMF = 7.0.6.0
   [WcsDbValidation]       Feature name = store-enhancements. VRMF = 7.0.6.0
   [WcsDbValidation]       Feature name = content-version. VRMF = 7.0.6.0
   [WcsDbValidation]       Feature name = location-services. VRMF = 7.0.6.0
   [WcsDbValidation]       Feature name = management-center. VRMF = 7.0.6.0
   [WcsDbValidation]   
   [WcsDbValidation]   Test connection with supplied jdbcURL using dbaName and dbaPassword.
   [WcsDbValidation]   Connection successful with the following parameters :
   [WcsDbValidation]     jdbcURL = jdbc:db2://localhost:50000/mall
   [WcsDbValidation]     dbType = db2; dbUserName = db2admin; dbUserPassword = **************
   [WcsDbValidation]       Database driver name = IBM Data Server Driver for JDBC and SQLJ
   [WcsDbValidation]   
8[WcsDbValidation]   Test other possible drivers and connections
   [WcsDbValidation]   jdbcDriver = COM.ibm.db2.jdbc.app.DB2Driver not found.
   [WcsDbValidation]     Class not found : COM.ibm.db2.jdbc.app.DB2Driver
   [WcsDbValidation]   
   [WcsDbValidation]   Connection successful with the following parameters :
   [WcsDbValidation]     jdbcURL = jdbc:db2:mall
   [WcsDbValidation]     dbType = db2; dbUserName = WCS; dbUserPassword = **************
   [WcsDbValidation]       Connection class name = com.ibm.db2.jcc.uw.UWConnection
   [WcsDbValidation]       Database driver name = IBM Data Server Driver for JDBC and SQLJ
   [WcsDbValidation]   
   [WcsDbValidation] >>>>>>>>>> Database <<<<<<<<<<
   [WcsDbValidation] End time = 2013-06-05 17:16:42.36
   [WcsDbValidation] ***************************************************************
   [WcsDbValidation]   
   [WcsDbValidation]   
   [eCDatabaseVersionInfo] SET SCHEMA WCS
   [eCDatabaseVersionInfo] COMPNAME
   [eCDatabaseVersionInfo] SELECT * FROM SITE WHERE COMPNAME='BASE'
   [eCDatabaseVersionInfo] Columns in the SITE table:
   [eCDatabaseVersionInfo] COMPNAME=BASE
   [eCDatabaseVersionInfo] EDITION=ENT
   [eCDatabaseVersionInfo] VERSION=7
   [eCDatabaseVersionInfo] RELEASE=0
   [eCDatabaseVersionInfo] MOD=0
   [eCDatabaseVersionInfo] FIXPACK=7
   [eCDatabaseVersionInfo] Properties in memory:
   [eCDatabaseVersionInfo] editionKey=ENT
   [eCDatabaseVersionInfo] ecVersionKey=7
   [eCDatabaseVersionInfo] releaseKey=0
   [eCDatabaseVersionInfo] modificationKey=0
   [eCDatabaseVersionInfo] fixpackKey=7
   
   UpdateFixpack:
   [EchoNL] Applying database fixpack update ...
   
   NoAction:
   [EchoNL] Completed database fixpack update.
   
   BUILD SUCCESSFUL
   Total time: 12 seconds
Where
System related information
1 - OS information
Information about the operating system. This information includes the name, version, and architecture of the operating system.
2 - Java information
Information about the Java Runtime Environment. The Java version must be 1.6.0.
3 - User information
Information about the WebSphere Commerce user that is applying the fix pack update.
4 - Memory information
The allocated memory. If errors are encountered during a database-related process, ensure that sufficient memory is allocated for the process to complete successfully.
5 - WebSphere Commerce information
Information about the WebSphere Commerce instance, including the instance name, installation directory, and logging configuration file.
Database connection information
6 - Input Parameters
The input parameters for the WebSphere Commerce database that are used to complete the database-related processes that are involved in applying the fix pack update.
7 - Connection Testing
Information about the JDBC driver and class are output in this section. If a successful database connection is established, the parameters that were used to establish the connection are included in this section.
8 - Test other possible drivers and connections
Information about alternate JDBC drivers that are tested and validated by the database connection validation utility. In this sample, no alternate JDBC driver and class are found.