What is a buffer pool ?
A buffer pool is main storage that is reserved to satisfy the buffering requirements for one or more tablespaces or indexes, and is made up of either 4K or 32K pages. Read more »
Archive for March, 2008
What is JMS?
JMS is an acronym used for Java Messaging Service. It is Java’s answer to creating software using asynchronous messaging. It is one of the official specifications... Read more »
What is the difference between ic and queue ?
A ic is typically used for one to many messaging i.e. it supports publish subscribe model of messaging. While queue is used for one-to-one messaging i.e. it supports... Read more »
What is the function of buffer manager?
The buffer manager is the DB2 component responsible for physically transferring data between an external medium and (virtual) storage (performs the actual I/O operations).... Read more »
What is a base table?
A base table is a real table - a table that physically exists in that there are physical stored records. Read more »
What is meant by AUTO COMMIT?
AUTO COMMIT is a SPUFI option that commits the effects of SQL statements automatically if they are successfully executed. Read more »
What is meant by the attachment facility?
The attachment facility is an interface between DB2 and TSO, IMS/VS, CICS, or batch address spaces. It allows application programs to access DB2. Read more »
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. Read more »
What is a DB2 bind?
Bind is a process that builds “access paths” to DB2 tables. A bind uses the Database Request Modules(s) (DBRM(s)) from the DB2 pre-compile step as input and... Read more »
Explain what a plan is?
Plan is a DB2 object (produced during the bind process) that associates one or more database request modules with a plan name. Read more »
What is an alias?
It is an alternate name that can be used in SQL statements to refer to a table or view in the same or remote DB2 subsystem. Read more »
What is an access path?
The path that is used to get to data specified in SQL statements. Read more »
What is IBM Database 2?
DB2 is a subsystem of the MVS operating system. It is a Database Management System (DBMS) for that operating system. Read more »