Search found 27 matches

by octogun
Wed Oct 07, 2009 12:10 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Starting DSEngine Connecting to Windows host
Replies: 0
Views: 916

Starting DSEngine Connecting to Windows host

Hi- I have 2 questions hopefully I can get some answers here: a. Can DSEngine be started with a non-root id. example dsadmin id. b. In Designer can we access Sequential files located in Windows Server. the engine and services tier on RHEL servers. Data is located in Flat file on Windows server. We a...
by octogun
Thu Aug 13, 2009 8:45 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: metadata in csv import it into datastage
Replies: 4
Views: 6009

Something in the same lines, we have a tool which will directly convert ABI graphs or other ETL's to DataStage. We may go that route. Also if creating metadata is one time thing why not go that way. will see what happens. thanks If you have 100 of them, it may be simplest just to write a program tha...
by octogun
Thu Aug 13, 2009 8:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Teradata ODBC
Replies: 3
Views: 3997

Re: Teradata ODBC

The issue is this : Teradata ODBC made it work but Teradata Connector to import metadata doesn't. For Teradata ODBC > Configure .odbc.ini file in $DSHOME to use Teradata drivers. The Resolution for Teradata Connector is: DataStage is 32Bit which can run on 32bit or 64bit RHEL OS. Our OS is 64bit. Wh...
by octogun
Fri Aug 07, 2009 4:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Teradata ODBC
Replies: 3
Views: 3997

Re: Teradata ODBC

Q: Does /usr/ODBC/lib be put in LD_LIBRARY_PATH on in the env settings
by octogun
Fri Aug 07, 2009 4:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Teradata ODBC
Replies: 3
Views: 3997

Re: Teradata ODBC

connection failed An exception occurred while trying to receive the response from the handler: An exception was received from the handler:ODBC function{0} reported : SQLSTATE = IM003: Native Error Code = 0: Msg =[DataDirect][ODBC lib] Specified driver could not be loaded i am not quite clear where t...
by octogun
Fri Aug 07, 2009 2:52 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Teradata ODBC
Replies: 3
Views: 3997

Teradata ODBC

Hi - I am stumped at creating connection to Teradata. import - table definitions - connector import wizard allows ODBC connection and/or Teradata Connector using ODBC Connector - attempt to create connection to Teradata. get a error Driver could not be loaded. We have installed all packages of v12. ...
by octogun
Wed Aug 05, 2009 12:15 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: metadata in csv import it into datastage
Replies: 4
Views: 6009

metadata in csv import it into datastage

Hi - We have about 100 excel files which contain table layout information ( Column names, Data Types ) Is there a way to import these into one of the folder in DataStage Designer. We tried using Sequential import but that function requires a file with column names and data. Our file has no data in i...
by octogun
Tue Aug 04, 2009 1:07 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: compiler error new installation
Replies: 6
Views: 5707

Problem resolved just need to put this package glibc-devel-2.3.4-2.25.i386.rpm thanks for all the help. cheers The OS is 64bit DS is 32bit so it needs 64bit C++ compiler and 32bit runtime component? OS: 64-bit Red Hat Enterprise Linux Advanced Server 4 c++ compiler : gcc 3.4.6 runtime component : Av...
by octogun
Tue Aug 04, 2009 11:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: compiler error new installation
Replies: 6
Views: 5707

The OS is 64bit DS is 32bit so it needs 64bit C++ compiler and 32bit runtime component? OS: 64-bit Red Hat Enterprise Linux Advanced Server 4 c++ compiler : gcc 3.4.6 runtime component : Available on the Red Hat Linux installation media: glibc-devel-2.3.4-2.25.i386.rpm. We thought the above requirem...
by octogun
Tue Aug 04, 2009 10:45 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: compiler error new installation
Replies: 6
Views: 5707

I went to the IBM site: http://publib.boulder.ibm.com/infocenter/iisinfsv/v8r1/index.jsp?topic=/com.ibm.swg.im.iis.productization.iisinfsv.install.doc/topics/wsisinst_set_envars_cpp.html my new settings are compileopt : -0 -fPIC -Wno-deprecated -c -m32 compiler : g++ linker :g++ linkopt : -shared -m...
by octogun
Tue Aug 04, 2009 10:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: compiler error new installation
Replies: 6
Views: 5707

Please note this is a 64bit installation and installation documents require
gcc 3.4.6 C++ compliler and documents mention installation media contains glibc-devel-2.3.4-2.25.i386.rpm

can we put 32bit c++ software on 64bit RHEL 4 OS?

again thanks for your responses and help.
by octogun
Tue Aug 04, 2009 10:21 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: compiler error new installation
Replies: 6
Views: 5707

compiler error new installation

Hi - I got a compiler error in transformation stage for tutorial example job in our Information server linux 4 installation. I did a search for this as past responses indicated and people mentioned check compiler settings my settings are compileopt : -0 -fPIC -Wno-deprecated -c compiler : g++ linker...
by octogun
Fri Jul 31, 2009 2:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: 8.1 IBM InformationServer first time login error
Replies: 20
Views: 11062

if engine tier and Service Tier are on different machines how can a user registry be shared? I finally got it. Service tier is in Box 1 connected to LDAP. Id dsapp is WAS login and is in LDAP Engine tier is in Box2 Credentials cannot be shared because tier's are in separate machines(i think) Default...
by octogun
Fri Jul 31, 2009 1:29 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: 8.1 IBM InformationServer first time login error
Replies: 20
Views: 11062

I changed the Registry to External LDAP.

We have to use LDAP ID to login into administration client.
The datastage credentials are now shared.

But still I can't login.

I will ask admin to start ds.rc as root. See what happens.
thanks
by octogun
Fri Jul 31, 2009 12:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: 8.1 IBM InformationServer first time login error
Replies: 20
Views: 11062

If I use some other port in Box3
say I tried 31531 it generates error RPC deamon
it has to be port 31538 and I checked its listening on that port.

cheers