Search found 4605 matches
- Wed Mar 16, 2016 7:46 pm
- Forum: General
- Topic: Whence Windows?
- Replies: 2
- Views: 1970
- Thu Mar 03, 2016 1:52 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML staging - tables or files more efficient?
- Replies: 4
- Views: 3353
I agree with Ray. I never store XML in tables. I would prefer to parse the XML and then write to a table. Then I can format it to whatever is need down the line. In a table you can also query it. It is easy to resend something. It is easy to reconcile. How many rows did I process on Tuesday? Lots of...
- Mon Feb 29, 2016 9:47 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Amount field in Complex Flat File in Parallel Vs Server
- Replies: 21
- Views: 11561
- Mon Feb 29, 2016 9:45 am
- Forum: General
- Topic: change file system of DataStage installation
- Replies: 8
- Views: 3980
If all the paths are the same to the engine and the projects then this should work. If you changed the paths to the projects by editing UV.ACCOUNT records then that is your problem. The only other issue that could bite you is the mount points are considered B NFS mounts or some other kind of network...
- Mon Feb 29, 2016 9:41 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: BW load stage Environmental variables
- Replies: 2
- Views: 2632
- Mon Feb 29, 2016 9:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ODBC join tables limitation
- Replies: 10
- Views: 5933
Not the same query in the 2 examples. The first example: from table 1 lst inner join table2 ent ON ent.ENT_NO=convert(varchar(9),lst.key) and ent.CUR_FLG = 'Y' inner join table3 ctry on ent.key = ctry.key and ctry.CUR_FLG='Y' inner join table4 on ent.ENT_NO = convert(varchar(9),dps.key) and dps.FLAG...
- Mon Feb 29, 2016 9:31 am
- Forum: General
- Topic: OCONV and ICONV clarification
- Replies: 2
- Views: 2008
- Mon Feb 29, 2016 9:29 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Insert into Oracle with reserved word
- Replies: 3
- Views: 16825
If you use generated code then add a quote character to properties then it will get the correct quote character. I am not sure what Oracle's quote character is but it appears not to be a double quote otherwise this would work. Most databases work this same way. Keywords can be column names if quoted...
- Mon Feb 29, 2016 9:18 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DataStage partitioning
- Replies: 6
- Views: 4555
- Thu Feb 18, 2016 9:25 pm
- Forum: General
- Topic: IIS 11.5 on RHEL 7
- Replies: 7
- Views: 6308
Not a lot of benefits for separate mount points if on the same SAN if they share the same physical drives. The only benefit is the size of the disk space is reduced. The SAN itself tries to spread the load and most are not optimized for ETL. There is usually lots of buffering in the SAN which helps ...
- Thu Feb 18, 2016 9:16 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: 11.5 Backward compatibility not working
- Replies: 6
- Views: 15138
- Thu Feb 18, 2016 9:12 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DataStage partitioning
- Replies: 6
- Views: 4555
If you run a job that runs in 5 minutes with a 1x1 in DEV with 10,000 rows. Then you run same job with 8x8 and it runs in 2 minutes. Does not have much to do when you run 10 million rows through it in PROD. Does not mean it will only be 2.5 times faster. It might be closer to 8 times faster. It also...
- Thu Feb 18, 2016 8:43 pm
- Forum: General
- Topic: Automate Datastage Job cleanup
- Replies: 2
- Views: 2647
EtlStats had a way to get row counts on every job. We used this to see when the last time a job ran to do a similar removal of old jobs. Any jobs not ran in the last 45 days was assumed to be a candidate. That way if a job runs monthly then you are safe. If a job runs annually then you might have is...
- Thu Feb 18, 2016 8:31 pm
- Forum: General
- Topic: Writing Job log into UNIX file
- Replies: 6
- Views: 4164
I have a script which does this. Here are the dsjob calls in that script: GetLogJobEnd=`$DSPath/dsjob -lognewest $ProjectName $GetLogJobName 2>/dev/null | awk -F= '{print $2}'` GetLogJobBeg=$( $DSPath/dsjob -logsum -type STARTED -max 2 $ProjectName $GetLogJobName 2>/dev/null | head -1 | awk '{print ...
- Sun Feb 14, 2016 9:48 pm
- Forum: General
- Topic: Can we create separate log for Multiple instance jobs?
- Replies: 7
- Views: 3558