« Technical Interview & Viva Questions : KyaPoocha.com home page
« When one binds a PACKAGE ( of a plan ) what package information is stored and where it is stored ?
Can you access the DB2 Directory table using SQL? ? »



Where besides the DB2 catalog is database object information stored by DB2 ?


DB2 also stores information about DB2 objects as database descriptors (DBDs) in the DBD Directory table.



Explore posts in the same categories: Database Interview Questions


BOOKMARK THIS : del.icio.us | Digg it | Furl | reddit |

Related Questions :

  • What is system catalog or catalog relation? How is better known as?
    • A RDBMS maintains a description of all the data that it contains, information about every relation and index that it...
  • There are at least seven IDCAMS commands; name and explain each of them ?
    • ALTER modifies information for a catalog, alternate index, cluster or path. BLDINDEX builds the alternate index, of course. ...
  • What information is used as input to the bind process?
    • The database request module produced during the pre-compile. The SYSIBM.SYSSTMT table of the DB2 catalog....
  • What is a DB2 catalog ?
    • The DB2 catalog is a set of tables that contain information about all of the DB2 objects(tables, views, plans etc.)....
  • What is the advantage of using stored procedure over the SQL queries ?
    • Writing the SQL statements inside our code is usually not a good idea. In this way you expose your database...
  • What is VLDB?
    • VLDB stands for Very Large DataBase.It is an environment or storage space managed by a relational database management system (RDBMS)...
  • Difference between:-DOMAIN CONTROLLER and GLOBAL CATALOG ?
    • 1. Transmission Control Protocol: a standard protocol for transmitting the information. Remote Desktop Protocol: Used for accessing the Desktop Remotely 2. Domain:...
  • When one binds a PACKAGE ( of a plan ) what package information is stored and where it is stored ?
    • The access path information for the PACKAGE is stored as skeleton package tables in the SPT01 table....
  • Which catalog tables contain authorization information ?
    • The SYSIBM table that contain authorization information are SYSCOLAUTH, SYSDBAUTH, SYSPLANAUTH, SYSTABAUTH and SYSUSERAUTH....
  • Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database ?
    • The catalog tables to use are the SYSIBM.SYSTABLES and the SYSIBM.SYSCOLUMNS....

    Comments are closed.