DSXchange

Historically the transform stages have been a cause for delayed compile times, but nothing on the order of 4 hours. Some process must be busy during this extended period, so please check the following: 1. How long do other jobs take to compile? 2. While compiling, check your PC's I/O and CPU usage 3...

Purged log contents are deleted and are not retrievable. If you have an OS-level backup of the system one could restore the appropriate RT_LOGnnn directory to overwrite the current log file.

I cannot read the flowchart you posted (perhaps it is just my eyes), but the second repartitioning from A,B,C to A,B,C,D is not necessary; since for any give D to match it will already be hashed into the same A,B,C group. On the same note, I would sort the data on A,B,C before the first join, then r...

I will have to see the code for WEEK.TAG, I can't remember it.

To the First day of the year - that is always the same day when in the same year, thus your value is identical.

Although I concur with Craig, I can imagine a scenario when logging to the repository at 8.1 and beyond and the repository is full of both log files and table definitions that it might impact runtime performance, particularly if a lot of records get written to the job log.

... "39368,39399,39429","TEY/MTH10/2007","2007 October - 2007 December" If "," is your separator then the first column will be read as a string regardless of whether or not you specify a quote character and you cannot load that value into a numeric field. Or ...

Also, what is your data type definition for field "ZZPA_M001_RKF008"

If disk space and process space is not the issue, then you might have hit the limit on memory allocation for lookup mapping. What UNIX system are you on? If on AIX you can use the ldedit command to increase that space, but I don't know what the appropriate commands in other UNIX flavors might be.

Could your last transform stage output have RCP enabled? Add the "$APT_PRINT_SCHEMAS" environment variable to your job and then examine what the runtime schemeas between the stages really are so that you can check.

What sort of a stored procedure is involved - does it use internal cursors or other complex logic where the state of the query might affect the result?

Stick with the CFF stage. What is the data type of JNAFOC_DATCRE and do you have NLS turned on?

(2nd attempt, somehow my longer first post disappeared)

Use the CFF stage, it makes reading COBOL and EBCDIC files simple and performs the EBCDIC to ASCII conversion automagically.

Using the ".ds" extension is not mandatory.

Hi All, I am trying to load some data to DB2 table and getting the following error: main_program: Error loading "orchdb2op": Could not load "orchdb2op": 0509-022 Cannot load module /data/ds/Projects/IBM/InformationServer/Server/DSComponents/bin/orchdb2op.o . 0509-150 Dependent m...

Are you certain that your database is running? Take DataStage and WAS out of the equation and try to login to your database from the command line. Does that work? If not, then you've located the culprit.