DSXchange

Xiong At first glance I would surgest that you are reading and writing to the same source and have encountered Deadlock. I have had this where the Main Source is the same as the Update. A simple technique I have used where I encounter this is to write update data to a Temporary Store (Sequential Fil...

Are you loading Red Brick through an ODBC stage or the Red Brick (tmu) stage? I would guess an ODBC stage, because youre complaining of row-by-row errors. IS the setting of PRECOMPUTED VIEW MAINTENANCE ON ERROR in rbw.config INVALID? Can you experiment with commands such as SET STATS OFF, or SET USE...

This is a topic for an orphaned message.

Hello Mike, Thanks for the advice. We are currently running v4.2 of DataStage. I had tested it against v4.1 and the date subtraction worked fine. This is a bug. I had already logged a call with Ascential. Thanks. Cheers, Paul. -----Original Message----- From: michael.ruland@ascentialsoftware.com [ma...

More specifically it seems to run faster when there is less load on the network, although there is still a marked difference. It may be connected with data moving between client and server. The test I use is to logon to Manager and move between job folders to show the list of jobs. The admin user br...

Log this with Ascential Tech Support. I put a call in about 1 month ago for this same issue. Were on an E10k vs 2.7 running DS 4.1. We get this once in awhile on batch jobs, no apparent pattern. This is something new to 4.1. Good luck! -Ken --- "Li, Xiong (Corporate Manukau)" wrote: > Hi, All > > I ...

Hi, Jack Thanks for your help. This job is a control job, there is no stage within it. Only codes in Job control panel of Job Parameter call another job B processing. The source and destination table of job B are definitely in different databases. I have many same control job like this, they all wor...

Paul, Your technique is valid. What release of DataStage are you running? Have you checked with Ascential support to assure you have the correct patch levels installed on your client workstation? Mike Ruland. -----Original Message----- From: Paul Ko [mailto:PKO@clear.co.nz] Sent: Wednesday, October ...

Hello Paul, I havent experimented with any date arithmetic in DS 390 yet, so I can only give you some ideas to try out (I dont currently have access to DS 390 to try these out myself). 1) Your nested casting has a significant logic flaw. If you subtract 1 from an integer that ends in 01, you get an ...

Thanks David, I see what you mean. Ill have to brush up on my scripting skills and find a way for the script to return a 0 status. Thanks for the advise. Dirk -----Original Message----- From: David Barham [mailto:david@barham.hm] Sent: Thursday, November 01, 2001 4:21 PM To: datastage-users@oliver.c...

Again I am limited by my lack of knowledge of RedBrick or how you achieved this in a before-job routine. However, assuming that you did it in a before-job routine, then it must be possible to write your own routine which calls whatever you put in the before-job routine field in job properties. Your ...

Ok, I tried this one first, seeing that it is an easier solution and I can keep the control inside Datastage. When running the before-job routine to disable the view, the status sent back is 1932. In Redbrick 1932 means "the view has been disabled". This is exactly what I want, but Datastage sees th...

Hi Peter, Is it possible that a Solaris administrator has set different (lower) default priorities for the other users? Theres a bit of information on this under the man page for priocntl. Im not sure that this would explain the lack of difference when jobs are run though. Regards - Chris Thornton

Does redbrick allow you to manually disable the precomputed view? If so, can you use stage before/after routines or job before/after routines or even separate jobs to disable the view while your job runs. I dont know anything about RedBrick, but maybe this will point you in a useful direction. -----...

I have a job that reads a text file and loads it into a Redbrick database. For those of you who know Redbrick, the table I am loading into has a precomputed view running on top of it. This means every time I do an insert, the precomputed view gets disabled, and again enabled when the insert is compl...