Enabling interim fix JR49904

Interim fix JR49904 adds an option to check the status of a broadcast job on different nodes in a cluster by using the CloneID column of the SCHBRDCST table.

The interim fix includes the following SQL files:

WC_installdir/schema/db2/fixpack6/JR49904.sql
WC_installdir/schema/oracle/fixpack6/JR49904.sql
WC_installdir/schema/cloudscape/fixpack6/JR49904.sql
WC_installdir/schema/os400/fixpack6/JR49904.sql
WCDE_installdir/schema/db2/fixpack6/JR49904.sql
WCDE_installdir/schema/oracle/fixpack6/JR49904.sql
WCDE_installdir/schema/cloudscape/fixpack6/JR49904.sql
WCDE_installdir/schema/os400/fixpack6/JR49904.sql

Note: For AIX and Linux only: The root user must copy the appropriate JR49904.sql file to a location that the database user can access. For example, for a DB2 database, copy the WC_installdir/schema/db2/fixpack6/JR49904.sql file to the /home/db2inst1 directory.

Run the SQL that pertains to your database to alter the CloneID column size.

Before you begin

Install the interim fix for JR49904.
Install the cumulative interim fix for Fix Pack 6, JR53048.fp. JR49904 is included in the cumulative interim fix.

For information about how to install an interim fix, see

Procedure

Open a connection to your database.

Run the appropriate SQL file for your database to apply the changes.

For example,

On a DB2 database, run the following commands

db2 connect to <database> [user <username> using <password>]
db2 -tf schema/db2/fixpack6/JR49904.sql
db2 REORG table WCS.schbrdcst
db2 connect reset

On an Oracle database, run the following command

./sqlplus dbuser/dbuserpassword@database < JR49904.sql > JR49904.log