DSXchange

Hello Experts,

If we run a sort stage on 2 partitions, each partition would have its set of sorted data. How does the overall data( from both partitions) get sorted? Is it during collecting? That means the data needs to be re-sorted while collecting?

Thats true. But i am curious as how does stage partitioning on 1X1 do even least bit of good to the job. It should make no sense to partition the input links on a single node environment. I know the job would process data but it would make no sense of the partition technique used, correct? Just curi...

Hello Experts,

I had a doubt about the partitioing in datastage jobs. Will partitioning techniques still be effective if i use a config file with 1X1 configuration ( 1 compute node with 1 partition) . If yes, then how?

Thanks

Hello Experts,

I had this doubt as to which connector to use to connect to i-series? Should i prefer DB2 or ODBC? Currently i am able to connect with both but is there any pros and cons of these two, i mean which one should i chose ? Are there any factors to be considered?

Also we found through IBM that the way Datastage idoc connector stage connects to SAP is different than it does using R3 stages, hence this new problem arises in the new stage.

I tried searching the portal and other websites as well, couldn't find anything related

Hi Experts,

Is there any way i can restrict users from creating environment variables on their own through admin clients. I have currently setup the user-role as Super Operator, but these users have access to create and modify env variables.

Any idea ?

Turns out that using short password(around 8 letters) resolved the issue. Long passwords were not working.

Hi Experts, I am using ODBC connector to connect to a sql server. If the password length is around 12 or 13 characters , i am getting an error related to out of memory ( glibc detected ) But if the password length is reduced to say 7 or 8 characters, the connection is getting established. I am using...

Hi Everyone, I am facing a weird issue with DB2 conenctor stage. I have just specified the Database, username and password fields and left the instance as blank. When i try to test connection or view data i get an error message: An error occured while getting the db2 instance.Verify that a valid db2...

After installing all the transports provided by IBM at the SAP end , we still faced this issue. We found a security parameter at SAP end, RFC something like that, we played with its value and change it to 1. Earlier its value was 9. This worked for us and now we are able to connect.

Hi I am using webservice stage to connect to sharepoint. Getting the below error: APT_CombinedOperatorController,0: Fatal Error: Fatal: 0026`:`com.ascentialsoftware.wsclient.ServiceInvocationException: Service invocation exception: <Fault xmlns="http://schemas.xmlsoap.org/soap/envelope/"> ...

Thanks Mike for the info.

I just got to know that there are a few Transports and profiles that are needed to be deployed at the SAP end as well.

Do you have any idea about this if you might have done the same?

i am following http://www-01.ibm.com/support/docview.w ... wg21579738

Hi Guys, I am facing issues connecting to SAP systems. If i use the IDOC load connector stage, then while selecting the idoc type iam getting the below error: CALL_FUNCTION_SIGNON_INCOMPL Incomplete logon data But if use the same rfc connection to establish the connection using Idoc load stage for S...

Hello Guys, I am using a shell script to encrypt a .csv file using pgp encryption and calling the script in Execute Command activity stage. I am just using this command in my script: gpg -e -r "$KeyName" $SRCDIR/$FNAME This scripts is successfully able to encrypt the files when i run the s...