DSXchange

I believe on Windows there would be a few entries in the Registry as well, so does need to be backed up as well along with Install and Project Directories?

I created a Credentials File and it has values for all 4 components, Order in the file does not matter # Datastage credentials domain=<Servername>:9080 server=<servername> user=<username> password={iisenc}ELpGU5b/cE8a6db8yIqw8Q== ** NOTE:password is encrypted using this command C:\IBM\InformationSer...

Thanks..
I was also thinking of that as the last option..Securing the credentials file!

But even if I call this Credentials file the password would still not be encrypted right..It is still visible in this file

Since it does not seem to work with dsjob command, how else can we have a encrypted password work with dsjob
(we do not have any third party encryption tool/utility)

Hi All, Datastage 8.7 on Windows 2008 R2 I am successfully able to run a job from a script using the dsjob command and hard coding the userid and password, along with other required parameters for this command. (So this means my domain used in the command is correct). Now I tried to use an Encrypted...

The User DOES NOT need to be a Windows User. A valid SQL Server User is enough and works fine. I cleaned up the earlier Install using the DSODB_SetUp_Remove.sql and reran all the steps as listed for setting up the Operations Console and it worked w/o any issues. We created a new Database for it that...

This IBM link for Operations Console says so..hence it is confusing http://pic.dhe.ibm.com/infocenter/iisinfsv/v8r7/index.jsp?topic=%2Fcom.ibm.swg.im.iis.ds.monitor.doc%2Ftopics%2Fcreatingodb.html generate_ddl.cmd HostServerName DatabaseName UserName existingwhere ◦HostServerName is the name of the ...

No we did not find any errors when we ran the scripts as per steps listed in the readme.txt. Yes I know skipping the Errors will not help but was just trying to bring all the services up and see if we see anythign in the Operations Console!! The Username we use for the generate_ddl.cmd is NOT a Wind...

Hi All, We are on Ds 8.7.0.1 on Windows 2008 We Installed Operations Console but had an issue in the EngAppMon service starting. It has been installed on SQl Server 2008 DB under the XMeta database as a seperate scheme (default schema of DSODB, we tried installing as a seperate database but it kept ...

Hi BI-RMA,

The select statement does retrieve 1 row..In fact I also tried to return 100 rows for testing but the After Sql still did not execute!

Using the RowGenerator for 1 Dummy source row with 1 column and using a Delete statement (deletes nothing) in the Target ODBC Conn stage worked..

Thanks for your help

I was providing valid columns existing in the actual table in the update query On trying the Select option in a Source ODBC connector and writting the o/p to a Copy stage, the Merge in the Before SQL works fine (no warnings) but for some reason the After SQL (I need to do something) is not executing...

Thanks All.. As suggested, I used a Row Generator to create 1 record with 1field (Appt Num) and in the ODBC connector stage I am writing a User Defined Update SQL using this as key for the update along with 1=2 in the where clause to NOT update anything. Running on 1 Node Configuration The Merge sta...

Hi All, We are on DS 8.7 on Windows We are currently using Datastage and planning to use Metadata Workbench and Information Analyzer in the future. My question is there any special consideration(s) to be followed in the way we design and implement Datastage jobs OR it does not matter and this does n...