Search results: Db2 Utilities Suite for z/OS

Showing 20 of 1578

REORG PREFORMAT of 1 TB page set should be interruptable

With PH64760 one can create 1TB page sets in one step. If one runs a REORG PREFORMAT on such large objects, the Media Manager Preformat task is not interruptable. Such a size of 1TB needs ~1.5hours to preformat the page set. In the meanwhile neith...

3 months ago in Db2 Utilities Suite for z/OS 0 Future consideration

25 VOTE

ENHANCEMENT FOR REDIRECTED RECOVERY - CHECK SCHEMA ONLY

ENHANCEMENT FOR REDIRECTED RECOVERY - CHECK SCHEMA ONLY The DB2 redirected recovery functionality allows RECOVER utility to be used to redirect the recovery of an object (the source) to another object (the target). The source and target objec...

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

3 VOTE

Reorg discards with PARTITION range for PBR

we are using PBR with multiple partitions per month. We perform reorg discards with PARTITION range like 1: 4. But discarded data is going to a single file when do the discards with range partition. example: We would like to get the first-part dat...

7 months ago in Db2 Utilities Suite for z/OS 1 Not under consideration

5 VOTE

Reorg Rebalance for partitions with different DSSIZE

Reorg Rebalance tries to set new partition boundaries so that rows are evenly distributed across the reorganized partitions. It does not consider that the partitions can have different values for DSSIZE. So the functionality of Reorg Rebalance sho...

over 1 year ago in Db2 Utilities Suite for z/OS 1 Not under consideration

8 VOTE

REORG PART LEVEL PBG tablespace

When I run a PART LEVEL REORG (PART 1 in this case) of a PBG tablespace and the current data doesn't fit into its original partition DB2 adds a new partition at the end and uses it for the "overflow" data, although all the already existing partiti...

almost 3 years ago in Db2 Utilities Suite for z/OS 0 Not under consideration

4 VOTE

Improved message text for DSNU537I

DSNU537I displays a page set which is not allowed in the list. As the utility can not know what the user intends to do, the text should be changed to a more general text without naming a pageset. Why: 1) Assume userA runs COPY with 4 objects, one ...

almost 2 years ago in Db2 Utilities Suite for z/OS 1 Not under consideration

4 VOTE

REBUILD - After recovery of TS is NPSI improvement

Recovered SEMHNSA Partition 1 which has a NPSI. Rebuild has no idea that only partition 1 was recovered and rebuilds all the partitions for NPSI XEMHUNSA. Believe improvements need to be made to make the REBUILD know that only partition 1 needs to...

almost 2 years ago in Db2 Utilities Suite for z/OS 6 Is a defect

6 VOTE

REORG needs to be enhanced to separate processing for partitions having dictionaries and no dictionaries

Using LISTDEF there are 4 partitions selected to be reorged. Row length 2284 bytes KEEPDICTIONARY used PART 5 - CARDF 50M, dictionary PART 6 - CARDF 60M, dictionary PART 11 - CARDF 110M, dictionary PART 80 - CARDF 150,000, no dictionary Since PART...

over 3 years ago in Db2 Utilities Suite for z/OS 0 Future consideration

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...

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

2 VOTE

Usability of REORG

When we did a big reorg of 32 billion records we missed some details in dis util functionality:1. how long every phase will take place, RTS knows the amount of records needs to be approx unloaded ...if its been done 1 billion in 2 hours means you ...

over 1 year ago in Db2 Utilities Suite for z/OS 1 Future consideration

Please enter your email address

FILTER BY CATEGORY