DSXchange

Thanks Ray for the information.

Hi All,

Does anyone here offer hands-on course training for DataStage v8.1?

I am 7.5.x expert but I want to take v8 certification. I have v8 experience in the past, but I want to take some refresher so I can pass the test in one take.

Thanks.

Sorry took me sooo long to follow up..... just in case for those looking for answers... the DBA has to recreate the Oracle table segment with higher INITRANS and PCTFREE values... i don't remember it now exactly. Just work with your DBA.

neilbeckwith wrote:Do you HAVE Solaris auth codes ? As I said, they are platform (i.e. Operating System) specific.

Yes I do.
But i'm stuck now.
Having the same issue as the guy here viewtopic.php?t=112811

Has anyone here successfully installed datastage 7.5.2/3 on Solaris 10 x86?

The install script aborts when it's executing "./setup." binary. I'm thinking that it's not compatible with x86...

I already searched the forum and the posts are all unresolved.

tia.

I know this is an old topic... but i'm just trying to do this too. Seems like ./setup. is NOT a binary for Solaris 10 x86... I tried to execute it manually using various shells... from root and dsadm. It's either saying "Invalid Argument" or "cannot execute". I might just get an ...

I'm gonna install solaris 10 on my x86 machine and try installing it there.

neilbeckwith wrote:Don't believe so. see http://www-01.ibm.com/software/data/inf ... ents4.html

I was just thinking because opensolaris is basically solaris, which is free to download.

Do you know if DataStage Server will install on OpenSolaris?

Hi, I was able to install Server 7.5.3 on my Windows Server 2003. But I have to switch to 7.5.x2 to make Parallel work. Everything is working now Server, Parallel... etc. And I can connect to the server remotely. But I'm really a unix/linux type of person so I'm trying to install Server 7.5.3 on my ...

FINALLY!!!
I think we solved this mysterious deadlock issue!!!
It's a table setup issue.

Hash Partition and sort on the update key should resolve your problem. If you are updating a particular set of records, putting that filter in update will you help you better I've done this and it was fine for some days, but today, I got the same deadlock. I even had it checked "unique" t...

i had similar problem and hash partitioning help me. hash partition the input, on the columns used in the where clause. Now i'm getting a deadlock too on another job even if I try 4 or 8 nodes. I just have one primary key (used on the update condition). Hash partitioning on the Update input stage d...

It seems like this is caused by the parallel configuration. I was using 6 nodes. I tried 8 and 4 nodes and I don't get the deadlock anymore. Now I don't know yet if it's the number of nodes, or the location of the disk and scratch. On 6 nodes I had it on the same filesystems. On 4 and 8, I splitted ...

As per my understanding, changing Oracle partitions into sequential will again make the load sequential, but is there any way to avoid deadlock even with parallel loading ? Of course. So basically, the answer you got is not a good answer. (it amused me somehow) And I don't have a good answer to you...