DSXchange

Thanks to all , I am going to start routine , I will let you if any issue .


Regards

Arun Verma

Thanks Mr. Ray ,

Can you Pl guide , how to get info and from which table , so we can start developing routine .

Reagrds

Arun Verma

Hi , We are having two dept. , development and operation . development team develop application and create root job sequencer , this sequencer call one by one all job . operation team is responsible to run application's sequencer . on daily basis they send us application wise status report , like fi...

Are you trying to populate data into Hash File ??? , If yes then , this is Hash file size limitation problem . in DataStage - 7 , default hash file size is 2GB ( 32 BIT ) and if size exceeds this value then it will failed and give error . Solution :- You need to resize Hash file ( 64 BIT ) from Univ...

HI ,

You can put Arraysize as 32767 which is the maximum limit , to put value of transaction size ( commit size ) , if you put 5000 the in oracle after 5000 it will commit in database , so to get optimum value pl concern your Oracle DBA .

Regards

Arun

Use TO_CHAR function in user define sql while extracting data from source system . Ex :- TO_CHAR(A.LAST_MODIFIED, 'YYYY-MM-DD HH24:MI:SS') and make column data type Timestamp and while loading data into Oracle with using Oracle plug-in , use column data type as char(30) , it will load automatically ...

Hi Anupam ,

Where are you ??? , no communication for last six month ....


Regards

arun

At the time of data loading , change the data type of all date column as Varchar2(38) , Oracle automaticaly load as time stamp .

HI Battliou , If you are getting special character in source column , then you can create routine and use in transformation , it will remove those character . Ex:- Routine - RemoveUnWantedChar It removes following character. Chr(10) , Chr(13) = "Enter Key" Chr(124) = "|" ---> Pip...

I have two version of application in my version control , now this is new application and for some reason , we have complete deleted Application category and respective job from production DataStage server . Now my requirement is also delete entry from version control , I want to create fresh entry ...

Hi Mr. Roy/Ray/Chulett . I agree with your point , We had faced directory limit ( Unix -3500) problem one year back then we create new project for version control . I have promoted one application through version control . and after some days I made some changes in application and promote , so in My...

Hi Chulett/jman ,

I want to delete particular application category , not all entry , I tried to choose application category and delete from Edit-> Delete option but it delete component only not complete category ?

Pl help .


Regards

Arun verma

We have three Datastage platform - Development , QA and Production , and we are promoting application through version control . today we try to promote new application but due to some nework and system problem process could not completed properly and got some garbage entry , Now we want to delete al...

Hi Karina , We have faced the same problem earlier , whenever you stop DS engine You can confirm connectivity to DS serevr by netstat -a | grep dsr If you wnat to discontinue , then find out PID and kiil it . for ex: you want to get PID of root process 1324 then give following command lsof -i | grep...

Hi ,

We have created operator user on production for Operation people
they monitor and run job . we have observed that operator user can delete any job also create job in production . pl help me how to revoke
this right .


Regards

Arun Verma