DSXchange

Hi Ken, could you please send the complete link for your tools, because I doesnt find it on www.datastagexchange.com. Regards, Udo Kenneth Bland 12.03.03 21:03 Bitte antworten an datastage-users An: datastage-users@oliver.com Kopie: Thema: RE: dsjob logsum - Slow down in performance If I may ask Ian...

This is a topic for an orphaned message.

Hi Denzil I realize the bulk loader is faster, but this was a proof of concept site and I did not want to use the bulk loader for the smaller volumes of data we were processing. What I have found is that the ODBC works when I set the transaction size to 1, (it was on 1000). Hence, I was wondering if...

You WILL be covering: (1) environment variables (DS_MMAPPATH, etc.) (2) hashed file tuning (3) what hashed files are not ... wont you? Regarding point (3), I had one site who, until educated, would not use hashed files believing them to be ISAM. Regards, Ray (from Mumbai) ----- Original Message ----...

When using odbc to load data into a redbrick table, the datastage log is supposed to give you the warning "referential integrity" message, and supposed to abort after so 50 (or whatever you set it to) warnings logged. I usually use the TMUbulkloader to load the data and check the redbrick log file. ...

Hi Guys I have created several jobs using version 6.0r3 and do an insert via an ODBC to Redbrick (6.1). The DataStage log shows that all the rows have been inserted, but when I query the database, only about 20% of the rows have been inserted. When I look at the Redbrick log, the rows have been reje...

I have removed the entry from VOC. Many thanks for your help, thanks pavan as well. Regards Xiong -----Original Message----- From: Kenneth Bland [mailto:kcbland_2000@yahoo.com] Sent: Thursday, 13 March, 2003 17:25 To: datastage-users@oliver.com Subject: RE: how to create file in localuv. Youve obvio...

Youve obviously allowed this hash file to be created within the DataStage project. Heres the problem (and you can check www.tools4datastage.com, which has an archive of the Oliver mailing list and this and other issues have been covered many times in the past) with what youre experiencing. If you ar...

Thanks, Ken. I tried using "DELETE.FILE FV_XXXX", but it gave me this message: Unable to open "FV_XXXX" file. I am wondering this file actually doesnt exist any more. Xiong -----Original Message----- From: Kenneth Bland [mailto:kcbland_2000@yahoo.com] Sent: Thursday, 13 March, 2003 16:36 To: datasta...

Xiong, you are trying to create a table but it exists as a hash file within the DataStage project. To answer your question, you could use the command: >DELETE.FILE FV_XXXX This will remove the hash file. Better yet, why are you trying to create a hash file using SQL? DataStages hash files are great ...

Hi, I am trying to create a dynamic table by DataStage Administrator command. However, it gave me a message: "FV_XXXX" is already in your VOC file as a file difinition record." However, while I tried to drop this file, it gave me another message: Table "FV_XXXX" exists in VOC but not in UV_TABLES. H...

Sorry Ken - found it! Kenneth Bland wrote: >If I may ask Ian, you state you set the log purge >setting. But, have you looked at the job log to see >that it is purging? Setting the purge setting on the >project does NOT enforce it in existing jobs, just new >ones that get imported. You will have to m...

I cant seem to find the location of your job purge - what is the name or page its listed under? John Schatz Kenneth Bland wrote: >If I may ask Ian, you state you set the log purge >setting. But, have you looked at the job log to see >that it is purging? Setting the purge setting on the >project does...

If I may ask Ian, you state you set the log purge setting. But, have you looked at the job log to see that it is purging? Setting the purge setting on the project does NOT enforce it in existing jobs, just new ones that get imported. You will have to manually set it on all of your jobs, or, reimport...

One process runs dsjob. This spawns another process that runs uv. This spawns another process that runs the job (via DSD.RUN) as a phantom (DataStage terminology for a nohup background process). If there are Transformer stages these run as child processes of the job phantom, and show up in a ps repo...