Db2

Showing 1401

Add support to update "Last Login Time" of Linux OS for Db2 LUW

Db2 LUW on Linux OS only use auth and password module of PAM to validate and change password, but it didn't record the "Last Login Time" for the users on the Linux OS, so we don't know if the users are actually using the Db2 for data query. And th...

almost 4 years ago in Db2 0 Future consideration

3 VOTE

Avoid the database, configured in HADR, on primary side experience an outage when the database on the standby side experience any problem.

We use Db2 pureScale in many environments using POWER System. For our disaster recovery strategy we use HADR for each database between sites. In a specific situation of when some standbys databases experienced HADR_FLAGS = STANDBY_RECV_BLOCKED, re...

over 5 years ago in Db2 1 Not under consideration

3 VOTE

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

almost 6 years ago in Db2 / pureScale 2 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

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

almost 8 years ago in Db2 0 Not under consideration

2 VOTE

Avoiding 0C7 on UNLOAD from FIC when structure has changed

Hi all, To explain what the idea I'm going to explain the "issue" In a project, we add to drop a column from a table. To do that on multiple environment we use automation tool. The tool drop/create the object without unloading data. So to correct ...

almost 4 years ago in Db2 2 Not under consideration

2 VOTE

User management auditing

Our auditor is asking questions like 'Can we see that user X is locked or removed from DB2 when he left the company'. There is no way to see a lock date or create or remove dates on account that are created through the web console.

almost 4 years ago in Db2 / Data Management Console 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 ...

almost 8 years ago in Db2 0 Not under 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 ...

almost 6 years ago in Db2 1 Not under consideration

Please enter your email address

FILTER BY CATEGORY