DSXchange

Get your Oracle DBA to monitor the session and, in particular, the SQL statement that is received in that session. Compare that with the SQL statement reported in the DataStage job log. Figure out any differences.

Two easy ways. There will exist a directory called I_hashedfilename (this directory contains the indexes themselves). Or at the TCL prompt (or in Administrator client command window) execute LIST.INDEX hashedfilename provided that there exists a VOC pointer to the hashed file.

Ray, If Baha had only one designer client session open, then there would be only one session in web console with his User name, type as DS Designer etc. So he/she could directly select that session and disconnect. Big If. We had no information as to whether or not that was the case. I have clients ...

Yes, it's called the Oracle Enterprise stage with load method = "Write". This invokes sqlldr "under the covers". Once sqlldr is started DataStage no longer has control. You can process the log and bad files produced by sqlldr in DataStage once sqlldr finishes, but there is no mec...

Lots of possible ways. A server job using an Aggregator, a server job using a Transformer stage reporting @INROWNUM into a hashed file with a constant key, an Execute Command activity executing a wc -l command are among them.

Implied, eh? Seek more information from the IBM consultant. Why does s/he believe that?

You advertise yourself as "IT Consultant". Try it, and report your findings. If it's doable in user-defined SQL then you ought not to have any major issues with DataStage being the database client that executes that particular SQL statement.

To tell whether the services are running you simply need to check for the appropriate processes (dsservice.exe, dsrpcd.exe, etc). There is no port that can be monitored. Running server jobs do not typically use any ports. You would need to modify your Daily Job to keep a record of progress (for exam...

Don't you need single quotes around a -name argument to find when the argument contains wildcards? Also don't you have to do something with what's found (for example -exec or -print)?

WHERE is the file? Unless it's in the project directory on the server you need to specify the pathname of the file.
tail -1 /usr/data/test

saikrishna wrote:Please dont concentrate on the type of file, instead can you please tell us, if possible, the problem with the non-conversion of chinese characters using UTF8?

Your thinking is "off base" here. The NLS Map must accurately describe how the data in the file are encoded.

A source link will be an output link, and therefore have "Out" as part of its OLETYPE in its record in the DS_JOBOBJECTS table. Once you have the record for the link, the key to the corresponding stage can be obtained by removing the Pnn part of the key to the link record. For example if t...

You actually need a combination of techniques; you need to know the session ID of the session that owns the lock, otherwise you don't know which session to release in the IS administrator.

There is no limit in the product. There is a physical limit based on how much memory is available.

Done properly an audit IS time consuming. There's no way around that. You just have to make the investment.