Featured Groups

Achieve Better Data Quality with Data Warehouse Observability

Apr 19, 2023 from 11:00am to 12:00pm
Virtual Webcast
  • Description:

    Achieve Better Data Quality with Data Warehouse Observability

    Wed, Apr 19, 2023 11:00 AM EDT

    REGISTER NOW


    Summary

    Making sense of all your input data isn’t fun, especially when consuming inputs from 10s to 1000s of data sources daily.

    If your data teams teams are orchestrating massive amounts of data, across multiple data pipelines, it’s nearly impossible to…

  • Created by: Surekha Parekh
  • Categories: Webcasts
  • Tags: data, data quality, data warehouse, observability, databand, ibm

Db2 GSE workgroup meeting

May 25, 2023 from 9:00am to 9:00pm
IBM Brussels
  • Description:

    Location :       IBM Belgium, Avenue du Bourget / Bourgetlaan 42
                            B-1130 Brussels Belgium

    Agenda

    09:00 – 09:30 Registration

    ·      09:30 – 09:40 Welcome and intro – Jan Tielemans

    ·      09:40 – 10:40 ‘Db2 13 for z/OS performance and zSynergy updates’, Akiko Hoshikawa – IBM

    ·      10:40 – 11:40 ‘Db2 real-time application monitoring, our needs, implementations, and an open  discussion’, Jan Cannaerts –…

  • Created by: Tielemans Jan
  • Categories: User Groups

User and Group permissions for Procs, Views and Triggers – Part 2

Posted by Carol Davis-Mann on February 22, 2023 at 9:27am

 

By Mark Gillis

 

In the first part of this blog I outlined an issue I’d come across with the conferring of Role-based permissions to Groups for certain objects. Here’s one way around it and some further observations on the underlying issue.…

Read more…

Db2 Log Space Management in V11.5

Posted by Carol Davis-Mann on January 11, 2023 at 10:12am

By Damir Wilder

Damir recently found himself in a situation where he needed to expand (quickly and without downtime) the Db2 Transaction Log space in a customer’s live production database, which had been steadily filling up (for several hours) by a very long and intensive transaction. Also contributing to the log space usage were numerous other (smaller) transactions that were executing during the same time and…

Read more…

Db2 pureScale – The Deployment Journey [10 Years On]

Posted by Carol Davis-Mann on January 4, 2023 at 4:29pm

By Iqbal Goralwalla

Earlier this year Db2 pureScale deployments were made available as a bring-your-own-license (BYOL) option through the AWS Marketplace with a pre-packaged template and point/click interface. This significantly simplifies the deployment process. It facilitates setting up a pureScale cluster from what used to be weeks or months to less than an hour. …

Read more…

Cancelling Db2 threads from the TEP interface with logon credential

Posted by Hong Zhou on November 30, 2022 at 5:01pm

Using take action to invoke predefined command to cancel a thread is available from OMPE’s Tivoli Enterprise Portal (TEP) interface. This requires granting Db2 authority to the user ID of the OMPE started task which for some customers is not desired and considered a security concern.

With OMPE V540 APAR PH47423/UI82806 and fixpack 5.4.0-TIV-KD5-FP0025, two new prefixes “DP:” and “D5:” are introduced to pair with the existing cancel thread command. With prefixed command, the cancel…

Read more…