Page 1 of 1
Information about activities in DataStage
Posted: Tue Apr 12, 2005 8:29 am
by egury
Hello.
I would like to collect some information about activities in DataStage.
1) Time of beginning and ending of session.
2) Identification of the user who performs actualizations.
3) Identity or location of the terminal.
4) Record of successful and unsuccessful access to the system and to the data.
5) System errors.
6) Log of every task of user and resource administration inside the application.
Thank you very match.
Posted: Tue Apr 12, 2005 8:56 am
by ArndW
egury,
there is a hash file in each project called DS_AUDIT. This file contains a lot of the information that you are looking for, but not all.
You can read this file from a DataStage job and also import the metadata, but here is a list of the columns. The KEY (column 0) is the unique KEY:
Code: Select all
KEY D 0 Class\ID 40L S
DTC D 1 Created on 20L S
CREATOR D 2 Created by 20T S
PREVDTD D 3 Last deleted on 20L S
PREVDELETOR D 4 Last deleted by 20L S
DTM D 5 Modified on 20L M MODS
MODIFIER D 6 Modified by 20T M MODS
REASON D 7 Reason for modi 38T M MODS
fication
Does this help?
Posted: Tue Apr 12, 2005 9:36 am
by kduke
Do a search for DS_AUDIT. There are several examples out there already.
Posted: Tue Apr 12, 2005 1:46 pm
by egury
Thanks to both.
egury
Posted: Tue Apr 12, 2005 2:00 pm
by egury
I have a question:
How do I import the metadata from DS_AUDIT using the Manager?
I tried using Import -> Table Definitions -> UniVerse Table Definitions..., but I couldn't do it.
Thanks in advance.
egury.
Posted: Tue Apr 12, 2005 2:57 pm
by mhester
The DataStage repository files are not visible via the manager for import, therefore you would not be able to import the dictionary of the file.
Posted: Tue Apr 12, 2005 3:07 pm
by ray.wurlod
Did you notice that there's been no response from Editor, even though you posted on the Editor's Corner forum? Editor just doesn't have the technical knowledge you have ascribed to him!
The reason Arnd posted the column definitions for DS_AUDIT is that they can't be imported; they, like all Repository tables, are explicitly blocked from the Import process. Create a table definition manually; use VarChar as the data type for all columns (precision as per Arnd's post), mark the table definition as able to handle multi-valued fields, and ensure that you record DTM, MODIFIER and REASON as multivalued and associated by the name MODS.
Alternately, execute the following command (in Administrator client)
Code: Select all
COPY FROM VOC 'DS_AUDIT','MY_AUDIT'
to create a synonym called MY_AUDIT and import the table definition for MY_AUDIT in Manager.
Posted: Wed Apr 13, 2005 6:25 am
by egury
I'm sorry. I posted this to Editor's corner by error (this is my first post !!!)
How can I move to server forum?
Regards.
egury.
Posted: Wed Apr 13, 2005 7:06 am
by chulett
You can't move this thread - Ray has asked The Powers That Be to do that for us. For now, just take this conversation over to the proper forum if you have any other questions!
Posted: Wed Apr 13, 2005 9:14 am
by Editor
Okay, now the scoop, as you might have seen in my recent posts, their is a change of the guard. The reason this post hasn't moved into the server section is that Walter is getting up to speed with the site duties. I will ask him to move this directly.
Ray is right, don't anyone think that I can support even the lightest of technical questions.
But we have some experts that can make the 'grade'. :D
Dennis,
Editor.
Posted: Wed Apr 13, 2005 9:37 am
by whardeman
Topic moved to Server forum