DSXchange

I had a look at the manual again. The RB bulk loader manual is very short - only 10 pages. I couldnt find anything there that helps. In my bulk loader stage (properties) I specified "create a new table? N" With this setting I am getting "Test6.Customer_insert_Redbrick: Failed to create the SQL file"...

Hello to all. I would like to submit a question, if you are using DataStage 4.1 and doing a lookup to an oracle8i table, which is the most effective way to speed up that lookup, please note that the lookup field has an index in the table, and the table has more than 10000000 registers? Best regards ...

Thanks Ray! ))) Giovanni Boccia Sales Engineer Direzione Industria e Servizi Datamat - Enabling Your Future ----- Original Message ----- From: "Ray Wurlod" To: Sent: Wednesday, November 07, 2001 10:33 PM Subject: RE: Clean-Up > CleanUp Project from the Administrator client performs two tasks, one > ...

Thank you, I will also have a look at this. Dirk -----Original Message----- From: Ray Wurlod [mailto:ray.wurlod@Informix.Com] Sent: Friday, November 09, 2001 4:19 AM To: datastage-users@oliver.com Subject: Precomputed View Invalid Messages Dirk, Try setting TMU_ROW_MESSAGES NONE in the TUNE section ...

Thank you Ray, I appreciate the help. I am also reading the manual, but its not been very descriptive so far. I will test this today. I prettty sure I did specify the option not to create the target table, but Ill have a look again. Thanks again Dirk -----Original Message----- From: Ray Wurlod [mail...

As for why the job didnt stop when you first tried, we would need more information about what the jobs does, what data sources it talks to etc. No that the server has been rebooted, you are right, the job cant be running. However the status information thinks that it is as it probably was when you s...

Hi, We use DataStage 4.1. I was trying to stop a DataStage Job from DataStage Director by clicking on the "stop" icon. However, the job status kept showing "Running" and the reset icon is disabled for this job, so I could not reset it. We rebooted the machine and I am sure nothing is really running ...

Dirk,

Try setting TMU_ROW_MESSAGES NONE in the TUNE section of the rbw.config file.

Just a thought.

Regards,
Ray

I dont know of any specific issue, but I do remember reading documentation saying that BO/Webi must be the only service running...most likely though, this would only have related to Microsoft installs (20 applications, thatll be 20 servers...thankyou!). Take care if you are configuring the cluster m...

Is anyone using DataStage and Bus Objects Webi product on the same UNIX server successfully ?

Were about to install the Webi product onto our DataStage server and wanted to know of any configuration issues.

regards,
Peter

What youre doing is OK, but you are asking the Red Brick stage to create the table. There is a known bug in this stage type where it generates an incorrect CREATE TABLE statement when there is more than one primary key column. Workaround is to create the table in Red Brick manually, and dont ask the...

I am now trying the redbrick bulk loader for the 1st time, and Im getting the following error. Test6.Customer_insert_Redbrick: Failed to create the SQL file Im not sure if I am using the loader correctly. The manual says I can get data from any stage. I am using and odbc stage as input and writing i...

Dear all I am using DataStage 4.1 on NT. I am trying to access Oracle Tables using ODBC. I have defined a system DSN. while importing the tables using Manager - i use Import->ODBC table definations. It allows me to connect to the database and i can see my list of tables. However when i select a tabl...

Ray, Yes, lots of changes. Apparently this is on the Ascential KnowledgeBase as a known problem to be fixed in 5.1.1. ( I should have looked there first). Article ID G36148 regards, Peter -----Original Message----- From: Ray Wurlod [mailto:ray.wurlod@Informix.Com] Sent: Thursday, 8 November 2001 12:...

By default &PH& is what UniVerse terms a "Type 1" file. In a Type 1 file, IDs are limited to 41 characters. "JOB.1182663753.DT.1236265332.V0S175.IDENT1" is 42 characters long, which is why it was truncated. To prevent recurrence, get to a UniVerse command prompt (perhaps the Command facility in the ...