Search found 224 matches

by attu
Mon Mar 31, 2008 11:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: LIST DS_JOBS
Replies: 12
Views: 9802

LIST DS_JOBS

Hi, when doing an export a job gets associated with the process and gets locked, this job does not exist in the manager and has been deleted. LIST DS_JOBS WITH @ID='JOBNAME' job name... description.... category .... 1 records listed Doing a select on ds_audit table returns Compiling CLASS FIELD(KEY,...
by attu
Mon Mar 17, 2008 10:02 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: XML Input Stage
Replies: 3
Views: 1027

chulett wrote:I got 8 hits when I searched for C Stage PlugIn function "Run" required, did none of them help? ...
The job is acting kind of weird, it aborts couple of times and then finishes successfully.
I am not sure whats happeneing?

Any suggestion is appreciated.

Thanks
by attu
Fri Mar 14, 2008 1:15 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DS Export
Replies: 14
Views: 6122

What was the first version of DataStage ?
was it Release 3.6 of Ardent's ?
by attu
Fri Mar 14, 2008 12:59 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DS Export
Replies: 14
Views: 6122

Hi Andrw,
Current version 7.5.1A is not the first one installed.
It's a Server Job and compile date is 2/11/2005.

Thanks
by attu
Fri Mar 14, 2008 9:55 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DS Export
Replies: 14
Views: 6122

DS Export

Hi,

I got this message after exporting dsx.

Code: Select all

Job ProvMembrHistUpdate has not been compiled with a compatible version of the job compiler.
Any thoughts?

Thanks
by attu
Tue Mar 11, 2008 3:48 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: XML Input Stage
Replies: 3
Views: 1027

XML Input Stage

Hi we are getting these errors in an xml job CFR310ACISXML..ACIS_XML_Input: C Stage PlugIn function "Run" required CFR310ACISXML..ACIS_XML_Input: |-100| The same job ran fine earlier. :? In manager, what does register a plug in means ? If code is migrated to a new environment do we need to...
by attu
Tue Mar 11, 2008 10:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Protecting a Project
Replies: 7
Views: 1800

well my concern was that he should be able to do import export but IF he wants to open a job for whatsoever reason , he should be able to accomplish it but not execute the job..
by attu
Tue Mar 11, 2008 9:45 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Protecting a Project
Replies: 7
Views: 1800

Re: Protecting a Project

If all they need to be able to do is "Import/Export jobs", then why not just give them access to scripts that contain the dscmdexport/dscmdimport commands? And BTW, why do they need to "see" the job to be able to import/export them? If they could take a look at their job designs...
by attu
Tue Mar 11, 2008 9:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Protecting a Project
Replies: 7
Views: 1800

not really...we want to limit the access to this old env until we shut it down completely.
by attu
Tue Mar 11, 2008 9:14 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SDK Sequences
Replies: 8
Views: 4861

Thansk gateleys.. i will try that
by attu
Tue Mar 11, 2008 9:13 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Protecting a Project
Replies: 7
Views: 1800

Protecting a Project

Hi, We have migrated code from old environment to new env, we need to do following steps. All developers can see the jobs in old env and import and export them. No one can edit or compile jobs or execute them. Can we protect the project or assign the dstage group Operator Role? any thoughts please. ...
by attu
Mon Mar 10, 2008 5:15 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Connecting to Remote DB2 V9
Replies: 5
Views: 1961

We have asked the DBA to to run a bind20 and newly created plan be granted public.
by attu
Mon Mar 10, 2008 3:13 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SDK Sequences
Replies: 8
Views: 4861

Hi,

When I checked in the administrator for the old environmnet and new one using this command

Code: Select all

SELECT @ID, F1, F4, F5 FROM SDKSequences USING DICT VOC
I got the same values for F1.

Does it mean we have the next value already updated in the new environment?
by attu
Mon Mar 10, 2008 2:20 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SDK Sequences
Replies: 8
Views: 4861

Re: SDK Sequences

SELECT @ID, F1, F4, F5 FROM SDKSequences USING DICT VOC; F1 column gave me a value , is this the last surrogate key number used in the routine? F1 is the last_value + 1 (or, Next_Value) for the sequence name given by @ID. I don't know what F4 and F5 are. Thanks for the reply. So if we happen to mov...
by attu
Mon Mar 10, 2008 1:39 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SDK Sequences
Replies: 8
Views: 4861

SDK Sequences

Hi, We are trying to find out the current value of the keys (SDK keymngmnt) in Administrator. This is the command I run, SELECT @ID, F1, F4, F5 FROM SDKSequences USING DICT VOC; @ID tells the name of the routine, what is F1, F4,F5,F6 and LOC ? F1 column gave me a value , is this the last surrogate k...