Db2 Utilities Suite for z/OS

Showing 15

Provide ROWID addition for PBG to PBR conversion in V13 ALTER statement.

In V13m we get to convert PBG tablespace to PBR by a simple ALTER statement. However, we will be forced to look for a partitioning key by working with application team. In the mean time, in V12 we have a feature called "Hidden ROWID support for pa...

about 2 years ago in Db2 Utilities Suite for z/OS 2 Delivered

34 VOTE

Option to override LOAD utility maintaining MAXASSIGNEDVAL for identity columns in Db2 V12

Our existing process to move data from one region to another using the LOAD utility stopped working on tables with generated by default as identity key column after we upgraded to Db2 12. The new LOAD enhancement to maintain MAXASSIGNEDVAL is caus...

over 4 years ago in Db2 Utilities Suite for z/OS 5 Delivered

19 VOTE

Allow for UNLOAD SHRLEVEL CHANGE and REORG SHRLEVEL CHANGE to be compatible wen executing on the same partition

We are running very busy environmenet with IDAA being frequently refreshed by loader with increamnts of inserted records. In addition, we are using the DB2 automated housekeeping approach with the DSNACCOX stored proc implmentation to manage and t...

over 4 years ago in Db2 Utilities Suite for z/OS 2 Delivered

18 VOTE

Improve DSNACCOX procedure and DISPLAY command to provide correct information

This idea is a result of case TS002735466 and is being opened as recommended by IBM Support. Currently, there is an undocumented limit of the internal buffers which are managed by DB2 and which are used when processing DISPLAY DB command. When it ...

almost 5 years ago in Db2 Utilities Suite for z/OS 1 Delivered

7 VOTE

IMAGECOPY support: LOAD PART to support STACK YES like REORG PART

For the subject image copy behavior in the LOAD utility, it is as the customer describes: COPYDDN can be specified at the job / table space level but requires the RESUME or REPLACE keywords at the table space level, so this would effectively resul...

over 4 years ago in Db2 Utilities Suite for z/OS 1 Delivered

9 VOTE

"Reorg force all" should kill all existing (active or inactive) threads which belong to the object which would be reorganized

we have many tables which are changed and selected 24 hours a day - 7 days a week. So this tables need more reorgs than other not so much changed tables but it is not possible to make a reorg (force all) because there are Spufi User with autocommi...

over 5 years ago in Db2 Utilities Suite for z/OS 2 Delivered

7 VOTE

FORCE for LOAD

We are currently depending on vendor software that has the capability of cancelling DB2 threads when entering the switch phase of a load. This capability has saved the application team hundreds of incident tickets nightly as they perform loads daily.

almost 5 years ago in Db2 Utilities Suite for z/OS 1 Delivered

5 VOTE

Limit the number of tape drives allocated when using a TEMPLATE with STACK NO specified

In our reorg utilities against lobs using inline image copy it is required to use STACK NO, however, since we image copy to tape it causes the DB2 utility to acquire multiple tape drive units all at once for each partition of a UTS. This is an iss...

about 5 years ago in Db2 Utilities Suite for z/OS 2 Delivered

4 VOTE

DEFAULTIF <> functionality does not exist in IBM LOAD; IBM only allows ‘=‘

about 5 years ago in Db2 Utilities Suite for z/OS 0 Delivered

3 VOTE

LOAD REPLACE inline copy does not have a PIT_RBA value therefore does not create a valid recovery point

This was reported in Case:TS002919261, text included in next section. All customers using LOAD REPLACE inline copy. This is a gap in the Utility process.

almost 5 years ago in Db2 Utilities Suite for z/OS 1 Delivered

Please enter your email address

FILTER BY CATEGORY