Search found 37 matches

by Pete Morris
Thu Apr 17, 2008 9:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Warning Message - APT_CombinedOperatorController
Replies: 2
Views: 1307

Yes you were right it was a data type mismatch.

I was pulling in a job parameter as the start value within the surrogate key stage. It seems the supplied start parameter needs to be a string.
by Pete Morris
Wed Apr 16, 2008 6:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Warning Message - APT_CombinedOperatorController
Replies: 2
Views: 1307

Warning Message - APT_CombinedOperatorController

I am encountering the following warning message:-

APT_CombinedOperatorController,1: Failure parsing the init expression X+part; the default value of 0 will be used.

but the job produces the expected output.

Any ideas what the warning relates to?
by Pete Morris
Wed Feb 13, 2008 3:09 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unable to Save Jobs
Replies: 8
Views: 4137

Guys,
you were right, we have exceeded the unix limit for subdirectories.

Can this limit be increased or is it fixed?
by Pete Morris
Tue Feb 12, 2008 10:24 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unable to Save Jobs
Replies: 8
Views: 4137

Tried the rebuild index command but still get the same error.
by Pete Morris
Tue Feb 12, 2008 7:25 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unable to Save Jobs
Replies: 8
Views: 4137

Unable to Save Jobs

When trying to save a job the following message is encountered
'cannot open executable job file RT_CONFIG6311'

Any ideas?
by Pete Morris
Tue Jun 19, 2007 5:33 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: 64-bit hashed files
Replies: 1
Views: 1161

64-bit hashed files

If a hashed file is converted to 64-bit do all the DS jobs that access the file need recompiling.

Also are there performance implications of using 64-bit hashed files.
by Pete Morris
Tue Jun 05, 2007 2:24 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: oracle bulkloader stage not trapping oracle error mesages
Replies: 2
Views: 1539

Yes i am using automatic mode.

I will change the job to use SQL*Loader instead.

Thanks for your help.
by Pete Morris
Mon Jun 04, 2007 9:28 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: oracle bulkloader stage not trapping oracle error mesages
Replies: 2
Views: 1539

oracle bulkloader stage not trapping oracle error mesages

When encountering oracle error
'ORA-01653: unable to extend table VAM_OWNER.ASAT_ARECVBL by 3200 in tablespace ASA_DATA_LM_50M using the oracle bulkloader stage the stage nor the job aborts.

Is there a way to ensure that the job aborts if the above oracle error message is encountered.
by Pete Morris
Fri Apr 20, 2007 3:12 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Import and Compile of large number of jobs
Replies: 7
Views: 3132

Import and Compile of large number of jobs

We are trying to import 2000 job designs using DS manager and then compile them.
It is taking 5 hours to complete the import and 2 hours to compile them.
The jobs already exist in the target project but are being updated with new versions.

Is there any way i can speed up the process.
by Pete Morris
Mon Apr 16, 2007 2:46 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: "Error selecting from log file RT_LOG862"
Replies: 9
Views: 7409

i imported the old project into a new project.
This resolved the problem.

If this happens again i will use the 'LIST.ITEM VOC 'job number' command as suggested.

Is there a TCL command that will tidy up a corrupted job.
by Pete Morris
Thu Mar 15, 2007 2:58 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Director Crashing
Replies: 9
Views: 4441

I ran DS.TOOLS and rebuilt the indicies and it resolved the problem.

Thank for your help.
by Pete Morris
Wed Mar 14, 2007 7:57 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Director Crashing
Replies: 9
Views: 4441

I have tried rebooting and the error still occurs.
Also in designer there are two versions of the job; not sure why.

DS version is 7.5.1.
by Pete Morris
Wed Mar 14, 2007 5:33 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem deleting sequence in designer
Replies: 3
Views: 1396

I created a copy version of the job and created another RT_CONFIG1521 file based on the RT_CONFIG file associated with the copy version.

This allowed me to delete the sequence job.
by Pete Morris
Wed Mar 14, 2007 5:27 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Director Crashing
Replies: 9
Views: 4441

It is affecting all clients.