DSXchange

another way of approaching this is to break the delete statment into chunks - delete from MYTABLE where KEYFIELD in ( select KEYFIELD from MYTABLE fetch first 1000 rows only ) ; And keep running this in a loop until all the records are gone ! Obviously you want to bump up the 1000 fetch limit to som...

sorry sam , was speaking a bit generically - but since I am downloading a patch for UT2004 and twiddling my meterphorical thumbs will try to expand. Basisically a datastage job could take many variables , examples are Source File e.g. /prd/data/CUST_20050101.DAT Target DataBase e.g. BIWAREHOUSETHING...

Hi, we use controlM quite easily here - all it does is run a command line after all but a few points that you may wish to consider a) you could have CtrlM kick of a $DSHOME/bin/dsjob -etc -etc -etc -project PROJNAME -job JOBNAME command but this isnt particular migratable between dev and prod envior...

The transformer Is accessabile through the repository tree ->stage types-->parrell--> processing --> basic transformer Care should be taken as though it still fits the parallel archetiture - it can be a severe bottleneck for each processing node. Cunningly it also looks EXACTLEY the same as the EE t...

The transformer Is accessabile through the repository tree ->stage types-->parrell--> processing --> basic transformer Care should be taken as though it still fits the parallel archetiture - it can be a severe bottleneck for each processing node. Cunningly it also looks EXACTLEY the same as the EE t...

we have been plagued by this one, basically the out the box DS configuration allows for only a set amount of dynamic and static hash files to be open at once. These are specified in uvconfig (see T30Files and Mfiles entrys) once this number is hit then universe starts closing file handles to open ne...

this often means that it cant write a scratch file (used in merge, sorting etc) check disk space - when job running - we hit this and an 'annoyying thing about px is it can clean up nicely if job aborts' so removed tmp files - so cant always see if disk full once job completes. also can be caused (i...

I dont believe all stages are installed by default , unless they are specified in the original install. (Bit of a pain if you forget to do it as you have to add them in after creating new projects - not that you can create old projects - i digress) there is a unix util , something like dspackinst in...

Hi, having some less than performant results with writing to db2 (insert mode) and want to get some input. Basically have a partioned db2 table (20x) and have set up a config.apt on appserver with 4x on app and 1 node for db2 (the db2nodes.cfg) says 20. When using the db2 stage for reads it launchs ...

You can also use the Complex File Stage with multiple output links - the selection page allows you to define the field as the rectype indicator and each output link can have different table defs on it Its a more elegant, and understandable solution but I am not sure about performance vs reading from...

I have had this problem in our set up and I believe it can be resolved by reindexing the version control repository, using DS.TOOLS from the command line in Admin.exe often does the trick

Simple one, is there a standard function to write debug info to job log in my buildop c++ code

Hi , I have a file that has two distinct record types of form RECT1 field1 field2 field3 RECT2 fielda fieldb Question is what is the easiest way to read this using PX v7.1 (I know there is CFF stage in 7.5) I believe I can do something with schemas but am new to this and documentation is a bit uncle...

This can be a pain, but its worth understanding what is going on DataStage maintains a list of locks on all universe files that are used in the system , including runtime files such as RT_CONFIGxx and designtime files such as DS_JOBS (this lock I guess is record level) When a user opens a job in des...

I believe (but will prob get blasted by the likes of Ray) that this can also happen if deadlock daemon enabled and it found a deadlock.

Basically if 'deadly embrace' occurs on a hashfile record/group the daemon kicks in and nobbles one of the offenders