Search found 44 matches
- Thu Jul 17, 2008 3:02 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 Upsert in too slower to Mulit Partitions
- Replies: 1
- Views: 1857
Re: DB2 Upsert in too slower to Mulit Partitions
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...
- Thu Jul 10, 2008 7:34 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 Upsert in too slower to Mulit Partitions
- Replies: 1
- Views: 1857
DB2 Upsert in too slower to Mulit Partitions
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...
- Wed Apr 23, 2008 7:41 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How long time to need to start with DB2 64 partitions
- Replies: 6
- Views: 3860
Suggested Machine and BCU Architecture
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...
- Wed Apr 23, 2008 6:10 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How long time to need to start with DB2 64 partitions
- Replies: 6
- Views: 3860
How long time to need to start with DB2 64 partitions
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...
- Thu May 11, 2006 3:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 Enterpirse Stage use /tmp directory to making temp file
- Replies: 7
- Views: 4066
- Thu May 11, 2006 1:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 Enterpirse Stage use /tmp directory to making temp file
- Replies: 7
- Views: 4066
- Thu May 11, 2006 12:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 Enterpirse Stage use /tmp directory to making temp file
- Replies: 7
- Views: 4066
DB2 Enterpirse Stage use /tmp directory to making temp file
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...
- Thu Feb 09, 2006 8:14 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 UDB Enterprise Stage with "Load" Write Method
- Replies: 0
- Views: 1381
DB2 UDB Enterprise Stage with "Load" Write Method
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...
- Thu Jan 26, 2006 7:05 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to execute cognos transformer through DataStage ExecDOS
- Replies: 3
- Views: 3722
How to execute cognos transformer through DataStage ExecDOS
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 ...
- Tue Jul 26, 2005 2:14 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Again TIMEOUT(-14) .
- Replies: 2
- Views: 1572
Again TIMEOUT(-14) .
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...
- Tue Jul 05, 2005 1:54 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Sequencer Job is aborted in DS7.5.1
- Replies: 13
- Views: 7061
- Mon Jul 04, 2005 6:36 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Sequencer Job is aborted in DS7.5.1
- Replies: 13
- Views: 7061
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...
- Mon Jul 04, 2005 6:29 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Sequencer Job is aborted in DS7.5.1
- Replies: 13
- Views: 7061
- Mon Jul 04, 2005 4:14 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Sequencer Job is aborted in DS7.5.1
- Replies: 13
- Views: 7061
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...
- Mon Jul 04, 2005 3:31 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Sequencer Job is aborted in DS7.5.1
- Replies: 13
- Views: 7061
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 ...