- Blog
- Blog
- Homepage
- Homepage
-
OMIT condition in Sort top example to read now
OMT condition in sort explained with best examples to use in your project.
-
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 can also type ‘start’ to…
-
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 WHERE clause. 4) Can you use…
-
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 the system does not page…
-
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.
-
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 data. Interact with the operating…
-
IMS DB: Application Vs System service Calls
Application Calls get unique (GU) The GU (get unique) call retrieves a specific segment or path of segments from a database. At the same time, the GU call establishes a position in a database from which additional segments can be processed in a forward direction. get next (GN) The GN (get next) call retrieves the…
-
DB2 Concurrency: Top Interview Questions Unlock now
These questions are helpful to answer correctly on DB2 Concurrency and locking mechanism.
-
Tokenization in Payments Why You Need
The increased security is called Tokenization. Its real concept explained with examples.
-
Multi-tired Application Vs. Stored Procedures: Top Differences
Tired Applications The concept of tiered applications presents a solution to design architects that uses distributed resources dynamically with the ability to insert software and hardware when and where they are needed. Two-tiered client/server applications might require extensive and expensive deployment strategies for DB2 enablers and business logic. Multi-tiered (three or more tiers) client/server applications…
-
CICS Performance: Here are Ideas How to Improve
-
10 Top Uses of Mainframe DFSORT Utility
DFSORT flowchart tells you the real uses of it. Also, I have explained how it would process the input dataset.
Srinimf 