Mainframe Tips, Tricks And Tutorials
Mainframe tips
Tuesday, December 6, 2011
DB2 : Getting all the plans for a table
We can get all the plan names associated to a table with this Query.
SELECT DNAME FROM SYSIBM.SYSPLANDEP
WHERE BNAME = '< Your Table Name >' ;
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.