Migration to Smart blobs
Kenneth needed to migrate ~20 GB of BYTE (simple blob) data from Informix 7 to BLOB smart large objects in sbspaces on IDS 10, and asked how to convert the actual data, not just the storage definitions. After advice to read the admin/migration manuals on sbspace sizing and metadata, Gerd Kaluzinski gave the working answer: upgrade first keeping the old datatypes (in place or via dbexport/dbimport), then create a new table with BLOB columns and do INSERT INTO new_tab SELECT ..., f_byte::blob, ... FROM old_tab, as the cast converts the data automatically. Kenneth confirmed this solved his problem.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
People,
I am currently involved in the migration of a system that that included blobs
from Informix 7 to 10. Currently we are using columns of type byte to store
data. With the migration to Informix 10, we intend to move to smart blobs. Can
anyone suggest to me a way to migrate circa 20G of data from byte columns to
blobs ( in smartblob spaces). The upgrade to Informix 10 will be done using
dbexport/dbimport or HPL.
Regards
Kenneth
Hi Kenneth,
A smart blobspace dbspace and chunks are quite
different of a blobspace, you have to consider disk
space for you metadata and other performance options.
I would recommend you first to read the Admin manual
and play a bit with the parameters to create a smart
space.
Take a deep look at the migration guide then.
hope this helps you,
esteban.-
--- KENNETH PENZA <kenneth.penza@gov.mt> escribió:
>
> People,
>
> I am currently involved in the migration of a system
> that that included blobs
> from Informix 7 to 10. Currently we are using
> columns of type byte to store
> data. With the migration to Informix 10, we intend
> to move to smart blobs. Can
> anyone suggest to me a way to migrate circa 20G of
> data from byte columns to
> blobs ( in smartblob spaces). The upgrade to
> Informix 10 will be done using
> dbexport/dbimport or HPL.
>
> Regards
> Kenneth
>
>
>
*******************************************************************************
>
> Forum Note: Use "Reply" to post a response in the
> discussion forum.
>
>
___________________________________________________________
1GB gratis, Antivirus y Antispam
Correo Yahoo!, el mejor correo web del mundo
http://correo.yahoo.com.ar
Actually I have checked the documentation and we are looking in the different
options related to smartblob spaces. What I did not figure out is how to
perform the data type migration from byte to blob (not as regards to storage
and create statements, but for the actual data stored in the byte columns).
Thanks and Regards
Kenneth Penza
Technical Services Officer
Systems and Database Services
Service Management Department
Malta Information Technology & Training Services Ltd
Please read our Legal Notice: http://emailpolicy.mitts.gov.mt
P
Please consider your environmental responsibility before printing this e-mail.
END OF TEXT
-----Original Message-----
From: Esteban Cas.... [mailto:estebanc00@yahoo.com.ar]
Sent: 16 January 2006 17:17
To: Penza Kenneth at MITTS
Subject: Re: Migration to Smart blobs [6217]
Hi Kenneth,
A smart blobspace dbspace and chunks are quite
different of a blobspace, you have to consider disk
space for you metadata and other performance options.
I would recommend you first to read the Admin manual
and play a bit with the parameters to create a smart
space.
Take a deep look at the migration guide then.
hope this helps you,
esteban.-
--- KENNETH PENZA <kenneth.penza@gov.mt> escribió:
>
> People,
>
> I am currently involved in the migration of a system
> that that included blobs
> from Informix 7 to 10. Currently we are using
> columns of type byte to store
> data. With the migration to Informix 10, we intend
> to move to smart blobs. Can
> anyone suggest to me a way to migrate circa 20G of
> data from byte columns to
> blobs ( in smartblob spaces). The upgrade to
> Informix 10 will be done using
> dbexport/dbimport or HPL.
>
> Regards
> Kenneth
>
>
>
*******************************************************************************
>
> Forum Note: Use "Reply" to post a response in the
> discussion forum.
>
>
___________________________________________________________
1GB gratis, Antivirus y Antispam
Correo Yahoo!, el mejor correo web del mundo
http://correo.yahoo.com.ar
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Migrate with your old datatypes (InPlace or using dbexport/dbimport).
In Version 10 create a new table with the same structure as your tables with
BYTE-Columns.
Then use the internal conversion like:
insert into new_tab
select f1, f2, ... f_byte::blob, ...
from old_tab
The Cast "::blob" automaticly converts the byte data to blob data.
This was we converted a lot of old ducuments to be able to use excalibur on
them.
bunny
ids@iiug.org schrieb am 16.01.06 15:19:00:
>
>
> People,
>
> I am currently involved in the migration of a system that that included blobs
> from Informix 7 to 10. Currently we are using columns of type byte to store
> data. With the migration to Informix 10, we intend to move to smart blobs.
Can
> anyone suggest to me a way to migrate circa 20G of data from byte columns to
> blobs ( in smartblob spaces). The upgrade to Informix 10 will be done using
> dbexport/dbimport or HPL.
>
> Regards
> Kenneth
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
__________________________________________________________________________
Erweitern Sie FreeMail zu einem noch leistungsstärkeren E-Mail-Postfach!
Mehr Infos unter http://freemail.web.de/home/landingpad/?mc=021131
Gerd,
Thanks very much you, I can now move byte columns to blob columns in smartblob
spaces.
Thanks again
Kenneth Penza
Technical Services Officer
Systems and Database Services
Service Management Department
Malta Information Technology & Training Services Ltd
Please read our Legal Notice: http://emailpolicy.mitts.gov.mt
P
Please consider your environmental responsibility before printing this e-mail.
END OF TEXT
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of gerd
kaluzinski
Sent: 17 January 2006 13:25
To: ids@iiug.org
Subject: Re: Migration to Smart blobs [6220]
Migrate with your old datatypes (InPlace or using dbexport/dbimport).
In Version 10 create a new table with the same structure as your tables with
BYTE-Columns.
Then use the internal conversion like:
insert into new_tab
select f1, f2, ... f_byte::blob, ...
from old_tab
The Cast "::blob" automaticly converts the byte data to blob data.
This was we converted a lot of old ducuments to be able to use excalibur on
them.
bunny
ids@iiug.org schrieb am 16.01.06 15:19:00:
>
>
> People,
>
> I am currently involved in the migration of a system that that included
blobs
> from Informix 7 to 10. Currently we are using columns of type byte to store
> data. With the migration to Informix 10, we intend to move to smart blobs.
Can
> anyone suggest to me a way to migrate circa 20G of data from byte columns to
> blobs ( in smartblob spaces). The upgrade to Informix 10 will be done using
> dbexport/dbimport or HPL.
>
> Regards
> Kenneth
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
__________________________________________________________________________
Erweitern Sie FreeMail zu einem noch leistungsstärkeren E-Mail-Postfach!
Mehr Infos unter http://freemail.web.de/home/landingpad/?mc=021131
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Not sure that many people currently use smart blobs.
Yoy may have to create an esql/c program to do the unload/load.
Otherwise talk to the vendor for the DataBlade that implements the smart
blobs.
Perhaps they have some tools to assist?
----- Original Message -----
From: "Penza Kenne...." <kenneth.penza@gov.mt>
To: <ids@iiug.org>
Sent: Tuesday, January 17, 2006 11:05 AM
Subject: RE: Migration to Smart blobs [6219]
>
> Actually I have checked the documentation and we are looking in the
> different
> options related to smartblob spaces. What I did not figure out is how to
> perform the data type migration from byte to blob (not as regards to
> storage
> and create statements, but for the actual data stored in the byte
> columns).
>
> Thanks and Regards
> Kenneth Penza
> Technical Services Officer
> Systems and Database Services
> Service Management Department
> Malta Information Technology & Training Services Ltd
>
> Please read our Legal Notice: http://emailpolicy.mitts.gov.mt
>
> P
> Please consider your environmental responsibility before printing this
> e-mail.
> END OF TEXT
>
> -----Original Message-----
> From: Esteban Cas.... [mailto:estebanc00@yahoo.com.ar]
> Sent: 16 January 2006 17:17
> To: Penza Kenneth at MITTS
> Subject: Re: Migration to Smart blobs [6217]
>
> Hi Kenneth,
>
> A smart blobspace dbspace and chunks are quite
> different of a blobspace, you have to consider disk
> space for you metadata and other performance options.
>
> I would recommend you first to read the Admin manual
> and play a bit with the parameters to create a smart
> space.
> Take a deep look at the migration guide then.
>
> hope this helps you,
> esteban.-
> --- KENNETH PENZA <kenneth.penza@gov.mt> escribió:
>
>>
>> People,
>>
>> I am currently involved in the migration of a system
>> that that included blobs
>> from Informix 7 to 10. Currently we are using
>> columns of type byte to store
>> data. With the migration to Informix 10, we intend
>> to move to smart blobs. Can
>> anyone suggest to me a way to migrate circa 20G of
>> data from byte columns to
>> blobs ( in smartblob spaces). The upgrade to
>> Informix 10 will be done using
>> dbexport/dbimport or HPL.
>>
>> Regards
>> Kenneth
>>
>>
>>
>
>
>
*******************************************************************************
>>
>> Forum Note: Use "Reply" to post a response in the
>> discussion forum.
>>
>>
>
> ___________________________________________________________
> 1GB gratis, Antivirus y Antispam
> Correo Yahoo!, el mejor correo web del mundo
> http://correo.yahoo.com.ar
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> ---
> [This E-mail has been scanned for viruses but it is your responsibility
> to maintain up to date anti virus software on the device that you are
> currently using to read this email. ]
>
>
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.371 / Virus Database: 267.14.18/230 - Release Date:
> 14/01/2006
>
>
---
[This E-mail has been scanned for viruses but it is your responsibility
to maintain up to date anti virus software on the device that you are
currently using to read this email. ]