DSXchange

Hi Ray, here is some of the info:
"Use realm-qualified user names" box is unchecked. Administrative and application security is checked and java 2 is not.

"LTPA" radio button is selected for authentication.

User Account Repository: Local operating System.

Thanks Ray for responding on Xmas eve. I feel grinch
I will take a look at the setting on Thursday and let you know.

Thanks again for reply and Merry Xmas.

Sorry didn't know WAS security doesn't exist. Then I guess we are using Operating System security but not LDAP for sure. I was told, we are not using LDAP because LDAP doesnt allow generic ids (like appadm, dsadm) to login into applications (I have a feeling it is incorrect but I dont have a documen...

Were using LDAP security then switched to WAS security with sharing registry option Checked off, and user's own credential are used instead of dsadm. To prove if code is working created another project and imported this useless project without exe and recompiled and working fine. This doesn't tell m...

@zulfi123786: Did you ask IBM what is included in this patch? any reference or details? was this patch to fix UV information about the project.

Jobs that were compiling yesterday morning cannot compile. I hit compile in designer, window says job compiled successfully, but director still says not compiled. When i try to run the job i get notfication that job is not compiled, its not just one job, its with all the Jobs. Mind you this code was...

@zulfi123785: Issue you and I had are similar. IBM manual and best practices docs all suggest to use Auto option to let DS decide the partition. However I read Ray's response to another post where he recommended to use environment variable (I think score dump) to see what DS actually does behind the...

Thank you Ray for sharing the insight. I think you meant to say "I prefer to use explicit Sort stage." and "The Sort stage allows me to..." I dont mean to be rude but hoping someone else doesnt get confused as we value experts' opinion. Thanks again for your detailed and timely r...

Thank you Ray for quick response. Good catch I corrected spelling. :) In DS 7.5, job that had Join stage with Auto partitioning was working okay but when we migrated this Job to DS 8.1 results were not same. Once we hash partitioned input on keys and then sorted before joinining, results were same a...

Some questions are bothering me and after spending some time, I thought I should ask you guys for enlightenment. It will help me immensely. No these are not interview stumpers. I am told that new configuration might have have different output (assume if developer used AUTO partitioning) even if we r...

I found the answer for #4 in IBM's White paper for Netezza. PDF "ID_628_Public_Whitepaper_IBM_InformationServer_Netezza" can be found online and please read the section "7.2 How to Manage Temporary Work Tables (TWTs)". Here is the summary: 1) Well DataStage Application ID really ...

Thank you for your quick response Ray.
Well you hit three birds (questions) with one stone. Thanks for enlightening me Ray.
It leaves me with question #4? Anyone ?

I am trying to understand Netezza connectivity, and type of access between Datastage to Netezza, and hoping someone can help. Some of these questions may be basic but would surely help my undrestanding on the topic. I know Netezza native connectivity is available since 8.1 version and 8.7 makes it t...

So, its pretty much done deal, cannot be done pre 8.5 pack 1 Datastage versions.
Sorry for the lengthy post, I just wanted to be helfpul to those who will be searching in the future.

@chulett: Good suggestion. Since table structures are same for DBNAME.TABLENAME and DBNAME.TABLENAME_EXPTN I tried loading the DBNAME.TABLENAME_EXPTN and it was successful. That leads me to believe access are same for both tables. @Kryt0n: yes, I referered schedma as DBNAME. Sorry for the confusion....