DSXchange

None of our staging tables that are populated during this stage of the load are partitioned. The issue we are seeing with any design changes, including things as small as the key generation, is we cannot reproduce this error anywhere but production so we cannot verify the change is effective and the...

I'm losing some of your posts due to premium content - the issue we're having in debugging currently is this only occurs on production systems - which we need to request access to. Because of the sporadic nature of this failure there is no guarantee that while our access is enabled and we are monito...

Hi - thanks for the reply. That is how the log looks when the job is hung - it will remain that way until the job process is killed from the command line (it does not respond to stop requests). We've recently tried setting DS_NO_PROCESS_METADATA = 1 but that didnt seem to help as we experienced the ...

This has become quite a large problem for us - any help would be appreciated... Information Server 8.0.1 Fix Pack 1 System : Linux version 2.6.9-42.ELsmp (bhcompile@ls20-bc1-13.build.redhat.com) (gcc version 3.4.6 20060404 (Red Hat 3.4.6-2)) #1 SMP Wed Jul 12 23:32:02 EDT 2006 Basically we have two ...

Hi Rajan, Assuming you can afford to disable NLS for this particular stage I have come up with a temporary workaround until the root cause is identified. In the DB2 API stage under the NLS Map tab rather than selecting from the list simply type 'OFF'. Fortunately for this particular project NLS wasn...

I am in the same issue now, Job is very simple Its a DB2 UDB stage to a Sequential file. 1) Fetching only one field and its an Integer( Tried changing to Char also) 2) Volume is 325944 ( Tried fetching first 10 rows also) 3) having this error with only one table. I have plenty of other jobs working...

Is there anyone know the root cause about the below issue? This issue happened for Information Server v8.1 on Red Hat Linux 4. Sequential file -----------------------> DB2_UDB_API The job is very simple. But when DB2 API Stage was used and the target table name was like SDS7.SDS_I_143_RAW_MATERIAL,...