DSXchange

The uvrpc port (31438) is the only one used directly by DataStage 4.0. However, if you want to connect to the machine via telnet to access DataStage projects, then you could argue that the telnet port (23) is also "in use". ----- Original Message ----- From: "Lam Tat Hoong" Date: Tue, 25 Feb 2003 10...

Does whatever starts the jobs that fail to start check that the jobs are in a runnable state? For example, if the job aborted on its previous run, it needs to be reset (or recompiled) before it can be run again. The same is true if the job has been stopped, for example in the Debugger. -- __________...

Hi,

Currently I had found the uvrpc port 31438/tcp.

Besides this, may I know any other ports will use in DataStage
(4.0.3r1) in Solaris 8.

Thank you.

B.Regards,
tathoong
Adtel Systems Sdn. Bhd.

Forgot to mention that any changes to the uvconfig file requires some obscure steps to implement. As always, you should be root! Before shutting down the DataStage engine, make sure no one is using datastage. # netstat -a |grep uv phu228.uvrpc xydsd9999994.fp.us.abcdefg.com.1316 8508 0 8760 0 CLOSE_...

There are limitations to the number of datastage jobs that you can have running. One such limitation is the total number of dynamic hash files that can be open at any given type. Every job in DataStage Server edition uses hash files to store job log, status, run-time configuration, and other informa...

There is no theoretical upper limit to the number of DataStage jobs that can run simultaneously, though there may be system-imposed and other practical limits, such as how many processes the operating system can deliver (should be at least 32,000: DataStage Engine port numbers may also impose a simi...

Hello Malathi The short answer to your question using parameters with a single OCI or ODBC stages is yes. As far as I can see, you have two alternatives: create a user defined query against your SQL in your OCI stage or generate a sql command file for use with sqlplus. We dealt with a similar issue ...

Yes, general interest or, as the spin doctors might put it, eagerness to learn. =8^) ----- Original Message ----- From: "David Barham" Date: Sun, 23 Feb 2003 13:42:00 +1000 To: Subject: RE: Can this requirement be done in one single OCI or ODBC stage? > Ray ... no, the view is not updateable. I assu...

Ray ... no, the view is not updateable. I assume this is a general interest question as I did not notice any requirement for update in the original message. I tried it in Oracle 8.1.7 and Oracle did not allow it. -----Original Message----- From: Ray Wurlod [mailto:rayw@mindless.com] Sent: Sunday, 23...

Is this an updateable view? (Cant see why it wouldnt be, though it wouldnt be in UniVerse for reasons outside the scope of the present discussion.) ----- Original Message ----- From: "David Barham" Date: Sun, 23 Feb 2003 08:12:16 +1000 To: Subject: RE: Can this requirement be done in one single OCI ...

The parameterised query you suggest would work fine if the values of the parameter remain the same for the job. For example, if you have one job which reads the list of table names etc and then runs a second job for each row (Id suggest writing a function to run the second job and calling it in a st...

I havent done exactly this with the OCI stage, but with other SQL-oriented plugins, provided the columns in the SQL are consistent for the entire "run" of the job, you can gain "some" flexibility by parameterizing the SQL, and merely providing placeholder columns in the link grid. So as you say belo...

Hi, We like to get some technical assistance for the problem that we are having now while designing a certain job with OCI stage in the DataStage designer. In many jobs, we successfully used OCI stage that works perfectly with hard coded column names and table names. e.g. SELECT CUSTNO, NAME FROM CU...

DaeHwan and lurkers There is a new updated version of the XML Pack available compatible with DataStage release 6 - it can presently be ordered through manufacturing by customers on maintenance and will be available next week on the eservices web site for download. The new Pack is a major update on t...

Delete the .ldb file that is in the same directory as your .mdb file. This is Access "locking" file. There are also some utilities to see who has control over the access DB: m and m Jacob > -----Original Message----- > From: William Hulme [mailto:whulme@psu.edu] > Sent: Wednesday, February 19, 2003 ...