Evaluate

Tracking row changes in DB2 tables

ISeries database expert Kent Milligan discusses how to track changes made to DB2 tables.

IBM

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please login.

You have exceeded the maximum character limit.

Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

Is there a way to determine when a row in a table on iSeries has been added or changed? Currently there is no user field tracking this. I'm looking for some hidden DB2 function, like the RRN.

Activating journaling for this table would allow easy tracking of row changes. If an adding a new column is an option, you can add a column with the ROWID data type. DB2 will update this value each time a row is added or updated. In V6R1, DB2 for i5/OS supports the creation of a hidden timestamp column just for this purpose.

This was last published in April 2008

Dig Deeper on DB2 UDB (universal databases)

All
News
Get Started
Evaluate
Problem Solve

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our AS/400 experts

View all AS/400 questions and answers

SQL server error message -321

Choose which column names are returned via ODBC when working with DB2 files

Developing tables in a parent-child relationship in DB2

When is the YES option for 'reuse deleted files' function the best choice?

DB2 Viper to boost XML capabilities

IBM steps up iSeries, pSeries overlap

IBM pumps up on-demand line with new iSeries model

V5R1 DB2 enhancements ease B2B dealings

WebSphere Development Studio Client (WDSC)

AIX (Advanced Interactive eXecutive)

Choose which column names are returned via ODBC when working with DB2 files

Developing tables in a parent-child relationship in DB2

When is the YES option for 'reuse deleted files' function the best choice?

Monitoring members 'stuck' within a physical file on an EDI system

SQL server error message -321

Choose which column names are returned via ODBC when working with DB2 files

Developing tables in a parent-child relationship in DB2

When is the YES option for 'reuse deleted files' function the best choice?

Please create a username to comment.

How to cultivate the ideal IaaS agreement

China's supercomputing systems soar from 21 to 219 in a decade

Data center cooling systems advance, incorporate natural sources

Dig Deeper on DB2 UDB (universal databases)

Related Q&A from Kent Milligan

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.