Srinimf

Blog

srinimf.com/

Blog

srinimf.com/

Profile

srinimf.com/author/moonrobot/

Profile

srinimf.com/author/moonrobot/

Homepage

srinimf.com

Homepage

srinimf.com

  • DB2 SQL Query Performance Tuning (3 of 3)

    SQL performance tuning tips for database developers. Read more.

  • DB2 INSERT’s Performance and What is Newly Added

    In DB2, performance affects on the size of the index. When you create an index, it is useful to exclude one or more values from being indexed – such as values that will never be used in a SQL query. For example NULL, blank, and 0. Improvement in Performance DB2 11 NFM can improve insert…

  • What are Array functions Read today

    Array functions in Db2 explained with how to use.

  • Mainframe ISPF Commands(3 Of 5)

    21) I am not able to delete a dataset that resides on a tape. A. Yes. You cannot delete/rename a tape dataset. Only you can uncatalog it. ISPF Editor 22) How do I see only those lines that contain a particular string? A. Type ‘X all’ then ‘F all ‘search-string’ 23) Now I want to…

  • IMS DB Interview Questions for Beginners

    IMS DB low complex interview questions for less experienced developers.

  • 5 More Frequently Asked DB2 SQL Queries

    Frequently asked SQL queries you need to know. Useful for SQL developer interviews.

  • 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 ‘.PATH’ file which will show…

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

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