IBM Db2 - The Ultimate Database for Cloud, Analytics & Mobile
Introduction:
Assume the following scenario:
Added by Peter Hartmann on July 29, 2020 at 13:37 — No Comments
Introduction:
AUTOBIND is a very useful automation instrument inside the Db2 engine.
Recently there are 2 enhancements in this area. For the first enhancement refer to my blog post.
The second enhancement is described in this blog post and was introduced by…
ContinueAdded by Peter Hartmann on April 17, 2020 at 7:38 — No Comments
Toleration:
Is maintenance needed in Db2 for z/OS (V11 or V12) for a migration to
- the current hardware z15
- or the current operating system z/OS 2.4 ?
As of today there are no APARs/PTFs needed to tolerate such a migration.
Exploitation:
The following…
ContinueAdded by Peter Hartmann on November 19, 2019 at 7:55 — 2 Comments
Introduction:
Sometimes it is useful to generate JCL executable code for //SYSIN via SQL mass operations, e.g. change specific tables from one option to another. If the result row fits into one JCL line with a length of 72, then all is fine. If the line must be split, then the question comes up: How to split?
Here is a solution for commands (like REBIND PACKAGE), SQL (like ALTER TRIGGER) or…
ContinueAdded by Peter Hartmann on August 28, 2019 at 18:39 — 1 Comment
Introduction:
AUTOBIND is a very useful automation instrument inside the Db2 engine.
Suppose you change the definition of the table or index and these changes have impact on the dependent package, the static SQL package is marked as invalid,…
ContinueAdded by Peter Hartmann on August 20, 2019 at 19:29 — No Comments
If you think you know all about APPLCOMPAT, then please read this!
Introduction:
Advanced triggers introduced in V12 allow SQL PL statements and this opens “SQL only applications” to triggers. There is reduced need to call a stored procedure,…
ContinueAdded by Peter Hartmann on August 7, 2019 at 11:13 — No Comments
Level setting:
A Db2 group buffer pool (GBP) consist of two parts:
1) Directory entries
2) Data entries
For each data entry there must be an associated directory entry in the GBP.
A directory entry can exist without a data entry in the…
ContinueAdded by Peter Hartmann on July 30, 2019 at 12:27 — 2 Comments
V12R1M504:
With APPLCOMPAT V12R1M504 on e.g. SPUFI or DSNTEP2, one can no longer create segmented or classic partitioned table spaces. See knowledge center for this restriction.
A small marginalia is behind this restriction, if this is combined with another…
Added by Peter Hartmann on July 19, 2019 at 9:57 — 1 Comment
Introduction:
One of the major challenges for RUNSTATS is the sampling of the data rows e.g. for calculation of the COLCARD value in SYSIBM.SYSCOLSTATS and SYSIBM.SYSCOLUMNS.
The challenge is to balance the CPU resources used by RUNSTATS to calculate column cardinalities with high accuracy…
ContinueAdded by Peter Hartmann on July 17, 2019 at 10:38 — 1 Comment
History:
With DB2 Version 9.1 for z/OS a new system supplied stored procedure SYSPROC.ADMIN_INFO_SYSPARM was delivered. As the name suggests, this routine can be called to obtain the current settings of the Db2 subsystem parameters (DSNZPARM) and the…
Added by Peter Hartmann on July 16, 2019 at 8:04 — 6 Comments
Description of the new feature:
When Db2 in a data sharing environment writes a changed page to the GBP the same page in the buffer pool(s) of the other member(s) must be invalidated to avoid back level data access in this/these member(s). This invalidation is done by the cross invalidation (XI) feature which is a key functionality of data sharing and controlled by coupling facility…
ContinueAdded by Peter Hartmann on July 12, 2019 at 7:57 — No Comments
February 9, 2021 from 11am to 4pm – Live webcast
Db2 12 Exploiting new functions and Migration Planning REGISTER NOW Db2 12 for z/OS® takes Db2 to a new level, both extending the core capabilities and empowering the future. Db2 12 extends the…
Organized by Surekha Parekh | Type: webcast
1 Comment 1 LikeFebruary 10, 2021 from 11am to 4pm – Live webcast
Db2 12 Exploiting new functions and Migration Planning PART 2 REGISTER NOW Db2 12 for z/OS® takes Db2 to a new level, both extending the core capabilities and empowering the future. Db2 12 extends…
Organized by Surekha Parekh | Type: webcast
0 Comments 0 LikesFebruary 16, 2021 from 11am to 12pm – ET
Register Today! Whether you are an existing Db2 Analytics Accelerator user or considering becoming one, you won’t want to miss this webcast! Join Daniel Martin, STSM, IBM Db2 Analytics Accelerator De…
Organized by Annette Zawacki | Type: webcast
0 Comments 0 LikesBringing Db2 enthusiasts together virtually. Expert or novice, distributed or mainframe, this is the place for everything DB2.
Started by Shaun Hide in Security and DB2. Last reply by Alexander Dashevsky Nov 17, 2020. 1 Reply 0 Likes
I would need to know who modified table data on a certain day.I do have my backups and database logs available.DB2audit was however not activated at this point.How would i be able to access this information?Continue
Tags: #DataAccess
Started by Kip in What's hot ? Nov 4, 2020. 0 Replies 0 Likes
This digital event examines how enterprises can become smarter with a data management system that is developer-inclusive. During this session, participants will get to learn how Db2 integrates with a broad array of programming languages, employs…Continue
© 2021 Created by Surekha Parekh.
Powered by