About

What best describes your job role?

Other


Db2portal.blogsspot


Earned points: 5800
Db2 Fan
Received:
Nov 1, 2021
0
Db2 Leader
Received:
Dec 3, 2021
0

Special

Db2 Log Space Management in V11.5


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…

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…

By Gareth Copplestone-Jones

If you attended Gareth Copplestone-Jones' presentation at IDUG EMEA and want to learn more about Db2 Locking, here’s where to start. 

This Db2 for z/OS Locking blog series is mostly targeted at Db2 for z/OS application developers, but is also appropriate for application designers, database administrators,…

Read more…

Tablespaces: where exactly is my data?


By Mark Gillis

This should be pretty straight-forward: you can look in the TABLES System Catalogue and find references for the data (TBSPACE), Indexes (INDEX_TBSPACE) and Large Objects (LONG_TBSPACE). But DB2 throws a few curved balls here; partitioned tables (where the data, indexes and LOBs can be in multiple tablespaces), particular types of index that don’t seem to be in…

Read more…

By Mark Gillis

There are easily accessible means of checking what your Stored Procedure needs in the way of dependent objects (SYSCAT.ROUTINEDEP, basically). So, what if you find a, or a number of, Stored Procs that are marked as needing a REBIND and then, when you do that rebind, you get an SQL0440 indicating that “something” is missing. How do you go about checking that situation out? …

Read more…

Activity Feed

Carol Davis-Mann posted a blog post
 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. Possible…
Feb 22
Carol Davis-Mann posted a blog post
By Damir WilderDamir 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…
Jan 11
Carol Davis-Mann posted a blog post
By Iqbal GoralwallaEarlier 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…
Jan 4
Carol Davis-Mann posted a blog post
By Gareth Copplestone-JonesIf you attended Gareth Copplestone-Jones' presentation at IDUG EMEA and want to learn more about Db2 Locking, here’s where to start. This Db2 for z/OS Locking blog series is mostly targeted at Db2 for z/OS application…
Nov 2, 2022
Carol Davis-Mann posted a blog post
By Mark Gillis Mark Gillis has been doing some migration work; porting a Db2 database to a PostgreSQL one. You could say that is going from an Enterprise strength solution to a simpler, but less expensive option, but it’s not a choice Mark is in a…
Sep 27, 2022
Carol Davis-Mann posted a blog post
By Mark GillisIn his new blog, Mark Gillis explores how to modify queries on the fly using Jupyter Notebook, widgets and interactive SQL.   OK, fair enough, that does sound a bit specialised and will maybe put some people off. Nothing like a good…
Sep 20, 2022
Carol Davis-Mann posted a blog post
By James GillIntroductionA long time ago (in a galaxy far, far away), I began this series with the intention of blogging about using Jenkins to orchestrate some tasks on z/OS. I did an introduction to Jenkins and one on groovy pipelines.  In this…
Mar 9, 2022
Carol Davis-Mann posted a blog post
By Mark GillisThis should be pretty straight-forward: you can look in the TABLES System Catalogue and find references for the data (TBSPACE), Indexes (INDEX_TBSPACE) and Large Objects (LONG_TBSPACE). But DB2 throws a few curved balls here;…
Mar 2, 2022
Carol Davis-Mann posted a blog post
In part one of this blog James Cockayne looked at what might happen to a DB2 database that was attacked by ransomware encryption.  In part two James shares four dos and four don’ts to help protect DB2 databases from ransomware…
Nov 29, 2021
Carol Davis-Mann posted blog posts
Nov 1, 2021