Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2011
    Posts
    3

    Unanswered: Reorg LONGLOBDATA without Shadow Copy

    DB2 9.5 fp5
    AIX 6.1

    Hi all,

    I have a table with BLOB data that I'm trying to reorg to reclaim disk space back to the OS for various reasons (mainly it's relatively low on free space and is going to be a pain to give it more).

    The problem is when I run an offline reorg on the the table with the LONGLOBDATA option, there's not enough free disk space to create the shadow copy of the table. As far as I know the LONGLOBDATA option is only available to offline reorgs.

    Code:
    REORG TABLE JCR.ICMUT01254001  LONGLOBDATA USE ICMLSSYSTSPACE32 ;
    Code:
    2014-05-16-02.01.25.016216+600 I83147A566         LEVEL: Warning
    PID     : 11075754             TID  : 34133       PROC : db2sysc 0
    INSTANCE: db2inst4             NODE : 000         DB   : JCRDB61
    APPHDL  : 0-19118              APPID: *LOCAL.db2inst4.140515155242
    AUTHID  : DB2INST4
    EDUID   : 34133                EDUNAME: db2agent (JCRDB61) 0
    FUNCTION: DB2 UDB, trace services, sqlt_logerr_string (secondary logging fu, probe:0
    MESSAGE : Reorg table failed.
    DATA #1 : String, 79 bytes
    Table(4:274)=JCR     .ICMUT01254001, Flags=x00004099, IID=0, Temp=0, LongTemp=0
    
    2014-05-16-02.01.25.016378+600 I83714A507         LEVEL: Warning
    PID     : 11075754             TID  : 34133       PROC : db2sysc 0
    INSTANCE: db2inst4             NODE : 000         DB   : JCRDB61
    APPHDL  : 0-19118              APPID: *LOCAL.db2inst4.140515155242
    AUTHID  : DB2INST4
    EDUID   : 34133                EDUNAME: db2agent (JCRDB61) 0
    FUNCTION: DB2 UDB, data management, sqldTableReorgObject, probe:4296
    RETCODE : ZRC=0x850F000C=-2062614516=SQLO_DISK "Disk full."
              DIA8312C Disk was full.

    This leaves me in a bit of a catch 22, I need to free up disk space by reclaiming space used by LOB data, but to do so I need more disk space.

    Is there any way around this? Can I do an offline reorg without using a shadow copy?

    Thanks,
    Caleb

  2. #2
    Join Date
    Sep 2011
    Posts
    3
    Anyone have any ideas?

    Thanks,
    Caleb

  3. #3
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    maybe export - load of the table could be used
    but export of lobs, will also take some time
    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
  •