Hello Friends,
I have two doubts related to interactive SQL in iseries.
1) Is there any way to default the option 4=Save session in source file while exiting the SQL?
We want to track the SQL queries executed by any USER(s).
This is required to keep track on the SQL updates/ inserts.
2) I Google'd and found out one command DMPSYSOBJ which keeps track of the SQL queries for Users but the doubt here is how many days data will be there to view?
Kindly, help me out on this.
Thanks! in advance.
I have two doubts related to interactive SQL in iseries.
1) Is there any way to default the option 4=Save session in source file while exiting the SQL?
We want to track the SQL queries executed by any USER(s).
This is required to keep track on the SQL updates/ inserts.
2) I Google'd and found out one command DMPSYSOBJ which keeps track of the SQL queries for Users but the doubt here is how many days data will be there to view?
Kindly, help me out on this.
Thanks! in advance.
Comment