DSXchange

hi,

As i checked the Db2 is having 109 gb free space of memory and for datastage 90gb free space of memory is there.

still is it the problem with memory

any how i will try to make it free some more space in both the servers

Thanks for you information.

Let me google it how i can clear the db2 logs

what i understand from above post is ( we can do setup in server side ) am i right

but i am looking in parallel jobs

hi

can any one please help on this.

use of ODBC connector stage over an SSL connection to connect to I series through datastage 8.5 version

i googled but i didnt get related result.

HI i had checked below all things in my job before job sub routine - use Execsh and try to echo the parameter value. Verify if the value has any spaces, extra characters etc. but it's help less onething i observed is when i tried to do some changes ( minor will effect any logic or code ) and compila...

HI

I am just passing one parameter to sequencer which contains DB connection information

i am not getting any kind warnings other than this issue

hi client has enabled SSL certificate to use of secure data connectivity on top of us need to connect the JDBC to pull data from iseries table one question do we have JDBC connector in Datastage 8.5 version as as for as i googled i got information like its available in Datastage 9.1 version if we ca...

HI ,

i have checked all DB2 and datastage settings and did both the servers down and up . if there is any problem with DB2 connection it should occur while running job indivdually

this issue is occuring at the time of job running through sequencer.

Thanks your information

as for as we are only acting as DBA's we couldn't get how to resolve the issue

hi we are passing one parameter which contains ( DB connection ) through sequencer . FYI the same job is running fine in UAT and prod through sequencer when we passed the same parameter the jobs are running fine and now only i observed the same issue is coming for all jobs in dev environment Thanks ...

Hi can any one please help me on below issue when i trigger job directly ,it's running fine with out any warning if i trigger through sequencer the job is getting aborted due to below issue . Upd_STG_MFAINVNMP: DB2 function SQLFetch failed: SQLSTATE = HY000: Native Error Code = -1,042: Msg = [IBM][C...

Hi ,


can any one help me on use of ODBC connector stage over an SSL connection to connect to I series through datastage 8.5 version.

please guide me

Thanks in advance

Hi All,

can some one suggest me how i can connect to i series through Datastage 8.5 by using JDBC connections

if it is possiable please help me on this

Hi Criag,

currently i m using 8.5 Datastage 8.5 Version

Thanks for your help in advance

Hi Team, Can any help on below Scenario How To Generate Dynamic Target File In datastage Based On Column Value Dept name, Dept ID, Location DWH ,1 ,Mumbai Java ,2 ,Bangalore Dot net ,3 ,Delhi i want to generate the file name as Mumbai.dat if the employee location is Mumbai. Thanks