DSXchange

The more likely cause is that your data contains more characters than the table allows; i.e. you have a char(10) definition but are inserting 11 characters into that column. DataStage server will let you get away with that, but the database won't and issues an error.

or go to the UNIX command line with the same userid and set your dsenv environment variables and enter the command opt/SUNWspro/bin/CC -KPIC -O -I/opt/dsSoftware/Ascential/DataStage/PXEngine/include -dalign -O -PIC -library=iostream -c /datastage/Projects/DataStageTest/RT_BP78.O/V0S20_UpdateLoadDate...

Does this error happen all the time or to just one job or just some of the time? When you logged in to your client, did you click on the "omit" box?

Fernando, I think I would create a complete export .DSX file with all the jobs, then remove all non-parallel jobs from the export file - either by writing a DS job to do this or a macro in my favorite text editor ( EMACS , since I can barely call up and exit VI ) In the .DSX export file each job sta...

If you write to a sequential file instead of DB2 does it speed up greatly? (it should, if not you do have some issue). Do other jobs that write to DB2 also show a slowdown?

add a line like

to your job to see what your error is.

Hello info_ds,

I am not sure what you mean by "log entries of previous compiled jobs". Do you wish to know which jobs were compiled at what time? The DS_AUDIT hashed file lets you see when changes were made via the designer, but no track is kept of actual compilations.

Add "-jobstatus" to your dsjob call, or if that cannot be done you can issue a subsequent call to dsjob -jobinfo {project} {job}to get the status.

Good job, it looks like you've diagnosed the problem now.

If your OS supports files larger than 2Gb and you set the process limits to not cap files at 2Gb then you will not hit this problem. What settings do you actually have at present for the "file size"? Using a sequential file instead of a data set while keeping the 2Gb limit will actually let you stor...

No, I haven't seen anything like that. What does your job do? Did you change anything else at the same time (OS or patch level, DB version, etc.)?

Since the Operating System is a virtual machine layer between the application and the hardware, it is more appropriate to ignore the actual hardware and concentrate on the OS. If you are staying in the UNIX world or even staying within the HP-UX implementation then the steps you have illustrated are...

Unfortunately, there is no mechanism for you to add a user-command (such as taking an archive) to the autopurge mechanism. You would need to do something like set your auto-purge to 3 days and run a log backup process of your choice every 2 days (and remove duplicates).

What partitioning method did you choose for the fileset?

I guess in your case the postcode field was the last one in the row, which is why the error disappeared when you changed delimiter settings.