Search found 63 matches

by crystal_pup
Fri Mar 22, 2013 1:00 am
Forum: General
Topic: Make Jobs Readonly
Replies: 2
Views: 2527

I tried by exporting a test job to XML file and then replacing every occurrence of Readonly="0" to Readonly="1".I then imported the job back into the project, however the job is still editable.It appears to me that the only way to make a job read only is to "Protect Project&...
by crystal_pup
Fri Mar 22, 2013 12:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: TD Connector Stage Bulk Load
Replies: 11
Views: 6713

Decrease the array size value to somewhere like 150 or 200.It will solve the problem.
by crystal_pup
Wed Mar 20, 2013 4:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to Split the Huge Data?
Replies: 9
Views: 4966

Can you paste the exact error that you are getting on using the head command on the test.txt file?
by crystal_pup
Tue Mar 23, 2010 7:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Facing the Transformation compilation error
Replies: 6
Views: 4207

We had faced the same issue...however in our case the problem was that we were using lot of stage variables in a single transformer.We removed some of the stage variables and put them into another transformer and then the job compiled successfully...I hope this helps.

Cheers
KD
by crystal_pup
Thu Dec 17, 2009 4:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need to delete temporary datasets after jobs get completed
Replies: 3
Views: 2391

You can use the orchadmin command to delete the temporary datasets.The command sysntax would be :-

../bin/orchadmin rm nameofthedataset
by crystal_pup
Fri Sep 21, 2007 9:16 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Scheduling
Replies: 2
Views: 1493

Hi,

In such a requirement you can make use of scheduling tools that are available.One of them is ControlM Scheduler.You can make use of file watchers to look out for source files.Once the file has arrived in required location then it will automatically trigger the datastage job.


Regards,
Kunal
by crystal_pup
Fri Sep 21, 2007 8:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Abnormal termination of stage
Replies: 1
Views: 964

Hi,

Can you please provide us with more information about the error.Please copy the error which you are getting in the director and we can then analyse the error in more detail.

Regards,
Kunal
by crystal_pup
Tue Sep 18, 2007 8:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: error encountered while connecting to db2 database from ds
Replies: 4
Views: 3964

Hi Arvind, I guess ur account doesnot have the rights /access to ' rsh ' to the ' PNBDWH01 ' server.Please try the following command at your command prompt --> rsh PNBDWH01 If you are able to connect to the server then the error could be because of some other reasons.However if you are unable to rsh...
by crystal_pup
Mon Jul 30, 2007 3:48 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ds_uvopen() - Unable to read file header
Replies: 2
Views: 2647

Hi,

Even we have faced the same problem a couple of times.The action taken by us to resolve such issue is to re run the job by first resetting it.This has till date worked fine for us.

Thanks,
KD
by crystal_pup
Sun Jul 29, 2007 10:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage Administrator
Replies: 4
Views: 2477

My Apologies...

Cheers,
Kunal
by crystal_pup
Fri Jul 27, 2007 5:31 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hashed file size
Replies: 6
Views: 3603

A bit problem with tht...Actually i dont hav administrator rights to the folder wherein the command can be run...Any other way to have it done? When i tried to find the required command it took me to the folders titled CAT and VCOMM within datastage home directory on UNIX server...When i tried to ge...
by crystal_pup
Fri Jul 27, 2007 4:25 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hashed file size
Replies: 6
Views: 3603

Could u pls throw some more light on the above command...Is it run on Windows machine or unix server?

Thanks,
KD
by crystal_pup
Fri Jul 27, 2007 3:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage Administrator
Replies: 4
Views: 2477

Dats right...There is no default password...U gotta hav the admin username as well as the password...However u can still login into the datastage administrator provided ur username is having proper access...but since u r no administrator, u ll hav limited access to project properties n other options...
by crystal_pup
Fri Jul 27, 2007 3:21 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job in Running State
Replies: 19
Views: 9327

Sometimes the job doesnt terminate successfully and takes a lot of time to complete....If u experience such delays then one thing u can do is to empty the &PH& directory from ur datastage home directory.The &PH& directory consists of information abt active stages and every time a job...
by crystal_pup
Thu Jul 19, 2007 5:40 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error in using Fileset
Replies: 9
Views: 3925

Hi, I created the Dept.fs file by using touch command.Actually i developed one job wherein i read data frm a sequential file n wrote it to a Dataset....Tht time also i created the required 'Department.ds' file by using touch command & in the property of dataset i set Update Policy value to Overw...