Warning message on Matching - IIS-DSEE-TFOR-00073

[cfuller]

Hi all

I'm upgrading from v7 to v8, and am getting the following warning message when testing one of my match jobs -

Server:DPLAPP1
Project:POLNEW
Job No:571
Job name:MatchSubmissionLocality
Invocation:
Event Number:136
Event type:Warning
User:dsadm
Timestamp:24/07/2008 9:20:06 AM
Message Id:IIS-DSEE-TFOR-00073
Message:
sVELOCPCD: When checking operator: A sequential operator cannot preserve the partitioning
of the parallel data set on input port 0.

I have checked both the documentation and DSXchange, but am unable to determine the meaning of this message, or what I need to do to correct it, if I should.

The job design is thus -

Code: Select all

sLOCIM ------> Match <------sAUSPOST
                 |
                 |
                 |
                 |
                 |
                \/
              sVELOCPCD

Does anyone know the meaning for this message, and what I need to do to correct it?

Thanks

[ray.wurlod]

Yes. You would have found it by searching the DataStage forums. A parallel stage has a sequential stage downstream of it, but the setting of the parallel stage is "preserve partitioning". Changing this property to Clear stops the upstream stage from trying to require the downstream (sequential) stage to preserve partitioning.

All stages that write to sequential files (such as QS reports) execute in sequential mode. The parallel stage in your case is the Match stage. Find Preserve Partitioning property on the stage properties' Advanced tab.

[cfuller]

Thanks Ray...worked exactly as described.