DSXchange

From memory there's a "minimize all windows" option available if you right mouse click on the task bar. This is also a neat and quick way to get to the Task Manager.

You read the cautions in the manual better than I did! You're correct (according to the manual at least) that shared containers are only applicable in the SMP environment, not in the MPP environment. Have not checked this out - lacking appropriate hardware - in DS 7.0 in an MPP environment. Perhaps ...

A lot of work has gone into setting appropriate default values for the tuneable parameters in the uvconfig file. So the rule of thumb that chuarkai seeks is "leave it alone" or seek expert assistance. To gain in-depth information about this file you would need to take IBM's UniVerse System Administr...

A lot of work has gone into setting appropriate default values for the tuneable parameters in the uvconfig file. So the rule of thumb that chuarkai seeks is "leave it alone" or seek expert assistance. To gain in-depth information about this file you would need to take IBM's UniVerse System Administr...

DataStage (and therefore DataStage BASIC) has the quirky ability to treat a directory (folder) as a "table". This is the underlying premise of the Folder stage. You can do the same thing in DataStage BASIC. If the O/S directory is seen by DS as a table, then each file name in that directory is seen ...

A DIY approach is to create a server job that consists purely of job control code that interrogates either the job, link and stage properties or the log file in order to produce the requisite report. This is a fairly straightforward DataStage BASIC programming task. On Ascential's Programming with D...

This is particularly true on Solaris, where swap is mounted on /tmp by default, and /tmp is pretty small by default. Usually some tweaking of the latter is necessary in any case, and using other disk space for application-based temp is highly desirable.

Can you take a server job and run it in an MPP environment? The answer is a qualified yes. You encase the server job in a shared container, which you can use in the PX job design. There are restrictions on what the server job can do; for example it can not use COMMON. This is documented in the Para...

The answer is a qualified yes. You have to encase the server job in a shared container, which you can then use in a PX job design. Then the resource file governs its use in an SMP or MPP environment. The qualification is that there are some restrictions on this (for example that the server job does ...

I just read a topic that I would like to have emailed to a friend. To achieve this I had to copy the URL from the Address field in the browser and paste it into an email message.
A "send this topic to a friend" link on the Topic viewer page in the Forum would be a useful adjunct.

You can tune the initial memory and multipliers used by the Aggregator stage from option 6 of the DS.TOOLS menu on the server.

Something that is really cool is that the compiler can pre-evaluate certain functions. For example: <pre> EQUATE TAB TO CHAR(9)</pre> In this case this means that the compiler can evaluate the CHAR(9) function and load it into the constant. It doesn't make a great deal of difference at run time, but...

... which, as being handled within DataStage, is simply a signed integer. These can readily be converted to unsigned numeric values within DataStage, for example for writing to text file. I outlined the technique earlier (for four-byte integers) - use a different constant for eight-byte integers.

You can even do two exports - one in DSX format and the other in XML format - and compare them.

The only reason I'm replying to this is to get my post count to a round 1300 before the changeover! [:D] Never did catch up with Admin. [:(] (But I don't get to count posts to the archive of the Oliver list!) On behalf of all the Forum participants, a heartfelt vote of thanks to Dennis and the team ...