DSXchange

im sure there is no one schedule the job outside of Director.
i will try to log in using other users who might have schedule the jobs , thanks.

I got few job running at everyday 6am.
But i look through those job in Director , those job are not scheduled. (These job probably is schedule before and is set to run once)
Any idea why those job run without schedule?

Thanks

what is the recommendation record count if my job is around 11+ million rows of records?

Thanks

It occurs everytime on the same job and same record count (which is equal to the total record count within the job , 11+ million rows of records.) No changes on the job, but there is some database configuration changes on the logging part. Where i can set the commit interval ? Is it the array size i...

Hi
this problem is just occur recently, previous running prefectly, i was able read from that table. there is no any commit setting in the stage.

Hi All does any one know how to solve this bug on datastage. DB2_Connector_0: SQLEndTran(SQL_COMMIT) reported: SQLSTATE = 08007: Native Error Code = -30,081: Msg = [IBM][CLI Driver] SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communicatio...

This is the error log i got when try to view data in Classic Federation Stage : ##I IIS-DSEE-TFCN-00001 15:52:11(000) <main_program> IBM WebSphere DataStage Enterprise Edition 8.5.0.5746 Copyright (c) 2001, 2005-2008 IBM Corporation. All rights reserved ##I IIS-DSEE-TFCN-00006 15:52:11(001) <main_pr...

i already change the max heap size in administrative console and also the proxy.xml
But the heap size error still there...

in WAS... , is it the Administrative Console under the IBM WebSphere? I able to login , but i can't find where to set the heap size. By the way , i found some guide on changing the heap size in registry , not sure if this is the right one , need some advice first before i change this. To change the ...

My job flow is like this : DB2Connector --> Sort --> Transformer --> Filter --> DB2Connector My source data is around 10m records with 8 columns , final output data is around 1m records with 80 columns. My development server is win2008 r2 with 32g ram. And i got the error at the transformer when i r...

already solve the problem using loop condition under transformer stage. i make the data into : ID,Item1,Item2,Item3,Item4,Item5,Item6,Item7,Item8 001,a1,Null,null,null,Null,Null,Null,null 001,a1,Null,a2,null,Null,Null,Null,null 001,a1,Null,a2,a3,Null,Null,Null,null 001,a1,Null,a2,a3,Null,Null,Null,a...

QualityStage adds "data quality" stages to your DataStage Designer palette. If you check under the "processing" palette category, you should find the Pivot stage. You can mix and match DS & QS stages in the same job design. I look through "Data Quality" and "P...

Ray , i know this section is about DataStage , however i believe my current scenario is more towards DataStage rather than QualityStage. And i already stated that im using QualityStage 8.5 in my first post. Eric , actually i am not familiar on how the transformer loop works but i will try it out. Cu...

I see. But i'm using QualityStage 8.5 and i believe Pivot Stage is not include in QualityStage right ?

Is there any workaround to perform task like Pivot Stage under transformer stage ?

Thanks.

ID Code Value
1 Item1 a1
1 Item3 a2
1 Item4 a3
1 Item8 a4
2 Item1 b1
2 Item5 b2
2 item6 b3

Like this , in DB2