DSXchange

Thanks all
But still i am not clear.

If the no of records to update is more then
we have to use ->Update existing rows or insert new rows

If the no of records to Insert is more then

we have to use -> Insert new rows or update existing rows

Am i Right?
George

Hi everyone.

can any one tell me which one is faster for table update action.
using update existing or insert new rows
OR
insert new or update existing rows

and why?

Is there any real difference between the two?

Thanks
George :D

Finally The plugin is resolved, It was the problem with dsenv file format, there was some unnessasary if else loop,the SHLIB_PATH was not defined in a single line Took off the unnessasary if else loop, made the SHLIB_PATH in a single line ,it worked this is how our new dsenv file looks like $ more d...

We have registered a case with IBM, These are the steps that we did, thanks for all ur help i will up date u all.. These are the commands that we tried on our dev server # cd /opt/products/Ascential/DataStage/DSEngine # netstat -a |grep dsrpc tcp 0 0 *.dsrpc *.* LISTEN # ps -ef|grep phantom root 233...

We have registered a case with IBM, These are the steps that we did, thanks for all ur help i will up date u all.. These are the commands that we tried on our dev server # cd /opt/products/Ascential/DataStage/DSEngine # netstat -a |grep dsrpc tcp 0 0 *.dsrpc *.* LISTEN # ps -ef|grep phantom root 233...

Hi,

I have opened a case with IBM.
In progress,
Will update you everyday...
Thanks for all your help
George

ray.wurlod wrote:Can the Administrator client connect to the project?

Can you invoke dssh in a project on the server? ...

Hi,

Administartor client also cannot connect same error.
Kindly would you tell me how can i invoke dssh in a project on server?
Thanks
george

We have changed the permission of ds.rc file to $ ls -al ds.rc -rwxrwxrwx 1 dsadm dwcap 16865 Jan 16 09:10 ds.rc stopped the Dsengine with "uv -admin -stop" dsengine is stoping but $ uv -admin -stop Unable to remove the following shared memory segment(s) during shutdown: m 33798 0xadec7512...

Hi,

The permission of the file /opt/products/Ascential/DataStage/DSEngine/sample/ds.rc
is

$ ls -al ds.rc
-r-x------ 1 root dwcap 16865 Jan 16 09:10 ds.rc

we will change the permission of the file 'ds.rc' and tell you the update
Thanks'
george

Thanks for the replay Craig,

The file exists there and the permission is
$ ls -al uv
-rwxr-x--x 1 root dwcap 65536 Apr 13 2005 uv
the user we are using is having administrator rights

Thanks
George

Are there issues with importing tables through the orchestrate schema definitions versus the plug-in metadata definitions? I have heard that when using paralleism the table structure that is imported through the orchestrate method works better then if it is done using the plug-in meta. Is this true...

Data Source Names for ODBC are configured in a file called .odbc.ini for DataStage on UNIX. You also need an entry for the DSN in the uvodbc.config file in the project directory. You also need to be ... hi, i have already done this. still facing the error. can you please sent me a copy of .odbc.ini...

Hi Every one, We have installed DS 7.5.2 in HP unix at our Development Server.But we are facing a problem. Our ODBC connection with Oracle is not working. 1st In the D.Manager while importing it was showing the error "NO DNS name found" With the postings from Dsxchange,i gave an entry in t...

chulett wrote:So... you are planning on using ODBC? Why not 'go native' and use OCI?

I dont mind using anything OCI or ODBC.But to import metadata i need a DSN connection its not there.Can any one show me a copy of .odbc.ini and uvodbc.config files. I think these are not created properly.

Welcome Aboard, No, just those two files for an odbc connection. This has been discussed here before, search on keywords. Sir, our pre prod's DSN is working well and fine.so i checked the .odbc.ini,uvodbc.config files with our Development server. The files are almost the same. But i didnt find the ...