DSXchange

Thanks all for the comments. From Vincents reply, I get that XMETA is just supposed to be the repository and that there are various options to maintain/update the definitions in it. I knew about the Shared Table Defs in Datastage and the Parallel, Save As option (thanks Ray and Ernie) but I was thin...

I am working at an organization that has developed an Integration Hub for loading Interface Files from various source systems. There are a few generic loading jobs that use the Sequential File stage and employ the RCP method for load with .schema files specified through a Parameter Set at runtime. T...

Thanks Ernie for your response. The bootstrap option was required because the iiop port has been modified in our instance. I also had to drop the FQDN and Port on the domain option. Here is the command working:- istool> workbench -b 2825 -dom aud4078l -u prothera -p {iisenc}2zyEhabPJI+3eaiPuVYeVA== ...

I am trying to execute a workbench generate command from the ISTOOL command line to create an ISX file from a CSV file. But the command is throwing an error:- istool> workbench -dom aud4078l.unix.anz:9443 -u prothera -p {iisenc}2zyEhabPJI+3eaiPuVYeVA== -generate -i C:\IBM\InformationServer\imports\F...

ArndW

Most of the jobs in the project have "$OSH_PRINT_SCHEMAS" so I'm sure I can get that added. I should have made it more clear that the dataset is written by a 2-node job, then read by a 1-node job and then read by a 2-node job later.

Alan

There is a generic load job that reads a Dataset and writes it to an Oracle OCI stage. The job uses RCP entirely. The error we are getting is:- Item #: 14 Event ID: 57786 Timestamp: 2013-07-07 06:15:18 Type: Fatal User Name: dsops Message Id: IIS-DSEE-TFIP-00034 Message: ociTarget,0: Could not find ...

Hi We have been trying to optimise some jobs that run over a WAN link. When running on development, we typically get between 1000-2000 rows/sec. Over the WAN link this drops to 60 rows/sec. Upping the Array size > 1 has helped, sometimes cutting job times to 1/20th the elapsed time. However, we have...

Kenneth

Thanks for your response. Luckily we will only be retrieving data at end of day, so I doubt we will have to coordinate transactions.

Alan

The company I am assigned to is building a Transactions database from the ground up. It will be hosted on DB2. Our Datastage team has been tasked with a) extracting MI data from it and b) writing a few interfaces which update it in Batch mode. Online (Real-Time) updates will take place via Web Servi...

kumar_s

I tried that but it didn't clear the problem. By deleting the jobs, then re-importing, you force DS to use new RT_BP### and RT_BP###.O directories where ### is a new Job number.

The solution was:-

1) Take an export of the Jobs, Routines and Transform code, but without any executables.
2) Then re-import and perform a re-compile of everything.

Don't ask me why this has fixed it but it has!

Thanks for all your responses

Alan

loveojha2 I tried a reset too but I just get a repeat of the same messages. What I am trying to do is have our jobs run without any warnings. The project is on a production box and will go live in a couple of weeks. The way we have the sequences setup is to abort when they see warnings. I don't want...

Klaus

Thanks for the suggestion but I have checked in there already. The phantom ids in the files in there don't correspond to the ones appearing in the logs anyway.

Regards

Alan

We are getting Phantom Warnings in our Job Logs, when connecting to SQL Server using ODBC. The same jobs work fine on other servers, and were working fine a few days ago. Anybody come across this before?. I have tried using ODBC tracing but it all looks normal. e.g. Item #: 65 Event ID: 64 Timestamp...

AlanP - Out of interest - Is the new DataStage Sever 1) the same version? 2) the same OS? 3) the same NLS settings? (i.e DataStage NLS enabled) Yes it is. Even same compiler. One we are using as dev and the other as system integration test server. But I think that each time I transfer the jobs acro...