how do you resolve -818 error in db2. where we have to see
time stamp token. i said by seeing in load module and
plan .is it correct or not. give clear explination for how
to see time stamp token
Answers were Sorted based on User's Feedback
Answer / lu
Recompile your DB2 program, check your plan name if it
doesn't work..go to see your DBA....this a Plan problem....
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / ganesh
Compile and Bind must have the same Timestamp. Rebind or
Recompile and then Rebind.
| Is This Answer Correct ? | 0 Yes | 0 No |
How to design maps
Suppose we are doing transaction in a table and abend happened in between. Suppose i have completed the transaction upto X rows and I want to start the transaction again where the abend happened. I don't want to do the transaction from the first record. Then what i have to do.
What is read-only cursor?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is db2 bind process?
When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing?
What is the role of the data page in the db2 database?
What does a deadlock mean in DB2?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
how will you retrieve first record in table
how can we retrieve the 100 records of the file ?
When can an insert of a new primary key value threaten referential integrity?