Multiple choice technology mainframe

DB2 query to get the bind plans attached with the tables.

  1. A. SELECT * FROM DB2P.SYSIBM.SYSPLANDEP WHERE BCREATOR = 'DBNAME' AND BTYPE = 'T' ORDER BY BNAME, DNAME

  2. B. SELECT BNAME, BQUALIFIER, BTYPE, DCOLLID, DNAME FROM DB2P.SYSIBM.SYSPACKDEP WHERE BQUALIFIER = 'DATABASE NAME' AND BTYPE = 'T' ORDER BY BNAME, DNAME

  3. C. (A) or (B)

  4. D. Neither (A) nor (B)
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

DB2 system catalogs track plan-table dependencies. Both SYSIBM.SYSPLANDEP and SYSIBM.SYSPACKDEP contain this information depending on the DB2 version and configuration, so either query could work depending on your environment.

Keep practicing — related questions