Db2

Showing 1216

STMM Monitoring

With the memory statistics similar to the ‘db2pd -dbptnmem’ output within the STMM logs, it would be possible to get memory usage report over time from Db2 perspective without any permanent monitoring tool (as long as STMM is used/active). It woul...

5 months ago in Db2 / Monitoring / Other/Unknown 0 Under review

25 VOTE

Review automatic prefetch

This IDEA it to request a more dynamic management of PREFETCHSIZE when it is set to AUTOMATIC. The documentation states: "The database updates the prefetch size automatically whenever the number of containers in a table space changes (following su...

5 months ago in Db2 / Workload Management 2 Submitted

3 VOTE

Make "Open Console" Suggest You Need to Create DMC Instance

When you create a DB2 Warehouse instance in a fresh install of CP4D 4.5 and then click on the "Open Database" you initially get just a blank screen. This screen should let the user know that they need to create an instance of Data Management Conso...

5 months ago in Db2 / Data Management Console 0 Under review

1 VOTE

Allow RESTSERVICEDEFAULT on BIND SERVICE

When using BIND SERVICE to implement new Db2 REST services it would simplify integration with existing change management systems to allow the specification of the default version on the BIND SERVICE. This may be accomplished by using REBIND PACKAG...

5 months ago in Db2 / Application Development 0 Submitted

2 VOTE

Silent uninstall of ibm data server runtime client renders in error with db2lswtch

We are having problem when uninstalling IBM Data Server Runtime Client 11.5.7.0 from a script. Install works fine but when uninstalling I use this command from a command window as administrator MSIEXEC /X {9915B73E-D89B-4D1C-89B3-5FEF7978024C} /le...

5 months ago in Db2 / Db2 Connect and Drivers 0 Submitted

5 VOTE

DMC Missing Feature from DSM - Table Comparison

DSM has a feature where you can select a table to compare between databases. This is the only feature that we are missing so we can fully migrate to DMC. Our team uses this for troubleshooting and confirmation.

5 months ago in Db2 / Data Management Console 0 Future consideration

8 VOTE

Remove Group Based Access Limitation

Description of Limitation: IBM has defined a few limitations with role based access which include the following: A role cannot own database objects. Permissions and roles granted to groups are not considered when you create the following database ...

5 months ago in Db2 / Security 1 Submitted

28 VOTE

Include CTQ reason / details in db2exfmt advanced diagnostics

We need an "Extended Diagnostic Information" in Explain (db2exfmt) that details if and why the column organized tables had been (early) converted to the row format for processing it in the row engine. This is important to detect performance issues...

5 months ago in Db2 / BLU Acceleration 2 Submitted

6 VOTE

Add microseconds to the Db2 pureScale log timestamp to match what Db2 z/OS is doing today.

We require accurate microseconds from the Db2 pureScale log in order to process our CDC messages via infosphere. Currently LUW logs only go to the second and stop. We currently use Db2 z/OS across a 3 member data sharing group. We have CDC turned...

5 months ago in Db2 / pureScale 1 Not under consideration

5 VOTE

IBM does not support SSL communications for 2-phase commit (DB2 & MQ)

TS010796788 : DB2 - SSL - Two-Phase commit failures We are mandate to close unsecured connections to DB2 by closing the TCP/IP connections to DB2. However, we are using 2 -phase commit in between MQ and DB2, which looks for TCP channel opened. As ...

5 months ago in Db2 / Security 1 Under review

Please enter your email address

FILTER BY CATEGORY