Srinimf

Blog

srinimf.com/

Blog

srinimf.com/

Profile

srinimf.com/author/moonrobot/

Profile

srinimf.com/author/moonrobot/

Homepage

srinimf.com

Homepage

srinimf.com

  • 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.

  • PLSQL Procedures – Top Syntax Rules

    PL/SQL is a case-independent language, unless you specifically set up Oracle to be case-sensitive or explicitly define object names within the “” marks. Audio Post You can also align all long-running code blocks vertically, as follows: Data types Data Type Prefix Example Comment Boolean B lb_employee_status Prefix common variables Date D ld_hire_date   Number N gv_bonus_percentage  …

  • DFSORT: How to Use Conditional Include In OUTFIL

    JCL sample how to use OUTFIL in DFSORT.

  • JCL Sort Interview Questions

    Here are top interview questions on JCL sort. JCL Interview Questions on Sort (Slideshare) Keep Reading

  • Oracle-Shared Pool Concept

    Oracle interview question on shared pool: The shared pool is one of the most critical memory components particularly when it comes to how SQL executes. The way you write SQL doesn’t just effect the individual SQL statement itself. The combination of all SQL that executes against the database has a tremendous effect on overall performance and scalability…