Peopletools & Disappearing Blobs

Steve Grimes

Peopletools & Disappearing Blobs
Hello, z/OS 1.4, DB2 V7.1 here, cross-posting to DB2-L and the PeopleSoft
for DB2 for OS/390 list.

We have developed several PeopleSoft components that use the getattachment
(and related peoplesoft functions) to capture and store BLOBS in DB2.

Periodically (usually about once a month, but twice this week,) all of the
BLOBS are disappearing -- being deleted. The table is still there but
empty. We log it now (with triggers), and can see that the rows were
actually deleted in one instant.

We've tried to recreate what could be happening, but have failed so far.
Three components developed by different developers all seem to be having
this problem.

Has anyone else experienced this? Have any suggesions? We haven't
reported it because we can't replicate it at will.

Thanks in advance..


Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at