DSXchange

Is the Windows 2000 "Telnet" service running? -----Original Message----- From: Pasquale Vaira [mailto:pasquale.vaira@cgey.com] Sent: Saturday, 8 February 2003 2:00 AM To: datastage-users Subject: Unable to bind socket to telnet port Importance: High Hi everyone, Im looking for help regarding an inst...

Ciao Pasquale, did you install as Administrator? ..be careful.. even if your user is in the Administrator group you will get this error. Hope this will help you Riccardo ----- Original Message ----- From: "Pasquale Vaira" To: "datastage-users" Sent: Friday, February 07, 2003 4:59 PM Subject: Unable ...

Hi everyone, Im looking for help regarding an installation of DataStage that persists in giving me trouble. The version of DataStage is 4.2 on a PC with Windows 2000 Professional and AMD Athlon XP 1600+ processor. At the end of the Server installation, the application stops, while it is trying to st...

Two suggestions: (1) Use an enterprise scheduler like Maestro, Control-M, etc, to handle scheduling. Those type of products have all of the needed functionality. (2) Use a batch job that sits in a loop, waiting for three conditions. The first is a timeout, such as exiting the loop when the system cl...

How abt loading the Sequential file in the DB2(enviornment) temp table and then having the join with the lookup table in the DB2 does this improve the performance ... HTH -----Original Message----- From: Sharon Asmus [mailto:sharon.asmus@pmic.com] Sent: Wednesday, February 05, 2003 10:31 PM To: data...

Sharon As already suggested, using the native data format for DS is much much faster. We have had similar problems, converted the lookup data to hashed files, and had huge improvements. Regards Adam "Sharon Asmus" on 06/02/2003 04:01:24 AM Please respond to datastage-users@oliver.com To: datastage-u...

Hi Sharon, You can try to use an UV table instead of an ODBC connection to MainFrame. You can try to build an Universe table (making the right analysis on the data) and create an index on the field where you have to make the multirow look-up. That means that first of all you have to check the record...

Hi , I am not a DB2 expert, so here is an alternative approach. Where is the source of your input data. If not already there load the input information into a database staging table that can be joined to the 21 million row lookup table. Then using a DB2 source stage extract the data back out, doing ...

DataStage Users, I have a job with a sequencial file input and an ODBC reference input. The ODBC stage is accessing DB2 on the mainframe via DB2Connect (ODBC since we have a multi-row return). We have tried to optimize the lookup with indexes (clustering indexes if possible). But our typical row/sec...

Yes I do. No they dont. ----- Original Message ----- From: Date: Wed, 5 Feb 2003 11:17:36 +1000 To: datastage-users@oliver.com Subject: API to DS version control > > > Hi all, > > Does anyone know if Datastage have an Application Programming Interface to its > source control functionality? > > KeeWa...

Hi all, Does anyone know if Datastage have an Application Programming Interface to its source control functionality? KeeWah ************************************************************ Opinions contained in this e-mail do not necessarily reflect the opinions of the Queensland Department of Main Road...

The Merant ODBC drivers (on UNIX) include one for dBase. There is also a dBase database in the test directory, which can be used to verify that drivers and driver manager are correctly installed. ----- Original Message ----- From: "David Barham" Date: Wed, 5 Feb 2003 06:25:56 +1000 To: Subject: RE: ...

If you are running DataStage on Windows, use the Microsoft Visual FoxPro ODBC driver. If you are on Unix, I have no idea. -----Original Message----- From: Doris Zammit [mailto:Doris.Zammit@oit.state.nj.us] Sent: Wednesday, 5 February 2003 2:44 AM To: datastage-users@oliver.com Subject: DBase 4 Hello...

Craig, You are absolutely right. I missed that line. Thanks alot! Leonid Craig_Hulett@rsau sa.com To: cc: 02/04/2003 11:41 Subject: Re: Running unix script from DataStage AM Please respond to datastage-users Probably another environment mismatch. What shell are you running from your command prompt? ...

Probably another environment mismatch. What shell are you running from your command prompt? I would guess it is running under a different one under DataStage. What we do is specify the shell in the script so things like that dont happen. For example, everything we do is korn, so the first line of al...