DSXchange

Carl, There is no MAXFETCHBUFF entry in uvodbc.config. -----Original Message----- From: carl.braganza@ascentialsoftware.com [mailto:carl.braganza@ascentialsoftware.com] Sent: Friday, 19 April 2002 10:48 AM To: datastage-users@oliver.com Subject: RE: UniVerse SQL buffer size exceeded What is the size...

Thanks, for the responses. Our Environment as it stands is: DataStage 4.1 on Win2kServer Ingres II DBMS on Solaris 2.6 SQL Server 2000 Staging DBMS on Win2kServer Most connections are using ODBC which tends to be a little slow with Ingres due to the drivers. We are using a lot of Hash stages, and te...

I have run a simple test job against a different log file without any problems. This is the first time I have run this job though. Of course, I selected a serious log file to test with I havent tried it with any other log files yet. (But I will do so.) -----Original Message----- From: carl.braganza@...

What is the size of the MAXFETCHBUFF entry in the uvodbc.config? Thanks, Carl. -----Original Message----- From: David Barham [mailto:David.Barham@Anglocoal.com.au] Sent: Friday, April 19, 2002 10:42 AM To: datastage-users@oliver.com Subject: UniVerse SQL buffer size exceeded OK, Im no UniVerse exper...

Hi David, Does this happen every time you run this job? Thanks, Carl. -----Original Message----- From: David Barham [mailto:David.Barham@Anglocoal.com.au] Sent: Friday, April 19, 2002 10:42 AM To: datastage-users@oliver.com Subject: UniVerse SQL buffer size exceeded OK, Im no UniVerse expert. What/w...

OK, Im no UniVerse expert. What/where do I increase the buffer size to solve this problem: SYDSJobLogExtract2.FilterLog.iLog: DSD.BCIGetNext call to SQLFetch failed. SQL statement:SELECT "@ID", "TYPE", "WAVE.NO", TIMESTAMP, "MSG.ARGS", "MSG.TEXT", "FULL.TEXT", SEVERITY FROM "RT_LOG239" order by "@ID...

Hi To the group. We are attempting to connect to a UniData server without success. The DataStage Server is installed on Windows 2000 Professional. It is version 5.1.a. The UniData resides on AIX 4.3.3, R/S 6000 and is release 5.1.39 We have experimented with the following configuration files and hav...

Were running DS on NT and Ive run into a unique problem. All of a sudden, I can no longer execute a clearing of locks via DS.TOOLS option 8 in a Telnet session. The message comes back: "Insufficient privileges to perform lock maintenance" This happens no matter which client terminal I log into. I ca...

Hi All, I have a control job that exectes about 10 jobs in sequence. This job seems to run fine in most occassions. But once in a while some strange things happen. Some logs are properly written to the control job (like Job1 starting and finishing). Then at any job (say Job4) the control job just wa...

Hi all, How can I use a multidimensional dynamic array in a DS routie?? Thanks and Best Regards, Sameh S. Bishara IT Dept. - Data Warehouse Administrator Egyptian Company for Mobile Services (MobiNiL) m Mobile: +(2) 012-240-2097 Phone: +(2) 012-320-1059 > Fax: +(2) 012-320-0319 Email: sbishara@mobin...

Im having an odd problem using SQLBULK stage. I am starting with a Hashed File Stage I am taking 628 records ( some of which are multivalued ). I am normalizing on a particular multivalued attribute. A count of rows (with a value in the multivalue field) written to a text file indicates I should hav...

There is an upper limit to the number of Dynamic hashed files that can be open system wide. This is configured by the T30FILES parameter in the uvconfig file. To change this involves three steps on the server machine. (1) Edit the uvconfig file in the Server Engine directory (maybe use Notepad, but ...

Ive only had a quick look but is this caused by a syntax error? values(:1,:2;:3) should be: valuse(:1,:2,:2) regards Vincent www.intramatix.com Hi All, Today, I upgrade DS 4.0.x to DS4.2.x and OCI Stage 2.3 to 3.0, but I found something wrong in jobs Some Job use OCI Stage with user defined sql. I w...

Hi All, I have a job with an ODBC as input, two Hash file lookups and writing out to a sequential file. This job was running perfectly well till now. But suddenly it has started giving the following error: Program "DSD.Init": Line 41, Unable to allocate Type 30 descriptor, table is full. Job Aborted...

Marzio, You need to open the port on which D/S server listens. On Windows platform the port number is 31438/tcp. I would have a guess that its the same on Unix. You can refer to the services file to find this out. YN --- Marzio Rotondo wrote: > Dear all, > Im trying to connect to a unix (compaq tru6...