RE: [U2] D3 to U2 - how to import a FileSave tape

2006-05-12 Thread Timothy Snyder
Bill Haskett wrote on 05/12/2006 11:46:20 AM:

> IBM advises that those migrating an MV system to U2 select UniVerse not
> UniData.  UniData is not inherently multi-value aware

Just curious - who within IBM supplied that information and opinion?  The 
last time I looked, UniData seemed to have one or two features that 
address multi-values.  ;-)

Tim Snyder
Consulting I/T Specialist , U2 Professional Services
North American Lab Services
DB2 Information Management, IBM Software Group
717-545-6403
[EMAIL PROTECTED]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] D3 to U2 - how to import a FileSave tape

2006-05-12 Thread Bill Haskett
David:

IBM advises that those migrating an MV system to U2 select UniVerse not
UniData.  UniData is not inherently multi-value aware and there are a number
of other issues that IBM suggests will be avoided by migrating to UniVerse.
So, take IBM's advice and move D3 to UniVerse not UniData.

When saving D3 data try the following:

1) prepare the D3 system for conversion,
   + this is your choice of what you want.  The U2 products
 are case sensitive.  However, there are utilities in UV
 to help with the conversion and they will upper-case
 everything for you.
   + make sure you don't use the PE version of UV unless no
 file in D3 exceeds something like 60MB (I'm not sure
 and would have to look this up to be sure).
2) do an account-save of the selected accounts to a "pseudo"
   + account-saves are the only supported method for transfer
   + do the following:
 :set-device {n}  (where {n} is a "pseudo" device)
 :t-rew
 : select mds,, 'acct1''acct2''acct3'...
 {n} items selected.
 :account-save (a
  .
  .
 :t-rew
 :t-det
   Note: the "pseudo" device you select may or may not be a
   compressed device.  I always recommend you save to a non-
   compressed device.  Don't mess with compression unless
   you're ftp'ing the file over the internet.  If so, use
   whatever Linux tool exists to compress the file before
   using ftp but after the D3 backup.
3) use the "D3RESTORE" program to restore onto UniVerse
   + place the "pseudo" file onto the UV system
   + create a new UV account from which to run D3RESTORE
   + start a UV session and log to the "UV" account
   + copy the new versions of CONVERT.VOC and D3RESTORE
 to the APP.PROGS file
   + run BASIC APP.PROGS D3RESTORE CONVERT.VOC
   + run CATALOG APP.PROGS *D3RESTORE D3RESTORE FORCE
   + run CATALOG APP.PROGS *CONVERT.VOC CONVERT.VOC FORCE
 (note: overwrite existing if asked)
   + LOGTO the account from which to run D3RESTORE
   + run the D3RESTORE program from TCL

General info from the account to run D3RESTORE from:
:CT VOC D3RESTORE (this item must exist locally)
 D3RESTORE
0001 V
0002 *D3RESTORE
0003 B
0004 BN
:LOGTO UV
:LONGNAMES ON NEWAC
All NEWACCs have been modified to use long file names.
:LOGTO {AccountToLaunchFrom}
:D3RESTORE INFILE {PathOfPseudo} - e.g. C:\IBM\d3save

Next run the CONVERT.VOC program, which should convert the VOC.  I had
to recatalog the programs DC, DC.ITEM, and DC.CORR.CONV after
recompiling them. Recompile in local account then recatalog in "UV"
account.

I had some real difficulties with the "DC..." programs in UniVerse.
They didn't seem to work properly and I had to review them and
activate a bunch of lines of code to make it work properly.  This
may be because I had the UV PE version.  I still have these programs
and here's a list of the ones I changed:

CONVERT.VOC
DC
DC.A
DC.CORR.CONV
DC.F
DC.ITEM
DC.OPENS
D3RESTORE

Hope this helps a little.  If you get this far ask and I'll offer whatever
help I can.

Bill

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of 
> David Wolverton
> Sent: Thursday, May 11, 2006 8:00 PM
> To: u2-users@listserver.u2ug.org
> Subject: [U2] D3 to U2 - how to import a FileSave tape
> 
> If I to a 'file save' from D3 to a 'disk' tape device, then 
> ZIP the file from a Linux Box onto a Windows Box and unZIP it 
> to do 'account restores' on a U2 box...
> 
> What surprises await me?  The issue on a test conversion I 
> need to run is that the tape drive on the Linux box cannot be 
> accessed on a Windows Box, and go figure, I don't have $3k to 
> throw down for a one-time conversion 
> 
> So - I'd like to use the tape 'disk' file to import.  But 
> would love any knowledge from those bearing the arrows of 
> being leaders on this process!
>
> They have about 2GB of data - likely much smaller ZIPed, so I 
> can get it on a single 'tape file' and 'ftp' it from one 
> machine to the other (while I'm at lunch...).  From there, is 
> it 'smooth sailing'?
> 
> Also, this customer could care less if I dropped them into 
> UniVerse or UniData - I use UniData more, but that's just a 
> preference I can get over if UniVerse makes this substantially easier.
> 
> TIA for any thoughts -
> David
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] D3 to U2 - how to import a FileSave tape

2006-05-11 Thread colin.alfke
I've done a number of these. We had a D3/Aix box that I would restore the
tapes on. I would then run a program that renamed all of the D3 files as upper
case (made things come through cleaner on UD). It pretty much simply selects
the file-of-files and does a rename to xxyyz and then back to the original
name 'MCU'd.

I had a pseudo floppy setup (with a 512 block-size). I did an account-save to
it then used SFU (now free) to copy the file to the UD windows box. I think I
also checked that a binary ftp transfer worked.

I then created the tape device in UD (making sure to set the 512 block size).
Then did an acct-restore. Worked like a charm. We converted approx 50 clients
like this. Others haven't had very good luck.

Once you get the data into UD note that D3 is not case-sensitive - but UD is.
At least by default, I believe it's an option now. That means that all of your
primary and foreign keys need to be in the same case. My old boss even tried
taking the unix file the D3 save creates and running it through a Unix utility
to upper case ALL of the data. We have a lot of "textual" data that didn't
really lend itself to this method, YMMV.

I have some more complete notes at work that I can post in the morning if you
like.

hth
Colin Alfke
Calgary Canada



From: David Wolverton

If I to a 'file save' from D3 to a 'disk' tape device, then ZIP the file
from a Linux Box onto a Windows Box and unZIP it to do 'account restores' on
a U2 box...

What surprises await me?  The issue on a test conversion I need to run is
that the tape drive on the Linux box cannot be accessed on a Windows Box,
and go figure, I don't have $3k to throw down for a one-time conversion 

So - I'd like to use the tape 'disk' file to import.  But would love any
knowledge from those bearing the arrows of being leaders on this process!
They have about 2GB of data - likely much smaller ZIPed, so I can get it on
a single 'tape file' and 'ftp' it from one machine to the other (while I'm
at lunch...).  From there, is it 'smooth sailing'?

Also, this customer could care less if I dropped them into UniVerse or
UniData - I use UniData more, but that's just a preference I can get over if
UniVerse makes this substantially easier.

TIA for any thoughts -
David

[demime 1.01d removed an attachment of type application/ms-tnef which had a 
name of winmail.dat]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/