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

How does one remove entries from the SCT02 table?

Question Posted / s

Answer Posted / s

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

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is reorg?

628

How to view db2 table structure?

603

What is a system catalog table in db2?

596

Describe major components of db2?

649

What is the role of schema in the db2 database?

665

What does db2 blu stand for?

680

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2293

What is runstats utility in db2?

584

What does db2 stand for?

608

How to retrieve rows from a db2 table in embedded sql?

742

What do you mean by cursor?

596

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3130

How to fetch the last row from the table in SQL (db2)?

1045

Explain the contention situations caused by locks?

601

How can you count the number of rows from a table tab?

647