DSXchange

I found out the problem. This is caused by DB2 Fix Pack 9.1.5 I downgraded DB2 9.1.5 to 9.1.4 It's solved it. Hi All This week, I have installed DataStage Enterprise Edition on MPP Environment. after that, I check functionality or performance of DataStage Server , Parallel Job. My Problem is that Wh...

Hi All This week, I have installed DataStage Enterprise Edition on MPP Environment. after that, I check functionality or performance of DataStage Server , Parallel Job. My Problem is that When I upsert data to single partition table. Row per Second is aroubd 20,000 records. but When I upsert data to...

Hi Now IBM has suggested Db2 BCU Architecture with datastage EE. My role is a design of ETL Architecture with this platform. The Platform is below ============= It consists of 10 P570 Macnines. One of Machine is DB2 Admin BCU and another is ETL BCU (ETL Main Machine, ETL Main machine has 12 core (24...

Hi All Now I am participating DW Project with DataStage PX and DB2 BCU Architecture. This system will Near Real Time DW with huge volumn data. So DBA draws 64 Partition Configuration on 8 SMP Machines. My Concern is how long time to need to start DS PX Job with DB2 Enterprise Stage. Does Any body ha...

Hello, I think that if you have not configured the DB2 Enterprise Options, the stage is using the /tmp directory by default for Local Message files and other DB2 load files. You can add the "Message File" options, available in the stage and use your own directory. I configured the DB2 ent...

kumar_s wrote:Datastage Adminstrator cleint --> Project --> Properties -- > Environment -- >General ---> TMPDIR

I changed This Parameter /tmp ==> /disk1/dstmp already But result is same.

PLS Help me.~~

Hi All, I Now use db2 enterpise stage for loading data with write method "load". then My Concern is that Each Job exhaused "/tmp" for making tempaory file, msg and error file also. My machine is allocated small size volume for /tmp. So I want to change direcotr /tmp to /disk01/tm...

Hi All, I want to use DB2 UDB Enterprise Stage with "Load" Write Method. but That job was aborted with a message. the message is below DB2_UDB_Enterprise_14: Error Idx = 1; DB2 Driver Embedded SQL message: ; sqlcode = -332; sqlstate = 57017 Failed to connect to the database but When I chan...

Hi All Now I have tried to execute Cognos Transformer Command throuth DataStage ExecDos Routine. the Command is below. "C:\Program Files\Cognos\cer2\bin\trnsfrmr.exe" -n -s "D:\OLAP\Model\hlc-m-01.pyi" When I ran this command using Windows Terminal Service. It's Okay. But When I ...

I am using DataStage 7.5.1A on AIX 5.3. a problems is that some jobs have aborted on schedule. I checked log in Director. There are just one message. Job has aborted because of Timeout[-14]. Some one said to me the reason is that too many jobs to run concurrently. So I arranged schedule. so the Maxi...

Unfortunately the only detection in DataStage is the timeout when a job fails to start within a hard-coded interval. That is we can't tune the timeout. And, as you noted, the job that can not start aborts. You probably could do something with UNIX, but there's nothing supplied "out of the box&...

JdDSSJOBUpdate_T1_JC_JOB_PARAMETERS_Hf is just one of server job. the job processes reading sequence file and transfomrating and looking up some hashed file , and writing to sequence. It's plain job. I recognize now my problem with utilizing H/W Resource Usage. But I wonder how to protect job from a...

You are right.
but I just want to control how to retain this process until getting H/W Resource.
the current issues is that ds jobs have aborted when resource lack.

Now Current System available resource is 2 ~ 0 when Sequencer jobs running.


Thank your hands in advance.

Does the same server job timeout each time? I suspect that it does not; could you stagger your 30 concurrent calls by making some of them depend upon others finishing? Also, monitor your cpu usage while these are running, vmstat should be detailed enough. Each job is different one. and this machine...

Do you run in multiple instance? No, I did not use multi instance. but this entry-point sequencer job runs 30 more server jobs concurrentyly. So I wonder datastage engine could not start some child jobs. I used Unix (with 16CPUs, 60G Memory) for datastage process. SO I wonder why datastage did not ...