Search found 126 matches
- Tue Dec 16, 2014 7:27 am
- Forum: General
- Topic: Identify userid which used to execute jobs
- Replies: 7
- Views: 5731
- Thu Dec 04, 2014 6:28 pm
- Forum: General
- Topic: Unable to delete Datastage Job
- Replies: 3
- Views: 5233
- Wed Dec 03, 2014 11:47 am
- Forum: General
- Topic: Unable to delete Datastage Job
- Replies: 3
- Views: 5233
Unable to delete Datastage Job
Hi I am unable to delete Datastage Job in one of my Project, It is giving below eerror: Unable to delete the item(s). Delete object for '\Jobs\Feeds\GlobalArtist\INTL305101_ArtistDuplicateValidation' failed.Cannot open executable job file RT_CONFIG205 This error occurred on 03/12/2014 at 17:43 (Stan...
- Fri Nov 14, 2014 4:29 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job Performance
- Replies: 8
- Views: 10569
- Thu Nov 13, 2014 11:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job Performance
- Replies: 8
- Views: 10569
Thanks Everyone, I have increased the RMU and Job looks fine. Arndw: ODBC Stage extracting the 21K/Sec and when it goes to the Sort stage it's come down to 16K/Sec. I need some help on increasing the throughput in Sort Stage. I tried increasing the Buffer in Sort Stage but couldn't see any differenc...
- Tue Nov 11, 2014 5:59 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sequential File - 2 Character Delimiter
- Replies: 3
- Views: 2914
- Tue Nov 11, 2014 4:48 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job Performance
- Replies: 8
- Views: 10569
Job Performance
Hi I have Datastage Job which does Null Validation, Duplicate Validation and finally loads into Dataset. Which takes around 50MINS to complete(27 million Rows). I would like to improve the performance can some one advise on? ODBC Stage --> Transformer(Validation) Sort--> Transformer(Duplicate Remova...
- Sat Nov 01, 2014 5:59 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Scratch Disk & Resource Disk Space Issue
- Replies: 6
- Views: 3189
- Tue Oct 28, 2014 3:08 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Scratch Disk & Resource Disk Space Issue
- Replies: 6
- Views: 3189
- Tue Oct 28, 2014 12:02 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Scratch Disk & Resource Disk Space Issue
- Replies: 6
- Views: 3189
I am Sorry.... if it means in that way. But I would like to know How much space Resource Disk We need to process 1 GB Flat File(CSV), Because I am processing one file which is 30GB which is creating 230GB Files in Resource Disk Area where I have no transformations Just removing the Duplications if t...
- Tue Oct 28, 2014 10:49 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Scratch Disk & Resource Disk Space Issue
- Replies: 6
- Views: 3189
Scratch Disk & Resource Disk Space Issue
Hi I have Data stage Job which process the file has 30GB(14m Rows). Which will Remove the Duplicates and writes the valid data into Dataset. Which is creating 230 GB datafiles in Resource Disk and 200GB temp files in Scratch Disk. Does Dataset Data files become these many time on actual raw files? A...
- Fri Oct 17, 2014 1:47 am
- Forum: General
- Topic: Identify userid which used to execute jobs
- Replies: 7
- Views: 5731
Identify userid which used to execute jobs
Hi Is there any way to find the user name which is used to execute the datastage job/sequence??? Because i am trying to execute batch script through datastage sequence. But it was successful and there were no error. I thought it might be access related issue. The script is working when i execute on ...
- Sat Oct 11, 2014 4:07 pm
- Forum: General
- Topic: Password Encryption through ParameterSet
- Replies: 1
- Views: 1201
Password Encryption through ParameterSet
Hi I have Database table with all Database Names, User Name and Password(Text). I have Datastage Job which creates Parameter Set when i set Password parameter as Encrypted, Job is failing due to password incorrect,it was success otherway round. But i want to make this encrypted. is that possible? Th...
- Tue Aug 12, 2014 9:41 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unable to load huge data onto Field in Sql Server
- Replies: 0
- Views: 2726
Unable to load huge data onto Field in Sql Server
Hi, I am trying to load flat file on to Sql Server table. There is one field which has huge data its almost 2000000 bytes. I am extracting this using "LongNVarchar" data type in Datastage and loading into "ntext" datatype column in Sql Server. I am getting below error when i exec...
- Thu Jul 24, 2014 4:23 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ODBC Connector - Design time information error
- Replies: 3
- Views: 3144