IDS Forum

RE: - RE: informix upgrade to V10 [8204] - Bayesia

Posted By: Penza Kenneth at MITTS
Date: Saturday, 13 January 2007, at 10:54 a.m.

Denny,

I suggest that you use HPL and unload to NFS and use HPL to load

the data from NFS. This will allow you to overcome the problem of 2G

tables, by assigning multiple devices for a particular table/s. For

example if a table is 15G create 8 or 9/10 devices for that table.

Note that HPL will use all the files at once, but there is not

guarntee that the files will all be of the same size so better an

extra one if you are not sure.

During loading use express mode for tables that do not

byte/text/blob/clob as it is a lot faster (bypass SQL layer), and for

tables that have byte/text/blob/clob columns use deluxe mode which as

slower as it requires transaction logging. Another advantage over

dbexport/dbimport is that the process is restartable of each table

without messing around.

HPL is not as straight forward as dbexport/dbimport but from my

experience with the product it justifies its complexity. I had issues

with byte/text columns and HPL in 7.30 but when I upgraded to 7.31.UD7

it worked seamlessly.

Another option can be to migrate smaller that using load/unload

commands and use HPL for the bigger tables.

Regards

Kenneth

-----Original Message-----

From: ids-bounces@iiug.org on behalf of Marcus Haarmann

Sent: Sat 1/13/2007 11:13 AM

To: ids@iiug.org

Subject: [SPAM] - RE: informix upgrade to V10 [8204] - Bayesian Filter

detected spam

Denny,

This should be the easiest way, in order to go around tape problems.

A dbexport to an NFS mount should be no problem, you can also import

from

the same external volume.

In this case you do not even need a tape.

If you have a table > 2GB (as export file !), you should use unload to

...

in 2-3 steps and then concat the data.

Truncate the table to one row and do the rest by dbexport. In the

export

script, you can see the filename and replace it by the unloaded one.

Marcus

-----Original Message-----

From: ids-bounces@iiug.org [[1]mailto:ids-bounces@iiug.org] On Behalf

Of

Everett Mills

Sent: Friday, January 12, 2007 8:13 PM

To: ids@iiug.org

Subject: RE: informix upgrade to V10 [8201]

Denny-

Assuming the you're running a Unix variant, have you considered

loading

Linux on a PC with a 50GB + hard drive in it? You could then NFS mount

the

PC's drive and dbexport to it. As long as none of your tables is

bigger than

2GB unloaded, you should be in good shape... You could then tar (or

whatever

your favorite Unix backup util is) the mounted directory to your tape.

--EEM

-----Original Message-----

From: ids-bounces@iiug.org [[2]mailto:ids-bounces@iiug.org] On Behalf

Of Guo,

Denny

Sent: Friday, January 12, 2007 12:40 PM

To: ids@iiug.org

Subject: RE: informix upgrade to V10 [8199]

Thanks Kern.

I will think about it.

Have nice weekend.

Denny

-----Original Message-----

From: ids-bounces@iiug.org [[3]mailto:ids-bounces@iiug.org] On Behalf

Of Kern

Doe

Sent: Friday, January 12, 2007 1:19 PM

To: ids@iiug.org

Subject: Re: informix upgrade to V10 [8197]

Based on what you want to do (no tape changing) and with IDS version 7

you're running with, dbexport won't serve you well -- again because of

the

dbexport's 2G limitation. This is what you can try and I've done it

before,

for

example:

1) using "unload" statement to unload tables to a tape, specify "no

rewind"

--> n

for example,

unload to /dev/rmt/tl0n select * from customer; unload to

/dev/rmt/tl0n

select * from order; unload to /dev/rmt/tl0n select * from state;

unload to

/dev/rmt/tl0n select * from inventory; unload to /dev/rmt/tl0n select

* from

address;

2) the reload is tricky, you will to rewind the whole tape, then start

with

the last table, still with "no rewind":

for example,

load from /dev/rmt/tl0n insert into address; load from /dev/rmt/tl0n

insert

into inventory; load from /dev/rmt/tl0n insert into state; load from

/dev/rmt/tl0n insert into order; load from /dev/rmt/tl0n insert into

customer;

This will help you to overcome the 2GB limitation, say, your customer

table

is greater than 2GB, it won't matter any more.

3) the last tricky part is, and it depends on the logical design of

your

database -- in some cases, you must load one table before another --

so you

must understand your database structure, that's the whole new subject

besides this dbexport issue.

Good luck.

----- Original Message ----

From: "Guo, Denny" <DGuo@livingstonintl.com>

To: ids@iiug.org

Sent: Friday, January 12, 2007 12:07:43 PM

Subject: RE: informix upgrade to V10 [8188]

Yes. I think The limitation is 2GB.

Say for a 50G database, do you need 25 tapes? How to solve such

problem?

I am trying to not change the tape (100G capability), the dbexport can

write

to the same tape.

The question is will it write from beginning? Will old data been

erased?

Thanks,

Denny

-----Original Message-----

From: ids-bounces@iiug.org [[4]mailto:ids-bounces@iiug.org] On Behalf

Of Kern

Doe

Sent: Friday, January 12, 2007 11:52 AM

To: ids@iiug.org

Subject: Re: informix upgrade to V10 [8187]

I thought the limitation for IDS 7 is at 2GB for dbexport (2,097,151

kilobytes.) -- you can't specify size 100000000 (yes/no?)

----- Original Message ----

From: "ART KAGEL, BLOOMBERG/ 731 LEXIN" <kagel@bloomberg.net>

To: ids@iiug.org

Sent: Friday, January 12, 2007 11:39:15 AM

Subject: RE: informix upgrade to V10 [8186]

Remove the commas from the -s argument. It should be:

dbexport -c -ss -b 1024 -s 100000000 -f db.sql ip_0p

Art S. Kagel

----- Original Message -----

From: Denny Guo <ids@iiug.org>

At: 1/12 11:41:58

Hi All,

I am doing the dbexport now. But have some issues.

The current version of informxi we are running is V7.31.

The tape we are using have 100G capability.

Issue command " dbexport -c -ss -b 1024 -s 100,000,000 -f db.sql

ip_0p"

would work. It complains about the block size must less than or equal

to

tape side.

I have to change to tape size to "1,000,000,000". However it stops at

some

point ask to mount another tape? The databse we try to export only

50G.

According to the manual, there are some restrictions for version 7.

See

below statement.

"-s tapesize Specifies, in kilobytes, the amount of data that you

canstore

on the tape. ** Restrictions: The tape size is limited to

2,097,151 kilobytes. The limit is required because of the way dbexport

and

dbimport track their positions into the tape."

Any ideas?

Thanks,

Denny

*******************************************

The information contained in this e-mail message may contain

privileged and

confidential information.

If you are not the intended recipient, you are hereby notified that

any

review, dissemination, distribution or duplication of this

communication is

strictly prohibited. If you have received this message in error,

please

notify the sender by return e-mail, delete this message and destroy

any

copies.

Internet e- mail is not guaranteed to be secure or error-free.

Messages

could be intercepted, corrupted, lost, arrive late or contain viruses.

The sender will not be liable for

these risks.

*******************************************

Ce message electronique pourrait contenir des informations

privilegiees et

confidentielles. Si vous n'en etes pas le recipiendaire prevu, nous

vous

signalons qu'il est strictement interdit d'examiner, de diffuser, de

distribuer et de reproduire le present message. Si vous l'avez recu

par

erreur, veuillez prevenir l'expediteur par courriel, puis effacer ce

message

et en detruire toute copie.

Le courrier electronique n'est pas garanti securitaire ni exempt

d'erreurs.

Les messages pourraient etre interceptes, corrompus, egares, retardes

ou

contamines par des virus.

L'exp'editeur n'est pas

responsable de ces risques .

**********************************************************************

**

*******

Forum Note: Use "Reply" to post a response in the discussion forum.

**********************************************************************

**

*******

Forum Note: Use "Reply" to post a response in the discussion forum.

**********************************************************************

**

*******

Forum Note: Use "Reply" to post a response in the discussion forum.

*******************************************

The information contained in this e-mail message may contain

privileged and

confidential information.

If you are not the intended recipient, you are hereby notified that

any

review, dissemination, distribution or duplication of this

communication is

strictly prohibited. If you have received this message in error,

please

notify the sender by return e-mail, delete this message and destroy

any

copies.

Internet e- mail is not guaranteed to be secure or error-free.

Messages

could be intercepted, corrupted, lost, arrive late or contain viruses.

The sender will not be liable for

these risks.

*******************************************

Ce message electronique pourrait contenir des informations

privilegiees et

confidentielles. Si vous n'en etes pas le recipiendaire prevu, nous

vous

signalons qu'il est strictement interdit d'examiner, de diffuser, de

distribuer et de reproduire le present message. Si vous l'avez recu

par

erreur, veuillez prevenir l'expediteur par courriel, puis effacer ce

message

et en detruire toute copie.

Le courrier electronique n'est pas garanti securitaire ni exempt

d'erreurs.

Les messages pourraient etre interceptes, corrompus, egares, retardes

ou

contamines par des virus.

L'exp'editeur n'est pas

responsable de ces risques .

**********************************************************************

**

*******

Forum Note: Use "Reply" to post a response in the discussion forum.

**********************************************************************

**

*******

Forum Note: Use "Reply" to post a response in the discussion forum.

*******************************************

The information contained in this e-mail message may contain

privileged and

confidential information.

If you are not the intended recipient, you are hereby notified that

any

review, dissemination, distribution or duplication of this

communication is

strictly prohibited. If you have received this message in error,

please

notify the sender by return e-mail, delete this message and destroy

any

copies.

Internet e- mail is not guaranteed to be secure or error-free.

Messages

could be intercepted, corrupted, lost, arrive late or contain viruses.

The sender will not be liable for

these risks.

*******************************************

Ce message electronique pourrait contenir des informations

privilegiees et

confidentielles. Si vous n'en etes pas le recipiendaire prevu, nous

vous

signalons qu'il est strictement interdit d'examiner, de diffuser, de

distribuer et de reproduire le present message. Si vous l'avez recu

par

erreur, veuillez prevenir l'expediteur par courriel, puis effacer ce

message

et en detruire toute copie.

Le courrier electronique n'est pas garanti securitaire ni exempt

d'erreurs.

Les messages pourraient etre interceptes, corrompus, egares, retardes

ou

contamines par des virus.

L'exp'editeur n'est pas

responsable de ces risques .

**********************************************************************

**

*******

Forum Note: Use "Reply" to post a response in the discussion forum.

**********************************************************************

******

***

Forum Note: Use "Reply" to post a response in the discussion forum.

**********************************************************************

*********

Forum Note: Use "Reply" to post a response in the discussion forum.

References

1. mailto:ids-bounces@iiug.org

2. mailto:ids-bounces@iiug.org

3. mailto:ids-bounces@iiug.org

4. mailto:ids-bounces@iiug.org

IDS Forum is maintained by Administrator with WebBBS 5.12.