in a table consist of 1000 records among that i was updated
145 record how could i know that ..list of recently updated
record's and where could i see those updated
record's....pls help me out....
Answer Posted / girish kumar
i don't know exactly but what i feel, DB2 active logs
records events of all data changes in DB2. In case of
failure, it uses this data to recover the lost information.
CORRECT ME IF IAM MISTAKE.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What is performance tuning db2?
What are the full forms of spufi and dclgen and why are they used?
What is clone table?
When the like statement is used?
What is dbrm library?
How do I add a column in db2?
What is blu acceleration in db2?
List out the data types available.
What is the role of schema in the db2 database?
What is a collection in db2?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What is cascading rollback?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
Mention some fields that are a part of sqlca.