DSXchange

Hi All,

I am trying to load Oracle data to GreenPlum using ODBC driver, for loading 50 million records it took 27 hrs.

Did some one have any experience in using gpfdist(Greenplum file distribution) in DataStage for bulk loading the data.


Thanks
Sundar.

For 2 nd query.. try this.. apt_string_pad_char(0X20) we had simlar situation seen tiny box symbo, while viewing data from DB2 .. resolved with setting apt_string_pad_char(0X20) .

Issue got resolved.

Issue is with User id Privileges..

HI Friends, Am also facing same issue as this while installing DataStage 8.5 I am installing DataStage 8.5 on Windows server 2008r2 Standard. Installed VS 2008 Pro After running setup file, IE browser shows error Http 404 error, BridgeServlet: /ISInstall. Installed Mozilla browser and tested but no ...

Hi Craig, I have executed .\dssh in DSEngine directory.. while executing :UPDATE SDKSequences USING DICT VOC SET F1 = '192' WHERE @ID = 'E_OPER_UNIT_TBL' got error: DataStage/SQL: table sdksequence doesn't exist. when i search in forum.. found that, execute the statement: CREATE.FILE SDKSequences 2 ...

Hi craig, i am able to execute .\dssh E:\IBM\InformationServer\Server\DSEngine\bin>.\dssh This directory is not set up for DataStage. Would you like to set it up (Y/N)?N E:\IBM\InformationServer\Server\DSEngine\bin>.\dssh This directory is not set up for DataStage. Would you like to set it up (Y/N)?...

Hi craig, i have moved SDKSequence hash file to PROD env and most of the jobs finished without any duplicate rows only 2 jobs were dropping records as generated value is already existing in table. So now i am planning to update only that 2 sequenc using below cmd. UPDATE SDKSequences USING DICT VOC ...

Hi Craig, I didn't modified the routine... Yes .. it doesn't match with routine what was on 7.5.2 routine on 7.5.2 --------------- EQUATE RoutineName TO 'KeyMgtGetNextValueConcurrent' If NOT(Initialized) Then * Not initialised. Attempt to open the file. Initialized = 1 Open "SDKSequences" ...

Hi Craig,

i am able to see the SDKSequence hash file but i am not able to see the hidden file .type30

Can i copy(right click copy & paste) paste only SDKSequence hash file .

Hi Criag,

I can't see the full content of your post..

can i copy the SDKSequence hash file from old project to new project.. now? becuase already SDKSequence hash file is created in new project.

Hi Friends, i know this issue is already discussed in this forum.. but i need some guidence on this.. I have server job which is using KeyMgtGetNextValueConcurrent() routine.. 1> as part of upgrade jobs/routines/shared contianers.. moved from 7.5.2 to 8.5 and re-compiled. 2> all tables were moved to...

Issue got resolved..

created 32-bit odbc dsn name and it worked out..

Hi Frineds, I am facing issue while trying to connect SQL server 2008 R2 64 bit database from DataStage 8.5 on window 2008 64 bit server using System DSN. Issue: J_BASE_PS_COMBO_SEL_05..DRS_PS_S_COMBO_SEL_05: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch betwee...

Thank You Ray and Craig,

i reset the job.. it is fine now.

Hi Friends, I am having issue with one of my server job DataStage 8.5. Issue: Job control process (pid 5976) has failed. Problem is i have logout some processes from director window- job- resource clean-up, for releasing some locks. Now job status is showing as crashed. Please advice me how to proce...