All ideas

Showing 15251

Adjusting column status in syscat.tables by synchronizing with column AVAILABLE SYSIBMADM.ADMINTABINFO

Customer mentions that tables which are delivering aSQL1477N should have an inoperative status. But theyhave status 'N' (for normal) insyscat.tables. The only way to retrieve the status of anSQL1477N is to select the column AVAILABLE inSYSIBMADM.A...

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

2 VOTE

Add a function to determine if we are in the last row of a list or a crosstab

Ability to determine with a report function if we are in the last row of a list or a crosstab in order to apply specific layout (color coding).

over 9 years ago in Cognos Analytics 0 Not under consideration

1 VOTE

Unstructure Data Stage

While loading data from Datastage to excel using the Unstructure Data stage we want to control on the direction of the loaded data into the excel spreadsheet.

almost 5 years ago in Connectivity 1 Not under consideration

2 VOTE

Cannot logically restore a table when restoring smart blobs

System: IDS archeckerActor: Barmenia DBA Team We use archecker to perform table-level-restores. For various reasons it has to be on a point-in-time basis, which is not possible if a table has columns of data type blob.The following error occurs: E...

almost 10 years ago in Informix / Informix Server 0 Not under consideration

2 VOTE

Document permissions to update Deployment Manager client install when fixpacks or packages are applied to the C&DS server.

User has a existing installation of Deployment Manager client. Either a new package (ex: Modeler Adapters) or a Fixpack is applied to the Collaboration and Deployment Services Server. When the users deployment manager client first connects to the ...

over 9 years ago in SPSS Modeler / SPSS CNDS 0 Not under consideration

1 VOTE

Federation for XML data type

Description Federation queries (select statements) against an Oracle server are failing if the Oracle table has an XMLTYPE column. Even a select count(*) against these tables fails. Tables in the same Oracle server that do NOT have XMLTYPE colum...

almost 5 years ago in Db2 / Fluid Query 0 Not under consideration

1 VOTE

Implement Advisors for recommendations

Would be nice to have advisors and alerts in order to identify need of memory adjustments, table reorging, report the need of collecting statistics, database backups and other important things that DBA should be aware in order to guarantee a good ...

almost 5 years ago in Db2 / Data Management Console 0 Not under consideration

1 VOTE

Lack of information about Queries from Federated DBs - particulary from DB2 z/OS

From DSM we should be able to see the transactions from federated databases. In the case when we are having some federated transaction contention we are not able to see on the source database on DSM getting more difficulty to diagnose a performanc...

almost 5 years ago in Db2 / Monitoring 0 Not under consideration

1 VOTE

Improve backup configuration

Actually we need to define some environment variables like DSMI_DIR, DSMI_CONFIG to implement a TSM backup. So in case we forget to configure this at first moment we will need to do an instance restart. Would be better to consider some dynamic par...

almost 5 years ago in Db2 / Backup/Restore/ Rollforward/ Recover 4 Not under consideration

1 VOTE

Improve lock management

Eliminate a lock needed by a SELECT statement in order to performance a query without need to implement a dirty read - UR.Although there is a solution doing an uncommitted read on the transaction, it requires an application modification changing t...

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

Please enter your email address

FILTER BY CATEGORY