last import information of Datastage job
Moderators: chulett, rschirm, roy
last import information of Datastage job
Is there any way to check last import information of Datastage job? Details should include- User name, Import Timestamp and Job names.
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
Did I misunderstand something?
john3
john3
----------------------------------------------------
InfoSphere 8.5.0.2; DataStage 8.5.0.0; OS-RHEL 6.6; DB-Oracle Enterprise Edition 11g (11.2.0.4)
----------------------------------------------------
InfoSphere 8.5.0.2; DataStage 8.5.0.0; OS-RHEL 6.6; DB-Oracle Enterprise Edition 11g (11.2.0.4)
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.
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.
Choose a job you love, and you will never have to work a day in your life. - Confucius
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?
Can anyone confirm / deny?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Import from isx using istool command.chulett wrote: Pardon my aging brain but what other import mechanism is there?
Whether or not this updates the date/time created in XMETA remains to be tested, but not by me at the current time.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.