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.
REORG TABLE JCR.ICMUT01254001 LONGLOBDATA USE ICMLSSYSTSPACE32 ;
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