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 |
what is SPUFI ?
What is runstats utility in db2?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?
My SQL is not performing well. Describe how will you fine tune it?
Explain about dbrm.
Can SQL statements/queries be included in a copybook?
what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)
Can you search give an array in the WHERE clause of a db2 query?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
On the create tablespace, what does the CLOSE parameter do?
What is the syntax for FETCH in DB2 ?