DSXchange

kumar_s wrote:Yeah, first task for tomorrow. The job is locked as well. I cant even delete and reimport.

Dear Ray/Kumar,

I am running around 100 jobs in parallel of which 50 jobs are getting locked due to the above fifo file locked error. What could now be the possible solution for the above issue.

Thanks.

Hi We are trying to access a file on the mainframe using the FTP Enterprise stage and are using the following syntax in the URI tab(as per the parallel job developers guide):- ftp://hostname/\'path.filename\' However we get the following error. ##E IIS-DSEE-TFOR-00089 23:34:27(001) <FTP_Enterprise_0...

Jobs will need as many connections as you have DB stages. Yes, that is 'common' - what is uncommon is attempting to run 200 jobs at the same time. Unless you've ensured both your hardware and database resouces have been configured accordingly. Dear Chulett/Ray, Thanks for your response. What could ...

Thank you for the quick reply.

I am new to datastage. We have nearly 350 jobs and each job opens a oracle connection. Is it a standard practice to use 1 connection per job? Or is there any connection pooling concept in datastage?[/quote]

We have installed DataStage 8.x on RHL 4.5. We have tried few options of using (g++, gcc, gcc32) on Administrator console. When we compile a job, it throws error. Following are some notes of my config and the errors: Config: -compiler 'g++' -compileopt '-O -fPIC -Wno-deprecated -c' -linker 'g++' -li...

Hi, I have a sequencer which calls around 200 jobs in parallel. When I run the sequencer around 150 jobs are aborting due to Connect(eg. ORA-12518: TNS:listener could not hand off client connection) errors. Its not able to open more number of connections parallely. Do we need to change the hardware ...

We use IS8.x on Linux. while compiling a job, having transformer, we got the following error. We used the options of g++, gcc32 and gcc options. But all are failing. we have gcc compiler on the RHL OS that we are using. Can anyone help why this error is coming and what we need to check. ##I IIS-DSEE...

Hi Ray/Kumar,

Thanks for your response. The invocation id for the current run of job is 100556. Does this imply that I am using the same invocation id for 2 jobs due to which I am getting this error. Please confirm my understanding.

Thanks.

Still the option is "Maintenance"

I am getitng the following error after choosing the index mode="Maintenance" Ora_Ent_FILE_STATUS: Indexes on table 'VERIFY_CON.FILE_STATUS' preclude direct parallel loading unless an index option is included. Add an index option or drop indexes and rerun step. I have also set ORACLE_SQL_LO...

Sorry for the late reply.....Chulett its working ...Thank you for your solution.Now i will mark this topic as resolved

We are using load option in the oracle enterprise stage .Also there are indexes and partitioning enabled on the tables .

Thank you for reply. We have used "Maintenance" option in oracle entreprise stage after that we are getting following error in sqlldr log files and DataStage job also getting aborted. Please advice us how to resolve the issue. The following index(es) on table VERIFY_IDS.SECABS_RECORDS were...

We have created partitioned index in oracle table and we are using oracle enterprise stage optioin with rebuild option and getting the following errors "The index-rebuild options may not be used on a partitioned index" When we try with "Maintenance" option on enterprise stage we ...

Hi, We have installed datastage on RHLinux Environment: datastage v 8.01 - on RH linux 4 update 5 (no patches) Scenario 1: Job is having 3 stages. Seq ---->>>> Transformer ---->>>> oracle database Login Time : 3 min Open folder : 4 min Designing Job : 4 min Compiling a job : 10-14 min Running a job ...