DSXchange

What are the operating system permissions on D_RT_CONFIG, RT_CONFIG1, RT_CONFIG1/DATA.30 and RT_CONFIG1/OVER.30 ?

What group "owns" RT_CONFIG1? Are you in that group? If not, a quick fix might be the chgrp -R command.

Could be disk full, could be permissions, could be a corrupted RT_CONFIG1 hashed file, could be lots of things. The most common cause is a team of developers with a default UNIX umask of 022, which means that something created by one can not be written to be others in the same group. All DataStage d...

This message can be generated by many things, some of them outside of DataStage's control (such as disk full). Usually there are other warning messages in the log; if not, reset the job and look for a message with "From previous run..." as its first line - if present it will contain additional diagn...

Almost definitely not.

The two products work in quite different ways, so the probability of their design-time information (which is what you export) being compatible is of the order of the weight of a single atom of hydrogen in tonnes.

Decimal(10,0) has to be BigInt, because the largest possible four-byte signed integer (twos complement) is 2147483647 (ten digits): any ten digit number larger than this could not safely be construed as an integer so has to be something larger. Ultimately this is the root cause of your problem. You ...

Thanks. I had thought about that, but had hoped that I wouldn't have to do that much work.
If you use Copy/Paste, it's not really a lot of work.

Since you have a file corruption error during LOGTO, chances are that an important hashed file (possibly VOC) has become corrupted. Get to an operating system prompt and use fixtool to scan the VOC file in the project directory. fixtool -filepath ./VOC If this reports fixable errors, run it again wi...

None whatsoever.

Just create N parallel streams of jobs in the job sequence. Based on previous experience (from Director), try to make all streams contain jobs that give approximately the same total elapsed time.

Search the Forum for SETFILE, which is a DataStage command for creating a pointer. Or use the tool that Chuck has provided.

Once you have the pointer, you can use standard queries, such as or

Is it possible for me to provide set security at job level. Say I have 10 jobs in my project, I want 2 of them to be read only for other users. Or can I move them to a separate category and set security for that category. I believe there is read only if versioning is followed. Assume all jobs are i...

Just include the SET.TERM.TYPE or SETPTR command at the top of the getname file as you did when you were producing this report by hand. It becomes part of the input stream to uvsh . You should also consider switching from uvsh to dssh . Currently they are the same, but it's possible that uvsh might ...

My earlier reply was generic; consult DB2 documentation (or DBA) for an explanation of the different working of DELETE and TRUNCATE TABLE. You should be able to tie it in with what I wrote to enhance your understanding of the differences.

Surely it's the Oracle DBA's job to know about these things? That's the person whom you should ask. Did you try Ask Tom ? And, no, I've never seen that message. Here's output from oerr . $ oerr ORA 26028 26028, 0000, "index %s.%s initially in unusable state" //* Cause: An index is in IU st...

You want to log the value returned as the text of an informational message? Do you want to do this for every row returned from the stored procedure? If so, you will need to call the DSLogInfo() subroutine. There is no mechanism for calling a subroutine from within a job stream, so you will need to c...