DSXchange

Hi everyone,

i'm writing a job to get all the instances and jobs logs from the project.
Can i get somewhere the job folder seen in the director using a Datastage Basic function ?

Thank you


Carlos.

Hello everyone,

There is no way to delete jobs instances via a routine or another way using a keyword without doing it manually ?

Regards,

Carlos.

Hi chulett,

Jobs instances in the director.
Forget about my DB2 note

Hello everyone, Thanks for your feedbacks both. I'm working on 8.5 version. Most of the jobs are in server edition. I don't have access to the server but when i take a log to administrator parameters, all DB2 parameters are empty. Does it means that all logs are in Universe database ? As i don't kno...

don't know.
When i do a rigth click on the instance in the director, it delete what part ?

The deletion will be demand by functional team and for an establishment\day.
I can't do that automatically, it's on demand.
i know it's a little weard but....

At the present time, i make it manually one by one

Auto Purge ? I think i have not expressed well my needs. I have to purge instances in the director module using a keyword used in the instance name. Example : if i have 60 instances by each jobs and 10 jobs, that will do 600 logs in the director. Each instance have the establishment name and the day...

Hello Everyone, i know that using some routines, we can delete job's logs. But is there a way to delete instances\jobs runs in the director using a keyword that is in the name of the job instead of deleting jobs manually job by job ? Sometimes i have to delete some runs using a keyword like DC_YYYYM...

that's TRUE.
We insert CLOB using DRS stage with type longvarchar 10000000.
Extract faster, load faster and read faster too if you use an OCI to read other columns in another job.

Hello,

got the same problem and it was an unique index that causes the trouble.
My keys were not the same as the Unique index.

HTH

thank you

command is

orchadmin truncate dataset_file.ds :D

IF the messages are managed at the job level, messages will be attached to the executable.
If they are managed at the project level, you have to export the message handler file and managed the handler in the administrator module too.

HTH

Hello, I have designed a job sequencer that loop px job that makes an Oracle jointure and create a dataset with the loop value in the name.(So if the loop runs 5 times i have 5 datasets). A the end of the sequencer, i have to merge all datasets into one. Here is my problem\question : Can i make a pu...

Hello, We had some problems too with OCI and lot of rows. We decide to read table using "Read Method=Table" and "Partition Table="your_table. Also, you can test in the Additional Connection adding the ArraySize=#PAR_ORA_ARRAY_SIZE# where #PAR_ORA_ARRAY_SIZE# equals to a value tha...

Hello,
ORA-01418 gives http://www.techonthenet.com/oracle/errors/ora01418.php in the net.
Are you sure that your index exists ??
If yes i think it's an access problem.