InfoSphere 8.5 FP1 - any major known issues?

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

Post Reply
JonMorgan
Premium Member
Premium Member
Posts: 28
Joined: Tue Mar 24, 2009 7:34 pm
Location: Brisbane, Australia

InfoSphere 8.5 FP1 - any major known issues?

Post by JonMorgan »

Hi Folks,

I'm on a site which has a new Infosphere 8.5 installation.
Before we embark on any development on this new platform i want know if there are any known issues up front instead of bumping into them along the away. So i can get these fixed or raised with the support people while they are still on site.

The configuration is:-

InfoSphere 8.5 fixpack 1.
SUSE Enterprise Linux 10 service pack 3.
Oracle 11gR2 for xmeta and iadb.
SQL Server 2008 and Oracle 11gR2 for source and target databases.
We plan to develop with Oracle Connector and ODBC connector stages.

Any advice greatly appreciated.

Jon
SURA
Premium Member
Premium Member
Posts: 1229
Joined: Sat Jul 14, 2007 5:16 am
Location: Sydney

Re: InfoSphere 8.5 FP1 - any major known issues?

Post by SURA »

My target is SQL Server and i used WRITE method along with Surrogate_Key_Generator stage made the job to fail / hang. But this is for Win OS.

I suppose to raise a PMR for this issue.

Workaround is make the SQL Server EE stage to run in sequential mode.

Hence you are using unix, you might use ODBC and not sure how that will behave?.

DS User
iHijazi
Participant
Posts: 45
Joined: Sun Oct 24, 2010 12:05 am

Post by iHijazi »

Major, No.

Minor, yes.

Workarounds, there is.

In the end it's all about what you use. But I recommend using it (upgrading if you are an 8.1 user).

It's always fun to fix issues :)

Cheers.
Not only thoughts, but a little bit of experience.
JonMorgan
Premium Member
Premium Member
Posts: 28
Joined: Tue Mar 24, 2009 7:34 pm
Location: Brisbane, Australia

Re: InfoSphere 8.5 FP1 - any major known issues?

Post by JonMorgan »

SURA wrote:My target is SQL Server and i used WRITE method along with Surrogate_Key_Generator stage made the job to fail / hang. But this is for Win OS.

I suppose to raise a PMR for this issue.

Workaround is make the SQL Server EE stage to run in sequential mode.

Hence you are using unix, you might use ODBC and not sure how that will behave?.

DS User
Thank you, I will keep this in mind, yes ODBC Connector will be used for SQL Server.
JonMorgan
Premium Member
Premium Member
Posts: 28
Joined: Tue Mar 24, 2009 7:34 pm
Location: Brisbane, Australia

Post by JonMorgan »

iHijazi wrote:Major, No.

Minor, yes.

Workarounds, there is.

In the end it's all about what you use. But I recommend using it (upgrading if you are an 8.1 user).

It's always fun to fix issues :)

Cheers.
thanks for your commend, we're currently using 8.5 FP1.
I'm working in the best interest of the customer which is to have a fully functioning product for development and to build confidence for delivery.
If i can be aware of the issues big or small beforehand all the better.
RikDeclercq
Participant
Posts: 11
Joined: Wed Mar 16, 2011 5:56 am

some issues

Post by RikDeclercq »

We upgraded to 8.5 FP1 and noticed the following in the Designer client :
- the fan-symbols on the links have disappeared. However, you can still see them in the pop-up that comes up when you move your mouse over the job-name in the repository window
- in the sequential file stages, you can use DOS format for UNIX-files and vice versa, withought Designer complaining

We are not 100% sure we notice this behaviour since we installed the FP but lets say 90 % :wink:
jwiles
Premium Member
Premium Member
Posts: 1274
Joined: Sun Nov 14, 2004 8:50 pm
Contact:

Post by jwiles »

There is a patch available in FixCentral for the disappearing partitioning icons.

Regards,
- james wiles


All generalizations are false, including this one - Mark Twain.
JonMorgan
Premium Member
Premium Member
Posts: 28
Joined: Tue Mar 24, 2009 7:34 pm
Location: Brisbane, Australia

Post by JonMorgan »

I want to add the problem of "Cannot insert LONGVARCHAR data into Oracle function SDO_GEOMETRY"

This is a known issue to IBM.
The problem is of not being able to pump more than 4000 characters to a function that can accept LOB that is within an Insert statement.
This problem has been identified so far with the Oracle Connector Stage.

I already have this problem described in a separate forum thread.
JonMorgan
Premium Member
Premium Member
Posts: 28
Joined: Tue Mar 24, 2009 7:34 pm
Location: Brisbane, Australia

Post by JonMorgan »

I want to add the problem of "Cannot insert LONGVARCHAR data into Oracle function SDO_GEOMETRY"

This is a known issue to IBM.
The problem is of not being able to pump more than 4000 characters to a function that can accept LOB that is within an Insert statement.
This problem has been identified so far with the Oracle Connector Stage.

I already have this problem described in a separate forum thread.
SURA
Premium Member
Premium Member
Posts: 1229
Joined: Sat Jul 14, 2007 5:16 am
Location: Sydney

Post by SURA »

Add another

While using SQL Server WRITE method "BIT" Data type wont support. You need to change it as INT in the input link to DB.

DS User
JonMorgan
Premium Member
Premium Member
Posts: 28
Joined: Tue Mar 24, 2009 7:34 pm
Location: Brisbane, Australia

Post by JonMorgan »

SURA wrote:While using SQL Server WRITE method "BIT" Data type wont support. You need to change it as INT in the input link to DB.
Is that with ODBC Connector?
SURA
Premium Member
Premium Member
Posts: 1229
Joined: Sat Jul 14, 2007 5:16 am
Location: Sydney

Post by SURA »

Os is win, so I checked with SQL Server EE stage, for unix / ODBC not sure.

DSUser
Post Reply