DSXchange

ak77, if you used kill -9 then you are guaranteed to leave locks on jobs and other objects open. Even experienced people have trouble locating those locks on busy systems using LIST.READU or the client cleanup tools. Your best bet for the future is to ensure that the deadlock daemon is up and runnin...

Reading up on RMAN documentation shows that it works at a block level - so at any time that it is saving a block all rows in that block are locked; this "freeze" is split into block level as opposed to table or tablespace level in other backups. So although one doesn't see a lengthy freeze the lock ...

First off, put a constraint on your transform that always equates to false (I usually use "1=2") and see what the performance of your job without writing to the database is. I am fairly certain that the speed will be in the thousands per second (even faster if you pre-loaded your reference hashed fi...

We are talking different types of backups here. Every one of the databases we are talking about has an incremental backup functionality as you have described. But there is a difference between a table-level and a database-level backup (or schema/tablespace levle) and in order to retain consistency t...

The OPENSEQ will take the ELSE branch if the file does not exist, and you shouldn't be using the STOP statement in a subroutine; this is designed for use in normal BASIC programs, you could replace it with "ELSE TimeStampVal = ''". This is most likely the cause for your job control error. Sequential...

Ultramundane, it is not a lie, and that term is a bad one to use - it implies that Ray is intentionally trying to deceive; you might have stated that Ray is incorrect, which might have been more accurate - but I believe it is still false. The transaction logs are used to get a sequential list of cha...

Glad to hear that things are working out at the project and for this job; I'm sure it's a busy time for you!

Martin,

in that case Craig's suggestion will work. Change your job references to the Hashed files and rename the objects from the OS (type 30 files you need to rename the directory, other static hashed files rename the file itself)

No, it will still be there since it is integral to all the server functions; just that all the metadata will wander off to other repositories.

You need to have the following line in your job

to include the job mnemonics.

p.s. The jobname indicates you are still in the same place . Do you recall that we still have something open? How is the project going?

You can effectively rename the file pointer with a "COPY FROM VOC <OriginalFileName>, <NewFileName> DELETING" but the physical files at a UNIX level will remain named the same - thus if you try to create the same file again you will get an error stating the files exist already. Perhaps if you explai...

The problem hasn't been located yet so no possible solution can be given. You know the DB/2 write is unable to allocate memory; but not why. It could have several causes. First off, try to change your write stage settings to see if the error goes away - and think about the answers to the questions i...

Aye Up, John! you can call your own routine activity with a user-written routine to return then number of rows processed through a link for you. The routine would have Handle = DSAttachJob(<JobThatWasCalled>,DS.LOGFATAL) NumberOfRows = DSGetLinkInfo(Handle,<StageName>,<LinkName>,DSJ.LINK...

This is a driver message, see IBM Error Messages for details or further reading.

The process cannot allocate additional virtual memory. Is this error sporadic or does it happen every time you try it with this job? If it always happens, is it at the same row?

Hello,

you didn't really ask a question, so I'll just throw an answer back at you and see if it is what you want: PX offers you the substring function, In.Col[6,5] would give you a substring of length 5 starting at position six.