Sybase OC stage for PX jobs
Moderators: chulett, rschirm, roy
Sybase OC stage for PX jobs
Hi all,
I have installed DataStage 7.5x2 Enterprise Edition on Windows. The Sybase OC database stage is available for Server type jobs but is missing on the palette for PX type jobs.
Question: is the Sybase OC stage available for parallel jobs? If yes, how do i get the plugin installed?
Regards Hans
I have installed DataStage 7.5x2 Enterprise Edition on Windows. The Sybase OC database stage is available for Server type jobs but is missing on the palette for PX type jobs.
Question: is the Sybase OC stage available for parallel jobs? If yes, how do i get the plugin installed?
Regards Hans
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
Re: Sybase OC stage for PX jobs
The sybase OC stage will be available to you in parallel jobs too. I think you just need to customize your stages on the palette.hboekel wrote:Hi all,
Question: is the Sybase OC stage available for parallel jobs? If yes, how do i get the plugin installed?
I haven't failed, I've found 10,000 ways that don't work.
Thomas Alva Edison(1847-1931)
Thomas Alva Edison(1847-1931)
Re: Sybase OC stage for PX jobs
Could you tell me how to do that? Do we need to register a plugin using DS Manager? What is the path where the plugin is located?us1aslam1us wrote:The sybase OC stage will be available to you in parallel jobs too. I think you just need to customize your stages thru DataStage Manager.hboekel wrote:Hi all,
Question: is the Sybase OC stage available for parallel jobs? If yes, how do i get the plugin installed?
Thanks.
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
I followed your instructions but in the Default Palette groups box, the Database('Parallel - Database') group only contains the following entries:
DB2/UDB
DRS
ODBC Enterprise
Oracle
SQLServer Enterprise
STP
Teradata
Sybase is not listed, so what am i missing here? During install, we selected all plugins for to be installed. Sybase OC is only listed as a stage under Database - Server.
DB2/UDB
DRS
ODBC Enterprise
Oracle
SQLServer Enterprise
STP
Teradata
Sybase is not listed, so what am i missing here? During install, we selected all plugins for to be installed. Sybase OC is only listed as a stage under Database - Server.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Looking at the Stage Types branch of the repository (in DS Designer), the Sybase OC is listed under the Sever - Database branch. I dragged that one to the Database Parallel group in the palette. However, when i create a parallel job, the Sybase OC stage is greyed out and cannot be used.ray.wurlod wrote:Is it in the Stage Types branch of the Repository? If so, you can drag it from there to customize your Palette. ...
FYI: this is what i found in the WINEE.pdf document:
The only connectivity features included with release 7.5x2 for parallel jobs are:
These parallel stages:
Oracle parallel stages with 9i (Load, Upsert, Read, Lookup, Partition Read)
Oracle 10g parallel stage
ODBC parallel stage (new with this release, tested with the SQL Server)
SQL Server parallel stage (new with this release)
Teradata TeraRead, TeraWrite parallel stage, using TUF 6.1.1
These Plug-Ins:
IBM WebSphere MQ plug-in (available on separate media)
Pivot active stage plug-in
IBM DB2 8.1 API plug-in
IBM UDB 8.1 Bulk plug-in
Teradata Multi Load
Teradata API
Teradata Load
Stored Procedure Stage (Oracle 9i and Oracle 10g support only)
Dynamic Relational Stage (DRS)
This probably means Sybase OC is not yet avalaible for 7.5X2 EE for Windows. Is that a correct assumption?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: