Search found 81 matches
- Thu Aug 18, 2005 4:53 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Trace File Analysis
- Replies: 2
- Views: 2354
Ray, the trace file is quite large so I was just trying to keep the size of the post down. Please let me know if I have extracted enough of it this time. This is just more of Exert1. I suspect it's the same problem, but lets make sure I'm extracting enough of the trace before I post the 2nd exert. 0...
- Wed Aug 17, 2005 10:06 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Trace File Analysis
- Replies: 2
- Views: 2354
Trace File Analysis
I am trying to understand a particular section in a server-side trace file. The 2 exerts are as follows. Exert 1: 0 Arg4=pExecJobName=RunBatchJC.ETL_DEPRE_LOCN_TO_CC_SEQ pParameterFile=/etl/QA2/parameters/datastage_master_parameters.txt pParameterList=pBATCH_NAME=ETL_DEPRE_LOCN_TO_CC_SEQ|pJOB_NAME=E...
- Tue Aug 09, 2005 4:42 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Forcing the JobStatus in a Routine
- Replies: 8
- Views: 4277
I suppose I should have taken a step back and not gone into solutions mode :oops: So now I'm running a sequence using DSJOB but I've changed a UserStatus of a job within that sequence. If I use the -userstatus option I pressume I'll get the UserStatus of the sequence and not the job? Is this correct...
- Tue Aug 09, 2005 12:10 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Forcing the JobStatus in a Routine
- Replies: 8
- Views: 4277
- Mon Aug 08, 2005 11:19 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Forcing the JobStatus in a Routine
- Replies: 8
- Views: 4277
- Mon Aug 08, 2005 11:06 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Forcing the JobStatus in a Routine
- Replies: 8
- Views: 4277
Forcing the JobStatus in a Routine
I am trying to set a special JobStatus for jobs which reject rows based on certain business rules. The job is invoked using dsjob run from a third party scheduler and support needs to know when this situation occurs. I am using a Transform Routine invoked in a derivation of a Reject link. If we get ...
- Thu May 12, 2005 7:31 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: error in oci stage
- Replies: 5
- Views: 2823
- Tue Apr 05, 2005 12:33 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Hash File lookup
- Replies: 3
- Views: 2206
Well ideally you could use 1 transformer and perform both lookups in the same transformer using 2 hashed files as reference inputs. Note: The derivation for the 2nd lookup will show up as an error (in red) but the job will compile successfully and run. Try it out. Does anyone know if this is somethi...
- Tue Apr 05, 2005 12:29 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: CREATE.FILE and path
- Replies: 7
- Views: 3432
- Tue Apr 05, 2005 12:27 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to handle transaction in BASIC ROUTINE
- Replies: 2
- Views: 1715
You can obviously do this a few ways. I would personally use Semaphores for locking and unlocking processes you need shared.
This post will help you get started: <a href="viewtopic.php?t=84481&highlight=semaphores">Click here.</a>
This post will help you get started: <a href="viewtopic.php?t=84481&highlight=semaphores">Click here.</a>
- Sun Apr 03, 2005 5:16 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Fixed Width Files and NLS
- Replies: 6
- Views: 3296
I think Datastage uses UTF8 internally as it's own character map. Other NSL character maps store characters with 2 bytes as opposed to 1. I had a similar problem with the TIS620 Thai Character map and record sizes being to small. Whichever field contained Thai characters was doubled and then it stop...
- Sat Apr 02, 2005 2:48 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: license in datastage 6.0
- Replies: 3
- Views: 2218
- Thu Mar 31, 2005 11:03 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Job Effeciency?
- Replies: 6
- Views: 3635
You could try creating the hash files in seperate jobs and potentially firing them off in parallel could be faster. I think leaving the lookups and the tranforms together in the job should be ok (depending on your row size). Landing to disk is always a last resort. It seems your data is small enough...
- Thu Mar 31, 2005 5:47 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Job Effeciency?
- Replies: 6
- Views: 3635
- Wed Mar 30, 2005 10:19 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: 2 sequence daily job call a monthly job?
- Replies: 7
- Views: 4400