My Job is
ODBC ===> sequential file ===> Oracle connector
Search found 12 matches
- Mon Mar 05, 2018 12:03 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: ORACLE CONNECTOR STAGE IS SLOWER
- Replies: 4
- Views: 15482
- Mon Mar 05, 2018 8:26 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: ORACLE CONNECTOR STAGE IS SLOWER
- Replies: 4
- Views: 15482
ORACLE CONNECTOR STAGE IS SLOWER
Hello I have a ODBC stage and I charge an Oracle stage. The load is really slow, average 800 rows per second. Since DataStage has some particular settings with Oracle 12, I do not know how to improve this speed anymore. I have divided the job so that the data is in a sequential file and after transf...
- Fri Jul 28, 2017 10:04 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: What is "parameter1" in ODBC DB2 wire protocol err
- Replies: 19
- Views: 12042
- Fri Jul 28, 2017 7:31 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: SAP ABAP extractor stopped working
- Replies: 2
- Views: 14038
Re: Abap sap extractor no works
Some idea I'm not sure what to look at anymore
- Thu Jul 27, 2017 3:06 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: SAP ABAP extractor stopped working
- Replies: 2
- Views: 14038
SAP ABAP extractor stopped working
SAP ABAP extractor works in development environment but in QA environment and Sandbox environment does not bring back any records.
The configuration in the two environments is the same, does not create log and ends by timeout
SAPPack_7.1_JR52350_26Jan2015
The configuration in the two environments is the same, does not create log and ends by timeout
SAPPack_7.1_JR52350_26Jan2015
- Fri Mar 23, 2012 12:36 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error Oracle Connectivity
- Replies: 13
- Views: 10045
log DS Director: Oracle_OCI stage ==> Transformer_stage ==> Sequential_File_stage Starting Job PruebaLecturaOracleJOB. Environment variable settings: _=/usr/bin/nohup APT_ORCHHOME=/u02/IBM/InformationServer/Server/PXEngine ASBHOME=/u02/IBM/InformationServer/ASBNode BELL=^G CONSOLE=/dev/pts/0 DS_ENAB...
- Fri Mar 23, 2012 10:12 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error Oracle Connectivity
- Replies: 13
- Views: 10045
yes i restart the server. [dsadm@XXXXXXXXXXXX~]$ uptime 13:09:04 up 2 days, 20:25, 6 users, load average: 1.03, 1.07, 1.08 [dsadm@XXXXXXXXXXXX~]$ ls -l total 84 drwxr-xr-x 2 dsadm dstage 4096 Aug 26 2011 ArchivosMigracion drwxr-xr-x 2 dsadm dstage 4096 Mar 2 12:50 copia drwxr-xr-x 2 dsadm dstage 409...
- Fri Mar 23, 2012 9:32 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error Oracle Connectivity
- Replies: 13
- Views: 10045
- Fri Mar 23, 2012 9:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error Oracle Connectivity
- Replies: 13
- Views: 10045
- Fri Mar 23, 2012 8:49 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error Oracle Connectivity
- Replies: 13
- Views: 10045
- Fri Mar 23, 2012 6:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error Oracle Connectivity
- Replies: 13
- Views: 10045
tks for the answerd yes i do it that way [dsadm@XXXXXXXXXXXX ~]$ sudo su [root@XXXXXXXXXXXXdsadm]# cd /u02/IBM/InformationServer/Server/DSEngine/ [root@XXXXXXXXXXXXDSEngine]# . ./dsenv [root@XXXXXXXXXXXXDSEngine]# tnsping g100603sv242 TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 23...
- Thu Mar 22, 2012 9:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error Oracle Connectivity
- Replies: 13
- Views: 10045