DSXchange

dh_Madhu wrote:may be develop a server job ....Database server can be taxed for the extraction process....

the extraction has to be a parallel odbc process and hence I need parallel job.

dh_Madhu wrote:may be develop a server job ....Database server can be taxed for the extraction process....

the extraction has to be a parallel odbc process and hence I need parallel job.

No..it is not helping. The NZ stage is invoking the number of nodes specified for the job and not getting restricted by any of these.

v2kmadhav wrote:you could change the netezza stage execution properties to sequential. did you try that?

I tried this earlier but used node constraint along with this and it gave me some error. I will try just specifying the sequential.

I have a job which has to extract the data parallel and then insert the data into Netezza. Since the insert into NZ is fast I want only 1 process to insert. In order to extract, I have an parallel odbc stage for which I need to specify at least 4 nodes to pull data fast. So how do I restrict the one...

How do we refilter the returned log rows to just our invocation id??

Did DataStage 8 fixed the bug??

Hi, We are trying to capture logs of jobs into a file as soon as the job finishes. The logic used is: DSJOBN=Jobname.Instance lastmsgid=$(dsjob -lognewest $DSPROJ $DSJOBN | cut -c13-17) dsjob -logdetail $DSPROJ $DSJOBN 0 $lastmsgid > $DSLOGS/${DSJOBN}-${starttime}.log But "logdetail" is fe...

The Problem: I have an input XML in the below format: <ParXML> <Batch> <PR Rpt="101" Dt="2008-01-10"> <Loc ID="00005" Typ="A" /> <Loc ID="40536" Typ="B" /> <Loc ID="00105" Typ="C"> <Subloc ID="6300" Typ="5...

what is the 9i version...Is it 9.2.0.7 or is it 9.2.0.8?? ... We are having problem with java libs with the 9.2.0.7_64 client and 10g database.

The dsenv was changed to point to 10g since one project was migrating to 10g. We have now reverted back to 9i since we know that things will work with old setting. Now the work is to test all the 10G ones and find its problems. Have you guys faced any problems for migrating database to 10G where as ...

Hi, Thanks for the proper direction...I was searching the DS manuals for these options. It is there in the SQL Loader manuals... I have completed the task by using the following option APT_ORACLE_LOAD_OPTIONS= OPTIONS(DIRECT=TRUE, PARALLEL=TRUE, SKIP_INDEX_MAINTENANCE=TRUE,SKIP_UNUSABLE_INDEXES =TRU...

so is there a way for direct load and not to rebuild the index at end.

Hi, I am writing the data into Oracle table with write method as Load and write mode as Append. The table is empty before loading. In this scenario, I don't want to rebuild the index after loading. How can I achieve this. If I specify the APT_ORACLE_LOAD_OPTIONS as OPTIONS(DIRECT=FALSE, PARALLEL=TRU...

We need to extract data from a 10g database to a 9i database application. We created the datastage job and the write method is Load. Since the env file dsenv has path specified as 10g, the loader is failing after it loads the data. I am thinking the failure is becase the sqlloader is looking some 10...

I was thinking of 'lib' files. Has anyone done any changes to this and enhanced the tool..