473,854 Members | 1,822 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Peoplesoft on Federated UDB?

Anyone using Peoplesoft on a Federated UDB
(shared nothing)Environ ment on Open System Platforms?
Preferably AIX, but any war stories would be good.

TEA
EB-C
Nov 12 '05
96 6273
Know anyone that has done it using SAP?

--
BadPony
'03 ZRX1200R
'78 XS 1100
"Serge Rielau" <sr*****@ca.e ye-be-em.com> wrote in message
news:bu******** **@hanover.toro lab.ibm.com...
Bad Pony,

I haven't but I'm a DB2 developer, not a consultant.
Note that IBM is pushing DPF for BI which is not what Peoplesoft does AFAIK. An SAP BW would be a different story alltogether.

Cheers
Serge

Nov 12 '05 #21
Mark A wrote:
"Daniel Morgan" <da******@x.was hington.edu> wrote in message
news:1075003854 .992919@yasure. ..
The only two commecial RDBMS products with shared nothing architecture
are DB2 on mainframes (not other platforms) and Oracle on all platforms.
It will be nice when IBM can implement this for DB2 on all platforms.

--
Daniel Morgan

DB2 for Linux, UNIX and Windows clearly supports shared nothing
architecture. This is really a hardware issue, not a software issue. AFAIK,
all multi-node parallel databases that support multiple nodes, also support
shared nothing hardware (one database partition per physical node), although
it is often not cost effective to implement that way.


The difference is that with Oracle there is only one database no
matter how many nodes. Oracle does not replicate (like SQL Server) or
partition its data into separate databases (like DB2).

The equality you imply with "one database partition per physical node"
is where the architecture difference is important. Oracle never creates
one database partition per physical node unless you don't understand
what you are trying to do.

--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
da******@x.wash ington.edu
(replace 'x' with a 'u' to reply)

Nov 12 '05 #22
Daniel,

Mark A. and I may differ on the intricate details, but your definition
for shared nothing is way out there.
Because Oracle does NOT partition the data it certainly NOT shared
nothing and Oracle's docs go through great lengths to beg to differ from
shared nothing.
Note that I'm not saying anything about what's good or bad. I'm just
saying that Oracle in NOT doing shared nothing. Oracle's approach is
commonly referred to as shared disk since every node has access to all
the data (just as you say).

You can classify loosely like this:

shared nothing (one DB across multiple nodes, nodes own data):
DB2 ESE + DPF,
Informix XPS
Teradata

shared disk (one DB across multiple nodes, nodes do not own data):
Oracle with RAC
DB2 z/Series

federated (multiple DBs linked together presenting a single DB view)
MS SQL Server with linked tables (did i get that right?) (used for
distributed partitioned views)
DB2 II (Nicknames)
Informix IDS (external tables (?))
Oracle + Transparent gateway

Somewhere between federated and shared nothing DB2 for iSeries fits in
as well.
Nov 12 '05 #23
Serge Rielau wrote:
Daniel,

Mark A. and I may differ on the intricate details, but your definition
for shared nothing is way out there.


Not just "way out there" ... dead wrong.

It was late at night and I'd just spent the previous 12 hours teaching a
RAC class. Oracle hasn't used Shared Nothing for years and the last time
was, IIRC, with OPS. Shared Nothing has nothing to do with RAC.

My apology for having too little sleep and too much Chimay.

--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
da******@x.wash ington.edu
(replace 'x' with a 'u' to reply)

Nov 12 '05 #24
PS: Mark: if you folks don't deliver O10g within a week you'll have an
expired TPC-C result on your hands.. What's up?
I guess "we" tend to not subscribe to the the
there is significant pressure to get function out.
and
It's a well known problem that testing can never we enough.


school of software development.

Nov 12 '05 #25
Daniel Morgan <da******@x.was hington.edu> wrote in message news:<107504452 6.452560@yasure >...
The difference is that with Oracle there is only one database no
matter how many nodes. Oracle does not replicate (like SQL Server) or
partition its data into separate databases (like DB2).


The data is partitioned, but the partitions are still part of the same
database. I believe Teradata uses a similar approach. Shared-nothing
clustered architectures still dominate the TPC-H performance rankings
(which are noticeably RAC-free).
DG
Nov 12 '05 #26
Mark Townsend wrote, with liberal editing:

....
I guess "we" tend to not subscribe to the the
there is significant pressure to get function out.


Yes, you'll find that there is less pressure to get function out as your
market share falls.

Nov 12 '05 #27
> > The difference is that with Oracle there is only one database no
matter how many nodes. Oracle does not replicate (like SQL Server) or
partition its data into separate databases (like DB2).


The data is partitioned, but the partitions are still part of the same
database. I believe Teradata uses a similar approach. Shared-nothing
clustered architectures still dominate the TPC-H performance rankings
(which are noticeably RAC-free).

DG


Teradata invented share nothing (and also parallel database partitioning).
But it is rarely used today because it is usually more effective to have
multiple partitions per physical node, even when there are multiple nodes.
Back when Teradata invented parallel database partitioning, the hardware and
software platforms were not capable of SMP, so share nothing was the only
option. Today's sophisticated OS's and hardware can use SMP quite
efficiently.

Share nothing usually does not yield the best price/performance, but it
scales in linear fashion for each additional partition. Today, most parallel
implementations use a combination of multiple physical nodes, with multiple
partitions per node (SMP).
Nov 12 '05 #28
Database Guy wrote:
Daniel Morgan <da******@x.was hington.edu> wrote in message news:<107504452 6.452560@yasure >...

The difference is that with Oracle there is only one database no
matter how many nodes. Oracle does not replicate (like SQL Server) or
partition its data into separate databases (like DB2).

The data is partitioned, but the partitions are still part of the same
database. I believe Teradata uses a similar approach. Shared-nothing
clustered architectures still dominate the TPC-H performance rankings
(which are noticeably RAC-free).
DG


Add a node with shared nothing and your mean time to failure goes down
.... not up. Add a node with shared nothing and your realized performance
per node goes down rather than remaining stable. Add or subtract a node
with shared everything ... and you don't need to rewrite a single line
of code, perform a shutdown, reparse and reload your data.

Last time I looked TPC didn't give a .... about maintainability .

The fact that they are part of the same database is meaningless. If you
lose the disks attached to node 6 of 10 what happens? Is that data live
anywhere else? Do the transactions seamlessly fail-over and continue
running?

And , IIRC, DB2 on mainframes is shared everything ... not shared nothing.

--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
da******@x.wash ington.edu
(replace 'x' with a 'u' to reply)

Nov 12 '05 #29
Blair Adamache wrote:
Mark Townsend wrote, with liberal editing:

...
I guess "we" tend to not subscribe to the the
there is significant pressure to get function out.



Yes, you'll find that there is less pressure to get function out as your
market share falls.


Actually the opposite is true. A fact that seems to be recognied by
those folks on Wall Street where it appears that Larry's stock closed
above its previous 52 week high on Friday. Hardly a sign of corporate
failure.

But in this case ... Oracle's statement about the release of 10g by the
end of the year was related to Oracle's fiscal year which ends in May
.... not your calendar year. From what I hear ... it will be on-time.

--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
da******@x.wash ington.edu
(replace 'x' with a 'u' to reply)

Nov 12 '05 #30

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1811
by: Cindy B | last post by:
Please send your resume and position to Cindy@AtlanticResource.com! I CAN NOT accept candidates that ARE OUTSIDE OF THE US! NO PHONE CALLS PLEASE! Email your resume to me! Position:SQL SERVER/PEOPLESOFT DBA Date: 03/07/05 Location: Richmond, VA Duration: 5 month conract to hire Salary: 65,000-80,000K Contract to Hire 5 months
3
2967
by: Terry | last post by:
Hi All, Im trying to run db2expln over some sql in order to find out why its so slow. I receive the following error message. LINE MESSAGES FOR DYNEXPLN.sqc ------ -------------------------------------------------------------------- SQL0060W The "C" precompiler is in progress.
1
1999
by: RdR | last post by:
Hi, I have a table in SQL Server with no keys, I point this as a federated table in DB2 but in DB2 I have defined keys against this federated table in SQL. Where will the key constraints be followed in DB2 or in SQL? How should a select statement in DB2 for this federated table behave if there are duplicates in SQL? The result I am getting is it is showing an actual duplicate in DB2 for this federated table. Is there any setting in DB2...
4
606
by: uthuras | last post by:
Greetings all, Is it possible to have federated db feature implemented among DB2 family? I intend to create federated within DB2 databases. I have 2 databases TestA and TestB. I have some base tables in TestA database and the reference tables in TestB database. Now i want to select data from TestB database referencing base table in TestA database. One of the way would be Federated Database. I've seen some red books on setting up...
5
3349
by: Klemens | last post by:
I get SQL30090 reason 18 by trying to do an insert in a federated table and an update in a local table in one transaction Do I have to change some settings to get done or ist this not possible by definition? Thanks Klemens
1
2347
by: karpagam | last post by:
How to access the peoplesoft database from the .NET application. The peoplesoft database holds the user information, against which the user has to be authenticated for accessing the peoplesoft applications. Are there any built in API's provided by peoplesoft which can be called from the .net application ?
0
1375
by: Radhesh Reddy | last post by:
Please find the details of the requirement as follows : Location :- SFO,CA Duration :- Long Term Start date :- ASAP Job Description: Seeking a Peoplesoft integration/data architect consultant for a long-term project in the San Francisco Bay area. On this project, the PeopleSoft Consultant will be working on
4
3461
by: Praveen_db2 | last post by:
Hi All DB2 8.1.3,Windows I have 2 databases in a single instance, say DB_1 and DB_2.I need to query a table from DB_1 in DB_2.I am try to use a nickname for it.But nickname creation is not possible until federated server is made.Please tell me how to create a federated server.Moreover, is there any thing extra which I need to buy for this?When I gave this command to create a server CREATE SERVER "TEST1" TYPE DB2/UDB VERSION 8.1
0
1566
by: Imran | last post by:
JOB ID: BE 3001 Please refer to the Job ID in all your communication both in subject line of your email and in the body text. Hi Friends, Good Morning ,...Hope you doing good! Our client needs a PeopleSoft Performance Tester LOC: MN Duration: Long term
0
9752
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
1
10764
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9524
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7920
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
7083
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5753
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5945
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
4165
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3192
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.