Db2

Showing 215

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

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

over 1 year 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...

over 2 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 ...

over 2 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

1 VOTE

Please add the elements to 'LAST_REQUEST_TYPE' in the MON_GET_CONNECTION/MON_GET_UNIT_OF_WORK table function.

Please add the values from the following columns to 'LAST_REQUEST_TYPE' in the MON_GET_CONNECTION/MON_GET_UNIT_OF_WORK table function. (Please match the value of the STMT_OPERATION column in SYSIBMADM.SNAPSTMT/SNAP_GET_STMT) CALL EXECUTE_IMMEDIA...

12 months ago in Db2 / Monitoring 3 Future consideration

1 VOTE

Please add the missing SNAPSTMT/SNAP_GET_STMT columns to MON_GET_ACTIVITY.

1.SNAPSTMT administrative view/SNAP_GET_STMT table function is said to be replaced by MON_GET_ACTIVITY table function, but I would like to add the following columns because MON_GET_ACTIVITY does not have them. AGENT_ID STMT_TYPE STMT_OPERATION DEG...

12 months ago in Db2 / Monitoring 3 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...

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

Please enter your email address

FILTER BY CATEGORY