Ansicht
Dokumentation
05249 - LRAW data still in EBCDIC in file D010S af ter migration
ABAP Short Reference RFUMSV00 - Advance Return for Tax on Sales/PurchasesThis documentation is copyright by SAP AG.
LRAW data still in EBCDIC in file D010S af ter migration
Hi,We just finished reimporting to make sure we gathered the statitics
correctly for ourselves.
Our AS/400 DB is 61 gig. It took 19:40 hrs to export on a 2-way S20.
The NT-MSSQL DB is 55 gig. It took 11 hrs to import on a 2-way
933mhz 2gig ram Super-micro w/ 4 raid IDE drives.
There was also 4:30 hrs to FTP the data across our 16M token ring
network.
Phillip Pugh
Webco Industries
--- In SAP on System iZy..., "Anderson, Doreen" <dandersoZb...> wrote:
> What was the size of your EBCDIC r3<SID>data library before the
migration?
> How many hrs/days did the export take?
> What is the size of your NT DB now?
>
> Doreen Anderson
> Ball Horticultural Company
> dandersoZb...
> (630) 231-3600 x3214
>
>
> -----Original Message-----
> From: welchraider [mailto:ppughZw...]
> Sent: Wednesday, February 27, 2002 3:51 PM
> To: SAP on System iZy...
> Subject: Re: LRAW data still in EBCDIC in file D010S
af ter migration
>
> Hi Volker,
>
> Just to let you know it really is possible to migrate from the
AS/400
> to NT. After upgrading our kernel lib & r3install lib to 40B_COM +
> latest patches, The export worked without problems.
>
> Not that the Data Base import went without problem, but almost all
> solutions were found in OSS notes. The important lesson is to READ
> the notes. Then READ them again. If that doesn't work READ them
> anyway, maybe by the 3rd or 4th read it starts making sense that it
> is a solution to your problem.
>
> It looks like we might leave the AS/400's afterall. But when a 2-
way
> PC built for $1500 worth of parts can out perform a S20 that cost
> $300,000+ the migration starts to make sense.
>
> Thanks for your help.
>
> Phillip Pugh
> Webco Industries, Inc.
>
> --- In SAP on System iZy..., "Gueldenpfennig, Volker"
> <volker.gueldenpfennigZs...> wrote:
> > Hi,
> >
> > R3SETUP spawns a lot R3LOADs. They let you know in the export
file
> how they
> > were called:
> > e.g.
> >
> > # R3load version Z(#) $Id: //bas/46D/src/ins/R3load/R3load.c#11 $
> SAP
> > # Jobno/Jobuser/Jobname: "390558/D030451/QPADEV000J"
> > # GEN46DEDB2/R3LOADDB4 -e /tmp/r3load/ZMARA_MBEW.CMD -p
> > /tmp/r3load/ZMARA_MBEW_export.LOG.txt -M AS400
> >
> > "-M AS400" means it is on AS/400 and has to become converted
during
> export
> > from ebcdic to ascii. This ONLY happens during the export. The
dump-
> files
> > are always in ASCII. It is not supported with EBCDIC DUMP-files
to
> convert
> > to ASCII during import.
> >
> > What happens on the NT site if you issue the following SQL ?
> > SELECT PROG, R3STATE FROM d010s
> > Is it correct then ?
> >
> > As D021S is similar to D010S, I really have no clou at the
moment.
> I think,
> > you would have to open an OSS ticket on this.
> >
> > Regards
> >
> > Volker
> >
> > > -----Original Message-----
> > > From: welchraider [mailto:ppughZw...]
> > > Sent: Mittwoch, 6. Februar 2002 16:56
> > > To: SAP on System iZy...
> > > Subject: Re: LRAW data still in EBCDIC in file
> D010S
> > > after migration
> > >
> > >
> > > Hi Volker,
> > >
> > > The integrity of SAP software is still intact. The older
version
> > > R3LOAD (14) gave us the exact same result.
> > >
> > > It seems to me that there is either a problem with R3LOAD or
> there is
> > > some configuration or a flag in one of the command files or
> something
> > > we need to do different. What tells R3LOAD to do an EBCDIC to
> ASCII
> > > conversion? All the regular data files we've looked at are
> converted
> > > correctly.
> > >
> > > Thanks for your time,
> > >
> > > Phillip Pugh
> > > Webco Industries, Inc.
> > >
>
>
>
> Have a look to our homepage at: http://www.consolut.net
> SAP on System i-unsubscribeZy...
>
> Your use of consolut is subject to
http://www.consolut.net
Durban Tours - Südafrika Safari
PERFORM Short Reference PERFORM Short Reference
This documentation is copyright by SAP AG.
Length: 5199 Date: 20240425 Time: 061541 sap01-206 ( 2 ms )