We use a VTL for our Tape Environment. For a VTL it is recommended by IBM to use UNIT=(TAPE,,DEFER) in all Jobs. DB2 uses templates to generate JCL. In this templates it is not possible to code a DEFER parameter. Is there a way to solve this dilemma?
Roles by User Report contains a prompt to display individuals but will only show individuals directly associated to a security domain ( rather than listing the individuals within a associated group)
Need a function or pseudo-field to return the number of elements in a BSON array
Put in simplest terms, if I have a JSON/BSON record with an embedded array, I need to know how many elements are in the array. I need a function similar to bson_size() (which returns the string length of the total array) which instead returns the ...
support the configuration of route-maps and filters on BGP setup
We use BGP Setups for connection from IPS serveurs to our switches (client side). We need inter-IPS connections to have better network performances for IPS to IPS data copy. These connections use also BGP protocol. When we add these inter IPS conn...
In the below the foreign key does not use the compound index. Another index is created with adds overhead. create table p1 (t char(4) not null);
create unique index px1 on p1(t);
alter table p1 add constraint primary key (t) constraint p1_pk;
...
With the following the existing compound index is not used for the foreign key and another index is required. This adds overhead with additional maintenance. create table p1 (t char(4) not null);
create unique index px1 on p1(t);
alter table p1 ...
SMF data for use of SORTL and z15 Z Sort accelerator
Recently we have had some issues and queries around use of SORTL by Db2Sort and currently the only way to track whether SORTL is being used by Db2Sort is to scan every job and look for the message "CNK558I SORTL INSTRUCTION USED". To report on usa...
Kafka replication: Add a system parameter to set the number of Kafka producer threads
Currently CDC is relying on the number of source tables in the subscription to determine the number of Kafka producer threads. As an alternative, a Kafka data store parameter could be use to set the number of Kafka producer threads the same way it...