How does one remove entries from the SCT02 table?



How does one remove entries from the SCT02 table?..

Answer / s

When a plan is dropped it removes the entries from SCT02
table.

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More DB2 Interview Questions

What is deadlock in db2?

0 Answers  


How can you display the current date & current time ?

1 Answers   Cap Gemini,


Do we need cursor for Count(*)?

4 Answers   iGate,


What is dbrm? What it contains?

0 Answers  


What is a db2 table?

0 Answers  






What is a db2 schema?

0 Answers  


What is load replace in db2?

0 Answers  


What is a composite index and how does it differ from a multiple index?

1 Answers  


How does db2 sample database connect?

0 Answers  


How to resolve -502 sql code in DB2?

2 Answers   Cap Gemini,


What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?

1 Answers   CTS,


I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

0 Answers   ITC Infotech, Syntel,


Categories