About

What best describes your job role?

Other


Db2portal.blogsspot


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

Special

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…

As the world mourns the loss of the digital dance duo Daft Punk, Triton Consulting is sending its very own duo of digital pioneers Mark Gillis and Damir Wilder around the world – virtually.

IBM Champions Mark and Damir were delighted to get the call that they had been selected to present at IDUG Australasia and IDUG North America Tech Conferences.

Eagerly planning…

Read more…

Activity Feed

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