12-18-2017
DB2 - Tracking Table history
HI team
Is it possible to track DB2 table on the data insertion,deletion and updates on daily basis . Do we have any inbuilt feature to handle audit analysis ?
Any help appreciated
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi All,
I want to connect two tables in DB2 using shell script and then compare the contents of two tables field by field. Could any one please help me in connecting database tables using Unix and retriving data from the same.
Thanks,
Durwas (0 Replies)
Discussion started by: dtidke
0 Replies
2. Shell Programming and Scripting
Hi
I need help on this. Its very urgent for me.. please try to help me out..
I have data in tables in DB2 database. I would like to export the data from DB2 tables into a text file, which has to be space delimited. so that I can carry out awk, grep operations on that file. I tried to export... (2 Replies)
Discussion started by: ss3944
2 Replies
3. Shell Programming and Scripting
Can anyone please help me with an unix shell script to connect a DB2 database. My requirement is just to display the no of records present in a table of a DB2 database through Unix Shell script. Thx - Ram (1 Reply)
Discussion started by: onlyraja
1 Replies
4. Shell Programming and Scripting
Hi
I am having three oracle databases running in three different machine. their ip address is different. from one of the DB am able to access both the databases.(means am able to select values and insert values in to tables individually.)
I need to fetch some data from DB1 table(say DB1 ip is... (2 Replies)
Discussion started by: aemunathan
2 Replies
5. Shell Programming and Scripting
Hi ,
I Have following requirement:
DB2 Sql query to pass from a parameter file
for example, I would create a parameter file with (SELECT column 1, column 2 FROM Table name) then job would read it and create a file with the contents named table.txt
How to write/modify below ksh script to... (10 Replies)
Discussion started by: developer.dwh9
10 Replies
6. Red Hat
Dear All,
I want to keep all the session history in one file,please help me out to configure so.
Here is the test scenario-
Suppose i have three client A,B and C tries to log in to one Server XA there session specific command and Clint IPADDRESS should get logged in one file...like ... (0 Replies)
Discussion started by: monojcool
0 Replies
7. Shell Programming and Scripting
Hi folks,
I have the basic query that there are 3 unix boxes having their individual access now in my team there are 4 members who are using the same credentials to access those 3 boxes through putty ssh from their windows desktop , now if i want to check which 4 members have executed the... (1 Reply)
Discussion started by: punpun66
1 Replies
8. Programming
Dear team
I am using DB2 and wish to capture the ETL status on daily basis so that i can run the query and share the details in xls format to respective mail ids .
Currently i am using below query but this displays table name and counts for latest run.
select name ,CARD from... (0 Replies)
Discussion started by: Perlbaby
0 Replies
9. Shell Programming and Scripting
Team
I have files in different directories . How can i take the count of latest file and insert into Db2 table .
I am using
awk 'END{print NR+1-ARGC}' (File name)
to get the counts.
How can i take
1.The count of latest file
2.Insert into Db2 table( File Name and Counts) .
cd... (4 Replies)
Discussion started by: Perlbaby
4 Replies
10. Programming
Dear Team
I am using DB2 v10 z/os database . Need expert guidance to figure out best way to track table activities ( Ex Delete, Insert,Update )
Scenario
We have a table which is critical and many developer/testing team access on daily basis . We had instance where some deleted entire table .... (1 Reply)
Discussion started by: Perlbaby
1 Replies
LEARN ABOUT DEBIAN
globus-gram-audit
GLOBUS-GRAM-AUDIT(8) GRAM5 Commands GLOBUS-GRAM-AUDIT(8)
NAME
globus-gram-audit - Load GRAM4 and GRAM5 audit records into a database
SYNOPSIS
globus-gram-audit [--conf CONFIG_FILE] [[--create] | [--update=OLD-VERSION]] [--check] [--delete] [--audit-directory AUDITDIR] [--quiet]
DESCRIPTION
The globus-gram-audit program loads audit records to an SQL-based database. It reads $GLOBUS_LOCATION/etc/globus-job-manager.conf by
default to determine the audit directory and then uploads all files in that directory that contain valid audit records to the database
configured by the globus_gram_job_manager_auditing_setup_scripts package. If the upload completes successfully, the audit files will be
removed.
The full set of command-line options to globus-gram-audit consist of:
--conf CONFIG_FILE
Use CONFIG_FILE instead of the default from the
configuration file for audit database
configuration.
--check
Check whether the insertion of a record was
successful by querying the database after
inserting the records. This is used in tests.
--delete Delete audit records from the database right
after inserting them. This is used in tests to
avoid filling the databse with test records.
--audit-directory DIR Look for audit records in DIR, instead of looking
in the directory specified in the job manager
configuration. This is used in tests to control
which records are loaded to the database and then
deleted.
--query SQL Perform the given SQL query on the audit
database. This uses the database information from
the configuration file to determine how to
contact the database.
--quiet Reduce the amount of output for common
operations.
FILES
The globus-gram-audit uses the following files (paths relative to $GLOBUS_LOCATION.
etc/globus-gram-job-manager.conf
GRAM5 job manager configuration. It includes the
default path to the audit directory
etc/globus-gram-audit.conf
Audit configuration. It includes the information
needed to contact the audit database.
University of Chicago 08/30/2011 GLOBUS-GRAM-AUDIT(8)