DSXchange

not sure what the fix pack did..but we took it off and we are back to normal..

i guess datastage is having tough time to get partition information(we use db2 partition option in db2 stage) with new fix pack 10.

any pointers appreciated

Hi

we recently upgraded our db2 with fix pack 10. We are having performance problems with regular loads. The jobs are running just fine in production for over a year and we never had any issues with earlier fix packs.

Datastage 7.01 R1
Aix 5
DB2 UDB V8

is anyone in a similar situation?

What you're trying to achieve is called a vertical pivot - you can search the Forum for techniques. For a small, finite number of rows the stage variables approach is indicated, but you need to ensure that all values for each pivot key occur on the same processing node. Do this by partitioning and ...

Hi

i have a requirement which is as below.

i have 2 rows
A,P1
A,P2

A is the key. i want a ouput row as

A,P1,P2

I did this once using awk,but its too slow for huge volumes of data. So i want this to be done in datastage. Is it possible?

tia
pavan

i get the following messages in the log.. APT_CombinedOperatorController(1),0: The current soft limit on the data segment (heap) size (2147483645) is less than the hard limit (2147483647), consider increasing the heap size limit APT_CombinedOperatorController(1),0: Current heap size: 2,141,571,120 b...

How can we know our current allocation for osh?

Hi

we are upgrading as specified..Are there any open issues with this upgrade?

Does it require any code changes?

what we did is..

if u know the format of date like if it comes in 12/5/2005 we use to parse it and then build 12-05-2005 and then use the existing functions.

generate a unique sequence number using the surrogate key stage,then have a transformer,then use Mod() function and check value to 1 thru 8. u shud have a 8-way configuration file.

ray,

i am unable to find a link on IBM site for this test..can u provide me please?

Is there any way in dataStage where we can change the repository information in backend as in informatica In one of our project , the requirement is to add the description in all jobs (there are 500 + jobs ). Now instead of open each job and then add description in it, can we do something directly i...

Do we really need to worry about the warnings that appear in the log..my jobs have many numberous warnings,but i never fixed them..it always performs what it is supposed to do..no issues..

let me know if getting rid of warnings is really important..

Hi, While I am trying to convert datatypes for few columns like Varchar to Decimal, Varchar to Date and Varchar to Timestamp which are not nullable on the target table, I am getting following warnings: 1) APT_CombinedOperatorController,2: Numeric string expected, got "". Use Decimal defau...

Can i call a webservice residing on a web server from datastage?

if yes pls let me know..i am using 7.5

Hi, our record length is 930 bytes. we need to store it in a hashed file.The default size is 2gb for hashed file.Till recently we didnt have any problem.recently volume of data increased and the hash file stage is failing..how can we increase the limit of 2gb. i checked ulimit for my id and its unli...