Save 
Join IIUG
 for   
 

Informix News
18 Nov 13 - ZDNet - Top 20 mobile skills in demand... Read
09 Sep 13 - telecompaper - Shaspa and Tatung have shown a new smart home platform at Ifa in Berlin. Powered by the IBM Informix software... Read
06 Sep 13 - IBM data magazine - Mission Accomplished - Miami, Florida will be the backdrop for the 2014 IIUG Informix Conference... Read
01 Feb 13 - IBM Data Magazine - Are your database backups safe? Lester Knutsen (IBM Champion) writes about database back up safety using "archecker"... Read
14 Nov 12 - IBM - IBM's Big Data For Smart Grid Goes Live In Texas... Read
3 Oct 12 - The Financial - IBM and TransWorks Collaborate to Help Louisiana-Pacific Corporation Achieve Supply Chain Efficiency... Read
28 Aug 12 - techCLOUD9 - Splunk kicks up a SaaS Storm... Read
10 Aug 12 - businessCLOUD9 - Is this the other half of Cloud monitoring?... Read
3 Aug 12 - IBM data management - Supercharging the data warehouse while keeping costs down IBM Informix Warehouse Accelerator (IWA) delivers superior performance for in-memory analytics processing... Read
2 Aug 12 - channelbiz - Oninit Group launches Pay Per Pulse cloud-based service... Read
28 May 12 - Bloor - David Norfolk on the recent Informix benchmark "pretty impressive results"... Read
23 May 12 - DBTA - Informix Genero: A Way to Modernize Informix 4GL Applications... Read
9 Apr 12 - Mastering Data Management - Upping the Informix Ante: Advanced Data Tools... Read
22 Mar 12 - developerWorks - Optimizing Informix database access... Read
14 Mar 12 - BernieSpang.com - International Informix User Group set to meet in San Diego... Read
1 Mar 12 - IBM Data Management - IIUG Heads West for 2012 - Get ready for sun and sand in San Diego... Read
1 Mar 12 - IBM Data Management - Running Informix on Solid-State Drives.Speed Up Database Access... Read
26 Feb 12 - BernieSpan.com - Better results, lower cost for a broad set of new IBM clients and partners... Read
24 Feb 12 - developerWorks - Informix Warehouse Accelerator: Continuous Acceleration during Data Refresh... Read
6 Feb 12 - PRLOG - Informix port delivers unlimited database scalability for popular SaaS application ... Read
2 Feb 12 - developerWorks - Loading data with the IBM Informix TimeSeries Plug-in for Data Studio... Read
1 Feb 12 - developerWorks - 100 Tech Tips, #47: Log-in to Fix Central... Read
13 Jan 12 - MC Press online - Informix Dynamic Server Entices New Users with Free Production Edition ... Read
11 Jan 12 - Computerworld - Ecologic Analytics and Landis+Gyr -- Suitors Decide to Tie the Knot... Read
9 Jan 12 - planetIDS.com - DNS impact on Informix / Impacto do DNS no Informix... Read
8 Sep 11 - TMCnet.com - IBM Offers Database Solution to Enable Smart Meter Data Capture... Read
1 Aug 11 - IBM Data Management Magazine - IIUG user view: Happy 10th anniversary to IBM and Informix... Read
8 Jul 11 - Database Trends and Applications - Managing Time Series Data with Informix... Read
31 May 11 - Smart Grid - The meter data management pitfall utilities are overlooking... Read
27 May 11 - IBM Data Management Magazine - IIUG user view: Big data, big time ( Series data, warehouse acceleration, and 4GLs )... Read
16 May 11 - Business Wire - HiT Software Announces DBMoto for Enterprise Integration, Adds Informix. Log-based Change Data Capture... Read
21 Mar 11 - Yahoo! Finance - IBM and Cable&Wireless Worldwide Announce UK Smart Energy Cloud... Read
14 Mar 11 - MarketWatch - Fuzzy Logix and IBM Unveil In-Database Analytics for IBM Informix... Read
11 Mar 11 - InvestorPlace - It's Time to Give IBM Props: How many tech stocks are up 53% since the dot-com boom?... Read
9 Mar 11 - DBTA - Database Administration and the Goal of Diminishing Downtime... Read
2 Feb 11 - DBTAs - Informix 11.7 Flexible Grid Provides a Different Way of Looking at Database Servers... Read
27 Jan 11 - exactsolutions - Exact to Add Informix Support to Database Replay, SQL Monitoring Solutions... Read
25 Jan 11 - PR Newswire - Bank of China in the UK Works With IBM to Become a Smarter, Greener Bank... Read
12 Oct 10 - Database Trends and Applications - Informix 11.7: The Beginning of the Next Decade of IBM Informix... Read
20 Sep 10 - planetIDS.com - ITG analyst paper: Cost/Benefit case for IBM Informix as compared to Microsoft SQL Server... Read
20 Jul 10 - IBM Announcements - IBM Informix Choice Edition V11.50 helps deploy low-cost scalable and reliable solutions for Apple Macintosh and Microsoft Windows... Read
20 Jul 10 - IBM Announcements - Software withdrawal: Elite Support for Informix Ultimate-C Edition... Read
24 May 10 - eWeek Europe - IBM Supplies Database Tech For EU Smart Grid... Read
23 May 10 - SiliconIndia - IBM's smart metering system allows wise use of energy... Read
21 May 10 - CNET - IBM to help people monitor energy use... Read
20 May 10 - ebiz - IBM Teams With Hildebrand To Bring Smart Metering To Homes Across Britain... Read
19 May 10 - The New Blog Times - Misurare il consumo energetico: DEHEMS è pronto... Read
19 May 10 - ZDNet - IBM software in your home? Pact enables five-city smart meter pilot in Europe... Read
17 March 10 - ZDNet (blog) David Morgenstern - TCO: New research finds Macs in the enterprise easier, cheaper to manage than... Read
17 March 2010 - Virtualization Review - ...key components of Big Blue's platform to the commercial cloud such as its WebSphere suite of application ser vers and its DB2 and Informix databases... Read
10 February 2010 - The Wall Street Journal - International Business Machines is expanding an initiative to win over students and professors on its products. How do they lure the college crowd?... Read


End of Support Dates

IIUG on Facebook IIUG on Twitter

RSS Feed: IIUG Forum: Sapmix

More IIUG RSS Feeds

Sapmix is a discussion forum for the use of Informix products with the SAP product.


URL: http://www.iiug.org/rss/sapmix.rss

Below is the latest content available from this feed:

RE: SAP 4.5B - Certified with Informix 11.50?
Posted by: christian.knappke@sap.com (Knappke, Christian) - Fri, 13 Nov 2009 03:31:46 EST
Jeff Filippi wrote on Thursday, November 12, 2009 8:22 PM

> I have a customer who is running SAP 4.5B on Informix 7.30.
>
> Question, is Informix 11.50 certified to run with SAP 4.5B?

Dear Jeff,

the support of rel. 4.5B depends on the support contract you customer has with
SAP, as rel 4.5B is out of mainstream maintenance. The only public information
you get regarding Informix 11.50 and supported SAP releases is (from
http://sdn.sap.com/irj/sdn/inf):

"... released for SAP products based on the kernels 46D_EXT, 46D_EX2, 640, and
640_EX2. This includes, for example, SAP R/3 4.6C, SAP R/3 Enterprise 4.7, SAP
Netweaver 2004, and SAP Business Suite 2004."

I have a rel. 4.0B system running on 11.50 (together with a NW04 on the same
server, BTW). This is an indicator that 4.5B may run, too. But it is no
commitment by SAP that it is supported in a production environment.

I suggest that your customer asks SAP Support. The right message component is
BC-DB-INF.

Best regards
Christian

--
#include <std_disclaimer.h>
/* The opinions stated above are my own and not

necessarily those of my employer. */




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to sapmix@iiug.org
2. Include the bracketed message number in the subject line: [584]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

RE: SAP 4.5B - Certified with Informix 11.50?
Posted by: rtse@btinternet.com (Robert Tse) - Thu, 12 Nov 2009 22:03:17 EST
Correction.

SAP is still supporting Informix to run for some of the SAP releases, but
not the latest (ERP 6.0).

Further information - http://www.sdn.sap.com/irj/sdn/inf

-----Original Message-----
From: Robert Tse [mailto:rtse@btinternet.com]
Sent: 13 November 2009 10:35
To: 'jeff.filippi@itdataconsulting.com'; 'sapmix@iiug.org'
Subject: RE: SAP 4.5B - Certified with Informix 11.50? [580]

Hi Jeff,

No, Informix 11.50 is not certified to run with SAP 4.5B

SAP is no longer supporting Informix to run with any SAP products. Customer
should migrate the database to DB2 or Oracle or MS SQL. You will need a SAP
OS/DB Migration Consultant to do the migration.

If the customer wants to use the latest version of SAP, they must migrate to
another database software, then upgrade the SAP to the latest version (SAP
ERP 6.0).

If you need any helps on that please let me know, I can recommend a
consulting company who specialized in SAP.

Regards,

Robert
-----Original Message-----
From: sapmix-bounces@iiug.org [mailto:sapmix-bounces@iiug.org] On Behalf Of
Jeff Filippi
Sent: 13 November 2009 03:22
To: sapmix@iiug.org
Subject: SAP 4.5B - Certified with Informix 11.50? [580]

I have a customer who is running SAP 4.5B on Informix 7.30.

Question, is Informix 11.50 certified to run with SAP 4.5B?

Does anyone know where I can find out what Informix version is certified
with SAP versions?

Thanks, Jeff

Jeffrey J. Filippi

Integrated Data Consulting, LLC

104 Cottonwood Dr.

Streamwood, IL 60107

630-842-3608

630-497-1762 (Fax)

jeff.filippi@itdataconsulting.com

www.itdataconsulting.com

IBM BUSINESS PARTNER

Cert-Info-Mgmt_color

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
***





* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to sapmix@iiug.org
2. Include the bracketed message number in the subject line: [583]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

RE: SAP 4.5B - Certified with Informix 11.50?
Posted by: rtse@btinternet.com (Robert Tse) - Thu, 12 Nov 2009 21:47:28 EST
Hi Jeff,

No, Informix 11.50 is not certified to run with SAP 4.5B

SAP is no longer supporting Informix to run with any SAP products. Customer
should migrate the database to DB2 or Oracle or MS SQL. You will need a SAP
OS/DB Migration Consultant to do the migration.

If the customer wants to use the latest version of SAP, they must migrate to
another database software, then upgrade the SAP to the latest version (SAP
ERP 6.0).

If you need any helps on that please let me know, I can recommend a
consulting company who specialized in SAP.

Regards,

Robert
-----Original Message-----
From: sapmix-bounces@iiug.org [mailto:sapmix-bounces@iiug.org] On Behalf Of
Jeff Filippi
Sent: 13 November 2009 03:22
To: sapmix@iiug.org
Subject: SAP 4.5B - Certified with Informix 11.50? [580]

I have a customer who is running SAP 4.5B on Informix 7.30.

Question, is Informix 11.50 certified to run with SAP 4.5B?

Does anyone know where I can find out what Informix version is certified
with SAP versions?

Thanks, Jeff

Jeffrey J. Filippi

Integrated Data Consulting, LLC

104 Cottonwood Dr.

Streamwood, IL 60107

630-842-3608

630-497-1762 (Fax)

jeff.filippi@itdataconsulting.com

www.itdataconsulting.com

IBM BUSINESS PARTNER

Cert-Info-Mgmt_color

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
***





* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to sapmix@iiug.org
2. Include the bracketed message number in the subject line: [582]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: SAP 4.5B - Certified with Informix 11.50?
Posted by: udayk@us.ibm.com (Uday Kale) - Thu, 12 Nov 2009 19:32:54 EST
Hi Jeff,

SAP R/3 4.6C is certified with 11.50, and the Platform Availability Mat=
rix
on SAP website should be up-to-date with the certification info.

Regds,
Uday.

---------------------------------------------------
Uday Kale

E-Mail : udayk@us.ibm.com
Informix SQL Development
SAP IDS Development Lab Advocate
IBM Information Management Group

---------------------------------------------------

|------------>
| From: |
|------------>
>--------------------------------------------------------------------=
-----------------------------------------------------------------------=
-------|
|"Jeff Filippi" <jeff.filippi@itdataconsulting.com> =

=

|
>--------------------------------------------------------------------=
-----------------------------------------------------------------------=
-------|
|------------>
| To: |
|------------>
>--------------------------------------------------------------------=
-----------------------------------------------------------------------=
-------|
|sapmix@iiug.org =

=

|
>--------------------------------------------------------------------=
-----------------------------------------------------------------------=
-------|
|------------>
| Date: |
|------------>
>--------------------------------------------------------------------=
-----------------------------------------------------------------------=
-------|
|11/12/2009 01:22 PM =

=

|
>--------------------------------------------------------------------=
-----------------------------------------------------------------------=
-------|
|------------>
| Subject: |
|------------>
>--------------------------------------------------------------------=
-----------------------------------------------------------------------=
-------|
|SAP 4.5B - Certified with Informix 11.50? [580] =

=

|
>--------------------------------------------------------------------=
-----------------------------------------------------------------------=
-------|
|------------>
| Sent by: |
|------------>
>--------------------------------------------------------------------=
-----------------------------------------------------------------------=
-------|
|sapmix-bounces@iiug.org =

=

|
>--------------------------------------------------------------------=
-----------------------------------------------------------------------=
-------|

I have a customer who is running SAP 4.5B on Informix 7.30.

Question, is Informix 11.50 certified to run with SAP 4.5B?

Does anyone know where I can find out what Informix version is certifie=
d
with SAP versions?

Thanks, Jeff

Jeffrey J. Filippi

Integrated Data Consulting, LLC

104 Cottonwood Dr.

Streamwood, IL 60107

630-842-3608

630-497-1762 (Fax)

jeff.filippi@itdataconsulting.com

www.itdataconsulting.com

IBM BUSINESS PARTNER

Cert-Info-Mgmt_color

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ***=
* * * * * * * *



=




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to sapmix@iiug.org
2. Include the bracketed message number in the subject line: [581]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

SAP 4.5B - Certified with Informix 11.50?
Posted by: jeff.filippi@itdataconsulting.com (Jeff Filippi) - Thu, 12 Nov 2009 14:21:43 EST
I have a customer who is running SAP 4.5B on Informix 7.30.

Question, is Informix 11.50 certified to run with SAP 4.5B?

Does anyone know where I can find out what Informix version is certified
with SAP versions?

Thanks, Jeff

Jeffrey J. Filippi

Integrated Data Consulting, LLC

104 Cottonwood Dr.

Streamwood, IL 60107

630-842-3608

630-497-1762 (Fax)

jeff.filippi@itdataconsulting.com

www.itdataconsulting.com

IBM BUSINESS PARTNER

Cert-Info-Mgmt_color




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to sapmix@iiug.org
2. Include the bracketed message number in the subject line: [580]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Cannot read blob
Posted by: cvazquez@urrea.com.mx (CARLOS EDUARDO VAZQUEZ PRIETO) - Wed, 15 Aug 2007 10:42:02 EDT
Hi Dave!

We used the SAP note 163635 "To unload corrupt Blobs".

In our case the Table with the failure was rfblg, so step by step:

Note: use dbaccess -X

1.- First We find the wrong ROWID
with the command: oncheck -cD <sid>:<table>

in our case: oncheck -cD PRD:rfblg

we find in the result of oncheck, lines with the text:
Error:bstamp for rowid 0x1bd110d -> hexadecimal to decimal (29167885)
Error:bstamp for rowid 0x1bd110e -> hexadecimal to decimal (29167886)
etc.

2.- dbschema -d PRD -t rfblg -ss dbschema_rfblg.txt

3.- unloading non-corrupt data records

We create a tmp table using the dbschema:

create table "sapr3".rfblg_tmp
(

) in <same dbspace>

Note: Disable the logging with SAPDBA

4.- Insert in the new table the records without the wrong rowids:
in our case:

insert into "sapr3".rfblg_tmp SELECT * from sapr3.rfblg where (rowid!=
29167885 and rowid!= 29167886);

For reasons of performance indexes and constraints should be disabled

set constraints/indexes for rfblg_tmp disabled;

5.-Drop the table

drop table "sapr3".rfblg;

6.- Rename the new table

rename table rfblg_tmp to rfblg;

7.- Enable the indexes:

set constraints/indexes for rfblg_tmp enabled;

Note: Enable the logging with SAPDBA

Best Regards

Carlos Eduardo Vazquez Prieto
Administrador SAP




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to sapmix@iiug.org
2. Include the bracketed message number in the subject line: [579]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Cannot read blob
Posted by: dbeecher@tekops.com (DAVID BEECHER) - Wed, 15 Aug 2007 00:08:41 EDT
We had a catastrophic h/w failure, lost a database and did a restore, level 0
successfully. When we started it up we ran into inconsistencies in a table
with blobs. Did an oncheck -cD ... as directed from logs and got the same
error a few dozen times surrounded by thousands of:

PBLOB piece used more than once - id 5aec5f01
PBLOB piece used more than once - id 5aec6001
PBLOB piece used more than once - id 5aec6101
PBLOB piece used more than once - id 5aec6201
PBLOB piece used more than once - id 5aec6301
PBLOB piece used more than once - id 5aec6401
PBLOB piece used more than once - id 5aec6501
PBLOB piece used more than once - id 5aec6601

Did you ever find a solution?

Thanks,
Dave




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to sapmix@iiug.org
2. Include the bracketed message number in the subject line: [578]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

RE: sapmix Forum and Informix Forum @ sdn.sap.com
Posted by: Ashley.Williams@ap.o-i.com (Ashley.Williams@ap.o-i.com) - Sun, 25 Mar 2007 19:08:36 EST
We are another - except Oracle. We went live April 2006 with R/3, but BW
is still IDS - at the moment

I often miss Informix elegance, no-nonsense commands, ease of management .
.. . . . . . .

regards

"Sebastian, Norma J." <NormaJean.Sebastian@tellabs.com>
Sent by: sapmix-bounces@iiug.org
20-03-2007 09:41 AM
Please respond to
NormaJean.Sebastian@tellabs.com

To
sapmix@iiug.org
cc

Subject
RE: sapmix Forum and Informix Forum @ sdn.sap.com [576]

Java!!! I thought that was it, but I forgot...

Who's your certified DB migration partner?

At least IBM is so big it is almost like they are focusing on 1 platform
not 2. besides, depending on which sales rep you get, they might not
know informix is a product. I guess we have to be understanding cuz I'm
sure a good number of the sales people lived and breathed DB2 long
before informix came along.
If informix were fully supported, we'd 100% stay with it. And highly
likely we'd migrate our BW/Oracle to BW/Informix as well.
However because of unicode and java, we are migrating our BW/Oracle ->
BW/DB2, and R3/Informix -> R3/DB2.

I'm sure Robert didn't mean his query to take off on this tangent, so I
may mail you separately about your migration.

Norma Jean Sebastian
ERP Support Administration
IT - Enterprise Technical Services

-----Original Message-----
From: Randy Barbati [mailto:rbarbati@esri.com]
Sent: Monday, March 19, 2007 5:25 PM
To: Randy Barbati; Sebastian, Norma J.; sapmix@iiug.org
Subject: RE: sapmix Forum and Informix Forum @ sdn.sap.com [573]

>> (and something else I forgot)

Java

-----Original Message-----
From: Randy Barbati
Sent: Monday, March 19, 2007 3:22 PM
To: 'NormaJean.Sebastian@tellabs.com'; 'sapmix@iiug.org'
Subject: RE: sapmix Forum and Informix Forum @ sdn.sap.com [573]

Same boat here.
We're in final phases of DB2 go-live.

So far going quite smoothly.

Informix is still probably the more robust engine, but DB2 is doing well
too.
I suppose in the end I'd rather have a vendor (in this case IBM) focus
on one platform than multiples, so it's give and take.
I'll miss good ole Informix !

Randy

-----Original Message-----
From: sapmix-bounces@iiug.org [mailto:sapmix-bounces@iiug.org] On Behalf
Of Sebastian, Norma J.
Sent: Monday, March 19, 2007 8:01 AM
To: sapmix@iiug.org
Subject: RE: sapmix Forum and Informix Forum @ sdn.sap.com [573]

My 2 cents.....

1) there are not that many problems - informix is a great great product.

2) SAP's direction is unicode (and something else I forgot). Last I
knew we can't do SAP/unicode on Informix.

Either way, it's too late for us.... We got stung by the lack of IBM
direction which also possibly confused SAP... And therefore SAP would
rather we were on DB2 than Informix.... So we are going unicode on DB2
in preparation for our next SAP upgrade.

I would so much rather stay on Informix..... But at least we're not
going to Oracle.

Thanks,

Norma Jean Sebastian
ERP Support Administration
IT - Enterprise Technical Services

-----Original Message-----
From: sapmix-bounces@iiug.org [mailto:sapmix-bounces@iiug.org] On Behalf

Of ROBERT SEIFERT
Sent: Saturday, March 03, 2007 5:10 AM
To: sapmix@iiug.org
Subject: sapmix Forum and Informix Forum @ sdn.sap.com [572]

Dear sapmixers,

If not already known, SAP has been released a 'SAP on Informix(INF)'
forum on
SAP SDN (since Nov 2006).

The related URL is http://www.sdn.sap.com/irj/sdn/forum?forumID=188

Since on the IIUG sapmix forum as same as on the mentioned sap sdn forum

were
not much threads seen so far. So I am wondering whether there are not
much
problems etc. to be discussed to be reported in the mentioned forums.
Please
feel free to add your point of view on this.

Thanks, Robert

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

* * * * ***


_______________________________________________
sapmix mailing list
sapmix@iiug.org
http://www.iiug.org/mailman/listinfo/sapmix
============================================================
The information contained in this message may be privileged
and confidential and protected from disclosure. If the reader
of this message is not the intended recipient, or an employee
or agent responsible for delivering this message to the
intended recipient, you are hereby notified that any reproduction,
dissemination or distribution of this communication is strictly
prohibited. If you have received this communication in error,
please notify us immediately by replying to the message and
deleting it from your computer. Thank you. Tellabs
============================================================

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* * * * ***


_______________________________________________
sapmix mailing list
sapmix@iiug.org
http://www.iiug.org/mailman/listinfo/sapmix
============================================================
The information contained in this message may be privileged
and confidential and protected from disclosure. If the reader
of this message is not the intended recipient, or an employee
or agent responsible for delivering this message to the
intended recipient, you are hereby notified that any reproduction,
dissemination or distribution of this communication is strictly
prohibited. If you have received this communication in error,
please notify us immediately by replying to the message and
deleting it from your computer. Thank you. Tellabs
============================================================






_______________________________________________
sapmix mailing list
sapmix@iiug.org
http://www.iiug.org/mailman/listinfo/sapmix


***

Caution - This email and its content contain privileged information
that is intended solely for the recipient. If you are not the intended
recipient you are hereby notified that any use, dissemination,
distribution or reproduction of this email is prohibited. If you have
received this email in error please notify the Postmaster at
postmaster@ap.o-i.com immediately. Any views expressed
in this email are of the sender and may not necessarily reflect the
views of O-I Asia Pacific.


***




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to sapmix@iiug.org
2. Include the bracketed message number in the subject line: [577]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

RE: sapmix Forum and Informix Forum @ sdn.sap.com
Posted by: NormaJean.Sebastian@tellabs.com (Sebastian, Norma J.) - Mon, 19 Mar 2007 17:41:44 EST
Java!!! I thought that was it, but I forgot...

Who's your certified DB migration partner?

At least IBM is so big it is almost like they are focusing on 1 platform
not 2. besides, depending on which sales rep you get, they might not
know informix is a product. I guess we have to be understanding cuz I'm
sure a good number of the sales people lived and breathed DB2 long
before informix came along.
If informix were fully supported, we'd 100% stay with it. And highly
likely we'd migrate our BW/Oracle to BW/Informix as well.
However because of unicode and java, we are migrating our BW/Oracle ->
BW/DB2, and R3/Informix -> R3/DB2.

I'm sure Robert didn't mean his query to take off on this tangent, so I
may mail you separately about your migration.

Norma Jean Sebastian
ERP Support Administration
IT - Enterprise Technical Services

-----Original Message-----
From: Randy Barbati [mailto:rbarbati@esri.com]
Sent: Monday, March 19, 2007 5:25 PM
To: Randy Barbati; Sebastian, Norma J.; sapmix@iiug.org
Subject: RE: sapmix Forum and Informix Forum @ sdn.sap.com [573]

>> (and something else I forgot)

Java

-----Original Message-----
From: Randy Barbati
Sent: Monday, March 19, 2007 3:22 PM
To: 'NormaJean.Sebastian@tellabs.com'; 'sapmix@iiug.org'
Subject: RE: sapmix Forum and Informix Forum @ sdn.sap.com [573]

Same boat here.
We're in final phases of DB2 go-live.

So far going quite smoothly.

Informix is still probably the more robust engine, but DB2 is doing well
too.
I suppose in the end I'd rather have a vendor (in this case IBM) focus
on one platform than multiples, so it's give and take.
I'll miss good ole Informix !

Randy

-----Original Message-----
From: sapmix-bounces@iiug.org [mailto:sapmix-bounces@iiug.org] On Behalf
Of Sebastian, Norma J.
Sent: Monday, March 19, 2007 8:01 AM
To: sapmix@iiug.org
Subject: RE: sapmix Forum and Informix Forum @ sdn.sap.com [573]

My 2 cents.....

1) there are not that many problems - informix is a great great product.

2) SAP's direction is unicode (and something else I forgot). Last I
knew we can't do SAP/unicode on Informix.

Either way, it's too late for us.... We got stung by the lack of IBM
direction which also possibly confused SAP... And therefore SAP would
rather we were on DB2 than Informix.... So we are going unicode on DB2
in preparation for our next SAP upgrade.

I would so much rather stay on Informix..... But at least we're not
going to Oracle.

Thanks,

Norma Jean Sebastian
ERP Support Administration
IT - Enterprise Technical Services

-----Original Message-----
From: sapmix-bounces@iiug.org [mailto:sapmix-bounces@iiug.org] On Behalf

Of ROBERT SEIFERT
Sent: Saturday, March 03, 2007 5:10 AM
To: sapmix@iiug.org
Subject: sapmix Forum and Informix Forum @ sdn.sap.com [572]

Dear sapmixers,

If not already known, SAP has been released a 'SAP on Informix(INF)'
forum on
SAP SDN (since Nov 2006).

The related URL is http://www.sdn.sap.com/irj/sdn/forum?forumID=188

Since on the IIUG sapmix forum as same as on the mentioned sap sdn forum

were
not much threads seen so far. So I am wondering whether there are not
much
problems etc. to be discussed to be reported in the mentioned forums.
Please
feel free to add your point of view on this.

Thanks, Robert

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

* * * * ***


_______________________________________________
sapmix mailing list
sapmix@iiug.org
http://www.iiug.org/mailman/listinfo/sapmix
============================================================
The information contained in this message may be privileged
and confidential and protected from disclosure. If the reader
of this message is not the intended recipient, or an employee
or agent responsible for delivering this message to the
intended recipient, you are hereby notified that any reproduction,
dissemination or distribution of this communication is strictly
prohibited. If you have received this communication in error,
please notify us immediately by replying to the message and
deleting it from your computer. Thank you. Tellabs
============================================================

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* * * * ***


_______________________________________________
sapmix mailing list
sapmix@iiug.org
http://www.iiug.org/mailman/listinfo/sapmix
============================================================
The information contained in this message may be privileged
and confidential and protected from disclosure. If the reader
of this message is not the intended recipient, or an employee
or agent responsible for delivering this message to the
intended recipient, you are hereby notified that any reproduction,
dissemination or distribution of this communication is strictly
prohibited. If you have received this communication in error,
please notify us immediately by replying to the message and
deleting it from your computer. Thank you. Tellabs
============================================================




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to sapmix@iiug.org
2. Include the bracketed message number in the subject line: [576]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

RE: sapmix Forum and Informix Forum @ sdn.sap.com
Posted by: rbarbati@esri.com (Randy Barbati) - Mon, 19 Mar 2007 17:38:41 EST
>> (and something else I forgot)

Java

-----Original Message-----
From: Randy Barbati
Sent: Monday, March 19, 2007 3:22 PM
To: 'NormaJean.Sebastian@tellabs.com'; 'sapmix@iiug.org'
Subject: RE: sapmix Forum and Informix Forum @ sdn.sap.com [573]

Same boat here.
We're in final phases of DB2 go-live.

So far going quite smoothly.

Informix is still probably the more robust engine, but DB2 is doing well
too.
I suppose in the end I'd rather have a vendor (in this case IBM) focus
on one platform than multiples, so it's give and take.
I'll miss good ole Informix !

Randy

-----Original Message-----
From: sapmix-bounces@iiug.org [mailto:sapmix-bounces@iiug.org] On Behalf
Of Sebastian, Norma J.
Sent: Monday, March 19, 2007 8:01 AM
To: sapmix@iiug.org
Subject: RE: sapmix Forum and Informix Forum @ sdn.sap.com [573]

My 2 cents.....

1) there are not that many problems - informix is a great great product.

2) SAP's direction is unicode (and something else I forgot). Last I
knew we can't do SAP/unicode on Informix.

Either way, it's too late for us.... We got stung by the lack of IBM
direction which also possibly confused SAP... And therefore SAP would
rather we were on DB2 than Informix.... So we are going unicode on DB2
in preparation for our next SAP upgrade.

I would so much rather stay on Informix..... But at least we're not
going to Oracle.

Thanks,

Norma Jean Sebastian
ERP Support Administration
IT - Enterprise Technical Services

-----Original Message-----
From: sapmix-bounces@iiug.org [mailto:sapmix-bounces@iiug.org] On Behalf

Of ROBERT SEIFERT
Sent: Saturday, March 03, 2007 5:10 AM
To: sapmix@iiug.org
Subject: sapmix Forum and Informix Forum @ sdn.sap.com [572]

Dear sapmixers,

If not already known, SAP has been released a 'SAP on Informix(INF)'
forum on
SAP SDN (since Nov 2006).

The related URL is http://www.sdn.sap.com/irj/sdn/forum?forumID=188

Since on the IIUG sapmix forum as same as on the mentioned sap sdn forum

were
not much threads seen so far. So I am wondering whether there are not
much
problems etc. to be discussed to be reported in the mentioned forums.
Please
feel free to add your point of view on this.

Thanks, Robert

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

* * * * ***


_______________________________________________
sapmix mailing list
sapmix@iiug.org
http://www.iiug.org/mailman/listinfo/sapmix
============================================================
The information contained in this message may be privileged
and confidential and protected from disclosure. If the reader
of this message is not the intended recipient, or an employee
or agent responsible for delivering this message to the
intended recipient, you are hereby notified that any reproduction,
dissemination or distribution of this communication is strictly
prohibited. If you have received this communication in error,
please notify us immediately by replying to the message and
deleting it from your computer. Thank you. Tellabs
============================================================

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* * * * ***


_______________________________________________
sapmix mailing list
sapmix@iiug.org
http://www.iiug.org/mailman/listinfo/sapmix




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to sapmix@iiug.org
2. Include the bracketed message number in the subject line: [575]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

RE: sapmix Forum and Informix Forum @ sdn.sap.com
Posted by: rbarbati@esri.com (Randy Barbati) - Mon, 19 Mar 2007 17:38:38 EST
Same boat here.
We're in final phases of DB2 go-live.

So far going quite smoothly.

Informix is still probably the more robust engine, but DB2 is doing well
too.
I suppose in the end I'd rather have a vendor (in this case IBM) focus
on one platform than multiples, so it's give and take.
I'll miss good ole Informix !

Randy

-----Original Message-----
From: sapmix-bounces@iiug.org [mailto:sapmix-bounces@iiug.org] On Behalf
Of Sebastian, Norma J.
Sent: Monday, March 19, 2007 8:01 AM
To: sapmix@iiug.org
Subject: RE: sapmix Forum and Informix Forum @ sdn.sap.com [573]

My 2 cents.....

1) there are not that many problems - informix is a great great product.

2) SAP's direction is unicode (and something else I forgot). Last I
knew we can't do SAP/unicode on Informix.

Either way, it's too late for us.... We got stung by the lack of IBM
direction which also possibly confused SAP... And therefore SAP would
rather we were on DB2 than Informix.... So we are going unicode on DB2
in preparation for our next SAP upgrade.

I would so much rather stay on Informix..... But at least we're not
going to Oracle.

Thanks,

Norma Jean Sebastian
ERP Support Administration
IT - Enterprise Technical Services

-----Original Message-----
From: sapmix-bounces@iiug.org [mailto:sapmix-bounces@iiug.org] On Behalf

Of ROBERT SEIFERT
Sent: Saturday, March 03, 2007 5:10 AM
To: sapmix@iiug.org
Subject: sapmix Forum and Informix Forum @ sdn.sap.com [572]

Dear sapmixers,

If not already known, SAP has been released a 'SAP on Informix(INF)'
forum on
SAP SDN (since Nov 2006).

The related URL is http://www.sdn.sap.com/irj/sdn/forum?forumID=188

Since on the IIUG sapmix forum as same as on the mentioned sap sdn forum

were
not much threads seen so far. So I am wondering whether there are not
much
problems etc. to be discussed to be reported in the mentioned forums.
Please
feel free to add your point of view on this.

Thanks, Robert

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

* * * * ***


_______________________________________________
sapmix mailing list
sapmix@iiug.org
http://www.iiug.org/mailman/listinfo/sapmix
============================================================
The information contained in this message may be privileged
and confidential and protected from disclosure. If the reader
of this message is not the intended recipient, or an employee
or agent responsible for delivering this message to the
intended recipient, you are hereby notified that any reproduction,
dissemination or distribution of this communication is strictly
prohibited. If you have received this communication in error,
please notify us immediately by replying to the message and
deleting it from your computer. Thank you. Tellabs
============================================================

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* * * * ***


_______________________________________________
sapmix mailing list
sapmix@iiug.org
http://www.iiug.org/mailman/listinfo/sapmix




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to sapmix@iiug.org
2. Include the bracketed message number in the subject line: [574]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

RE: sapmix Forum and Informix Forum @ sdn.sap.com
Posted by: NormaJean.Sebastian@tellabs.com (Sebastian, Norma J.) - Mon, 19 Mar 2007 10:00:50 EST
My 2 cents.....

1) there are not that many problems - informix is a great great product.
2) SAP's direction is unicode (and something else I forgot). Last I
knew we can't do SAP/unicode on Informix.

Either way, it's too late for us.... We got stung by the lack of IBM
direction which also possibly confused SAP... And therefore SAP would
rather we were on DB2 than Informix.... So we are going unicode on DB2
in preparation for our next SAP upgrade.

I would so much rather stay on Informix..... But at least we're not
going to Oracle.

Thanks,

Norma Jean Sebastian
ERP Support Administration
IT - Enterprise Technical Services

-----Original Message-----
From: sapmix-bounces@iiug.org [mailto:sapmix-bounces@iiug.org] On Behalf
Of ROBERT SEIFERT
Sent: Saturday, March 03, 2007 5:10 AM
To: sapmix@iiug.org
Subject: sapmix Forum and Informix Forum @ sdn.sap.com [572]

Dear sapmixers,

If not already known, SAP has been released a 'SAP on Informix(INF)'
forum on
SAP SDN (since Nov 2006).

The related URL is http://www.sdn.sap.com/irj/sdn/forum?forumID=188

Since on the IIUG sapmix forum as same as on the mentioned sap sdn forum
were
not much threads seen so far. So I am wondering whether there are not
much
problems etc. to be discussed to be reported in the mentioned forums.
Please
feel free to add your point of view on this.

Thanks, Robert

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* * * * ***


_______________________________________________
sapmix mailing list
sapmix@iiug.org
http://www.iiug.org/mailman/listinfo/sapmix
============================================================
The information contained in this message may be privileged
and confidential and protected from disclosure. If the reader
of this message is not the intended recipient, or an employee
or agent responsible for delivering this message to the
intended recipient, you are hereby notified that any reproduction,
dissemination or distribution of this communication is strictly
prohibited. If you have received this communication in error,
please notify us immediately by replying to the message and
deleting it from your computer. Thank you. Tellabs
============================================================




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to sapmix@iiug.org
2. Include the bracketed message number in the subject line: [573]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

sapmix Forum and Informix Forum @ sdn.sap.com
Posted by: robert.seifert@de.ibm.com (ROBERT SEIFERT) - Sat, 03 Mar 2007 06:09:58 EST
Dear sapmixers,

If not already known, SAP has been released a 'SAP on Informix(INF)' forum on
SAP SDN (since Nov 2006).

The related URL is http://www.sdn.sap.com/irj/sdn/forum?forumID=188

Since on the IIUG sapmix forum as same as on the mentioned sap sdn forum were
not much threads seen so far. So I am wondering whether there are not much
problems etc. to be discussed to be reported in the mentioned forums. Please
feel free to add your point of view on this.

Thanks, Robert




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to sapmix@iiug.org
2. Include the bracketed message number in the subject line: [572]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Fragmenting the COEP table
Posted by: deirdre.terlecki@smsc.com (Deirdre) - Fri, 12 Jan 2007 16:48:06 EST
The following e-mail was sent to you via SAP Mix from Deirdre (deirdre.terlecki@smsc.com) at IP address 170.129.50.120 (proxy.smsc.com).



Fragmenting the COEP table

Hello Darrell,
In an old posting on IIUG (sapmix forum)(7/7/2003) you had stated that you had fragemented the COEP table on your HP-UX 11i, Informix 7.31FD2X9 database(with 69 million rows and 44.7 GB). I was hoping I could pick your brain a little about your experience with fragmenting of this table. We are just about to fragment our COEP table on our production server(we too are on HP-UX 11i, Informix 7.31FD2). Our COEP table is nearing the limit of 16m pages. We have been practicing the fragmentation on a sandbox system (with a copy of production) and will be fragmenting to 4 dbspaces and 1 index. We have noticed that the next extent size on the index is affected by the next extent size on the table. And depending on what size we make it, we have seen several extents added to the index. Do you see this on your index? Do you have to drop and recreate the index periodically? Do you even see alot of extents on your index dbspace? Do you have any thoughts on what the next extent size should be for the index? I want to thank you in advance for any insight and help you can provide for us about fragmenting this table.
Best regards,
Deirdre Terlecki
SMSC
Hauppauge, NY 11788




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to sapmix@iiug.org
2. Include the bracketed message number in the subject line: []

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

RE: Backup Performance time & Legato
Posted by: NormaJean.Sebastian@tellabs.com (Sebastian, Norma J.) - Wed, 04 Oct 2006 20:29:37 EDT
Nicole,

I think your biggest problem is :
"1) the database being backed up is physically attached to the tape
drives being used. No other processes are using these tapes.
2) the main networker server is in a different location (another state)"

Sounds like Informix Onbar is passing the dbspace (smallest unit of
work) to the networker server (in another state), and then the networker
server is passing the data back to the server such that it goes to the
tape drives attached to the server.....

If you can change the long trip the data takes to get to the backup
drives.... that would help. Perhaps you can back up the DB on tape
drives in closer proximity to the networker server? Or have another
networker server closer to your DB server to shorten the trip on that
end?

I don't use Legato, I use Symantec Netbackup.
My production database is 1TB (data), my largest DBspace is just over
50GB.
My BAR_MAX_BACKUP is set to 12, and on the netbackup side is tweaked for
performance as well.
We used to complete a backup in 7 hours.
Then we upgraded netbackup infrastructure and changed from going to tape
to disk (aka virtual tape library)....
Now we backup 1 TB of data in just under 4 hours.

Good luck,
Norma Jean

-----Original Message-----
From: sapmix-bounces@iiug.org [mailto:sapmix-bounces@iiug.org] On Behalf
Of Gurnee, Nicole
Sent: Wednesday, October 04, 2006 12:15 PM
To: sapmix@iiug.org
Subject: RE: Backup Performance time & Legato [569]

Thanks Moling,

I'm in the process of obtaining the information you requested. Thanks
for letting me know how long your backups with Networker used to take.
That's a useful figure...

Regards,
Nicole Gurnee

-----Original Message-----
From: sapmix-bounces@iiug.org [mailto:sapmix-bounces@iiug.org] On Behalf

Of Moling_Yeh@OXY.COM
Sent: Wednesday, October 04, 2006 1:11 PM
To: sapmix@iiug.org
Subject: RE: Backup Performance time & Legato [568]

Backup time depends on:
1. what kind of media device you are using - tape or disk.
2. if using tape device, what is the speed of the storage device.
3. how many devices are assigned to DBMIData pool. I use 2 DBMIData
devices and 1 DBMILog device.
4. number of target sessions set for each device.
5. change BAR_MAX_BACKUP to parallel the onbar processes.
6. since parallel backups are based on dbspaces, your largest dbspace
size will make a difference.

Our database is about 1 Tb with 850 Gb data. Our networker server is
local to the database.
We run 2 DBMIData and 1 DBMILog devices, our tape backup takes 5+ to 6
hours. Somedays more finicky than others due to tape issues.
We recently switched to advance disk devices, the backup time is 4-5
hours.

Moling Yeh
Oxy Inc.
972-720-7023

-----Original Message-----
From: sapmix-bounces@iiug.org [mailto:sapmix-bounces@iiug.org] On Behalf

Of Gurnee, Nicole
Sent: Wednesday, October 04, 2006 11:20 AM
To: sapmix@iiug.org
Subject: Backup Performance time & Legato [567]

Hello,

We are in the process of evaluating the Legato Networker Module for
informix. I have a parallel backup running (onbar -b -L 0). This is
projected to take 12 hours to backup. Does anyone know if anything can
be done at the Informix or Networker level to speed up the backup
process?

Here are the specs:
1) the database being backed up is physically attached to the tape
drives being used. No other processes are using these tapes.
2) the main networker server is in a different location (another state)
3) the following have been added to the onconfig file, and the database
has been brought down & restarted successfully:
ISM_DATA_POOL DBMIData # If the data pool name is changed, be
sure to
ISM_LOG_POOL DBMILogs
BAR_BSALIB_PATH /usr/lib/libxnmi.sl.1

I ask because our current tool takes a little over 3 hours to backup a
700 gigabyte database. We're looking to switch to a more reliable tool
since the one we currently have has been problematic.

Regards,
Nicole
Nicole Gurnee
Database Analyst
Tyco/Electronics M/A-Com
* gurneen@tycoelectronics.com
* Tel: 1 978 442-4389
* Fax: 1 978 442-4090

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

* * * * ***


_______________________________________________
sapmix mailing list
sapmix@iiug.org
http://www.iiug.org/mailman/listinfo/sapmix

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

* * * * ***


_______________________________________________
sapmix mailing list
sapmix@iiug.org
http://www.iiug.org/mailman/listinfo/sapmix

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* * * * ***


_______________________________________________
sapmix mailing list
sapmix@iiug.org
http://www.iiug.org/mailman/listinfo/sapmix
============================================================
The information contained in this message may be privileged
and confidential and protected from disclosure. If the reader
of this message is not the intended recipient, or an employee
or agent responsible for delivering this message to the
intended recipient, you are hereby notified that any reproduction,
dissemination or distribution of this communication is strictly
prohibited. If you have received this communication in error,
please notify us immediately by replying to the message and
deleting it from your computer. Thank you. Tellabs
============================================================




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to sapmix@iiug.org
2. Include the bracketed message number in the subject line: [570]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

RE: Backup Performance time & Legato
Posted by: gurneen@tycoelectronics.com (Gurnee, Nicole) - Wed, 04 Oct 2006 13:15:23 EDT
Thanks Moling,

I'm in the process of obtaining the information you requested. Thanks
for letting me know how long your backups with Networker used to take.
That's a useful figure...

Regards,
Nicole Gurnee

-----Original Message-----
From: sapmix-bounces@iiug.org [mailto:sapmix-bounces@iiug.org] On Behalf
Of Moling_Yeh@OXY.COM
Sent: Wednesday, October 04, 2006 1:11 PM
To: sapmix@iiug.org
Subject: RE: Backup Performance time & Legato [568]

Backup time depends on:
1. what kind of media device you are using - tape or disk.
2. if using tape device, what is the speed of the storage device.
3. how many devices are assigned to DBMIData pool. I use 2 DBMIData
devices and 1 DBMILog device.
4. number of target sessions set for each device.
5. change BAR_MAX_BACKUP to parallel the onbar processes.
6. since parallel backups are based on dbspaces, your largest dbspace
size will make a difference.

Our database is about 1 Tb with 850 Gb data. Our networker server is
local to the database.
We run 2 DBMIData and 1 DBMILog devices, our tape backup takes 5+ to 6
hours. Somedays more finicky than others due to tape issues.
We recently switched to advance disk devices, the backup time is 4-5
hours.

Moling Yeh
Oxy Inc.
972-720-7023

-----Original Message-----
From: sapmix-bounces@iiug.org [mailto:sapmix-bounces@iiug.org] On Behalf

Of Gurnee, Nicole
Sent: Wednesday, October 04, 2006 11:20 AM
To: sapmix@iiug.org
Subject: Backup Performance time & Legato [567]

Hello,

We are in the process of evaluating the Legato Networker Module for
informix. I have a parallel backup running (onbar -b -L 0). This is
projected to take 12 hours to backup. Does anyone know if anything can
be done at the Informix or Networker level to speed up the backup
process?

Here are the specs:
1) the database being backed up is physically attached to the tape
drives being used. No other processes are using these tapes.
2) the main networker server is in a different location (another state)
3) the following have been added to the onconfig file, and the database
has been brought down & restarted successfully:
ISM_DATA_POOL DBMIData # If the data pool name is changed, be
sure to
ISM_LOG_POOL DBMILogs
BAR_BSALIB_PATH /usr/lib/libxnmi.sl.1

I ask because our current tool takes a little over 3 hours to backup a
700 gigabyte database. We're looking to switch to a more reliable tool
since the one we currently have has been problematic.

Regards,
Nicole
Nicole Gurnee
Database Analyst
Tyco/Electronics M/A-Com
* gurneen@tycoelectronics.com
* Tel: 1 978 442-4389
* Fax: 1 978 442-4090

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

* * * * ***


_______________________________________________
sapmix mailing list
sapmix@iiug.org
http://www.iiug.org/mailman/listinfo/sapmix

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* * * * ***


_______________________________________________
sapmix mailing list
sapmix@iiug.org
http://www.iiug.org/mailman/listinfo/sapmix




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to sapmix@iiug.org
2. Include the bracketed message number in the subject line: [569]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

RE: Backup Performance time & Legato
Posted by: Moling_Yeh@OXY.COM (Moling_Yeh@OXY.COM) - Wed, 04 Oct 2006 13:11:19 EDT
Backup time depends on:
1. what kind of media device you are using - tape or disk.
2. if using tape device, what is the speed of the storage device.
3. how many devices are assigned to DBMIData pool. I use 2 DBMIData
devices and 1 DBMILog device.
4. number of target sessions set for each device.
5. change BAR_MAX_BACKUP to parallel the onbar processes.
6. since parallel backups are based on dbspaces, your largest dbspace
size will make a difference.

Our database is about 1 Tb with 850 Gb data. Our networker server is
local to the database.
We run 2 DBMIData and 1 DBMILog devices, our tape backup takes 5+ to 6
hours. Somedays more finicky than others due to tape issues.
We recently switched to advance disk devices, the backup time is 4-5
hours.

Moling Yeh
Oxy Inc.
972-720-7023

-----Original Message-----
From: sapmix-bounces@iiug.org [mailto:sapmix-bounces@iiug.org] On Behalf
Of Gurnee, Nicole
Sent: Wednesday, October 04, 2006 11:20 AM
To: sapmix@iiug.org
Subject: Backup Performance time & Legato [567]

Hello,

We are in the process of evaluating the Legato Networker Module for
informix. I have a parallel backup running (onbar -b -L 0). This is
projected to take 12 hours to backup. Does anyone know if anything can
be done at the Informix or Networker level to speed up the backup
process?

Here are the specs:
1) the database being backed up is physically attached to the tape
drives being used. No other processes are using these tapes.
2) the main networker server is in a different location (another state)
3) the following have been added to the onconfig file, and the database
has been brought down & restarted successfully:
ISM_DATA_POOL DBMIData # If the data pool name is changed, be
sure to
ISM_LOG_POOL DBMILogs
BAR_BSALIB_PATH /usr/lib/libxnmi.sl.1

I ask because our current tool takes a little over 3 hours to backup a
700 gigabyte database. We're looking to switch to a more reliable tool
since the one we currently have has been problematic.

Regards,
Nicole
Nicole Gurnee
Database Analyst
Tyco/Electronics M/A-Com
* gurneen@tycoelectronics.com
* Tel: 1 978 442-4389
* Fax: 1 978 442-4090

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* * * * ***


_______________________________________________
sapmix mailing list
sapmix@iiug.org
http://www.iiug.org/mailman/listinfo/sapmix




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to sapmix@iiug.org
2. Include the bracketed message number in the subject line: [568]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Backup Performance time & Legato
Posted by: gurneen@tycoelectronics.com (Gurnee, Nicole) - Wed, 04 Oct 2006 12:19:44 EDT
Hello,

We are in the process of evaluating the Legato Networker Module for
informix. I have a parallel backup running (onbar -b -L 0). This is
projected to take 12 hours to backup. Does anyone know if anything can
be done at the Informix or Networker level to speed up the backup
process?

Here are the specs:
1) the database being backed up is physically attached to the tape
drives being used. No other processes are using these tapes.
2) the main networker server is in a different location (another state)
3) the following have been added to the onconfig file, and the database
has been brought down & restarted successfully:
ISM_DATA_POOL DBMIData # If the data pool name is changed, be
sure to
ISM_LOG_POOL DBMILogs
BAR_BSALIB_PATH /usr/lib/libxnmi.sl.1

I ask because our current tool takes a little over 3 hours to backup a
700 gigabyte database. We're looking to switch to a more reliable tool
since the one we currently have has been problematic.

Regards,
Nicole
Nicole Gurnee
Database Analyst
Tyco/Electronics M/A-Com
* gurneen@tycoelectronics.com
* Tel: 1 978 442-4389
* Fax: 1 978 442-4090




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to sapmix@iiug.org
2. Include the bracketed message number in the subject line: [567]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

RE: vendor data conversions
Posted by: NormaJean.Sebastian@tellabs.com (Sebastian, Norma J.) - Mon, 02 Oct 2006 21:04:08 EDT
I agree, you're asking for trouble by not doing it in an "SAP approved"
way.

Having said that, we merged BAAN data into our SAP environment without a
lot of consultants.... It took us a long time, a lot of our programmers,
and lots of QA testing by a lot of various people.

The project to merge the 2 systems took longer than 1 year, but it was
successful.

If they are providing a slow ABAP program, find some programmers and
pick that code apart.... if you understand it inside and out, you
increase your chances of success.

Whatever you do, don't rush it
Good luck

-----Original Message-----
From: sapmix-bounces@iiug.org [mailto:sapmix-bounces@iiug.org] On Behalf
Of Randy Barbati
Sent: Monday, October 02, 2006 4:12 PM
To: sapmix@iiug.org
Subject: RE: vendor data conversions [565]

Just another note:

You're theory on the data validation on save after direct loading, well,

yes and no. It validates to an extent that those tables records are
complete, but there are many many many many jobs and ABAP modules and
SAP code that may not be ok.
Again, many tables inter-relate in SAP, and each should have a key for
any records loaded to a sub-table. (foreign keys if you will)

You should be able to review the ABAP code for the data loader, and that

may be time well spent to avoid future instabilities.

-----Original Message-----
From: sapmix-bounces@iiug.org [mailto:sapmix-bounces@iiug.org] On Behalf

Of Randy Barbati
Sent: Monday, October 02, 2006 1:58 PM
To: sapmix@iiug.org
Subject: RE: vendor data conversions [564]

OH I'd almost have to agree with the consultant on this one.
I'm a big fan of do it yourself and direct SQL when possible, but
understanding the underlying SAP table relationships I'd say that you'd
want to be really clear on the process. Sounds like you've performed
some pre-run samples, but maybe you want to do discovery on the BAP too,

determine real well what exactly it's doing.

300K records is quite small in a SAP environment honestly, so the volume

of data doesn't sound overwhelming, but noting that tables like ADRC
have probably 5-10 directly related tables, and SAP in whole (our
version anyway) has 38,000 tables, 45K indexes, you're going to want to
really cover your bases.

NOTHING in SAP goes into ONE table I've found.
For most clear queries you relate several tables at minimum, and all
with embedded keys. (many single tables store separate business data and

sort by special keys).

And curious on that minor change to the client name, as the client key
is part of many tables as well.

So I'm not saying you "shouldn't", but definitely trying to convey that
the underlying SAP architecture may be more than expected if not
familiar already.

Sounds intriguing though, hope all goes well - keep us posted .

R.

-----Original Message-----
From: sapmix-bounces@iiug.org [mailto:sapmix-bounces@iiug.org] On Behalf

Of DANIEL HUNT
Sent: Monday, October 02, 2006 10:28 AM
To: sapmix@iiug.org
Subject: vendor data conversions [563]

I'm looking for a little SAP advice. Our SAP reseller keeps claiming
that I
should not be migrating the data from our Lawson env to SAP myself. They

have
provided a spectacularly slow ABAP program of their own that they want
me to
use. Considering we are talking about over 300000 records, give or take,

I
don't want to spend a week or more running their process.

My general tests in the DEV client indicate to me that the three tables
I need
to populate are lfa1, lfb1 and adrc. My test was to copy a few vendors
over
with my program then go into SAP and make a minor change to the client
name
and re-save. At that point all the SAP validations, I presume, are run
and the
data is saved. This would indicate to me I have hit all the proper
tables.
When I did not have all the correct fields and tables populated SAP
would
error.

Any advice? Is this a bad thing to do?

Thanks
Dan

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

* * * * ***


_______________________________________________
sapmix mailing list
sapmix@iiug.org
http://www.iiug.org/mailman/listinfo/sapmix

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

* * * * ***


_______________________________________________
sapmix mailing list
sapmix@iiug.org
http://www.iiug.org/mailman/listinfo/sapmix

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* * * * ***


_______________________________________________
sapmix mailing list
sapmix@iiug.org
http://www.iiug.org/mailman/listinfo/sapmix
============================================================
The information contained in this message may be privileged
and confidential and protected from disclosure. If the reader
of this message is not the intended recipient, or an employee
or agent responsible for delivering this message to the
intended recipient, you are hereby notified that any reproduction,
dissemination or distribution of this communication is strictly
prohibited. If you have received this communication in error,
please notify us immediately by replying to the message and
deleting it from your computer. Thank you. Tellabs
============================================================




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to sapmix@iiug.org
2. Include the bracketed message number in the subject line: [566]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

RE: vendor data conversions
Posted by: rbarbati@esri.com (Randy Barbati) - Mon, 02 Oct 2006 17:11:41 EDT
Just another note:

You're theory on the data validation on save after direct loading, well,
yes and no. It validates to an extent that those tables records are
complete, but there are many many many many jobs and ABAP modules and
SAP code that may not be ok.
Again, many tables inter-relate in SAP, and each should have a key for
any records loaded to a sub-table. (foreign keys if you will)

You should be able to review the ABAP code for the data loader, and that
may be time well spent to avoid future instabilities.

-----Original Message-----
From: sapmix-bounces@iiug.org [mailto:sapmix-bounces@iiug.org] On Behalf
Of Randy Barbati
Sent: Monday, October 02, 2006 1:58 PM
To: sapmix@iiug.org
Subject: RE: vendor data conversions [564]

OH I'd almost have to agree with the consultant on this one.
I'm a big fan of do it yourself and direct SQL when possible, but
understanding the underlying SAP table relationships I'd say that you'd
want to be really clear on the process. Sounds like you've performed
some pre-run samples, but maybe you want to do discovery on the BAP too,

determine real well what exactly it's doing.

300K records is quite small in a SAP environment honestly, so the volume

of data doesn't sound overwhelming, but noting that tables like ADRC
have probably 5-10 directly related tables, and SAP in whole (our
version anyway) has 38,000 tables, 45K indexes, you're going to want to
really cover your bases.

NOTHING in SAP goes into ONE table I've found.
For most clear queries you relate several tables at minimum, and all
with embedded keys. (many single tables store separate business data and

sort by special keys).

And curious on that minor change to the client name, as the client key
is part of many tables as well.

So I'm not saying you "shouldn't", but definitely trying to convey that
the underlying SAP architecture may be more than expected if not
familiar already.

Sounds intriguing though, hope all goes well - keep us posted .

R.

-----Original Message-----
From: sapmix-bounces@iiug.org [mailto:sapmix-bounces@iiug.org] On Behalf

Of DANIEL HUNT
Sent: Monday, October 02, 2006 10:28 AM
To: sapmix@iiug.org
Subject: vendor data conversions [563]

I'm looking for a little SAP advice. Our SAP reseller keeps claiming
that I
should not be migrating the data from our Lawson env to SAP myself. They

have
provided a spectacularly slow ABAP program of their own that they want
me to
use. Considering we are talking about over 300000 records, give or take,

I
don't want to spend a week or more running their process.

My general tests in the DEV client indicate to me that the three tables
I need
to populate are lfa1, lfb1 and adrc. My test was to copy a few vendors
over
with my program then go into SAP and make a minor change to the client
name
and re-save. At that point all the SAP validations, I presume, are run
and the
data is saved. This would indicate to me I have hit all the proper
tables.
When I did not have all the correct fields and tables populated SAP
would
error.

Any advice? Is this a bad thing to do?

Thanks
Dan

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

* * * * ***


_______________________________________________
sapmix mailing list
sapmix@iiug.org
http://www.iiug.org/mailman/listinfo/sapmix

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* * * * ***


_______________________________________________
sapmix mailing list
sapmix@iiug.org
http://www.iiug.org/mailman/listinfo/sapmix




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to sapmix@iiug.org
2. Include the bracketed message number in the subject line: [565]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Just another note:

You're theory on the data validation on save after direct loading, well,
yes and no. It validates to an extent that those tables records are
complete, but there are many many many many jobs and ABAP modules and
SAP code that may not be ok.
Again, many tables inter-relate in SAP, and each should have a key for
any records loaded to a sub-table. (foreign keys if you will)

You should be able to review the ABAP code for the data loader, and that
may be time well spent to avoid future instabilities.

-----Original Message-----
From: sapmix-bounces@iiug.org [mailto:sapmix-bounces@iiug.org] On Behalf
Of Randy Barbati
Sent: Monday, October 02, 2006 1:58 PM
To: sapmix@iiug.org
Subject: RE: vendor data conversions [564]

OH I'd almost have to agree with the consultant on this one.
I'm a big fan of do it yourself and direct SQL when possible, but
understanding the underlying SAP table relationships I'd say that you'd
want to be really clear on the process. Sounds like you've performed
some pre-run samples, but maybe you want to do discovery on the BAP too,

determine real well what exactly it's doing.

300K records is quite small in a SAP environment honestly, so the volume

of data doesn't sound overwhelming, but noting that tables like ADRC
have probably 5-10 directly related tables, and SAP in whole (our
version anyway) has 38,000 tables, 45K indexes, you're going to want to
really cover your bases.

NOTHING in SAP goes into ONE table I've found.
For most clear queries you relate several tables at minimum, and all
with embedded keys. (many single tables store separate business data and

sort by special keys).

And curious on that minor change to the client name, as the client key
is part of many tables as well.

So I'm not saying you "shouldn't", but definitely trying to convey that
the underlying SAP architecture may be more than expected if not
familiar already.

Sounds intriguing though, hope all goes well - keep us posted .

R.

-----Original Message-----
From: sapmix-bounces@iiug.org [mailto:sapmix-bounces@iiug.org] On Behalf

Of DANIEL HUNT
Sent: Monday, October 02, 2006 10:28 AM
To: sapmix@iiug.org
Subject: vendor data conversions [563]

I'm looking for a little SAP advice. Our SAP reseller keeps claiming
that I
should not be migrating the data from our Lawson env to SAP myself. They

have
provided a spectacularly slow ABAP program of their own that they want
me to
use. Considering we are talking about over 300000 records, give or take,

I
don't want to spend a week or more running their process.

My general tests in the DEV client indicate to me that the three tables
I need
to populate are lfa1, lfb1 and adrc. My test was to copy a few vendors
over
with my program then go into SAP and make a minor change to the client
name
and re-save. At that point all the SAP validations, I presume, are run
and the
data is saved. This would indicate to me I have hit all the proper
tables.
When I did not have all the correct fields and tables populated SAP
would
error.

Any advice? Is this a bad thing to do?

Thanks
Dan

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

* * * * ***


_______________________________________________
sapmix mailing list
sapmix@iiug.org
http://www.iiug.org/mailman/listinfo/sapmix

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* * * * ***


_______________________________________________
sapmix mailing list
sapmix@iiug.org
http://www.iiug.org/mailman/listinfo/sapmix




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to sapmix@iiug.org
2. Include the bracketed message number in the subject line: [565]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

 
Subscribe to this feed
You can subscribe to this RSS feed in a number of ways, including the following:

Drag the orange RSS button into your News Reader

Drag the URL of the RSS feed into your News Reader

Cut and paste the URL of the RSS feed into your News Reader