Ansicht
Dokumentation

05249 - LRAW data still in EBCDIC in file D010S af ter migration

05249 - LRAW data still in EBCDIC in file D010S af ter migration

General Data in Customer Master   BAL Application Log Documentation  
This documentation is copyright by SAP AG.
SAP E-Book

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

Vendor Master (General Section)   CL_GUI_FRONTEND_SERVICES - Frontend Services  
This documentation is copyright by SAP AG.

Length: 5199 Date: 20240221 Time: 203701     sap01-206 ( 3 ms )