Hello ,
how to make a log file for a session , like log.aad4100 ?
I want to trace all the thinks make with session tisfc0206m000 .
Thanks in advance ;
Didier

hi,

I think you would like to trace the Database actions (Insert, Update and Delete) on the associated table of this session.

If so, enable the audit for this particular table (tisfc001)

Regards

I have been looking at the session, but since it is a process session, you might need a lot of audited tables and generate a lot of loggings that you will never look into...

It is not possible to just switch a parameter on the session so it will start logging. So alas... auditing will be the only option, but ise with precaution.

I don't know how to enable audit for a table ; can you explain me how do i do ?
Thanks

Hi,
If you do not want to go into much details of the records inserted, deleted or modified, you could run the session when Baan client is run in debug mode as under:

bw.exe -dbgbdbact -- -keeplog -logfile mylog

mylog file would contain the database actions which happened when the session was run.

Hope this helps.
Warm Regards
Manu

Should be:
bw.exe -- -dbgbdbact -keeplog -logfile mylog

My question whas :I don't know how to enable audit for a table ; can you explain me how do i do ?
Thanks

WIthin the tools/rdbms admin you have to specify that the table should be audited. The setup is slightly different for IV/ERP. Can you tell us which version so that we can give you the right session names?

Han

Hi,

Please find the audit setup information

Perform the following steps as user bsp:

1: Create a Database Definition for Audit.
Session: ttaad4110m000 Maintain Database Definitions.
Create a new definition called AUDIT, with audit trial on Yes.
Give CTRL-D to Convert to Runtime.

2: Assign the tables to the Audit Database.
There are two ways to do this:
-Session: ttaad4111m000 Assign Tables to Databases.
Insert a record for all the parameter files:
+------------------------------------------------------------------------------+
| Assign Tables to Databases |
|------------------------------------------------------------------------------|
| |
| Table Selection Table/ All Comp Company Database |
| Module |
| |
| Specified table tppbs000 Yes AUDIT Bisam Database |
| |
| Choice: .. |
+------------------------------------------------------------------------------+
Note:
from Baan IV you can use CTRL-Z to assign the default audit files to an audit
database definiton.

After this is done, use CTRL-D to Convert to Runtime.

-Run the script $BSE/bin/make_audit6.1.
This script will create the necessary records for you.
After this, run the session mentioned above
and use CTRL-D to Convert to Runtime.

3: Create Audit File directory.
Session: ttaad4116m000 Maintain Audit File Directories.
Insert a record such as:
+------------------------------------------------------------------------------+
| Maintain Audit File Directories |
|------------------------------------------------------------------------------|
| |
| Table Selection Table All Company Path Name |
| Comp |
| |
| All (other) tabl Yes /usr3/audit/# |
| |
| |
| Choice: .. |
+------------------------------------------------------------------------------+

The directory /usr3 can be a different directory.
Do a Conversion to Runtime using CTRL-D.

4: Exit the application and then start it again.
Try to run a session that uses an audit file and then change a record.
Check whether the change has been made, by starting the session again.
Under the audit directory you should see a directory for the company,
the module and the files for the table which you have
just entered into the audit.


Once you are done with the setup, you have to login as root and assign audit security to users (ttaad4162m000) to enable the user to print the audit information


Regards