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 db2 command?

965

When reorg is used?

1073

Define db2 and its databases?

1006

What is db2 and what is the use of db2 optimizer?

996

What is the difference between spufi and qmf?

1053

Which isolation level provides highest data integrity?

1044

What is null in db2?

950

What is the use of db2 optimizer?

1043

Explain dclgen.

1146

Before you give the explain statement, what are the prerogatives?

971

What is schema in db2?

963

What is ibm db2 connect?

932

Give the name of some fields form sqlca.

1024

When do you specify the isolation level?

974

How would the varchar column remarks defined?

1038