DSXchange

I just opened a PMR with IBM......will post any information I receive to resolve this issue.

I just opened a PMR with IBM......will post any information I receive to resolve this issue.

OK, I rebuilt the job from scratch and am using the following for the ODBC parameters: #$MF_DSN# #$MF_UID# #$MF_Password# all defined as $PROJDEF in the job properties. Now the job runs clean, but I am still unable to connect via the ODBC stage in designer(tried both the test and view data buttons)

Thanks for the suggestion, when I look at the OSH_DUMP I see..... type=\'string\'>1.0</DescriptorVersion><PartitionType type=\'int\'>-1</PartitionType></Common><Connection><DataSource modified=\'1\' type=\'string\'><![CDATA[$MF_DSN]]></DataSource><Username modified=\'1\' type=\'string\'><![CDATA[$MF...

I did check to make sure all were defined as $PROJDEF..... The weird thing is when i check the Job Status Details in Director they are identical for the run with the hard coded parameters(succesful and I can connect from the ODBC stage) Current job parameters: $MF_UID=Z8TDSTG $MF_Password=L<;@AIV8>=...

The fatal error I receive when I try executing is: ODBC_Connector_0: [IIS-CONN-ODBC-000004] ODBC function "SQLConnect" reported: SQLSTATE = 08001: Native Error Code = -30,020: Msg = [IBM][CLI Driver] SQL30020N Execution of the command or SQL statement failed because of a syntax error in th...

I have noticed that the variables look to be substitued properly (at least the dsn and UID) Server:NJROS1BBLA0602 Project:CRM Job No:2 Job name:Test2 Invocation: Event Number:0 Event type:Control User:NJROS1BBLA0602\DSADM Timestamp:4/15/2009 4:29:20 PM Message Id:DSTAGE_RUN_I_0070 Message: Starting ...

Hi, We are developing our first parallel job and early on already hit a stumbling block. In our server version of the job we defined the following administrative variables and imported them in the job prperties. $MF_DSN $MF_UID $MF_Password and just coded the following in the ODBC stage: #$MF_DSN# #...

Looks like this version requires the server parameter when using user and password....

Hi, In version 7.5 I always used BAT files like this to execute DS jobs. I just tried the same in version 8(we recently upgraded) and I get the error below. I'm not sure what I am missing. Thanks - - John Contents of BAT file D: CD D:\IBM\InformationServer\Server\DSEngine\bin dsjob -user Z8TDSTG ^ -...

Hi, I just finished loading Datastge version 8.0 software on our QA server and have configured it to use LDAP. I created a group and issued the securiy for the windows 2003 server per the IBM documentation. I granted the 2 users SuperOperator access to the project. They are able to log int Director ...

I believe your response was for a Unix install...I am running on Windows 2003. Thanks - - John

I did find some documentation on this and have a follow up question...... When I change the method of security in the WAS window to Local Operating Sytem(from custom), I am locked out of IIS completely...so I reverted back. What System id's can I use to log into WAS and IIS once I make the change to...

I'm sorry for the confusion...it is a Mainframe process id that get's locked. We connect to the mainframe via ODBC. It is the Mainframe DBA that repoprted to us that a process called "METASTAGE_LOCK_INFO" is causing our process id to get locked out of the database.

Hi,
Our process ID keeps getting locked out.....Our DBA has traced the issue back to something called METASTAGE_LOCK_INFO .
Has anyone heard of this?
Thanks - - John