DSXchange

I'm reading a sequential file, passing it thru a link splitter and generating 4 streams into a DB2 CLI stage. The DB2 stage does an 'update existing rows only' and each input stream is updating the same table. I'm trying this in an attempt to speed up the update process. However, I keep on getting u...

Thanks for the replies.

I thought the 2GB limit applied to al OS, hence my concern

I have heard that 64 bit hash files do not perform well hence I have not pursued this option. Is this just a perception of mine or should they be avoided?

Thanks everyone for the replies.

You will be please to know, I have bought a stun gun, to &&#% with a big stick

Hi Everyone We are creating huge hash files that are starting to touch on the 2GB limit. Typically, these hash files have around 40 million rows in them. I want to create a distributed hash file instead to make the maintenance/design of the DataStage jobs easier (lookup's become a problem when you h...

I want to restrict developers from viewing large files from within the DS Designer module. Why, because they press Ctrl Alt Del when they do not get a reponse and it is causing problems. Typically, I would only like to have the query return 100 rows. Is there anyway to set this in DS via, for exampl...

Hi Guys, thanks for the replies. Sorry, should have added more info. I can log onto my DataStage project, compile jobs etc. This only happens when I try to run the job. It is a normal DS Server job, not a Sequencer job. I logged into DS Administrator and did a DS.REINDEX ALL which seemed to fix the ...

I keep on getting the following error:

Error calling subroutine: DSR_EXECJOB (Action=5); check DataStage has been set up correcltly in project ForkLiftDevVAT (Subroutine failed to complete successfully (301107))

Can anyone help me with this error?

Many thanks

Hi Vincent

Guess I'm going to have to request an upgrade to 7.5.4r then

Ray, if we start reading the README files, we will all become CLEVA, like Vincent

:D Thanks everyone for the replies.

We have a limited number of developer licenses (10) and we want to know who is using them, hence the READU command. We will use the userid mostly I guess.

Hi Guys

I want to write a batch job that executes the Universe command LIST.READU

(Before/After job routine ExecTCL LIST.READU)

What I need to know is how to read the output from this command. Is it stored in some internal file?

Thanks

Thanks for the advice. I have Telnetted into the project, gone into DS.Tools and rebuilt the indexes. However, when I try to log onto a project (any project because we curently have 4 projects running concurrently) I get the following error: Error calling subroutine: *DataStage*DSR_SELECT (Action=4)...

Hi All

I'm trying to open the DataStage Administrator and get the following error:

CDSRUseraccess.TakeSharedLock: Internal error - Failed to open file: UV.ACCOUNT (81002)

I have stopped and restarted the services but still get the error.

Any help will be greatly appreciated.

Thanks

Hi All I need to import table definitions from an Informix database running on a Unix box. The only way to access these is via the ODBC metaroker -- I think? How does one set this up? Do I need the informix odbc driver on the same box as MetaStage? In the Windows ODBC Administrator, how does one spe...

Does anyone know if Ascential have a metabroker for Cognos Reportnet? I contacted Ascential some time ago and was told that one is due to be released. However, I'm using MetaStage 7.5...the latest release and still only have metabrokers for Impromptu and PowerPlay. Has anyone out there managed to im...

Has anyone experienced this strange phenomenon...

Certain login id's can view annotations in designer. However, they cannot add additional annotations because the annotation stage in the pallete is greyed out.

Anyone know how to fix this