Db2 for z/OS

Showing 975

REBIND allocated plan

Before going to Db2 13 we have to rebind some plans that were last bound in Db2 10. We have also previously got the recommendation to rebind all plans when we have migrated to a new Db2 version. We have a problem with plans that are always allocat...

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

16 VOTE

Enhanced Instrumentation for workfiles

A possibility through IFI and/or a new command -DIS WORKFILES to get an “asis” use list of all work pools (Sort , DGTT, Work etc.) This data is crucial for tuning the number, size and type of the work spaces that we all have. The output should be ...

about 1 year ago in Db2 for z/OS 1 Future consideration

6 VOTE

When DB2 writes a message to the DB2 Log, DB2 could also optionally write the contents of the message to a new IBM Catalog Table SYSIBM.DB2_Messages or a user defined table.

WHY THIS IS A GOOD IDEA Many of our DB2 subsystems and members remain active for several months or more. Searching for a DB2 Message can take a long time in SDSF when analysing and diagnosing problems. Having all of the DB2 Messages in a Table mak...

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

1 VOTE

simplified code path for RI checking

We had an interesting discussion with the development team about this. As I already mentioned, the RI code path is quite different than the R-scan which may use one or more predicates to evaluate the qualifying rows. The main module that is drivin...

29 days ago in Db2 for z/OS 0 Under review

61 VOTE

Stop package invalidation after ALTER MAXPARTITIONS

These days in an agile world we have to ALTER PBG spaces on-the-fly to raise the MAXPARTITIONS value. Sadly this ALTER, even though it is an immediate ALTER, sets all dependent packages to VALID = 'N' which is, of course, a disaster.

about 5 years ago in Db2 for z/OS 8 Not under consideration

6 VOTE

Extend Db2 Message monitoring IFCID 197 to include information about message tokens

Our shop is using ITM Situation management to heavily automate processing/notification for our customers and thus minimize the use of custom logic to be maintained (specific REXX programs etc.) . One feature that we leverage is the OMEGAMON for Db...

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

1 VOTE

IFCID 365 - Set variable QLSTNTLS to -1 for unknown.

TLS/SSL Used Number of connections from the remote site that were configured with SSL and AT/TLS support. This value is meaningful only at the server. (Field name: QLSTNTLS). We are reporting on this field and are seeing some values of 0 for conne...

about 1 month ago in Db2 for z/OS 0 Future consideration

11 VOTE

Externalize non-DSC SQL in IFCID 316

An old request that got rejected but is for me, and at least 52 other voters, important was the IFI 316 for non-DSC eligible Dynamic SQLs. The business case here has two major reasons: First and most important these days – Audit. Any Dynamic SQL m...

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

15 VOTE

Display IAG2 on object level

Sometimes IAG2 will be disabled, in some situations this is clear and ok, in some situations it is strange and not expected. To implement reliable automation we need e.g. an enhancement to DISPLAY DATABASE SPACENAM with IAG, which shows which inse...

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

53 VOTE

API to write dictionary to log

A number of our common customers run DB2 utilities from third party vendors and IBM replication solutions. They are requesting that our LOAD and REORG utilities write the old dictionary pages to the log for later retrieval by a replication product...

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

Please enter your email address

FILTER BY CATEGORY