DSXchange

Hello Experts, One of the quality stage job containing Address verification stage is getting aborted with below error. main_program: PATH search failure: [sil/step_il.C:1329] main_program: Could not locate operator definition, wrapper, or Unix command for "qsavop"; please check that all ne...

Thank you Ray,Chulett & Mark for providing your valuable inputs.

Hello Experts, There are close to 100 datastage projects in our infosphere environment and total job count is close to 100K across all datastage projects. Now the requirement is to get a list of parallel jobs which contain teradata connector stages in their job design. How to find out this, any clue...

Hello Experts, I am facing problems in one of the parallel job(9.1.2 version). I am not able to see the job run statistics (i.e. rows per second processed) do not update in DataStage Designer or Director clients for one particular parallel job only. I checked the JobMonApp service on the backend(Lin...

Hi DS experts, Our requirement is to process data by using teradata connector stage in datastage 8.7 version. We want to process data of type "TIMESTAMP WITH TIME ZONE".We are using Teradata as source/target database. But it is specified in documentation(IBM InfoSphere Information Server, ...

This is resolved now. We just re-started datastage services.

Hi Experts, We are not able to access datastage through datastage clients(Designer, director, administrator). Getting the below error while logging in, into any of these components. Error message : DSR.ADMIN: Cannot lock record - dsadm STATUS() 14 Please let us know how to resolve this error. We are...

This is resolved. We have replaced NextSurrogateKey() function in the transformer derivation with below expression and the job finished fine in 10 minutes. @INROWNUM * @NUMPARTITIONS + @PARTITIONNUM +1 - @NUMPARTITIONS + ps_nxtval Please note that ps_nxtval is the variable that holds the initial val...

Thanks Ray.

Actually XMETA was down. Now we have brought it up and the issue is resolved.

Thank you so much.

Hi Experts, While trying to access any of the infosphere information server 8.5 tools ( DS Designer, DS Director, DS Administrator, Web Console etc), getting the below error message. Unable to begin a transaction: [Can't lookup a connection] I checked the Systemout.log file and it contains the below...

Hi Experts, We are using datastage 8.5 version with internal registry configuration. That means suite users reside in XMETA. I would like to know what is the maximum limit of number of users that can be created by using webconsole. Is there any configuration file present on the datastage server that...

I have defined 5 nodes in the configuration file, one conductor node and 4 compute nodes, so I believe the job runs on all the nodes(conductor as well as compute nodes). I have not defined any block size in the properties of surrogate key tab under transformer stage, it is "System selected bloc...

Hi Experts, Our datastage architecture is comprised of one coductor node and one compute node.Datastage version is 8.5 FP 1 I am using flat file surrogate key and using it in my parallel job in transformer stage and passing the values through NextSurrogateKey() in the derivation field. When I run th...

Certainly Yes

Check what role has been assigned to other user and to you in webconsole for Information Analyzer components.

Then check your role in Information Analyzer project.