Information about activities in DataStage

[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.

[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?

[kduke]

Do a search for DS_AUDIT. There are several examples out there already.

[egury]

Thanks to both.

egury

[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.

[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.

[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.

[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.

[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!

[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.

[whardeman]

Topic moved to Server forum