Db2 for z/OS

Showing 786

Instantiated temp tables with full functionality

The SAP data dictionary supports the creation of temp tables. This allows application developers to speed up the processing by temporarily storing result sets of queries in the database and later process them. The data is only kept until commit. T...

over 8 years ago in Db2 for z/OS 1 Not under consideration

3 VOTE

Add new Status for stopping Databases that will be Dropped or decomissioned

When you work for several accounts it's not easy to know whether a DB or TS has been stopped on purpouse or just due to some previous error. I think that some new status would be great, some Advisory STOP, something that doesn't allow people to us...

7 months ago in Db2 for z/OS 3 Not under consideration

27 VOTE

Add Two Factor Authentication support for Data Studio

Our z/OS security infrastructure now requires two factor authentication for all z/OS IDs which have elevated privileges. These IDs are required to configure new connections or apply maintenance for bind activities in DS. Are there any plans to add...

almost 5 years ago in Db2 for z/OS 1 Not under consideration

9 VOTE

Enable DSNTIAUL to generate NUMRECS in the punchdataset

The UNLOAD using DSNUTILB generates the NUMRECS parameter which makes the Allocation of Sort/Workdatasets for the Load utility very effective. Because some collegues use IKJEFT01 (DSNTIAUL) for unloading data, we tried to use NUMRECS here also. Bu...

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

10 VOTE

Issue command DISPLAY DB CLAIMERS on a LOAD SHRLEVEL NONE when DRAIN fails in UTILINIT phas

We faced situations in which LOAD SHRLEVEL NONE jobs abends with S04E and Reason Code 00C200EC during UTILINIT phase. When this abends occurs, LOAD was unable to DRAIN all the claimers, once it is SHRLEVEL NONE, before beggining LOAD data into tab...

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

2 VOTE

Add timestamp to all -DISPLAY command outputs

More and more companies are using multiple DISPLAY commands to track for problems or usage statistics etc. The problem is that the TIMESTAMP when the command was issued is not in the output (apart from DISPLAY BLOCKERS) It would be really good to ...

5 months ago in Db2 for z/OS 1 Not under consideration

3 VOTE

Db2 image copies to S3 storage

With new storage technologies available, it would be nice if Db2 utilities could write image copies directly to S3 storage.

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

30 VOTE

Enhance ALTER of STOGROUP

Would like additional flexibility to change storage options without taking outages. First situation, we had a special storage group defined with a specific STORCLAS that was used to isolate a specific subset of data. That isolation is no longer ne...

almost 6 years ago in Db2 for z/OS 1 Not under consideration

11 VOTE

Modify DSNJU004 to print all information stored in a Db2 BSDS

Not everything that resides in a BSDS can be printed via this utility. However several items are stored in the BSDS that we need to go to several other places to get the information

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

24 VOTE

Improve persistent thread concurrency

With the implementation of transactions with persistent threads (like pseudo wait-for-input on IMS) we have been facing some concurrency issues in our site, specially with HPU and batch programs that perform lock escalation. This happens because t...

almost 5 years ago in Db2 for z/OS 7 Not under consideration

Please enter your email address

FILTER BY CATEGORY