in my table i will update only 100 record among 1000
records i need to display recently updated record'.....can u
tell me where those records are stored how can i display
those records...?if there is any sql query pls let me know....?
Answer Posted / adarsha
Use the DB2 COPY Utility with Incremental Image copy.. which
give you the latest update done to a prticular table/table
space from last update .. below is the utility step
COPY TABLESPACE DSN8D51A.DSN8S51E
FULL NO
SHRLEVEL CHANGE
Use jcl for that
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How do you select a row using indexes in db2?
What language is db2 written in?
What is db2 stogroup?
What is dclgen (declaration generator)?
How to connect to db2 database from windows command line?
List out the buffer pools in db2
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What does db2 plan contain?
What is load replace in db2?
How do you concatenate the firstname and lastname from emp table to give a complete name?
Is the primary key a clustered index?
How and when does the db2 enforces the unique key?
can all users have the privilage to use the sql statement select * (dml)?
What is a buffer in memory?
What is performance tuning db2?