« Technical Interview & Viva Questions : KyaPoocha.com home page
« Where besides the DB2 catalog is database object information stored by DB2 ?
Which DB2 command is used to retrieve environmental information ? »



Can you access the DB2 Directory table using SQL? ?


No. These tables are exclusively accessed by internal DB2 processes.



Explore posts in the same categories: Database Interview Questions


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

Related Questions :

  • Where is the access path logic created by the DB2 Optimizer stored ?
    • The access path logic is stored as skeleton cursor tables in the SCT02 Directory table....
  • Brief about the directory representation in UNIX
    • A Unix directory is a file containing a correspondence between filenames and inodes. A directory is a special file that...
  • Explain the directory structure of a web application.
    • The directory structure of a web application consists of two parts. A private directory called WEB-INF A public resource directory which contains...
  • Which catalog table stores referential constraints ?
    • The SYSIBM.SYSRELS table. DB2 Directory...
  • What are Hashed Tables?
    • Hashed tables - This is the most appropriate type for any table where the main operation is key access. You...
  • Discuss the mount and unmount system calls
    • The privileged mount system call is used to attach a file system to a directory of another file system; the...
  • What file will give you Oracle instance status information?
    • The alert.ora log. It is located in the directory specified by the background_dump_dest parameter in the v$parameter table....
  • What is LDAP? Where all can it be used ?
    • LDAP, Lightweight Directory Access Protocol, is an Internet protocol that email and other programs use to look up information from...
  • What is auditing ?
    • Recording SQL statements that access a table.  Specified at table creation time or through alter....
  • 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....

    Comments are closed.