Db2

Showing 216

Suitable Replacement for SNAP_GET_APPL_V95

SNAP_GET_APPL_V95 got introduced with Db2 9.5 but is deprecated in actual versions/releases. MON_GET_CONNECTION is declared as the replacement for this ‘old’ procedure, but the scope of the replacement procedure is different! Thus MON_GET_CONNECTI...

over 2 years ago in Db2 / Monitoring 1 Future consideration

3 VOTE

DMC Backup Restore

It would be great if database administrators could manage and schedule backups and restores from the DMC in Cloud Pak.

over 2 years ago in Db2 1 Future consideration

2 VOTE

IBM i Access Client Solutions (ACS) should be able to use a DB2 file as input from iseries

Very often a user gets a list of (hundreds or even thousands) similar changes to make. He gets the list of course in excel or text file and needs to type these in a green screen (5250 emulation). In Client acces there was a neat solution for this:...

almost 2 years ago in Db2 / Other/Unknown 0 Future consideration

3 VOTE

Allow called Programs in z/OS to execute SQL without requiring the main program to be started with a DB2 plan.

When it becomes necessary for a called program in z/OS to execute SQL statements it is only possible when the main program is alredy called with a DB2 connection (DSN and Plan). While the required modification seems minor, it is next to impossible...

almost 3 years ago in Db2 / Application Development 0 Future consideration

3 VOTE

Enabling readonly mode for database or user. (DB2 LUW)

Would like to see a db level and a user level parameter to enable readonly mode at database level or user level. Currently need to run set of statements to achieve this, which makes management difficult. A single statement to enable readonly mode ...

almost 3 years ago in Db2 / Statements (DDL and DML) 0 Future consideration

2 VOTE

Support for "every" in the "alter table add partition" to add multiple partitions

The "create table" statement supports this syntax to create a table with multiple partitions: CREATE TABLE DOCUMENTS ( ID INTEGER, CONTENTS VARCHAR(10)) PARTITION BY RANGE (ID)(STARTING 1 ENDING 1000 EVERY 100) This will create a table with 10 par...

almost 2 years ago in Db2 / Tables/Index (Range MQ MDC etc.) 0 Future consideration

3 VOTE

Alias for REST Services

Db2 REST services, with versioning enabled, sets the first service created via the BIND SERVICE command to be the default service. at this stage the URL and the REST service are in sync and the URL need not reference the version as DB2 will invoke...

almost 3 years ago in Db2 / Application Development 0 Future consideration

6 VOTE

Release the restriction of restoring and rollforward through a topology change in pureScale

After a change in topology that involves adding or dropping a member, you cannot perform rollforward recovery operations through the point where the topology change occurred;

almost 6 years ago in Db2 / Backup/Restore/ Rollforward/ Recover / pureScale 0 Future consideration

3 VOTE

Start Commandline-Script in Stored Procedure

Executes external commandline-scripts from stored procedure. The stored procedure call should work like following: select * from (VALUES '`sh /tmp/test.sh`') AS TEMP(Testoutput); With the script i check if new created tables or views from developm...

about 3 years ago in Db2 / Statements (DDL and DML) 1 Future consideration

2 VOTE

Error message improvement

We request na addition to the error messages for this specific scenario: While converting non-UTS tablespaces to UTS using SECQTY 0 the opperation returned only the message DSNI014I reason code 00C90101, no message indicating space shortage in tab...

about 2 years ago in Db2 / Analytical Functions 0 Future consideration

Please enter your email address

FILTER BY CATEGORY