Re: Is there a forum for SAP R/3 customers using Informix ?

Mario, you are a lucky guy ! You have a system to your technical group, its a dream ! We have SAP R/3.0F running in a SUN cluster with Solaris 2.5.1 and Informix 7.23 with Production, Q&A and Development systems. Since R/3 implementation started, SAP showed us how obscure the sizing and configuration process are ! The available documentation is not enough to answer a lot of questions regarding cpu, disk and memory sizing. Just do what SAP is recommending ... When you ask what is the best practice to table allocation they recommend to use default settings. What is your main source of information ? (Web sites, books, etc.) It=B4s a good idea to create a forum or a user group for Informix DBA=B4s supporting R/3. Regards. At 14:44 14/01/99 -0800, MOPSOMER@raychem.com wrote: > Hi, > > Does anyone know of a forum (e.g. user groups, internet sites or > even books) for Informix DBAs supporting SAP R/3 ? As SAP R/3 is > quite popular, I think there should be a number of Informix DBAs > who struggle with the same problems and questions ? I find the > topics covered in this informix-list very useful, but the majority > of the topics are not really relevant for SAP R/3 environments. > > The following things make an SAP/Informix site a bit different : > - you get the database schema with the SAP R/3 application, > - the standard SAP 4.x schema contains over 10,000 tables & views, > - after the SAP installation, you already have a DB of several GB, > - the database objects are created with the ABAP/4 WorkBench, > - SAP uses its own object locking methods on top of IFMX locking, > - SAP defines referential integrity without using IFMX features, > - the programs are written in the ABAP/4 language (so no ESQL/C), > - the SQL which is normally used in the ABAP/4 programs is Open SQL > which is quite different from Informix SQL and even ANSI-SQL, > - you can not use all IFMX features [e.g. expression-based fragm.], > - you have to use the SAP utilities for most db-related activities, > - etcetera > > Kind regards, > Mario Opsomer > SAP BC / Informix Support > RAYCHEM N.V. > > Raychem runs a worldwide single SAP system with 3,000 users, spread > over the US and Europe. Our production database is 300 GB and we > still grow with 3 GB per week. We use a SUN E6000 with 18 CPUs and > 5.5 GB RAM as DB server and 8 application servers (SUN E4000s with > 8 CPUs and 2GB RAM each). Not all Raychem plants are on SAP yet, > so these numbers could still increase. Except for this production > system, we also have a QA system (a copy of the production db), a > development system, a training system and a system for the > technical group to which I belong. We use SAP FI, SD, MM, PP, HR. > S=E9rgio Vianna Tecnologia de Informa=E7=E3o CSPC (011) 4745-5654

In article <77lj9a$fuc$1@news.xmission.com>, Sérgio Vianna <svianna@fb.suzano.com.br> writes > >Mario, > you are a lucky guy ! You have a system to your technical group, its a >dream ! >We have SAP R/3.0F running in a SUN cluster with Solaris 2.5.1 and Informix >7.23 with Production, Q&A and Development systems. >Since R/3 implementation started, SAP showed us how obscure the sizing and >configuration process are ! >The available documentation is not enough to answer a lot of questions >regarding cpu, disk and memory sizing. Just do what SAP is recommending ... >When you ask what is the best practice to table allocation they recommend >to use default settings. >What is your main source of information ? (Web sites, books, etc.) >It=B4s a good idea to create a forum or a user group for Informix DBA=B4s >supporting R/3. >Regards. > I'd like to add an appendix to the FAQ to cover SAP since it is such a popular system. Please pass on any info you have... >At 14:44 14/01/99 -0800, MOPSOMER@raychem.com wrote: >> Hi, >> >> Does anyone know of a forum (e.g. user groups, internet sites or >> even books) for Informix DBAs supporting SAP R/3 ? As SAP R/3 is >> quite popular, I think there should be a number of Informix DBAs >> who struggle with the same problems and questions ? I find the >> topics covered in this informix-list very useful, but the majority >> of the topics are not really relevant for SAP R/3 environments. >> >> The following things make an SAP/Informix site a bit different : >> - you get the database schema with the SAP R/3 application, >> - the standard SAP 4.x schema contains over 10,000 tables & views, >> - after the SAP installation, you already have a DB of several GB, >> - the database objects are created with the ABAP/4 WorkBench, >> - SAP uses its own object locking methods on top of IFMX locking, >> - SAP defines referential integrity without using IFMX features, >> - the programs are written in the ABAP/4 language (so no ESQL/C), >> - the SQL which is normally used in the ABAP/4 programs is Open SQL >> which is quite different from Informix SQL and even ANSI-SQL, >> - you can not use all IFMX features [e.g. expression-based fragm.], >> - you have to use the SAP utilities for most db-related activities, >> - etcetera >> >> Kind regards, >> Mario Opsomer >> SAP BC / Informix Support >> RAYCHEM N.V. >> >> Raychem runs a worldwide single SAP system with 3,000 users, spread >> over the US and Europe. Our production database is 300 GB and we >> still grow with 3 GB per week. We use a SUN E6000 with 18 CPUs and >> 5.5 GB RAM as DB server and 8 application servers (SUN E4000s with >> 8 CPUs and 2GB RAM each). Not all Raychem plants are on SAP yet, >> so these numbers could still increase. Except for this production >> system, we also have a QA system (a copy of the production db), a >> development system, a training system and a system for the >> technical group to which I belong. We use SAP FI, SD, MM, PP, HR. >> >S=E9rgio Vianna >Tecnologia de Informa=E7=E3o >CSPC >(011) 4745-5654 > -- David Williams