DSXchange

You left the first "me" off "membership".

You probably need to remove the record of the project from the XMETA database as well. (This is version 8 - we're not in Kansas any more, Toto!) Assuming you're using db2, connect to the database as XMETA (assuming you're using the default database owner) and find out the name of the table containin...

Meanwhile I've opened the status of the reply. Not much of it was hidden in any case.

We do not do "urgent" or "ASAP". DSXchange is a community of volunteers who post as and when they can. Your failure to research the required version does not constitute an emergency for us. If you need urgent support, sign up with your official support provider for priority serv...

Version 7.5.2 does not support compiling or running of parallel jobs on Windows platform. You need a different version. Search DSXchange for more details.

When you can get exclusive access to the project, open the Administrator client command window (or a telnet session and dssh in the project) and execute the command DS.CHECKER. This will clean up any orphaned entries caused by incomplete deletion. If the jobs still appear to be present, execute DS.R...

As always, "it depends".

For example, for very narrow rows, 500K rows is not such a large volume of data.

It should read the same records every time. The first reader will read the first 25% of the lines from the file, the second reader will read the second 25% and so on. None of that really helps you to know where the restart point might be.

What user ID is involved at run time (tip: include an id command executed through the before-job subroutine ExecSH to find out)? Check the job log for the settings of the DB2-specific environment variable values at run time.

What version number is the Oracle client software that is installed on the DataStage server machine?

Please advise the owner and group associated with DS_DATATYPES.

Please advise also the user ID doing the compilation, and the groups to which this user belongs.

What is the value of UVTEMP in the uvconfig file? This is the location where hashed file cache files are created.

Please monitor the free space both in this directory and in the file system where the DataStage projects are, while the jobs are running.

What is different between the environments?

DS_DATATYPES is a hashed file in the DataStage project. It appears that you can not write to it. Do you have write permission to the hashed files in the DataStage project?

The total record length that you provided was less than the total record length specified in the metadata. Are you using a fixed-width format and, if so, how are you representing NULL?