Assuming that a site’s standard is that pgm name = plan name, what is the easiest way to find out which
Query the catalogue tables SYSPLANDEP and SYSPACKDEP.
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
What is i-mode 12.11.08
A standard used by Japanese wireless devices to access cHTML (compact HTML) Web sites and display animated GIFs and other multimedia content....Explain complete process followed for the development of project? 05.11.08
first we must have to pre plan like analyse the cost, resources and time involved then if it is profitable we must have to take up. Then we must have to p...What happens to the PLAN if index used by it is dropped ? 16.03.08
Plan is marked as invalid. The next time the plan is accessed, it is rebound....What else is there in the PLAN apart from the access path ? 16.03.08
PLAN has the executable code for the SQL statements in the host program...Where are plans stored ? 10.03.08
Each plan is defined uniquely in the SYSIBM.SYSPLANS table to correspond to the transaction (s) that are to execute that plan....What will the FREE command do to a plan ? 09.03.08
It will drop(delete) that existing plan....Explain what a plan is? 07.03.08
Plan is a DB2 object (produced during the bind process) that associates one or more database request modules with a plan name....What is i-mode? 19.03.07
A standard used by Japanese wireless devices to access cHTML (compact HTML) Web sites and display animated GIFs and other multimedia content....How would you go about generating an EXPLAIN plan? 06.08.06
Create a plan table with utlxplan.sql. Use the explain plan set statement_id = ‘tst1′ into plan_table for a SQL statement. Look at the explain plan with utl...What is the easiest sorting method to use? 22.03.06
The answer is the standard library function qsort(). It’s the easiest sort by far for several reasons: It is already written. It is already debugged. It...