Search found 28 matches
- Mon Aug 29, 2016 11:33 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Long startup time
- Replies: 4
- Views: 3768
Thanks PaulVL for replying. What I have observed from the logs and designs of few jobs taking long startup time is like: Jobs which are having database connector stages at source or any other places (for lookups,funnel) with large USER-DEFINED complex sqls (large output schema with joins with other ...
- Mon Aug 29, 2016 9:37 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Long startup time
- Replies: 4
- Views: 3768
Long startup time
Hi Job is taking long startup time in PRODUCTION. The job is running with 1 processing node. Design: The job has one oracle connector stage as source. With 2 other connector stages as used for lookups with one target connector stage. Also there are one sort stage and transformer stages has been used...
- Fri Sep 05, 2014 8:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle Connector Stage error with "LOG ERRORS INTO"
- Replies: 0
- Views: 2695
Oracle Connector Stage error with "LOG ERRORS INTO"
Hi I am using Oracle connector stage to insert records into target database table. I am using user defined insert statement only where I am trying to use "LOG ERRORS INTO" clause to insert rejected records in a different database table.But to do this I am getting errors as : ORA-38909: DML...
- Sun Oct 07, 2012 8:19 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Vertical Pivot without any grouping column
- Replies: 3
- Views: 3764
Vertical Pivot without any grouping column
I have input data coming as : In_Field A ----------- 1a 2e 3f 7h 8t . . . n I need to map this input field value to 3 separate output fields. Ot_FieldA Ot_FieldB Ot_FieldC -------------------------------------- 1a 2e 3f 7h 8t .... ... .... .... I dont have any input field to group by the set (3 rows...
- Wed Oct 03, 2012 8:50 am
- Forum: General
- Topic: Password expired for datastage and db users
- Replies: 1
- Views: 2045
Password expired for datastage and db users
We have following users for different accounts in IIS. dasusr1,db2inst1,db2fenc1,xmeta,dsadm,iauser. Now we have all the users password expired as not being created with 'never expire' option. We are not able log in to the ds client. Even not able to restart the IIS. Please advice how to change the ...
- Wed Aug 08, 2012 12:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 load parallel instance
- Replies: 1
- Views: 1658
DB2 load parallel instance
We are running DB2 connector stage with Bulk load option. We are having following configuration : 4 cpu 4 Nodes in configuration file. All are non-db2 nodes as no node is specified for db2 only. When the job is running in log it is showing : running on non-db2 nodes. But only one process is being ge...
- Tue Aug 07, 2012 11:31 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Remove duplicate issue
- Replies: 2
- Views: 2505
Remove duplicate issue
We are having problem with remove duplicate stage.We are getting different outpu set for different run of the same job.Our requirement is to sort the source data on 3 different fields(A,B,C).Then preserving the sort order we need to remove duplicate on field D. We tried it like: Design 1. Source -Co...
- Thu Jun 07, 2012 8:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 sequence implementation in datastage
- Replies: 3
- Views: 3819
DB2 sequence implementation in datastage
I have one db2 main query which needs to be run for day 0 to the day calculated by following db2 query(select (days(last_day(CURRENT_DATE)) - days(to_date('20120101','YYYYMMDD'))) from SYSIBM.SYSDUMMY1). day value is passed as a parameter to the main query. I have the one job to run the main query w...
- Wed Jun 06, 2012 2:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: character field null issue
- Replies: 3
- Views: 2407
- Wed Jun 06, 2012 2:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: character field null issue
- Replies: 3
- Views: 2407
character field null issue
I have one source field 'A' defined as nullable varchar(5).The target database field is defined as nullable char(2). Whenever null values are coming in source field some unknown character is getting inserted in target field.Target database is DB2. Running ascii(A) function against the field(A) in th...
- Tue May 29, 2012 8:59 am
- Forum: General
- Topic: Datastage director job scheduling issue
- Replies: 5
- Views: 4554
Thanks Chulett for replying. I have schedule one job to run at particular time and another job to be run daily.In director I can see also that this jobs scheduled at mentioned time. But in linux server ,using 'crontab -l' or 'atq' command ,cant see any entries against that user.Also the jobs are not...
- Tue May 29, 2012 6:51 am
- Forum: General
- Topic: Datastage director job scheduling issue
- Replies: 5
- Views: 4554
Datastage director job scheduling issue
We are working on datastage v8.7 installed on linux server. We are trying to schedule jobs/sequences from datastage director.But the scheduled jobs or sequence are not getting triggered at all. We have check in the server we have access issuing crontab commands for that particular user.But in case o...
- Thu May 17, 2012 3:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: sequential stage read issue with double quotes used as data
- Replies: 5
- Views: 4455
- Thu May 17, 2012 2:55 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: sequential stage read issue with double quotes used as data
- Replies: 5
- Views: 4455
- Thu May 17, 2012 2:27 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: sequential stage read issue with double quotes used as data
- Replies: 5
- Views: 4455
sequential stage read issue with double quotes used as data
We are reading txt files using sequential stage with Quote property set as 'double'. But we are getting few rejections for data records like : 7724,"4957","""VENTILATION"" PNEUMONITIS",132,"Lung disease due to external agents",,"","Dia...