Unix Technical Forum

HPL

This is a discussion on HPL within the Informix forums, part of the Database Server Software category; --> Hello All, We are moving from (IDS 10 FC3R1) HP-UX 11i to an AIX partition on the iSeries. I ...


Go Back   Unix Technical Forum > Database Server Software > Informix

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-20-2008, 10:50 AM
tomcaml@yahoo.com
 
Posts: n/a
Default HPL

Hello All,

We are moving from (IDS 10 FC3R1) HP-UX 11i to an AIX partition on the
iSeries. I know i can use HPL to unload because it is a UNIX
environment but will i be able to use HPL to load into the new database
and environment that is not HP-UX - ?


Thanks,
Tom

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-20-2008, 10:51 AM
tomcaml@yahoo.com
 
Posts: n/a
Default Re: HPL

never mind - duh

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 04-20-2008, 10:51 AM
Superboer
 
Posts: n/a
Default Re: HPL

carefull do not use noconversion jobs (the fastest...)
ascii should be ok;


Superboer.

tomcaml@yahoo.com schreef:

> Hello All,
>
> We are moving from (IDS 10 FC3R1) HP-UX 11i to an AIX partition on the
> iSeries. I know i can use HPL to unload because it is a UNIX
> environment but will i be able to use HPL to load into the new database
> and environment that is not HP-UX - ?
>
>
> Thanks,
> Tom


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 04-20-2008, 10:51 AM
tomcaml@yahoo.com
 
Posts: n/a
Default Re: HPL

why "do not use the no conversion"?

i wont be converting anything -

Thanks,
Tom

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5 (permalink)  
Old 04-20-2008, 10:52 AM
david@smooth1.co.uk
 
Posts: n/a
Default Re: HPL


The noconversion unloads in a binary internal format that is platform
dependent.

Also check out Point In Time Table Restore. If you are moving from IDS
10 to IDS 10 you can use
the Point in Time Table Restore to restore a complete database from one
platform to another!!

Since you will be taking a level 0 archive anyway why use onbar and ism
and archive to disk.
They you can restore from that image rather than extracting all the
data from the database again!

Something to consider.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 08:58 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com