Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
adams06
Participant
Posts: 92 Joined: Sun Mar 12, 2006 3:00 pm
Post
by adams06 » Thu Dec 27, 2007 8:37 am
I am planning to install Datastage 8.0 version.
I am done with the installation of Oracle 9i, What configurations i am supposed to do in oracle.
Thanks in advance
ArndW
Participant
Posts: 16318 Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Post
by ArndW » Thu Dec 27, 2007 8:58 am
At version 8 the IBM Information Server Planning, Installation, and Configuration Guide documents most aspects of the installation including the database dependant ones. Those items that aren't covered can be read in the Connectivity Guide for Oracle Databases . What is your repository going to be?
adams06
Participant
Posts: 92 Joined: Sun Mar 12, 2006 3:00 pm
Post
by adams06 » Thu Dec 27, 2007 9:03 am
ArndW wrote: At version 8 the IBM Information Server Planning, Installation, and Configuration Guide documents most aspects of the installation including the database dependant ones. Those items that aren't covered can be read in the Connectivity Guide for Oracle Databases . What is your repository going to be?
Oracle 9i, i am looking for the set up requirements.
ArndW
Participant
Posts: 16318 Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Post
by ArndW » Thu Dec 27, 2007 9:22 am
According to the Docs, only Oracle 10.2g is supported for the repository.
ArndW
Participant
Posts: 16318 Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Post
by ArndW » Thu Dec 27, 2007 10:28 am
Ok, so we'll assume for the moment that the IBM documentation is wrong.
Did you successfully install Oracle and set up the TNSNAMES.ORA and other files as documented?
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Thu Dec 27, 2007 10:31 am
I personally would assume a typo in the FAQ posting.
-craig
"You can never have too many knives" -- Logan Nine Fingers
adams06
Participant
Posts: 92 Joined: Sun Mar 12, 2006 3:00 pm
Post
by adams06 » Thu Dec 27, 2007 10:58 am
chulett wrote: I personally would assume a typo in the FAQ posting.
Installation of Oracle9i is successfull, i need to set up TNSNAME.ORA and other file.
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Thu Dec 27, 2007 2:32 pm
According to IBM the only versions supported for XMETA are DB2 version 9, Oracle version 10g or Microsoft SQL Server 2003.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
gomez
Premium Member
Posts: 83 Joined: Tue Jun 22, 2004 6:11 am
Post
by gomez » Wed Apr 09, 2008 2:31 pm
A small correction - they support Microsft SQL server 2005 Oracle 10 g and DB2.