DSXchange

The setuid thing happens even when installed by root. ... This is what I meant, when you install as root some binaries get setuid to root and as a result the DataStage subprocesses are able to run using the userid that logs on to DataStage (root authority is required to switch ids). When you don't ...

zhaicaibing wrote:Hi,

I wonder dsadm can stop and start DataStage v6.0 on Sun Solaris 8 platform

Is dsadm the supper user?

So dsadm is not the super user. If you install DataStage as root some binaries are 'setuid'ed and run under root permissions but dsadm on itself is pretty harmless for the rest.

Ogmios

Hi All, Can we use BCP to be loaded in Sequential Files. If yes how can we do it. I see only options to a SQL Server. Thanks Krishna How would you bulk load to a sequential file :wink: ? Bulk loaders usually take a sequential file and dump it into a database by sidestepping a lot of database checks...

There's an Oracle client version for Solaris 2.9, I used it

Ogmios

1) How it would work: you would have DataStage generate the rows to be loaded to a Sequential file, have the control file generated by DataStage, have it edited via a program to add your fields... There have been some discussions on this in the past. 2) You can't use all features of the DB2 bulk loa...

CoSort's latest newsletter boasts its plugin for DS 7 is 2 to 10 times faster than the sort stage. Of course there is a big different between 2X and 10X. What are the approximate gains that CoSort implementers have had in the past? Also, how easily can it be implemented? It seems pretty simple... A...

roy wrote:Hi,
Just Wanted to fill you in.
the CLEAR.FILE for the RT_LOGnn & RT_STATUSnn files
did the job
Thanks All,

If you do a CLEAR.FILE on RT_LOGnn you will lose the autopurge.

Ogmios

Save the file in csv format, write a small perl script to take this file as input and generate an Ascential style .dsx file It would require a little bit of reverse engineering and would be totally on your own risk. I don't have an example handy right now. And I would only suggest to make it yoursel...

In the .odbc.ini file in the DataStage DSEngine directory activate Tracing: Trace/TraceFile and see what that gives. Or have your DBA's give you a list of SQL statements DataStage tries to execute. To see whether what you actually execute is what you intended to be executed, you could be amazed. Ogm...

Another method I've used in the past (with a moderate amount of rows < 400000) is just passing all rows to the database using update/insert and having the last_updated_on column changed by a trigger if there are different values in any of the columns (on update/insert). However in this case it would...

This is where the "fun" begins. I avoid hash files whenever I can, and if I have to use them I make sure it's recognizble to which jobs they belong (usually by using a prefix, but this would depend on how you make your ETL design). If you moved the hash file, your job still runs correctly ...

Hashfiles grow but they never shrink, unless you resize them.

The easiest is probably deleting the hash file after use and this depends on where you create the hash file: either in the project or in an explicit directory.

Ogmios

For the quick answer: the status in DataStage is just a snapshot. If the process is killed it's no longer updated, if you do a clear status you will be ready to run it again.

Ogmios

Rolling on the floor laughing. Sorry, DataStage is slow but I think you should split up your jobs in seperate smaller jobs. In most of my jobs I only have 1 transformer and possible 1 or 2 lookups. The problem with your slowness is probably because DataStage was never really "meant" to be ...

Hi, I've not been able to do it via DataStage directly. What we usually do is launch a script that does this. The "import" is probably not real a SQL statement but gets properly redirected via the client. One way to be absolutely sure: take a non DB2 client (e.g. winsql) and try whether th...