About

What best describes your job role?

Other


Db2portal.blogsspot


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

Special

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…

By James Cockayne

By now I’m sure everyone has heard of the malicious practice known as ransomware attacks, where miscreants break into a corporate network and encrypt data before demanding huge sums of money to provide a method to decrypt that data and make it accessible again.  The attacks tend to be insidious – sometimes the attacker is in the network for months before they gain access to the systems they are interested in, and they are known to target backup servers as…

Read more…

By Julian Stuhler

Background

With the advent of DB2 12 for z/OS, IBM has moved to a more agile approach for delivering new function to DB2 customers, known as “continuous delivery”. Major new releases of DB2 will now happen more rarely, with smaller packets of new functionality being delivered via the routine product maintenance process. This allows IBM to develop and release new features much more frequently, thereby reducing “time to value” – a…

Read more…

Activity Feed

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