Ansicht
Dokumentation
03504 - DB2 Locking
CL_GUI_FRONTEND_SERVICES - Frontend Services Fill RESBD Structure from EBP Component StructureThis documentation is copyright by SAP AG.
DB2 Locking
We use ODBC for a wharehouse application (scanning and printing shippinglables).
The overhead is not noticable, but we are reading and writing to customer
'Z' tables.
Any chance they can get the tables they need from your backup tapes??
I do not think you would want to be copying large amounts of data from you
sap production files. Perhaps someone else on this forum is doing that
and can give you a better idea of the impact on the system.
Charlie
> -----Original Message-----
> From: Mike Martin, IS, Sousa [SMTP:MMartinZa...]
> Sent: Tuesday, October 16, 2001 1:16 PM
> To: SAP - AS/400 List (E-mail)
> Subject: DB2 Locking
>
> I have a general question for the group. Our data warehouse team is
> recommending that we use ODBC access to read and download SAP production
> table data to an SQL server. My thoughts are that this isn't a very good
> idea, yet I need your help to clarify and define objections (and quickly
> if
> possible...the train is moving very fast in this wrong direction!).
>
> First, the memory of the 400 will be used for the ODBC queries outside of
> SAP's memory management which could force swapping and invalidations of
> SAP
> memory objects. Second, I've heard that while long reads are occurring on
> these tables, data cannot be updated (if the read is using an index, for
> example). I'm not certain if this is true, but I think that someone on
> this
> list will definitely know. Third, I am uncertain of the overhead on
> communications, disk subsystems, memory, etc, of ODBC access. I thought
> one
> of you would know that as well. Lastly, almost all system monitoring,
> etc,
> currently occurs in SAP, whereas this proposal would force more monitoring
> on AS/400 server level.
>
> Any clarification on the above objections are greatly appreciated. Also,
> any other benefits/downsides that I haven't considered?
>
> Thanks in advance,
> Mike D. Martin
> SAP Basis Administrator
> AO*SOLA
> 707-763-9911 x6106
> email: <mailto:mmartinZs...>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> The group has decided in January 2000
> to be free of recruiting and other SPAM!
> Violaters will be banned from the group.
>
> SAP on System i-unsubscribeZegroups.com
>
>
>
> Your use of consolut is subject to http://www.consolut.net
>
Durban Tours - Südafrika Safari
General Data in Customer Master Addresses (Business Address Services)
This documentation is copyright by SAP AG.
Length: 3483 Date: 20240425 Time: 090130 sap01-206 ( 3 ms )
