Db2 AI for z/OS

Showing 14 of 13628

Db2Z INSERT with VALUES should allow multiple rows

Db2 LUW and many other RDMS allow one INSERT with VALUES to insert multiple rows at once. Db2 Z does not allow that syntax. Db2 Z INSERT with VALUES only allows one row at a time So if you have multiple rows you want to insert with the INSERT usin...

about 1 month ago in Db2 AI for z/OS 1 Submitted

21 VOTE

Make Dynamic Plan Stability really stable

We use dynamic sql now in nearly all of our applications. It is essential for our shop that the access paths for dynamic sql are as stable as possible. So we will use the new V12 feature "dynamic plan stability". If you look into the manuals and i...

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

3 VOTE

Db2 AI should discover and prevent deadlocks, for example in situations where programs that previously have been in deadlock situations are expected to deadlock again.

In deadlock situations, one of the involved programs will be rolled back, resources have been unnecessarily used and DBA’s must spend time investigating deadlocks. In transaction intensive systems deadlocks also may cause response time delays or o...

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

1 VOTE

Add user group and individual profile management

Currently the DB2ZAI use privileges are done by DB2 grants and each features (DCC, SA, SQLOPT) usage can be restricted by TSO ID/RACF group privileges Suggest there should be role and the duty segregation within the db2zAI tools. (such as Administ...

3 months ago in Db2 AI for z/OS 0 Submitted

1 VOTE

Enhancement suggestion for Critical Only email escalation under system assessment

Critical warning email escalation should be more descriptive (suggested to include Metric name) Instead of just number of Critical warning. It should be a list list of critical exception description Administrator should have ability to setup the e...

3 months ago in Db2 AI for z/OS 0 Submitted

1 VOTE

System Assessment-Hide/Unhide metrics features based on user role

Currently, each user is able to Hide/Unhide Metrics under the Db2zAI dashboard for their own view. It would be very helpful if the Db2 AI administrator could choose which metrics would be available to show. For example, there are metrics that we o...

4 months ago in Db2 AI for z/OS 0 Submitted

1 VOTE

"snooze" email escalation under System Assessment

Currently customer from RBC setup email escalation based on the Critical alerts under the system assessment for example Subject: Db2ZAI System Assessment for Connection DB2ZAIGCCDB01 Completed with Status of SUCCESS. Critical Exceptions Found. Db2...

4 months ago in Db2 AI for z/OS 0 Submitted

14 VOTE

Dynamic Plan Stability - Capture statements from explain

If we want to capture a certain dynamic statement for dynamic plan stability, the statement has to reside in the dynamic statement cache. Than you have to search for the statement id and with the statement íd you're able to capture a certain state...

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

2 VOTE

RFE #5 API SUPPORT

API SUPPORT (REST_API ) FOR DB2AI INCLUDING SYSTEM ASSESSMENT,SQL OPTIMIZATION,DCC TO BE ABLE TO CONSUME THIS DATA FROM INHOUSE TOOLS AND ALSO ALTERT API SUPPORT REQUESTED FOR INTEGRATION TO OTHER TOOLS (such as OBM) THAT CAN CAPTURE ALTERS GROUPE...

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

2 VOTE

RFE #3 REQUEST TO BE ABLE TO EASILY SET TO TURN OFF DB2AI AFFECTING CHOICE OF ACCESS PATH AT PACKAGE/STATEMENT LEVEL FROM DB2ZAI UI

Ability to ignore Db2zAI chosen access path • Stopping ML will trigger this, however, there is no granularity as package or statement level.

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

Please enter your email address

FILTER BY CATEGORY