Search results: Db2 for z/OS

Showing 92

Db2 native and RACF security consistency requirement

This is especially important for shops like ours where for years DB2 native security and migrate to RACF security to be complaint with security audit and policies, and also new mainframe applications standards. There is multiple areas where curren...

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

27 VOTE

DB2 Return Code Differentiate for Deadlock and Timeout via Subsys Normal Call Exit

DB2 presents IMS ( via Subsystem Normal Call Exit ) with the same return code (4) for: DB2 resource deadlocks DB2 resource unavailable conditions Example, lock timeouts on object locks, such as are taken by DB2 utilities and those caused b...

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

2 VOTE

Publish the DSNTIJPM and DSNTIJPM members at the IBM site

There is people still running with Db2 V12, and probably without access to the V13 sotware. I think that could really be a benefit for them to be able to easily access to the Premigration Queries. Adding the DSNTIJPE and DSNTIJPM sources to the IB...

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

30 VOTE

Create INDEX and SKPT lock. DDL and continuous availability.

Working in a banking 24x7 environment without any maintenance window our concurrency issues with DDL changes are increasing more and more everyday as our workload increases. There are some concurrency problems that we think it should value the eff...

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

23 VOTE

Removal of an unnecesary system crash due to must-complete or latch holding agent - RC 00F3040A

Today, there is an intentional system crash designed and exploited with an abend code 00F3040A when an agent abending in system is in so called must-complete state or is holding a latch. We have been running a case TS006198341 where our system cra...

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

4 VOTE

Improve ALTER TABLE ROTATE PARTITION

Currently ALTER TABLE ROTATE PARTITION only allows the ENDING value to be a constant, minvalue, or maxvalue. I would suggest adding the ability to generate DATES or TIMESTAMPS so that additional programming is not necessary to generate the ALTER s...

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

15 VOTE

DB2 message showing a trace was started

Today we have situations where people authorized to start DB2 traces sometimes issue START TRACE commands with little qualifications with lead to traces being collected for lots of DB2 threads which ends having impact on general performance of the...

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

34 VOTE

Provide SQL access to product statistics API's

Provide a way to bring statistics from various products API's into an SQL context. Sample has been shown to selected zBLC customers during the Dublin face-2-face. Requirement has been discussed with Jeff Josten / Chris Crone. Offer has been made t...

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

48 VOTE

Command confirmation in joblog of DB2MSTR.

DB2 has many commands which display or alter the status of something. There are a lot of distinct environments from which the commands can be executed (z/OS console, DSN session, TSO DSN command processor, IMS or CICS terminal, special STPs, IFI-i...

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

12 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...

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

Please enter your email address

FILTER BY CATEGORY