Datastage V3.6r2 (ODBC V3.11) on Compag ( Dec ) Alpha runnin
Posted: Wed Aug 02, 2000 9:54 pm
Does anyone have experience with running Datastage V3.6 r2 on a Dec Alpha running TRU64 Unix V5.0(Rev9.10). Using ODBC V3.11 ( Intersolv )
Most importantly we need to improve the throughput.
We are also having problems with ODBC warning 6066:[INTERSOLV][ODBC 20101 driver]6060.
Has anyone tried using Informix ODBC drivers instead of the ODBC drivers supplied with datastage? If so which driver manager did you use and where did you get it from? We cannot get the informix ODBC driver to work with Datastage. It does work with demoodbc.branded.
We have tried the Informix CLI Plugin, this is just as slow as ODBC. CLI also has other issues like, not supporting text datatype, single database error returning as multiple warning messages in datastage. Informix CLI Version 1.0 ( For Tru64)
On average our throughput is about 20 rows per second, although initial loading is < 10 rows per second.
Details of our System setup follow.
Datastage Server.
Alpha running TRU64 Unix V5.0 (Rev.910),
Datastage V3.6r2 on Compag ( Dec )
Informix CLI Version 1.0 ( For Tru64)
Intersolv ODBC Driver 3.11 (Driver manager v2.x????)
Informix ODBC Driver 3.32 (driver manager v2.x ????)
Ods / Datamart Server
Alpha running TRU64 Unix V5.0 (Rev.910),
Datastage V3.6r2 on Compag ( Dec )
Informix 9.21 (Also on Dec Alpha)
Data Source Server
JDE
Oracle V8
AIX RS6000
Thanks in Advance
Hong / Leon
Most importantly we need to improve the throughput.
We are also having problems with ODBC warning 6066:[INTERSOLV][ODBC 20101 driver]6060.
Has anyone tried using Informix ODBC drivers instead of the ODBC drivers supplied with datastage? If so which driver manager did you use and where did you get it from? We cannot get the informix ODBC driver to work with Datastage. It does work with demoodbc.branded.
We have tried the Informix CLI Plugin, this is just as slow as ODBC. CLI also has other issues like, not supporting text datatype, single database error returning as multiple warning messages in datastage. Informix CLI Version 1.0 ( For Tru64)
On average our throughput is about 20 rows per second, although initial loading is < 10 rows per second.
Details of our System setup follow.
Datastage Server.
Alpha running TRU64 Unix V5.0 (Rev.910),
Datastage V3.6r2 on Compag ( Dec )
Informix CLI Version 1.0 ( For Tru64)
Intersolv ODBC Driver 3.11 (Driver manager v2.x????)
Informix ODBC Driver 3.32 (driver manager v2.x ????)
Ods / Datamart Server
Alpha running TRU64 Unix V5.0 (Rev.910),
Datastage V3.6r2 on Compag ( Dec )
Informix 9.21 (Also on Dec Alpha)
Data Source Server
JDE
Oracle V8
AIX RS6000
Thanks in Advance
Hong / Leon