DSXchange

Hi We are actually having a large number of Table Definitions in our Datastage repository.Most of them we are not at all using and occupying resources . It is taking more time to do manual cleanup from the Manager GUI. Is there any command that we can issue from the adminisrator and cleanup the unus...

Hi All Is there any way I can figure out like , what are all the routines that are referenced in a particular job using DS_ROUTINES.I got all the routines that are available in a project , but how can i tie this to get the job names too that are using those routines . I would really appreciate all y...

Thank you for all your time . I want to see what are the index columns that are defined on a particular hash file .

Thanks Ray , It is working .

Hi All Is there any way to find out what are the index columns that are used to define the indexes on the hash files . We actually recently upgraded from Datastage 7.5 to 7.5.3 version and as part of which some of the hash files got corrupted . So we have no clue like , what are the columns that are...

True .And I had also the same type of requirement and got it like :

May be helpful for you :

dsjob -report ProjNm JobNm 2>/dev/null)|grep 'Job elapsed time' |cut -d '=' -f2

The thing is we have a set of 4000 jobs under different categories .So we want to kind of create Automated script that would scan through the job logs of each job and fetch the Current days report with List of jobs that ran on that day.

Hi I have used the universe query SELECT DS_JOBS.NAME, DS_JOBS.CATEGORY, EVAL DS_JOBOBJECTS.'@RECORD<6>' FROM DS_JOBOBJECTS, DS_JOBS WHERE DS_JOBOBJECTS.OLETYPE IN ('CHashed%') AND DS_JOBOBJECTS.OBJIDNO = DS_JOBS.JOBNO ; To get the list of Hashed Files in my set of Jobs. Hope this might be helpful f...

Hi

We want to generate a report with the list of jobs that ran for that day . Is there a way How we can do that . If so , can anybody help us on this .


I would appreciate all your help on this .

Thanks a Bunch .It did worked with that Option .

Thank you for all your help.

Thank You For all your responses. AS in between the runs I am not deleting the hash file , but just clearing and overwriting , I can use the Option of RESIZE once and use it .

Thanks again for all your help.

Hi I have a quick question in increasing the limit of the hash file to 64 bit . I created a hash file with an option of 32 bit first and later i did use the command REZISE command to increase that to 64 bit limit , after creation of hash file. do i need to rerun the RESIZE command again whenever I r...

Hi I am having a hash file of size 3 GB and my job performance is really low. So from the FORUM , I have read like increasing the limit of hash file and creating it as 64 bit file may improve the performance . So from admin , I have tried using the command SETFILE hashedfilepath hashedfilename OVERW...

Hi We are actually planning to migrate our database from Oracle to Teradata Version 13 B because of the Large Volume of data we deal with. We are currently using datastage 7.5 . Will there be any kind of issues that need to be observed and to be careful for this migration. We are just wondering rega...

HI All

I have questions related to the datasets .

Is there anyway we can find out the old datasets on the unix server .

How can we find the last accessed time of the datasets ?


Can somebody help me on this . I would appreciate all your time and help on this .

Hi All I have a fundamental question while using the Oracle stage in the Parallel jobs . We have so many jobs using the Oracle stage and basically we use this stage to extract the data from our database . We have observed like this stage runs sequentially in our jobs . Is there any option available ...