DSXchange

Be aware that hashed files are created as dynamic hashed files by default. So the utilities you mentioned are not appropriate. The only inspection tools for dynamic hashed files are ANALYZE.FILE (which, you will see from its VOC entry, invokes the file.stat executable with a mode of ANALYZE) and fix...

There are lots of ways to increase "performance". Just look at all that spam you're getting for internet Viagra! You have to start by defining performance. Rows/seconds is not a reliable indicator, because row sizes vary. If you want a rate measure, settle on something like MB/minute. Since the key ...

Please note that I have made three separate posts immediately above. Don't read just the last one!

How can we check whether user is having the required permissions to do these tasks of unlocking or killing processes. Can anyone tell more about these privileges. UNLOCK is one of the commands reserved for the DataStage Administrator. Who this is depends on how you installed DataStage; in particula...

denzilsyb wrote:Ray - this sounds great. which manual do we read to get on this!

It doesn't appear in any of the DataStage manuals. You will find it in the IBM manual Administering UniVerse, as the final section of Chapter 9. This manual can be downloaded at no charge from IBM's UniVerse manuals website.

To enable automatic starting of the DataStage deadlock daemon go to your DataStage Engine directory on the server and find the file called dsdlockd.config . Edit this file, changing start=0 to start=1 . It will start next time DataStage is started. To start the deadlock daemon manually you need to b...

I concur 100%. Some of the small fixes are so small that only pedants and sticklers spot them, like spelling errors, but even these get fixed fast. Total professionalism. Right now (its September 11, 2004 as I post) I'd like to post a message wishing those in Florida (Ken Bland among them) the best ...

Yes, there are three ways. Both are executed through the Administrator command window connected to proj2, or at the TCL prompt within the proj2 account. SETFILE pathname pointername sets a pointer to the hashed file or Type 1/19 file in the other account. So, if you wanted to be able to see a hashed...

"Locked by another process" can be when you have the same job design open in another window, or another user has it open. It can also occur if the job is being monitored or, in some cases, executed. "Locked by another process" can also occur if the process owning the lock is made defunct, for exampl...

Did you select the "Show All" option at the bottom of the screen? Locks for a process only show when a process is selected. There's no setting to be done on the server, though you probably do need to be connected using a user ID that has administrative privileges. Depending on how you installed Data...

Mike's solution is pretty much the way to go; a little interlude job control. As the instance id, you might use the same thing that the Transformer stage uses; the date and time as a ten digit string, for example Fmt(Date():"R%5"):Fmt(Int(Time()),"R...

I don't believe this can be done either. If you need the capability, you could use separate Notification Activities for the Job Activities, and hard code the Job Activity job name.

Creating this function is one of the "fun" exercises in the Programming with DataStage BASIC class. :D

It does look like Oracle syntax. Check with the vendor. It may have only been tested against Oracle, and only with five rows!

You could adapt the following. DateStr is a data element describing an eight-character string that contains a date in CCYYMMDD format. FUNCTION IsDateStr(Arg1) * History (most recent first) * Date Programmer Version Details of Modification * ---------- ------------------ ------- ----...