Calculates how full and how close to maximum capacity a partition is. This is for DB2/z. Updated to use NPAGES instead of NACTIVE.
TSMAX.txt
Given a table partitioned by ascending date with a highest Limit Key = 'MAXVALUE' create alter statements ALTER TABLE [a.b] ALTER PARTITION [n] ENDING AT ('yyyy-mm-dd'); to bring table/partition limit keys up to the most recent possible period. * Statements sequenced in descending order by ...
Introduction to XML in DB2 11 for z/OS – Part 1 Have you ever thought about using XML in DB2 for z/OS, but were afraid that you would need to study a lot of material before you could actually begin? Don’t worry! You do not need to know much before you start. You can get by with basic DB2 for...
1 Comment - no search term matches found in comments.
The IBM DB2 Analytics Accelerator (IDAA) has proven to be a big success in enabling analytics on DB2 z/OS data. Roberta Barnabè gave a well-received presentation at IDUG EMEA 2015 in Dublin on how her company implemented IDAA. This presentation is full of practical advice and can help any shop...
Multi-statement SQL-only script, should be executable in all standard DB2 SQL processors (Data Studio, TEP2, SPUFI, Command Processor). Create Declared Global Temporary Tables; populate with DB2 Catalog Entry elements needed to create names of the underlying VSAM datasets; UPDATE to populate...
XMLModify function: sub-document update on an XML document In DB2 9 for z/OS, an update on an XML document is a delete of whole document following by a new insert. Since DB2 10 for z/OS, we are able to do sub-document update using XMLModify function. As you may know, DB2 for z/OS stores...
Does what it says in the title line! Will also work in V7 and V8 CM as long as you remove the STATSTIME CASE structure for the TP and IP. Now updated with a new file for DB2 10 and 11
2 attachments