Search found 131 matches

by GJ_Stage
Thu Mar 10, 2011 5:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: preclude direct parallel loading
Replies: 1
Views: 2240

Add parameter : APT_ORACLE_LOAD_OPTIONS
value is : OPTIONS(SKIP_INDEX_MAINTENANCE=TRUE)
in your job and then try.
by GJ_Stage
Wed Mar 09, 2011 10:44 am
Forum: General
Topic: Unable to open "D_DS_JOBS"
Replies: 6
Views: 2793

Still not able to see the jobs after attempt DS.REINDEX ALL command in admin.

It is saying "Unable to open DICT DS_JOBS"...
by GJ_Stage
Wed Mar 09, 2011 10:19 am
Forum: General
Topic: Unable to open "D_DS_JOBS"
Replies: 6
Views: 2793

Hi Craig ,

Your help more appreciated here.
by GJ_Stage
Wed Mar 09, 2011 10:07 am
Forum: General
Topic: Unable to open "D_DS_JOBS"
Replies: 6
Views: 2793

Still not able to see the jobs after attempt DS.REINDEX ALL command in admin.

It is saying "Unable to open DS_JOBS"...


Please help.
by GJ_Stage
Wed Mar 09, 2011 8:53 am
Forum: General
Topic: Unable to open "D_DS_JOBS"
Replies: 6
Views: 2793

Unable to open "D_DS_JOBS"

I am getting Unable to open "D_DS_JOBS" file error message while running SELECT category FROM DS_JOBS WHERE NAME = 'job_name' in admin.

Please help. how to solve this issue?
by GJ_Stage
Wed Mar 09, 2011 8:25 am
Forum: General
Topic: Jobs not displaying.
Replies: 2
Views: 1575

Thanks.

I will do search DS.REINDEX ALL..
by GJ_Stage
Wed Mar 09, 2011 8:08 am
Forum: General
Topic: Jobs not displaying.
Replies: 2
Views: 1575

Jobs not displaying.

We are facing an issue while opening jobs under one project. We are not able to view any jobs in designer. But we are able to call the job thru unix.

Please help this issue.

Thanks.
by GJ_Stage
Thu Feb 17, 2011 4:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Orchadmin command
Replies: 7
Views: 5183

Re: Orchadmin command

Try to find anyone of the ds command in main path like below :
find . -name 'dssearch'
by GJ_Stage
Thu Nov 25, 2010 6:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Using APT_ORACLEAPT_ORACLE_LOAD_OPTIONS
Replies: 2
Views: 1414

If you this value (OPTIONS(SKIP_INDEX_MAINTENANCE=TRUE) then It will skip indexes while loading. It will enable the indexes automatically once loading got completed.
by GJ_Stage
Mon Sep 27, 2010 5:41 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: default values in schema file
Replies: 3
Views: 2891

Try this:

Without Default value

FIELD_NAME:nullable string[4] {null_field=' '}

With Default value

FIELD_NAME:nullable string[4] {default='test', null_field=' '}
by GJ_Stage
Thu Jul 22, 2010 4:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: max number of invocation id.
Replies: 4
Views: 1488

Thanks Ray for your reply. :P

As you said "physical limitation deriving from the capacity of the server".
Can you tell me sample server name and capacity we can maintain invocation id. This will very helpful to me to define the same in Production machine.
by GJ_Stage
Thu Jul 22, 2010 4:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: max number of invocation id.
Replies: 4
Views: 1488

max number of invocation id.

Can someone help me how many invocation id jobs can create under one job. Sample : One job called ReadProcess. We are calling the same job using invocation ids like below ReadProcess.load1 ReadProcess.load2 ReadProcess.load3 What I am asking is, how many jobs we can call using invocation id like abo...
by GJ_Stage
Wed Jul 21, 2010 2:36 am
Forum: DSXchange Testimonials
Topic: Thanks Ray - 40000+ posts!
Replies: 3
Views: 22041

It is really a great news. Thanks a lot.
by GJ_Stage
Tue Jul 20, 2010 9:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Dataset write job hung
Replies: 5
Views: 2726

Can you able view the log in director? If possible please provide the log details to check.
by GJ_Stage
Fri Jul 09, 2010 5:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Aggregator error.
Replies: 2
Views: 2037

code is like this :

Both aggregator stage starts from 2 ds then output of aggregator is input of Join then this output is redirecting to final ds.