Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2013
    Posts
    33

    Unanswered: EXPORT BLOB data

    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) ,
    "PHOTO_FORMAT" CHAR(4)
    )
    IN "MYTS" ;

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •