Statements (DDL and DML)

Showing 95

Bufferpool and tablespace creation authority to DBADM

Create of a tablespace and bufferpool requires SYS* authorities. It made sense in earlier days when SYS folks needed to create filesystem, mount point etc. With automatic storage enabled database, it makes a perfect sense to delegate these authori...

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

27 VOTE

need to provide a RENAME SCHEMA statement (other database products provide this)

Need RENAME SCHEMA other databases other than DB2 LUW (i.e. MaxDB from SAP) provide a statement RENAME SCHEMA to rename a schema like a RENAME TABLESPACE/TABLE/INDEX. Needed on all supported operating systems.

about 10 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

7 VOTE

Automated Re-creation of Select-Star Views

If a view is created by using a 'SELECT *' statement, the view is not updated when a new column is added to the base table. An example: create table dm_tab(N integer, M integer) organize by row; insert into dm_tab(N, M) values (1, 2); create view ...

over 2 years ago in Db2 / Statements (DDL and DML) 1 Future consideration

5 VOTE

Enhance ALTER STOGROUP DROP ‚storage-path’ with optional specification of the Path_ID

As you may ADD the same path multiple times to a storage group (in order to have multiple containers of a single tablespace within that path), it should be possible to even DROP a single reference to that path from the storage group as well! But s...

about 2 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

18 VOTE

Improve access plan resolution for SELECT MAX() (or MIN()) statements on range-partitioned tables with local (partitioned)

Context: range partitioned table with partitioned indexes A SELECT MAX() statement is issued on a field that is not the part of the partitioned key. The query is resolved by performing a full index scan on a partitioned index on that field. That i...

about 8 years ago in Db2 / Statements (DDL and DML) 3 Not under consideration

15 VOTE

Consideration of Statistical Views for INSERT with Sub-SELECT

We try to improve the performance on an INSERT with an underlying complex subselect eg. "INSERT INTO table "Therefore we created a statistical view through which the optimizer should be able to get more distribution statistics and build a better a...

about 7 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

6 VOTE

Add "IF EXISTS" syntax to all DROP statements

More and more SQL is stored in repositories and needs to be applied in odd places and orders. One syntax element that supports this is the "IF EXISTS" on a drop statement. This causes a statement to not count as a failure if it finds no object to ...

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

13 VOTE

SQLCODE SQL0302N should give hint which parameter is too long.

Scenario: prepared statementsError: host variable too longProblem: SQL0302N should give a hint which parameter is affected. Details:Using prepared statements with parameter markers such as INSERT INTO TESTTAB (COL1, COL2) VALUES (?, ?)"); DB2 thro...

over 7 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

2 VOTE

Make multiple DDL changes transactional

Why is it useful? When complex changes are made in DDL and one of the changes fails, it can get pretty hard to revert the issue. Who would benefit from it? Implementing this idea would tremendously help database administrators. How should it work?...

over 1 year ago in Db2 / Statements (DDL and DML) 2 Functionality already exists

10 VOTE

InsteadOF SQL

It is common in the database world (DB2 but all the others I have worked with are the same) to have a separate product installed that generates code and submits it to the database for processing. Eventually, you will encounter SQL that doesn't per...

almost 7 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

Please enter your email address

FILTER BY CATEGORY