last import information of Datastage job

Apy · Post by **Apy** » Fri Oct 14, 2016 6:38 am

Is there any way to check last import information of Datastage job? Details should include- User name, Import Timestamp and Job names.

IBM Analytics Champion 2009 - 2020 · Post by **asorrell** » Fri Oct 14, 2016 9:22 am

Information Server Manager will show it as "Creation" date. However, no way to tell if the "creation" was an import, or just a new job creation.

Apy · Post by **Apy** » Sun Oct 16, 2016 11:29 pm

Does it mean that there is no way to keep track of version of your Datastage job?

johnboy3 · Post by **johnboy3** » Mon Oct 17, 2016 8:19 am

Would you like to just check the Job's Log in DataStage Director? Depending on how you have logging configured, that may show the entire history of the running of that Job.

Did I misunderstand something?
john3

chulett · Post by **chulett** » Mon Oct 17, 2016 9:02 am

This isn't about a history of running a job but rather a history of changes made to / versions of a job.

Apy · Post by **Apy** » Mon Oct 17, 2016 9:07 am

Yes, you misunderstood the question.

My question is " When I import any datastage job through Designer or Command line, Is there any way to check last import/History of import information like User, timestamp etc."
Hope this clarifies my question.

qt_ky · Post by **qt_ky** » Mon Oct 17, 2016 12:23 pm

Look in Designer to see who created it or modified it last, and when. As mentioned, you cannot tell if it was imported, per se. You can view details by clicking the little bar with arrows on the repository, or, you can go under the View menu and select the Detailed Repository View.

The first time in, you will have to right click in the header area and choose which columns you want to view. You can view details like Last modified date, Last modified by, Created date, and Created by. The dates are actually timestamps. However, it does not show any history beyond this.

chulett · Post by **chulett** » Mon Oct 17, 2016 1:44 pm

Unless things have changed, from what I recall when you import a job it completely replaces the original version of the job - i.e. it deletes the original and then imports the new version. Meaning I believe that the "creation date" would be the date of the last import... assuming it was imported into the environment.

Can anyone confirm / deny?

Apy · Post by **Apy** » Mon Oct 17, 2016 10:43 pm

I have cross checked this. Creation date is the date when first time Datastage job is created and not the last import date.

chulett · Post by **chulett** » Tue Oct 18, 2016 6:28 am

Thanks for that.

ray.wurlod · Post by **ray.wurlod** » Tue Oct 18, 2016 8:57 pm

This would depend surely on the import method. For example, when importing from DSX file using DataStage Designer, it's usually the case that the old job is deleted and a new job number allocated. This would surely indicate that creation date = import date in that case.

chulett · Post by **chulett** » Wed Oct 19, 2016 7:01 am

That was what I was thinking of and referring to, job number and all. Pardon my aging brain but what other import mechanism is there? I mean what other one would not do the delete/insert?

johnboy3 · Post by **johnboy3** » Wed Oct 19, 2016 8:02 am

Would Job Lineage provide this?
john3

ray.wurlod · Post by **ray.wurlod** » Thu Oct 20, 2016 12:43 pm

chulett wrote: Pardon my aging brain but what other import mechanism is there?

Import from isx using istool command.

Whether or not this updates the date/time created in XMETA remains to be tested, but not by me at the current time.