PROBLEM DESCRIPTION:
When trying to install the "Discovery Library Toolkit", the following errors is seen in the below log files.
Tue Mar 24 20:12:18.880 GMT+05:30 2015 : STDOUT : Entered
GetDatabaseType.getUrl
Tue Mar 24 20:12:18.881 GMT+05:30 2015 : STDOUT : WhichDB: 1
Tue Mar 24 20:12:18.882 GMT+05:30 2015 : STDOUT : Exit
GetDatabaseType.getUrl: jdbc:db2://10.10.126.149:50000/TBSM
Tue Mar 24 20:12:18.883 GMT+05:30 2015 : STDOUT : Database URL:
jdbc:db2://10.10.126.149:50000/TBSM
Tue Mar 24 20:12:22.735 GMT+05:30 2015 : STDOUT : Connection
successful.....
Tue Mar 24 20:12:22.778 GMT+05:30 2015 : STDOUT : Table access
exception: DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC:
TBSMSCR.SCCP_COMPONENTS
Tue Mar 24 20:12:22.780 GMT+05:30 2015 : STDOUT : Stopping installation
because of previous exceptions
SOLUTION:
One possible cause of this error was because of missing a step when creating the TBSM DB2 database, i.e.DB2 setup for the XMLToolkit.
To setup the schema for the XMLToolkit, IBM provide a script, the 'setdbschema' script. Please run :
setdbschema -U user -P password -f a
This command will drop and recreate all the tables used by the XMLToolkit, and should allow your base TBSM 6.1 install to complete successfully.
The details on the command as follow:
