By Tammie Dang , Euna Park , and Jennie Chang . Db2 12 for z/OS introduced the capability to specify resource limits for static SQL statements , and APAR PH07658 recently introduced the following resource limit facility (RLF) usability enhancements in Db2 12: A new Db2 capability that automatically refreshes the in-memory resource limit tables The ability to specify resource limit tables that are already active when issuing the START RLIMIT command A new SCOPE(GROUP) keyword in the START RLIMIT command   Resource limits for static SQL... [More]

Tags:  db2z12 rlf

By Sueli Almeida and Paul McWilliams . We recently published a sample Db2 software services template . As a service provider, you can use it to create services (DBaaS) to rapidly provision from scratch one or multiple standalone Db2 subsystems, in IBM Cloud Provisioning and Management for z/OS . The sample Db2 software services template is intended for service providers, who configure and make the Db2 system provisioning services available to the consumers of the service in their shops.   Services created from the sample template provision... [More]

Tags:  provisioning cloud dbaas

By Kalpana Shyam . Insert algorithm 2 (IAG2) was introduced in Db2 12 to increase throughput of INSERT statements and to reduce logging in specific conditions.  The purpose of this blog post is to help you understand IAG2 in the simplest terms possible and to provide you with information that will help you get the greatest benefits from using it. This blog post provides overview information to help you get started and more detailed information to help ensure your ongoing success with IAG2 in a production environment. This information will be... [More]

Tags:  performance dba db2

By Marie Sumabat and Jennie Chang .   With the activation of function level 504, Db2 12 for z/OS introduces support for the following 16 built-in functions , which can be invoked when using IBM Db2 Analytics Accelerator (Accelerator):   OLAP specification functions: CUME_DIST FIRST_VALUE LAG LAST_VALUE LEAD NTH_VALUE NTILE PERCENT_RANK RATIO_TO_REPORT Aggregate functions: CUME_DIST PERCENT_RANK Scalar functions: REGEXP_COUNT REGEXP_INSTR REGEXP_LIKE REGEXP_REPLACE REGEXP_SUBSTR These functions are passthrough-only expressions , which means that... [More]

Tags:  db2z12 fl504 idaa

By Kalpana Shyam with Eric Radzinski . Insert algorithm 2 (IAG2) was introduced in Db2 12 to provide significantly faster throughput for unclustered INSERTs. It is available only for universal table space objects that use the MEMBER CLUSTER option. If you're not already familiar with IAG2, be sure to read the About Insert Algorithm 2 section below to understand how and where it can be applied. APAR PH02052 improves IAG2 usability by allowing Db2 to re-enable IAG2 automatically whenever possible. This is a significant enhancement because... [More]

Tags:  dba programmer db2

We're proud to announce Db2 12 function level 504 ! Function level 504 (activation enabled by APAR PH07672 ) introduces the following new capabilities in Db2 12 for z/OS:   IBM z14 Huffman compression Function level 504 introduces support for compression of Db2® data with IBM® Z hardware-based entropy encoding (Huffman) compression with the IBM z14 Compression Coprocessor (CMPSC). Look for more about this new capability in a future post. The functional code was delivered in APAR PH04424 .   Prevent the creation of new deprecated objects... [More]

Tags:  administrator conintuous-delivery dba db2z12 application_developer

By Chris Crone and Paul McWilliams . Db2 12 function level 504 (activation enabled by Db2 12 APAR PH07672 ) introduces a step in the evolution of existing Db2 for z/OS infrastructure—the capability to prevent, if you want to, the creation of the following deprecated object types in your Db2 12 for z/OS environments: Synonyms Non-UTS table spaces, including "classic" segmented and "classic" partitioned Hash-organized tables and the associated hash table spaces To help our clients better understand what this means for their Db2... [More]

Tags:  db2z12 continuous-delivery fl504

Got millennials? It can be challenging to train a new generation of Db2 for z/OS users whose model of learning no longer includes days of reading long “manuals.” But they have energy, enthusiasm and lots of new ideas that you want to foster. Why not try teaching them with short videos? Check out this Db2 Utilities video, specifically aimed at orienting someone who is new to Db2 for z/OS and knows little or nothing about Db2 Utilities. We’d like your feedback! Are these kinds of videos useful? What topics do you want to see covered for the... [More]

Tags:  introduction utilities utility video

By Paul McWilliams. As we've written before in our recent series about PDF documentation , the main way that we deliver Db2 for z/OS documentation is IBM Knowledge Center . It contains the exact same content as the PDF manuals, except for minor high-level organization differences (and some newer content that is not delivered in PDF at all). Web-based documentation in IBM Knowledge Center offers significant advantages over PDF format, such as: You always find the latest content in Knowledge Center, especially compared to a PDF sitting on... [More]

Tags:  video documentation knowledgecenter

Are you a user of systems that access Db2 for z/OS on a regular basis? A designer or developer of applications that rely on Db2? A database administrator or systems programmer who installs, maintains, and secures Db2 in your company? Have you ever looked at new features in Db2 or the many Db2 tools from IBM, and thought: "These are great new features! I would like to add more use cases." "How do other people use this new feature? It would be useful to know how others optimize this feature." "I love the idea of this new... [More]

Tags:  feedback

IBM Db2 AI for z/OS V1.2 helps enhance the operational performance of Db2 for z/OS systems. It empowers the Db2 for z/OS optimizer to determine the best-performing query access paths based on workload characteristics using machine learning capabilities. Version 1.2 delivers: More Db2 generated machine learning models to help improve Db2 for z/OS performance in the following areas: Intelligent SQL concurrency Enhanced application performance through sort optimizations Exception detection from Db2 statistics with recommended actions Watson... [More]

Tags:  dbzai

We wrote in a previous post about Db2 for z/OS for Master Classes held for clients at IBM Silicon Valley Lab and IBM Hursley. Now the 2019 class schedule has been announced : June 24 - 28 at IBM Hursley near Winchester, Hampshire. September 23 - 27 at IBM Silicon Valley Lab in San Jose, California These invitation-only classes are taught by experts from the world-wide Db2 SWAT team and aimed at experienced professionals who want a deep dive into the internals of Db2 for z/OS. The subjects covered in the class include: Common issues related to... [More]

Tags:  education

By Eric Radzinski If you're headed to the IBM Think 2019 conference in San Francisco next week, don't miss an opportunity to hear from Db2 for z/OS technical leadership about our latest plans and innovations.  Details about their presentations and a link to a comprehensive list of z Analytics presentations are below.   We'll also be demonstrating the new features of Db2 AI for z/OS V1.2 at the Demo Center on Tuesday from 5:00 PM - 7:30 PM and on Friday from 8:00 AM - noon.    Empower IBM Db2 for z/OS with Machine Learning to Boost... [More]

Tags:  conference db2

By Paul McWilliams , based on John Campbell 's webcast. In Part 1 of his " Greatest Hits, War Stories, and Best Practices 2019 " webcast, IBM Distinguished Engineer John Campbell's provided some background on the subject of running out of the basic 6-byte log RBA addressing range in Db2 for z/OS. John said that this subject has become somewhat controversial because of conflicting recommendations given in various presentations, blog posts, and in face to face-conversations.  He also clearly outlined his strategy recommendations... [More]

Tags:  db2z11 best_practice jc_hits db2z12 migration