DSXchange

Please give me the name of the guy you got this from. EtlStats is free but please don't pawn it off as your own work. My name is on most of the jobs. The original job was DSJobReport. I did not write it. It was posted on ADN. It was very unstable and did not write to tables. I think I turned it into...

:idea: I suggest you contact the 'IBM SOFTWARE GROUP' that provided the jobs to you. They would be best equipped to resolve any issues with them. Or maybe have the IBM SOFTWARE GROUP software group call me and I will tell them how to install EtlStats. There is no way they named a file jobstatus.txt...

You could have a corrupt repository. You might need the XP patch for the Designer. You need to search for DS.TOOLS for the first one. The second is an obvious search.

You should put code tags around your job listing so we can see the formatted code. This job gets the job status. It does nothing with the job log.

Why do you need this? What are you going to do with the sequential file?

You need to create your own. Maybe Ken or someone has something they can share.

I have created a job that can do this. I think Craig has one too. It took several days to get it working. Not sure I want to share. I sure don't want to answer questions about it. I think my template had 4 jobs to load a dimension table extract, hashed file xref job, load job and a sequence. It alwa...

Looks like you are trying to install EtlStats. There is a file called EtlStatsInstall.txt which should explain how to install it. You need to create some directories by creating some type 19 files. Next copy all the folders in the directory Copy2ProjectDir to the poject. Copy2ProjectDir is a directo...

It is saying it cannot create /u02/XML/etlExtractGXStudent.xml. Does directory /u02/XML exist? Do you have write permission to it?

The job is still running when the after job routine kicks off. So the status still shows running and then it fails.

Kumar, this is exactly what Ray was saying not to do. If you delete a job in Designer or Manager then DS_JOBOBJECTS also gets cleaned out and RT_CONFIGnnn, RT_LOGnnn, RT_BPnnn, RT_BPnnn.O, RT_STATUSnnn and a few other files get removed. If you do not do this properly then your repository gets orphan...

You can extract this information in a DS job and create your own metadata tables. The latest EtlStats has several jobs which do this now. The dictionary items are also included. One of the jobs pulls the table names from custom links. It also pulls the property for truncate so I could create a repor...

Post your OLETYPE for the link in question then we will see if we can extract the column names. You need to specify the exact columns you want. Most plugins use a Custom stage and the table name is buried in a property field. There is a property name field and an associated property value field. If ...

You can do a search for SETFILE or OPENPATH. SETFILE is a TCL command and OPENPATH is a BASIC command.

Jobs can have a status of running when the process is killed abruptly like a power outage. You can recompile the jobs then most of the time this will fix the problem. If the jobs are truly running then you should not be able to compile them. There are more drastic measures you can take if you need t...

A DataStage project is attached to a DOS or UNIX directory. You need write permission to compile jobs, change jobs, import jobs or almost anything you can do in either Designer or Manager except view.