DSXchange

It gives out of memory error. I have tested with SSIS it worked well with exporting to csv file

Hi I have Datastage Job, Which reads the data from sql server and writes into Dataset. I am using ODBC Connector which uses the DSN(IBM native SQL Server Protocol) Job works fine upto some time and after that it runs but i can't see any change in processed rows in DS Monitor even after several hours...

dsrpc was running by using local system account, i have changed to specific user id which have full access and i have configured gpg keys for that user. It worked fine when i manually run a datastage Jobs. But it throws same error when i schedule datastage Job. i have configured same user in adminis...

Thanks Guys,

I've fixed this issue by changing the User ID which runs the dsrpcd Service.

Thanks

Yes Paul, Command worked from the Project home directory. I could see some differences in Environment settings Job Env: TEMP=C:\Windows\system32\config\systemprofile\AppData\Local\Temp TERM=nutc TERMCAP=C:\PROGRA~2\MKSTOO~1\etc\termcap TERMINFO=C:\PROGRA~2\MKSTOO~1\usr\lib\terminfo TMP=C:\Windows\sy...

Hi Ray

I don't see any difference in result of dsjob and client tool execution.

Hi qt_ky
I have checked the user id by using (id) in before routine and found the actual user and Command level the given command works fine.

What kind of comparisons we can do here??

Hi I need to decrypt the source files before processing into database using datastage. For this I have batch script which will decrypt the files and make them ready to process. I am calling script via Command Execute Activity in Datastage, which giving error "No Secret Key". Same Command i...

I dont see any warnings apart freom the above mentioned error message.

But i have informational message

transformer:Numeric String expected, use default value

Hi, We have built our Jobs in one environment and exported the complete project. We have reinstalled the DS application on same server and re-imported the project. All Jobs were compiled successfully. But when i try running the Jobs few jobs are failing with the error main_program: APT_PMsectionLead...

Not exactly.... I am building brand New Jobs in 9.1. as I mentioned few jobs startup time is very less (<5secs) which uses the same Same Parallel Shared Container. I have tested on job by removing the Funnel Stage the Startup time was decreased to half not sure what it was doing previously My Job de...

Hi I have One Parallel Job which takes around 8 mins startup time which is reading the dataset, two a shared containers one will do the Key Translation, one will write exceptions and writes into Dataset. Similar kind of Parallel Job just takes 40Secs Startup time(uses same Shared Containers) Can you...

I tried in Parallel Job which has given me the user id. Then i've configured AWS Credentials for that particular User. and ran the script through the same user it worked fine.

But when i invoke that Script in Datastage Sequence it says "Unable to locate credentials"

Thanks Craig,

Can you please advise where we achieve this functionality? I mean which stage and Options.

Currently I am using ODBC Stage and I couldn't find the Option.

Thanks

Hi Pandeesh,

The script works perfectly when we execute manually in Terminal.

So there won't be any issues with these Slashes

Hi

Is Bulk Load possible for Sql Server in Datastage 9.1 Parallel Jobs?