I/O operations are usually most critical for DB2 performance (or any other database for that matter).
Latest Answer : I'm sorry, but the answer is a firm "It depends."Depending on various factors, most MVS boxes run short on either CPU or I/O. These factors include, workload, time of day, day of the week, etc. A capacity planner could give you a better list, but these ...
The database descriptor, DBD is the DB2 component that limits access to the database whenever objects are created, altered or dropped.
SPUFI stands for SQL processing using file input. It is the DB2 interactive menu-driven tool used by developers to create database objects.
Latest Answer : SPUFI : SQL Processing Using File Input, it supports the on-line execution of SQL statements from a TSO terminal ...
This is a key concept for any relational database. Isolation level is the manner in which locks are applied and released during a transaction. For DB@ a 'repeatable read' holds all locks untile
Latest Answer : Isolation level means the extent to which the transaction isolates the data is accessed ...
How the durability(one amongst the ACID model) of database is achieved while loading table with 'Log No' option?
a.Database definitionb.Database descriptorc.Data buffer definitiond.Database dependencee.Direct buffer definitionDatabase descriptor
Latest Answer : DBD stands for database descriptor ...
a.Database Restrict Modelb.Database Resurrect Modelc.Database Request Moduled.Database Reference Modulee.Database Restrict ModuleDatabase Request Module
Latest Answer : Database Request module ...
DB2 is aa.Database/Data Communication Systemb.Databasec.Relational Database Management Systemd.Programming Languagee.Operating systemRelational Database Management System
Latest Answer : c)Relational Database Management System ...
Select the correct statement 1 Storage groups can be altered2 Database can be altered3 Tablespace can be altered4 All of the Choices
All of the Choices
Which of the following can duplicate the structure and related objects of a database table? A. Copy table B. Alter table C. Export table D. Generate DDL