4 avg. rating (80% score) - 1 votes
Do you become a software professional and want to be a part of it? find your chances in www.wisdomjobs.com portal showering jobs for your career. Software field is always on top and to grab the multi-talent persons who are having the skills. Mainframe DB2 jobs that are suitable for software engineers who have to be a professional. Performance of DB2 database systems persons should Monitor database performance, enhancement and modification database recovery and backup tasks on a daily and weekly basis. Explore the vision of Mainframe DB2 jobs interview questions and answers page for more information you need. Log on to our site www.wisdomjobs.com for more info and notifications to get. Apply from our portal and grab the offer to lay the suitable way.
Specify the indexed columns in the WHERE clause of db2 query.
Use SELECT MAX(...) .. in db2 query
SQL Query : SELECT SUBSTR(FIRSTNAME,1,5) FROM EMP;
Bulit-in mathematical functions for use in SELECT clause.
Because SALARY is not declared to have NULLs and the employees for whom the salary is not known are also counted.
The physical database is managed by the DB2 component called Data manager. It invokes other system components to perform logging, locking etc.
STOGROUP is a named collection of DASD volumes, which is to be used by index spaces and table spaces of the database.
Predicate is an element of a search condition. It expresses or implies a search condition.
Declaration Generator is a facility that is used to form SQL statements that describes a table or view. At pre-compile time, the table or view descriptions are then used to check the validity of SQL statements.
There are four buffer pools in DB2 and they are
Clustering index is a type of index, which locates the table rows and determines how to group the rows together in the tablespace.
More than one DB2 application process can access the same data at the same time, is known as concurrency. However, problems can happen such as, lost updates access to unrepeatable reads and uncommitted data.
Data manager can be considered as a component that is capable of managing the databases that are physically present and is capable of invoking other components associated with the system for performing functionalities like logging, locking and in performing other I/O operations.
DBRM stands for Database Request Module and is a component inside DB2, which is created by the pre compiler of DB2. This is a module that consists of SQL source statements that get extracted out of the application program. DBRMs form inputs that are helpful in the binding process.
Data page can be considered as a unit that is capable of retrieving data from the database. The database from which the data can be retrieved is in the form of 4 kilobytes or 32 kilobytes. The form in which data is retrieved depends on the way the table is defined inside the database. Data page also contains information regarding the catalog or user that are part of the database.
RCT is expanded as Resource – Control Table and is defined in the DB2/CICS region. This is the component that comprises of features that are gathered through macros of DSNCRCT. RCT matches with the transaction ID that of CICS, with the authorization ID that of DB2. This should also be matched with plan ID.
Tablespace that you are using is allocated only to STOGROUP, then you can enter the command ALTER STOGROUP for adding as well as deleting volume. REORG TABLESPACE and RECOVER TABLESPACE are statements that are helpful in creating new STOGROUP that can point towards the new volume. ALTER tablespace and REORG and RECOVER are statements used for altering and recovering the tablespace allocated in the memory.
This is the table that contains information on the links that exists between the tables created through referential constraints.
Buffer manager can be considered as the component inside DB2 that helps in transferring data between virtual as well as external medium. The buffer manager reduces the quantity of physical input as well as output operations that are actually performed by making use of buffering techniques that are highly sophisticated.
Cursor stability is the property that tells the DB2 that the values of database that are read by making use of this application gets protected while the data is used.
Use DECLARE CURSOR statement either in working storage or in procedure division(before open cursor), to specify the SELECT statement. Then use OPEN, FETCH rows in a loop and finally CLOSE.
If there is an ORDER BY clause, rows are fetched, sorted and made available for the FETCH statement. Other wise simply the cursor is placed on the first row.
Use WITH HOLD option in DECLARE CURSOR statement. But, it has not effect in psuedo-conversational CICS programs.
A VARCHAR column REMARKS would be defined as follows:
49 REMARKS-LEN PIC S9(4) USAGE COMP.
49 REMARKS-TEXT PIC X(1920).
Mainframe DB2 Related Tutorials
|IBM-REXX Tutorial||IBM-CICS Tutorial|
|IBM DB2 Tutorial||COBOL Tutorial|
|MySQL Tutorial||IBM-JCL Tutorial|
|Oracle 11g Tutorial||IBM Mainframe Tutorial|
Mainframe DB2 Related Interview Questions
|IBM-REXX Interview Questions||IBM-CICS Interview Questions|
|JCL Interview Questions||IBM DB2 Interview Questions|
|COBOL Interview Questions||MySQL Interview Questions|
|IBM-JCL Interview Questions||Oracle 11g Interview Questions|
|System Administration Interview Questions||IBM-JCL&VSAM Interview Questions|
|IBM Mainframe Interview Questions|
Introduction To Software Development
Introduction To Ibm Mainframes
Tso And Ispf
Introduction To Job Control Language (jcl)
The Job Statement
The Exec Statement
The Job And Exec Statements
Procedures And Symbolic Parameters
Generation Data Groups (gdg), Compile/link-edit And Run Jcls
Additional Vsam Commands
Introduction To Rexx
Overview Of Rexx
Introduction To Cics
Exception Handling In Cics
Developing A Cics Application
Cics Programming Techniques
Basic Mapping Support (bms)
Transient Data Control
Temporary Storage Control
Interval And Task Control
Cics Application Design
Recovery And Restart
System Security And Intersystem Communication
Cics Debugging Facilities And Techniques
Cics Response And Abend Codes
Data, Information And Information Processing
Introduction To Database Management Systems
Introduction To Relational Database Management Systems
Database Architecture And Data Modeling
Overview Of Db2
Structured Query Language (sql)
Data Security And Access
Db2 Application Development
Qmf And Db2i
Db2 Performance Monitoring, Utilities And Recovery/restart
Overview Of Information Management System (ims)
Introduction To Vs Cobol Ii
Overview Of Application Development In Vs Cobol Ii
Overview Of The Cobol Program
Sorting And Merging Files
Coding Cobol Programs That Run Under Cics. Ims, Db2 And Ispf
Compiling The Program
Link-editing The Program
Executing The Program
Improving Program Performance
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.