We have a 4 million row table which has a BLOB column. I would want to export the data in a del format including BLOB data before purging the data. Can some one confirm that the below command is the way to go.. Does the export utility writes data to the transactional log.
db2 export to myfile.del of del lobs to mylobs/
lobfile lobs1 modified by lobsinfile
select * from PTP.IM_BLOG
Also, I am going to delete 3 million rows from this table by issuing delete statement. Do I need to worry about transaction log ? See the LOB column definition with "NOT LOGGED NOT COMPACT".. I am assuming this LOB data will not be logged during DELETEs.
CREATE TABLE "PTP "."IM_BLOG" (
"PHOTO_KEY" BIGINT NOT NULL ,
"VW_TYP" CHAR(4) ,
"SZ" INTEGER ,
"PHOTO_CK" BLOB(1024000) NOT LOGGED NOT COMPACT ,
"FLNM" CHAR(250) ,
IN "MYTS" ;
try to delete with smaller parts delete.. where x in (select ...)
or try alter table not logged initially..
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified http://www.infocura.be