Question : The Following is the TCB index that I could get using a command for my DB2 database. I […]
Tag: db2
Backup and restore of RDBMS(Oracle, DB2, SQL Server) from Perl
Question : What could be the best approach ? Till now could figure out the following (Oracle) Calling exp.exe and […]
In DB2, what are the alternative ways of evaluating an index’s (or several indexes) benefit?
Question : I’m trying to evaluate different approaches to analyzing the benefit of changing the set of indexes that are […]
Help to optimize specific SQL query
Question : I have WORKLOGTABLE which has index on RECORDKEY column. WORKLOG table has currently 1,200,000 records When I do […]
DB2 ARCHIVE mode – Can all archive logs be deleted after doing the FULL OFFLINE backup?
Question : I am interested in one thing, if I understood correctly. DB2 is in Archive mode (online backups are […]
Adding group rights in db2 for a stored procedure
Question : I have a list of user accounts on AIX server, where the db2 database resides in. The user […]
non-optimal use of index
Question : I’m somewhat puzzled by the scenario below. The table involved (relevant parts) is defined as: CREATE TABLE Nya. […]
Is it worth duplicating a table for different types of an entity when one should be unique?
Question : In my database, I have a CUSTOMER table. I’m migrating an OPPORTUNITIES table, which contains two different types […]
Use multiple OUTER JOINS in a CASE statement
Question : I tried to put : Select …. , (CASE WHEN (D.C_ZONE is null or D.C_ZONE = ”) THEN […]
Migrate DB2 UDB (Iseries) to SQL Server [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the […]