Hi,

We suddenly started facing this problem after the database restart yesterday. Before that everything was working fine. problem is as follows: We have a table and it's definition is as follows:

************************************************** ********************

db2 => describe table Rule

Column Type Type
name schema name Length Scale Nulls
------------------------------ --------- ------------------ -------- ----- -----
BLOBRULESETFILE SYSIBM BLOB 1048576 0 Yes


************************************************** ********************

When we try to insert a file in this BLOB column using a java program, it executes the operation successfully
but when we issue the select on Rule table, the number of rows we get is 0.

We have one more database (on different machine) on which we are able to insert the row in the table using same java program.
Both databases have separate long tablespace (and a quite similar structure).

Java program is not giving any error in both the cases.



LOG FILE OUTPUT
-----------------------------------------------------------------

2003-01-19-15.25.33.712000 InstanceB2CTLSV Node:000
PID:541(db2syscs.exe) TID:509 Appid:0E100393.CA04.030119095533
base_sys_utilities sqle_db2ra_lob_send_receive Probe:101 Database:IRS_DEV
DIA3535C LOB File transfer error. Communications error encountered when
"receiving". ("0" "")

2003-01-19-15.25.33.712000 InstanceB2CTLSV Node:000
PID:541(db2syscs.exe) TID:509 Appid:0E100393.CA04.030119095533
base_sys_utilities sqle_db2ra_lob_send_receive Probe:101 Database:IRS_DEV
DIA3535C LOB File transfer error. Communications error encountered when
"receiving". ("0" "")