DSXchange

I've seen it happen that "slave zombies" cause performance problems. You can see this e.g. by checking via 'ps -ef' how many 'CPU seconds' are being used by a slave process. Not all of the slaves show this behaviour but it seems some slaves keep processing stuff after a client session has ...

There's no "native" integration of DataStage with the web (at least not in the current version). There's also no easy way of making the integration yourself. I'm sure it's possible but it will take you a lot of time to realize it. Now a plug for Kim Duke :wink:, there's additional software...

__SS__ wrote:Hello

I'm trying to use an oracle sequnce on a ORAOCI9 stage, but i get this fatal:

ORA-01036: illegal variable name/number.

Some can help me?

Ty
__SS__

What are you trying to do, what's the SQL query being executed, ...?

Ogmios

deep wrote:How do i clean up.
The way i know is to use DS TOOLS.Do you have any other suggestions.

Thanks!

I usually have everyone log out and do cleanup via DataStage administrator but via DS TOOLS it should also work. In any case try bouncing (stopping/starting) Datastage server.

Ogmios

Can be several things, seen it on several occasions: A few things to try (in order): * Reboot the system your Datastage client is running on and try it again; * Bounce the Datastage Server and do a cleanup of the projects; * Check whether no-one erased part of your DataStage Server installation. Reg...

Some stages as the DB2 stage want input/output in 'internal format" for dates, while ODBC stages use "string" input/output. So not sure as I don't have datastage access right now but I would switch the "format"s as: oconv(iconv(Input.Update_Date, "D/MDY[2,2,4]"), &...

Do you have a proper C++ compiler installed? HP comes default installed with a "small" compiler that can only be used to rebuild the kernel.

Regards,
Ogmios

"It's not our error, it's the error of the guy behind the tree" ... funny :D. At our site we're still on DB2 V7.2 fixpack 9 which still has the "problem", and we didn't find another workaround. By the way splitting the job in 2 jobs will be faster if you can select the update/ins...

Which kind of database stage generates the error? There are huge differences between the different kind of stages.

Ogmios

Can we have hash file whose size exceeds 2GB by any means. Need expert comments. No expert on hashfiles, but it can be done. The "size problem" is because of 32bit pointers used internally in hashfiles which is usually the default compared to using 64bit pointers. You can specify this whe...

Funny T.J. I have been DB2 administrator long enough to know the SQL codes out of my head, SQL00911N is something as "transaction rolled back because of deadlock or timeout". I never fully understood why transactions are implemented the way they are in DataStage, or maybe it's just a DB2 t...

My 2 cents would be to try to get your lookups included in the input query (calculating the data in the database not via DataStage). I only use database lookups or hashfiles for very large dimensions that are in other databases as the input-query. In 75% of the cases a properly tuned database will o...

First of all this site is English only, translating forth and back between languages for a lot of mails would be difficult. Now for your problem (in English): You have a deadlock error when using "2 lines", transactions are pretty tricky in DataStage... but you get used to them. Probably y...

Liberal translation... for as for as my French goes: Excuse me but that I don't write in English In my job I have 2 lines going to the same table (plugin DB2). Insert/Update ---------> T1 => Constraint ==> CODE = 1 Delete------------------> T1 => Constraint ==> CODE <> 1 This error provokes an SQL00...

The DB2 stage will happily continue on serious errors, it will only issue warnings even e.g. when the tablespace you're trying to write to is full, as long as I know DataStage the error handling of the DB2 stage is not as good as an ODBC stage. So I prefer to use an ODBC stage when writing to DB2. O...