DSXchange

Thanks for all your valuable inputs.

Yes datastage is installed only on server1, I didn't see much difference in proccesses when I set the option to store the log in datastage repository(XMETA) or the filesystem(just like 7.5.x version). For the above configuration file, we don't have to use the APT_PM_CONDUCTOR_HOSTNAME parameter, is ...

This is the changed configuration file: { node "node1" { fastname "server1" pools "conductor" resource disk "/datastage/Datasets" {pools ""} resource scratchdisk "/datastage/Scratch" {pools ""} } node "node2" { fastname ...

Thank you very much for your valuable inputs, 1)After making this change, the processes are running in the server2 (except the start up process which has to be run on server1 as expected). The behavior of this didn't change with or without the parameter APT_PM_CONDUCTOR_HOSTNAME, so we don't have to...

Thanks for the reply, If I mention server1 as fastname the job runs fine, but I don't require to use the APT_PM_CONDUCTOR_HOSTNAME parameter, so when do we use this parameter? By setting the fastname as server1, the process PXEngine/bin/osh run both in server1 and server2, is it possible to run all ...

Hi, I have searched in the forum and using this http://www.dsxchange.com/viewtopic.php?t=121634&highlight=CONDUCTOR_HOSTNAME as my starting point. Using server1 as a conductor node and use server2 to run all the processes { node "node1" { fastname "server2" pools "conduc...

Yes the was-admin and iisadmin are both Suite Administrator, still with both the id's not able to see the option User to be deleted.

Thanks for the reply When I logged as dsadm/was-admin user into the http://<server_name>:9080 --> Administration --> Users and Groups --> Users --> searched for the user When I selected the user I can see the following option CheckBox |Last Name|FirstName|UserName|Title|BusinesPhone|Location On the ...

How can we delete a user using webconsole? Our server is configured with LDAP. I explored the DirectoryAdmin.sh, it allows to delete all the users or all the groups not by individual id. DirectoryAdmin.sh -delete_users Parameters The following options are available for the DirectoryAdmin command. -d...

Agreed.

Thanks for the reply,
So datastage will not carry the content in Description as comment in the database table unless an user defined SQL. I think its easier to add comment in database level.

Thanks
Prasad

Hi, Is it possible to get the Description of the column [ For example oracle Stage --> Input tab --> columns tab --> Description Company name] Can we get the Company name in the above description as comment in target table in oracle stage or ODBC stage in either server or parallel job, as we are usi...

We could not use ODBC stage for reading the AS 400 [IBM mentioned they don't officially support the older version of AS400]

Workaround - use server job with ODBC stage for reading from AS400

You have to use 8.1.0 client to connect 8.1.0 server and 8.1.1 client to connect 8.1.1. server

Hi, Job Design ODBC[AS 400] --> Transfomer --> ODBC[SQL Server] Error: For every column I get the error ODBC_AS400: When checking operator: The modify operator has a binding for the non-existent output field "COL_1". and the job aborts When I run the same job with DRS Stage it runs without...