Db2

Showing 1393

A way can backup and restore pureScale instance

Currently an user is running a pureScale cluster, when all of the SAN disks(including the disk where instance path is on) were corrupted, he has to do the following to recovery the cluster: 1) replacing the corrupted disks 2) re-install and setup ...

over 5 years ago in Db2 / pureScale 2 Not under consideration

1 VOTE

Editing a job: showing job name on all "Edit job" screens

It would be nice to show the job name on every "Edit job" screen. Currently, the job name is shown on the 1st and 3rd screens (Define and Finish) but not on the 2nd screen (Select databases).

almost 2 years ago in Db2 / Data Management Console 0 Future consideration

3 VOTE

Add NEWMIRRORLOGPATH option to the restore command

This should be a fairly simple change/addition and prevent the possibilty that the mirrorlogs end up in the old databases mirrorlogpath by misstake or during the time it takes for the administrator to do the change manually, since the change will ...

over 5 years ago in Db2 / Backup/Restore/ Rollforward/ Recover 1 Not under consideration

4 VOTE

TRY_CAST for DB2 LUW (CAST without error)

"New" scalar-function TRY_CASTReturns a value cast to the specified data type if the cast succeeds; otherwise, returns null.

over 7 years ago in Db2 / Application Development 0 Not under consideration

4 VOTE

DDL creation support thru implicit trusted connection

Trusted context is a very good security mecanism to promote a user from an application server to a specific role. We face 2 problems:- DDL issued from Siebel application server, when applying a change, fails for CREATE TABLE- If user has no direct...

over 7 years ago in Db2 / Security 0 Not under consideration

2 VOTE

Support converting non-restricted databases to restricted databases in Db2

There can be legacy databases created with non-restricted mode. However as security policies get stringent there is need to convert these databases into restricted databases. The way to convert currently is to recreate the database from scratch. I...

almost 4 years ago in Db2 / Configuration Parameters 0 Not under consideration

3 VOTE

Default of for read only for all select statements

As you might have noticed, the "for read only" clause of the select statement in DB2 is not widely known nor used. Most standards select statements going through the DB2 engine have the risk of becoming an ambiguous cursor with sub-optimal perform...

over 5 years ago in Db2 / Application Development 1 Not under consideration

2 VOTE

Support for UR requested with column organized tables

Actually we're preparing a new Warehouse on DB2 BLU 11.5.5 on AIX using column organized tables. In an early technical examination we found, that concurrent access under isolation level UR ( reporting application ) and updating the same rows will ...

almost 4 years ago in Db2 0 Future consideration

4 VOTE

DB2 V9.7

When doing the case sensitive search, the index on ALT_IDENTIFIER is used correctly, and the query takes around 0.2 seconds as expected. When doing the case insensitive search, the optimiser correctly uses the V_N1999152021 column rather than the ...

over 7 years ago in Db2 / Text Search 0 Not under consideration

5 VOTE

Use trusted logging with db2audit to protect audit data from instance users and root

On Aix there is a trusted logging which can be used by syslog and AIX auditing. It would be nice if db2 can use this as well to store its audit data. At the moment it is written to Audit Data Path. It would be nice if this can be a character mode ...

over 9 years ago in Db2 / Security 0 Not under consideration

Please enter your email address

FILTER BY CATEGORY