Db2 for z/OS

Showing 963 of 14950

Use profile tables for local applications

We use profile tables successfully for different scenarios. In addition to remote applications, our DB2 IT infrastructure also includes local applications for which we also have profile table usage scenarios. For example, we set the explain mode f...

8 months ago in Db2 for z/OS 2 Future consideration

3 VOTE

Display Trace owner when OPx buffer used

The -DISPLAY TRACE(*) command does not indicate which address space owns the trace when the destination is OPx. Since the OPx destination must be managed by some product/address space it would be helpful to know this. A typical scenario: The syspr...

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

25 VOTE

Log offload task needs to be manually cancelled restarted after outage to tape

We are seeing situations when tape processing is down and a DB2 request to offload logs to tape is initiated using dynamic allocation, that offload task will hang and never be satisfied until the offload task is cancelled and re-driven manually. T...

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

8 VOTE

Populate DSSIZE for ALL pagesets to simplify monitoring and avoiding pageset full conditions

The rules surrounding the maximum size for any given pageset have become more and more complicated over recent releases of Db2. This severely affects our ability to monitor for pageset full conditions, as while it is relatively straight forward to...

over 2 years ago in Db2 for z/OS 0 Future consideration

4 VOTE

Support of static SQL (SQLJ) for IntelliJ regarding Code completion and Error Detection

A lot of customers are using IntelliJ enterprise wide, while still using static sql in Java and therefore have a heavy need for support of the IDE and not just read log output and match it with the code in the editor.

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

8 VOTE

Enhance the -904 REASON 00E30305 with the root cause of the failing AUTOBIND

The APAR PH13350 enhancement writes a notification DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE. REASON 00E30305 , TYPE OF RESOURCE This is a useful notification but it can be quite difficult to find the...

almost 3 years ago in Db2 for z/OS 0 Future consideration

4 VOTE

There should be a table like SYSUTILITIES that contains Db2 Commands that have been issued

There should be a table like SYSUTILITIES , say SYSCOMMANDS, that contains Db2 Commands that have been issued, including the full text of the Db2 command that was issued.

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

7 VOTE

real append processing on insert for LOB when specifying append

Our customers send us many millions of documents every day, which we have to save in the form of LOBs very quickly and without interruption in DB2. For this we use the APPEND option to be able to process the inserts as quickly as possible. Unfortu...

over 2 years ago in Db2 for z/OS 0 Not under consideration

7 VOTE

Add SCOPE(GROUP) to the Start/Stop Profile command

In our shop we have many Db2 data sharing members. If we need to stop and then start our profile tables we need to do so in many places. Adding the SCOPE(GROUP) to the both the start and the stop command would reduce the number of places and comma...

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

4 VOTE

Restart Time of DB2 should not be dependent on SCA size

During restart of DB2, the time difference between DSNR003I and DSNR004I is a function of the SCA size. Case TS009645595 was opened and has all the details. But in summary: this large time differenece of 30 seconds (in our case) is a function of t...

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

Please enter your email address

FILTER BY CATEGORY