Db2 Utilities Suite for z/OS

Showing 50

Include repair catalog in the redirected recover

It should not be necessary to explicitely run a repair catalog after running a redirected recover. The redirected recover should adjust the version information in the catalog itself.

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

1 VOTE

New message indicating how many rows are deleted in SYSCOPY and SYSLGRNX by MODIFY RECOVERY

Sometimes MODIFY RECOVERY does something although not visible by existing messages. With this enhancement customer can see what was done in the joblog and customer do not need to check SYSCOPY and SYSLGRNX before MODIFY RECOVERY and afterwards to ...

13 days ago in Db2 Utilities Suite for z/OS 1 Not under consideration

1 VOTE

USING LOADINCURSOR for XML COLUMN even nullable

We have a table with a XML column defined NOT NULL. We periodically transfer data from production to preproduction using unload/load.Because XML column has value nobody have to read after having transfered data applications execute a sql update fo...

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

1 VOTE

Load into util next to a reorg

As discussed in IDUG EMEA 2023 Praag, i gave a presentation about reorg a big table that took 8 days. If the table cant be accessed, a recover to that point would take 6 hours. So table created at front that can have the data already loaded until ...

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

1 VOTE

Change behavior of option PARALLEL(0) for REORG TABLESPACE

We had a problem recently when a reorg of a tablespace with 100 partitions consumed far too much real storage. We ran the reorg with PARALLEL(0) and it choose to use 188 parallel tasks. That was probably OK at the beginning of the execution but no...

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

1 VOTE

Support Spanned Record Format in Reorg Discard Dataset

We would like Discard Lob's from a Table and Load them into a Partner Table. The Discard Dataset can not exceed 32K, so it is not possible. With Unload Utility it is possible to define Spanned Yes for SYSREC. It would be helpful if you could suppo...

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

1 VOTE

DSNTYPE(PIPE) support for TEMPLATE utility

Would like to be able to dynamically allocate a z/OS Unix Named Pipe via the TEMPLATE utility. LOADing to and UNLOADing from named pipes is extremely useful, for example, to copy data between different Db2 systems on the same z/OS image. In JCL, t...

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

1 VOTE

Reorg Index functionality should allow parallel partition processing of a multi-part selection as per Reorg Tablespace.

It is best practice to minimise the exposure of mission critical application workload to the impact of reorg drain activity. It is best practice to minimise the cpu, i/o and elapse time of database maintenance activity which is often restricted to...

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

1 VOTE

DB2 Support

Customer would like the DB2 Unload and Load Utilities to support Partition by Growth (PBG) tablespaces.

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

1 VOTE

DSNZPARM to disable MODIFY option DELETEDS - compliance issue

It should be possible to disable the option for deleting physical datasets along with modifying recovery information for a tablespace, as in MODIFY RECOVERY TABLESPACE XXXXXX.XXXXXXXX DSNUM ALL DELETE AGE(32) DELETEDS There is increasingly more ...

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

Please enter your email address

FILTER BY CATEGORY