Search found 226 matches
- Mon Apr 15, 2013 7:41 am
- Forum: General
- Topic: Install Directory and Project Directory
- Replies: 4
- Views: 1683
Install Directory and Project Directory
Hi DS 8.7 on Window 2008 R2 We have Infosphere Information Server successfully installed and Datastage jobs are running fine. It has been installed in the default C drive on the server C:\IBM\InformationServer and the projects are under C:\IBM\InformationServer\Server\Projects,but since the C drive ...
- Tue Apr 09, 2013 2:31 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Performance Issue Stored Procedure Vs Datastage
- Replies: 6
- Views: 4373
I already tried breaking the procesess in multilpe parts..multiple jobs..but no effect as the the very first Select Query (join across 3 tables) that fetches the 4.5 M records takes about 6.5 Mins and everything else about 1.5 mins.. I created a simple job to fetch this data in a Copy stage at it ta...
- Tue Apr 09, 2013 11:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Performance Issue Stored Procedure Vs Datastage
- Replies: 6
- Views: 4373
Performance Issue Stored Procedure Vs Datastage
Hi, DS 8.7 on Windows Server 2008 R2 (Dual Core, 64 GB RAM) Src and Tgt Database - SQL Server 2008 Currently we have a SP that inserts about 4.5 Million records everyday..It drops target table first, creates and inserts the data from a 3 table join query, then runs 3 different updates on this data (...
- Mon Apr 08, 2013 5:28 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Delete,0: Query returned no results.
- Replies: 6
- Views: 2191
Let me walk you through my job design. I have 3 TD enterprise stages in one parallel job which run different queries parallely and i am combining the output using a funnel in a file. With your solution, the prob is, i will have to check the output for all the three queries and run them accordingly(s...
- Mon Apr 08, 2013 1:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Delete,0: Query returned no results.
- Replies: 6
- Views: 2191
- Fri Apr 05, 2013 7:20 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Delete,0: Query returned no results.
- Replies: 6
- Views: 2191
Delete,0: Query returned no results.
hi, i am facing a similar issue. My DS is running on 4 nodes. I have specified 2 sessionperplayer and hence 8 requested sessions. stil i am getting this warning when there are no records to be fetched :
Delete,0: Query returned no results. No read will be performed.
Delete,0: Query returned no results. No read will be performed.
- Wed Mar 27, 2013 7:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Wild Card - Get File Name
- Replies: 19
- Views: 14089
jwiles, I had selected the File Pattern. It does not work with selecting Specific File option as well, which I guess is expected, as this is Not a File Name but a pattern I see similar post here for v8.5 and it says it is a bug and that IBM is to fix it, doesn't look like it has been :( http://www.d...
- Tue Mar 26, 2013 9:16 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Wild Card - Get File Name
- Replies: 19
- Views: 14089
After adding the ENV Variable and setting it to True, the job runs successfully but does not read from the file, shows 0 records (I verified the file is present and has 45 records) It gives this warning message SEF_WNOACCS3_D34001: Fileset /tmp/import_tmp_729269132fb8.fs contains no files. If a file...
- Tue Mar 26, 2013 7:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Wild Card - Get File Name
- Replies: 19
- Views: 14089
- Sun Mar 24, 2013 12:18 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Date appearing in internal format when viewed from OCI stage
- Replies: 7
- Views: 3673
- Fri Mar 22, 2013 1:05 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Wild Card - Get File Name
- Replies: 19
- Views: 14089
Wild Card - Get File Name
Hi, DS 8.7 on Windows We are using a File Pattern in a Sequential Stage as we get dated files abc_20120322.txt (We expect only 1 per day).. So reading and processing this file is not a problem but I want to know the exact name of the file so an email notification can be sent. How can I get this full...
- Thu Mar 21, 2013 10:55 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: stored procedure in ODBC Connector Before SQL
- Replies: 2
- Views: 2144
- Wed Mar 20, 2013 11:16 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Date appearing in internal format when viewed from OCI stage
- Replies: 7
- Views: 3673
We tried changing the datatype to Timestamp from date but, when we tried viewing the data it threw an error stating conversion failed. Since, we are using a user defined SQL as given SELECT DW_DATE_ID,TO_CHAR(DATE_DT, 'YY-MON-DD') FROM STG2D_DATE. We encountered this issue when we were migrating the...
- Wed Mar 20, 2013 10:29 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: stored procedure in ODBC Connector Before SQL
- Replies: 2
- Views: 2144
stored procedure in ODBC Connector Before SQL
Hi, DS 8.7 on Windows I am trying to call a SP (DB - SQL Server) with one Input Parameter (and it does not return anything) from the BeforeSQL part in the ODBC Connector stage but it throws this error I tried all these but it still fails Execute SPNAME(1) Exec SPNAME(1) Call SPNAME(1) Con_ODBC_Campu...
- Wed Mar 20, 2013 2:02 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Date appearing in internal format when viewed from OCI stage
- Replies: 7
- Views: 3673
Date appearing in internal format when viewed from OCI stage
When we try to view data from Datastage OCI stage, the date is getting displayed in some internal format though the datatype is defined as date. ex. "20-MAR-2013" is displayed as 16516. when the query used in the above OCI stage is executed in toad we are getting the date in proper format ...