DSXchange

hi there, im using SQLBLK to transfer data from UNIDATA into table in SQL2000. The following error message appear while i run the job. sqlTest2.SQLBLK79: Number of rows committed 55900. Abnormal termination of stage sqlTest2.CTransformerStage16 detected Im using Datastage 4.1 in Windows 2000 platfor...

Ive been thru Datastage upgrades several times, having started with version 3.1 (on two different platforms) and it is rather painless. Best advice I could think of would be to make sure you read the readme files for both the Client and Server *before* you do anything, there may be prerequisites or ...

After years of collaboration with Ascential technical staff, the CoSORT sort stage plug-in for DataStage on Unix and Windows is now tested and ready for licensing. Beta sites report that CoSORT plug-in sorts are up to 10 times faster than the native stage. The CoSORT stage uses parallel processing a...

Hi, Im using Datastage 4.0, and we are planning to install a new version, 4.2 There is any requisit to install the new version ? Any doc with the steps to install, and migrat the project to the new version ? Rui Soares NOVABASE - Data Quality EMail : RumSoares@BES.PT Tel : 21 4168000 (ext : 266313)

Richard, Looks like the shared memory table for holding table information has been filled up, either by in use tables or (more likely) old information that for some reason or other never got cleaned up, thereby freeing up a table slot. The number of table entries is determined by the T30FILE engine ...

We are running DataStage 4.0.3r1 on a Sun E10000 with Solaris 7. Now, we have got the following phantom warning several times: DataStage Job 1245 Phantom 9754 Program "DSU.LookUpAVMRegionX": Line 41, Unable to allocate Type 30 descriptor, table is full. DataStage Phantom Finished The routine LookUpA...

Hi Prashant, The port on which the uvrcp is listen should be 31438/tcp on DtataStage Server running on NT. Best Rgds Giovanni Boccia Sales Engineer Direzione Industria e Servizi Datamat - Enabling Your Future ----- Original Message ----- From: To: Sent: Monday, January 07, 2002 12:13 PM Subject: Rem...

Hello, Is it possible to time all stages in a job which contains a lot of lookups to see which ones are the slowest and should be tuned. I am aware that you can see a rows/sec in the Director, but this is the result of the slowest link because all lookups are related. I am using Datastage 4.2.1 with...

Im running in a SunOS 5.8. > -----Original Message----- > From: Giovanni Boccia [mailto:boccia@datamat.it] > Sent: segunda-feira, 7 de Janeiro de 2002 10:58 > To: datastage-users@oliver.com > Subject: Re: Abnormal termination again > > > Hi Nuno, > > Could you pls inform me about the O.S. where serv...

Hello,
I want to know the Port on which DataStage Server listens to requests
on Windows NT.
The DataStage Version is 4.2.1.
Thanks,
Prashant

Hi all. Im writing 6 millions to an ORAOCI8 with the parameter "Rows per transaction" set to 350, but he aborts with "Abnormal termination of stage REF_TB detected", when he writes all the records to the table. It works only when i set the "Rows per transaction" set to 1. Im using version DS 5.1. An...

Hi Nuno, Could you pls inform me about the O.S. where server is running?? Bye Giovanni Boccia Sales Engineer Direzione Industria e Servizi Datamat - Enabling Your Future ----- Original Message ----- From: "Nuno Pimenta" To: "_LIST-DataStage (E-mail)" Sent: Monday, January 07, 2002 12:05 PM Subject: ...

Or for Oracle and the OCI stage, without reordering the columns: UPDATE TableA SET Field1 = :2, Field2 = :3 WHERE KeyField = :1 -craig Tony Curcio cc: Subject: Re: UPDATE problems 01/04/02 03:29 PM Please respond to datastage-use rs I have gotten around this by placing the key columns at the end of ...

I think this relates to a hash file lookup stage in a DS 5.1 project. Has anyone come across this before............. Program "JOB.1919249052.DT.1240167173.TRANS1": Line 214, "$DS.SEQGETNEXT" is not in the CATALOG space. [EISDIR] Is a directory Program "JOB.1919249052.DT.1240167173.TRANS1": Line 214...

I have gotten around this by placing the key columns at the end of the list of columns being updated and altering the sql. Here is an example. Assume the Key is named "KeyField". In my columns tab, I would place it as the third field listed (after "Field1" and "Field2") and then alter my sql to the ...