DSXchange

vidyavv wrote:Tell me how to handle deadlocks in db2

Avoid creating them.

DataStage is just another client application as far as Oracle is concerned. Oracle client software must be correctly installed and configured on the machine(s) from which DataStage is to request service from Oracle. This client software must be at an appropriate version for connecting to the Oracle ...

Yes it is.

This question was discussed when the test first appeared. Searching the forum will let you read that discussion, which was inconclusive.

Because this is a licensing issue, you need to have your support provider resolve it.

Did you upgrade just QualityStage, or both QualityStage and DataStage? Were there any warnings during the upgrade process? Have you tried re-licensing QualityStage?

Did you upgrade QualityStage, DataStage or both?
Because it's a licensing issue, you almost certainly need to have your support provider resolve it.

But with sequential (text) files you need to specify how NULL is represented. Text files don't really have data types - they only contain text. And with fixed-width format text files, the representation of NULL must have the same number of characters as any non-null value in that particular field (s...

Did you go to the end of the Internet?

It may be called Ceil. Use the expression editor so that you can choose it from a list. Then you have to get it right!

The number has not yet been announced. The major release number is likely to be 8. We're not sure about the minor release number; a rumour exists that IBM does not like 0 in version numbers, so it will either be 8.1 or 8.0. Release date depends on what's found during beta testing. "Late 2006" is abo...

How, exactly, are you generating the value? The mechanism for resetting the sequence will differ depending on your answer.

Of course, if it's a surrogate key the actual value is irrelevant; all a surrogate key provides is uniqueness.

What were the results of your searches on the forum for "T30FILE" and for "mutex" and "timeout" ? These questions have been answered before.

It means that you've never successfully invoked either of the key management functions in that project. If you had, then the hashed file SDKSequences would have been created. You can create it yourself if you wish, using the following command from the Administrator client's Command window. CREATE.FI...

Create two upstream Execute Command activities, one to get the first date, the other to get the second date, probably using a pipeline of head and cut commands. For example: head -1 filename | cut -c1-10 When allocating parameter values use the return value from the appropriate Execute Command activ...

Welcome aboard. :D
Thank you for that answer. Do you happen to have the ecase number?

You can see, but not identify, the processes using Windows Task Manager, on the Processes tab. A better approach is to execute the shrdump command in a DOS shell. Any entry with a "b" in the fifth-from-last position in the key (for example 0xadeb003c) is a DataStage process. The rightmost four hex d...