-
5 More Frequently Asked DB2 SQL Queries
Frequently asked SQL queries you need to know. Useful for SQL developer interviews. Read More ⇢
-
Mainframe ISPF Commands(2 Of 5)
In my series of posts, I am giving best ISPF tips to improve productivity. Across the companies following these tips.Mainframe+cobol+db2+jobs+USA+India+UK+ . Read my part-1 tips, if you missed. 11) How do I find out which base cluster does an alternate index file belong to? A. Display information in file aid for the… Read More ⇢
-
Top IMS DC Interview Questions for Experienced
The best interview questions asked on IMS DC in all big companies in recruiting of IMS DC developers or programmers. Explained the best way and flow about IMS DC. Read more. Read More ⇢
-
OMIT condition in Sort top example to read now
OMT condition in sort explained with best examples to use in your project. Read More ⇢
-
Mainframe ISPF Commands(1 Of 5)
Advanced ISPF commands. Many mainframe developers do not use these. So I categorized these for Senior Mainframe developers. 1). How do I create multiple instances of ISPF sessions? A. Use PDF command from the TSO panel, which will initiate a new ISPF session, Type =x to comeback to previous ISPF session. You… Read More ⇢
-
20 Top DB2 Frequently Asked Questions
1) How would you find out the total number of rows in a table? A. Use SELECT COUNT(*) … Allstate uses DB2v6. and QMF V3.3. 2) How do you eliminate duplicate values in SELECT? A. Use SELECT DISTINCT … 3) How do you select a row using indexes? A. Specify the indexed columns in the… Read More ⇢
-
Modernization of ZOS: 7 Top Steps
The following 7 strategies improve batch performance, that in turn reduce cycle time. Ensuring the system is properly configured mainframe+db2+jobs Ensuring a properly configured system means making sure there are generally adequate system resources, so work flow is not inhibited, such as: Adequate CPU to avoid CPU queuing Memory so… Read More ⇢
-
3 DB2 Optimizer Interview Questions
I have given DB2 Optimizer interview questions in this post, which covers the functionality of it and relation to statistics. Read More ⇢
-
IMS DB Administrator Top Interview Questions
1) What is database management system(DBMS)? A ). Allow access to the data for multiple users from a single instance of the data. Control concurrent access to the data to maintain integrity for all updates. Minimize hardware device and operating system access method dependencies. Reduce data redundancy by maintaining only one instance of the… Read More ⇢
Advertisements
Srinimf 