DSXchange

Supress the warnings thru datastage manager. thats the best way i feel I have a job which tries to update rows on a table. If these rows don't exist on the table, then under some conditions I get warnings and under other conditions I get no warnings. Does anyone know why, or what the rules are for t...

internal error-Function Row_row_to_buffer failed means ?

when we are trying to load a DB2 table by using DB2 bulk load from a DB2 table with two hash file lookups, while liading sometimes we are getting an internal error: Function Row_to_buffer Failed < ONT>

Hi, I am very new to metadata forum I hope u people will be help me out...... :lol: I need to have the current version of metstage available? what are the system requirements to use metastage? Can this run on Unix? and does it require an INTEL presence(ie. Part of infrastructure dependent on MS Wind...

Hi,

I need to have the current version of metstage available?
what are the system requirements to use metastage?
Can this run on Unix? and does it require an INTEL presence(ie. Part of infrastructure dependent on MS Windows Technology)?

Thanks n regards
Nagabhairu Venkat

what is DRS stage?

Differences between DRS Stage and ODBC? Which one is the best for performance?

Can we put filter conditions on sequential file? If how can ?

What is CRC32?
On which situation we will go for CRC32?
how we will use CRC32?

what is the difference betwwn clear status file and clearlog please let me know

Sainathan Is correct, thats the mistake in transform
You have mapped a col defined as string (char or varchar) to a col defined as date. Check it in the transformer stage.

I observed those parameters all are correct from batch job.
Actually when the batch job is called by crontab automatically at that time that is aborting due to sql connection failure. when we ran manually at that time those are running fine without any warnings like sql link failure

I am facing a problem with parameters That is when we pass parameters dynamically from batch job to sub batch jobs.Those callable jobs are every time aborting due to SQL connection failure because of I think those are getting some nulls or wrong passwords. thatswhy my host user Oracle source user Id...

Hi actually we tried with only one key coloumn there is no diff in the perfprmance
we are using hashed file reference lookups only.
In odbc stage we have parameter array size check box in that we gave 1 when we are trying to give more than 10 that will giving an error.

Thanks in advance
Venkat

When we are trying loading a sql server table by using ODBC with two reference lookups( which contains 100 rows and 5 coloumns) that job performance is very low nearly 2 rows per sec.We are using datastage version 7.1 How to improove the performance and is there any otherway to connect to SQL server...

after killing the session you have to check
Check to see if the kill command worked or not
by again ps -ef command
UID PID PPID C STIME TTY TIME CMD
root 1515 1 0 May 08 ? 0:00 /dstage/app/DataStage/DSEngine/bin/dsrpcd

when you are using ps -ef command that give output as UID PID PPID C STIME TTY TIME CMD root 1515 1 0 May 08 ? 0:00 /dstage/app/DataStage/DSEngine/bin/dsrpcd dsadm 1984 1515 0 10:17:36 ? 0:00 dscs 4 3600 0 dsadm 1985 1984 0 10:17:36 ? 0:03 dsapi_slave 7 6 0 dsadm 2102 1515 0 May 08 ? 0:00 dscs 4 360...