DSXchange

my first stumbling block: can a 7.5 job read and write to the same hash file as a 7.1 job?

All, We are currently migrating all our jobs from 7.1 to 7.5 and was wondering if there are any special things to watch out for. Things like DB2 stages not working the same, routines and internal commands being slightly different. Containers not working as expected etc etc. Is there a check list / t...

fixed it.. the status code is standard error apparently.

Cheers

I currently run the following command: `cat /.dshome`/bin/dsjob -jobinfo SystemTest TestSeq1 | head -1 and trap the Job Status (i.e.): Status code = 0 Job Status : NOT RUNNING (99) This ok i can get the NOT RUNNING (99) into a variable and test on this part. What i need to be able to do is get the a...

we don't use the 64bit check thing which is why one of my collegues told me about the limit. We are looking at setting this up in the future but as now going to have to alter the processing as we can't set that up on live yet.

think the problem we have had is the files are 2GB+

Had chance to have a look at the job properly now i am back in work. The 1st job creates the hash file fine. then the next checks and writes to the hash file, either writing an update, reject or no processing record all to the same hash file. The stage has none of the boxes ticked in the hash file (...

What happens is we have 4 jobs: 1st = create unload of a table (or part unload in this case) 2nd = create an update file. 3rd = copare the file against the 1st files unload 4th = load changes The process is failing on the 3rd step. it creates and clears the file ok and creates the unload. when it co...

When we run one of our generic jobs we get the following error: UKWH_ACCT_ARRG_IntSHPr1job.XPPAYHSTDWH_ACCT_ARRGshp192.StandardHistoryProcess.TargetTable_HFLkup_tfm.Source: ds_ipcflush() - Error in mutex_unlock() - Not owner The job creates a hash file then this job reads / updates the hash file so ...

been there done that. Re-indexed last night. Then we re-started the DS service after applying a fix pack and this has had no luck in fixing the problem.

OPen to more ideas?

When i create a new sequence and add a routine to the stage and go into it i get the following error: FieldToProp: Internal error - Bad number of subobjects Then it will still work fine / compile and run. Any ideas on how to fix this? This is fairly urgent as it stops the backups as the server pops ...

you're a star!!!! :D

Worked a treat thanks for the help (obvious but i would never of got that).

I have a timestamp field on an incoming file in the format: yyyy-mm-dd-hh.mm.ss.nnnnnn This is need to load into a 26 Timestamp field in DB2. I ahve made the format on the file Timestamp with scale 6 (as is on the DB2 from the import DCLGEN). but i am getting the date timestamp format is not represe...

I'll try and explaing better as i have just re-read and i haven't explained it well.. I have a table of customers and arrangements in the same table. 1 arrangement can have many customers (i.e. joint accounts). What i need on the same table is a sequence number for the customers on the one arrangeme...

All, I have an SQL statement which generates ID's for a given customer and product (basically like a count but there are a few restrictions and proviso's). What happens is i feed in a customer and get 0 - 9 products back and i want to update those N products with the number that gets generated. 1stl...