DSXchange

do I change the array size and the record count. What's the difference? Do they always have to match?

We link sort/partition in a slowly changing dimension stage then the data continues to an aggregator and a transformer before loading via a db2 connector stage. The aggregator and transformer are set to "auto" for partititioning.

Hi, thanks for reading. Getting the following error. Using a DB2 connector stage. db2IIW_Bus_Key_Xref_OUT,5: DB2 information: SQLSTATE = 40506: Native Error Code = -1476: Msg = [IBM][CLI Driver][DB2/AIX64] SQL1476N The current transaction was rolled back because of error "-911". SQLSTATE=4...

Looks like something corrupted the jobs during the migration between our test and prod environment. To fix the problem we simply tried the migration again. Everything works now.

Here are more messages from the log

db2Type_IN: Property : Property not valid in source context
main_program: Creation of a step finished with status = FAILED.

Thanks for reading. getting the error below when running a job using a Datastage sequencer job activity. The job runs fine when I run it directly without using the sequencer. The weird thing is the sequencer will work for days then it aborts with the error below. It's as if something gets corrupt so...

Seems to be working for me. We use the aggregator stage to bring fields from multiple records with the same keys into one record. As of now the data looks good. In the agg stage I'm using the sort method versus hash. Warnings are gone.

Thanks for your help.

Yes..it should be set to false. Which means it should take care of the sorting correct?

Auto Partition should should take care of any sorting that needs to be done...correct? always thought if you have the env variables below set to true DS will sort for you based on the grouping keys used in the agg stage by inserting tsort and partitioning operators? APT_NO_SORT_INSERTION = TRUE APT_...

So do I need to do my own sort or let datastage handle by using partition type = auto?

Thanks for reading. Getting warnings when using an agg stage. Hash Table has grown to 32768 I did a forum search and found that sorting on the grouping keys will elimintae the warning. If my 'partitioning type' is set to 'auto', is sorting required...wouldn't partition type set to auto take care of ...

My gut feeling was correct...I should have seen something different in the log. In teh code copy/pasted in my previous post....I was only passing one argument to DSLogFatal. I'm passing two now and see the following in the log. "Warning in testjob" which is what I expected to see. Everythi...

Hi, I added logic to an existing after job sub routine. The new logic should aborts jobs that finish with warnings. Below is the code I have added. If ObjectStatus = "Finished with warnings" Then Call DSLogFatal("Warning in":JobName) return End When there are no warnings the job ...

Hi thanks for reading and your help. In my after job routine I check the job status JOBINTERIMSTATUS then call DSLogFatal. I 'm having issues trying to call DSLogFatal() ....nothing happens in my routine when the job finished with warning. Should I pass arguments when calling DSLogFatal...anyone hav...

Hi chulett, I must admit creating routines is not my strength...work in a shop that doesn't create a whole lot of routines. Do you have a routine that does what you desribe?